(c) Using the IF or IFS function, write a formula in I15 to determine if the activity has overshot its budget. Copy the formula to cells I16 to I23.Thankyouzzz screenshots attached 910111213ABDEFHJYou are analyzing the budget overrun for the activities; this analysis is not helpful for an activity that is not yet completed; hence you decide to assign "NA" for such activities.An activity has overshot the budget if (i) it is completed and (ii) Actual Amount spent on the activity > Budget Allocated.An activity is Within Budget if (i) it is completed and (ii) Actual Amount spent on the activity < Budget Allocated.78 (c) Using the IF or IFS function, write a formula in 115 to determine if the activity has overshot its budget. Copy the formula to cells 116 to 123.(d) Apply conditional formatting to the Budget status column.(i) If the Budget Status text is Overshot, then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Red Color" (Any red color of your choice).(ii) If the Budget Status text is Within Budget then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Green Color" (Any green color of your choice).1415161718192021222321As on DateActivity Activity descriptionABсDEFGHIDetermine user needsReview software and languagesPurchase softwareDesign format and style.Write programsReview outcome product with userMake revisionsSelect server siteInstall on server and test2/12/2021Table 2: Activity Status of the projectStart Date2/1/20212/1/20212/3/20212/4/20212/7/20212/12/20212/13/20212/13/20212/15/2021End Date2/3/20212/3/20212/4/20212/7/20212/12/20212/13/20212/15/20212/14/20212/17/2021StatusBudgetAllocated$$$$$ 1,000 $200 $250 $99 $250 $100 $200 $500 $200 $$$$$ActualAmountSpent1201504452501,100100-KBudget StatusL ABDF1 You are creating a simple project tracking template to help you understand the current project status on a given date.2 Table 2 has the project activities, the project is going as per the planned start and end date, and there is no deviation.3 Any activity has three statuses, viz. Completed, In-progress, and not started.4 An activity's status is (i) Completed if "As on Date" > End Date (ii) In-progress if Start Date <= "As on Date" and End Date >= "As on Date" (iii) "Not Started" if Start Date > "As on Date".56910(a) Using the IF or IFS function, write a formula in F15 to determine the activity status. Use the As on Date value given in cell E11. Copy the formula to cells F16 to F23.(b) Apply conditional formatting to the status column.(i) If the Status text is Completed, then apply "Highlight Cell Rules", "Text that contains" with "Green Fill with Dark Green Text".(ii) If the Status text is In-Progress, then apply "Highlight Cell Rules", "Text that contains" with "Yellow Fill with Dark Yellow Text".(iii) If the Status text is "Not started" then apply "Highlight Cell Rules", "Text that contains" with Custom format, Grey fill (it can be any grey color of your choice).You are analyzing the budget overrun for the activities; this analysis is not helpful for an activity that is not yet completed; hence you decide to assign "NA" for such activities.An activity has overshot the budget if (i) it is completed and (ii) Actual Amount spent on the activity > Budget Allocated.7An activity is within Budget if (i) it is completed and (ii) Actual Amount spent on the activity < Budget Allocated.8 (c) Using the IF or IFS function, write a formula in 115 to determine if the activity has overshot its budget. Copy the formula to cells 116 to 123.(d) Apply conditional formatting to the Budget status column.(i) If the Budget Status text is Overshot, then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Red Color" (Any red color of your choice).(ii) If the Budget Status text is Within Budget then apply "Highlight Cell Rules", "Text that contains" with Custom format and fill with "Green Color" (Any green color of your choice).1112GAs on DateH2/12/2021KLM

If the the actual amount spent is more than the budget allocated then we can change the budget…

Answered: write a formula in I15 to determine if…

Engineering

Computer Science

write a formula in I15 to determine if the activity has overshot its budget

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

Draw an activity network and find the critical path for a research project given below.There are eight tasks in a small project. Task A takes 14 days to complete. Task B takes 16 days to complete and can be executed in parallel with Task C which takes 22 days to complete. When tasks B and C are completed, task D can be executed which will take 17 days to complete. When D is completed, tasks E and F can be executed which will take 13 and 10 days to complete. When tasks E and F are completed, task G can be executed which will take 15 days to complete. (Note: Highlight the critical path in the network)
A.1 Q is a local governmental organization (council) for a town in country U. It has a large call center to deal with queries and complaints from local residents and aims to ‘help callers find the information they need. Callers are asked to grade their satisfaction levels from 1 to 10 once they have completed their call, depending on how satisfied they were with their service. Currently, the higher the average grades given by callers across the year, the higher the bonus given to call center staff. The call center experiences a high volume of calls, with a number of calls going unanswered. Q has recently decided to change the performance mix for its call center staff. Staff will now be assessed on three separate measures: the number of calls taken by the center in the period, the average speed with which the call is handled and the total number of complaints about call center service received by Q. Each of these three measures will contribute equally to call center staff bonuses. Based…
Scenario: You are tasked with the development of an E-Scooter ride-share system. It allows registered commuters to approach an idle E-Scooter and reserve it, following which they use the E-Scooter to commute a certain distance (that is not known prior to use). Finally, after the commuter reaches their destination, they end the ride, which prompts an automatic computation of the ride fees. which is automatically debited using the commuters registered payment details. TAsk 1 Create a CPN model based on the AOM Goal and Behavioural Interface Models using the mapping heuristics discu
Activity Duration (wks) Precedents A Hardware selection 5 B Software Design 3 C Install Hardware 2 A D Code & Test software 4 B E File take-on 3 B F Write user manual 9 G User training 3 E, F H Install & test system 2 C, D Produce the Activity network diagram (CPM) of the given activity chart. [5] Find all the possible paths by using the above activity network and highlight the critical path. [5] (PLO1, PLO3, CLO2, CLO3)
COPY FROM CHEGG == DISLIKE AND REPORT Assume that a finite number of resources of a single resource type mustbe managed. Processes may ask for a number of these resources and will returnthem once finished. As an example, many commercial software packagesprovide a given number of licenses, indicating the number of applications thatmay run concurrently. When the application is started, the license count isdecremented. When the application is terminated, the license count isincremented. If all licenses are in use, requests to start the application aredenied. Such a request will be granted only when an existing license holderterminates the application and a license is returned. The following program segment is used to manage a finite number of instancesof an available resource. The maximum number of resources and the number ofavailable resources are declared as follows: #define MAX_RESOURCES 5 int available_resources = MAX_RESOURCES; /** When a process wishes to obtain a number of…
Given that there are FIVE (5) processes (A, B, C, D and E) and FOUR (4) resources (R1, R2,R3 and R4) involved in a project. Assume that all the resources are non-sharable and the number of instances for each resource is 2, 3, 2, 3 respectively. *Process A holds one instance of R1, R2 and R4. It requests one instance of R3.* Process B holds one instance of R1 and R3. It requests one instance of R4.* Process C holds one instance of R2 and R4.* Process D holds one instance of R2 and R4. It requests one instance of R1.* Process E holds one instance of R3. It requests one instance of R2. (i) Draw a directed resources allocation graph for the above scenario and Are these five processes in a deadlock state? Justify your answer.
Scenario: You are tasked with the development of an E-Scooter ride-share system. It allows registered commuters to approach an idle E-Scooter and reserve it, following which they use the E-Scooter to commute a certain distance (that is not known prior to use). Finally, after the commuter reaches their destination, they end the ride, which prompts an automatic computation of the ride fees. which is automatically debited using the commuters registered payment details. TAsk 3. You can use the CPN model example used in the lecture and modify it to suit your needs
Suppose an iteration in Elaboration is 2 weeks and you are the leader of the team. Also assume that Elaboration has 20 iterations and you are now in the 5th iteration of Elaboration. (a) What are the activities that would typically happen in this iteration? (b) What is the order of these activities? (c) Roughly how much time and on which day(s) should you spend on each of the activities?
A project has three sequences of activities (paths), two of which are critical. The critical paths of this project can be characterized in the following way: a. The slack times for each task in the entire project are zero. b. The chain of activities (from start to finish) that has the largest sum of activity durations. c. The early start date and early finish date are always the same for each activity on the critical path. d. To reduce the project duration, you must reduce the slack time of a task on the critical path. e. None of the above are correct.
Question #01: Provide the solution for the following open ended problem. Assume you are CEO of a well-known company. You need to create a salary management system for the company in order to check the amount spent on salaries of your employees. Let there be 3 types of employees in the company i.e. Developers, Marketing Teams and Human Resource Your company gives salary on the basis of experience of the employee. Initial salary for the Developers is $800, for the Marketing Team is $700 and for Human Resource is $600. Your program should ask the employee to enter the year of experience in the company, if the experience is more than 2 years an increment of $50 is given. The Salary mentioned above is monthly. Annually two bonuses are given to the employee, Bonus is 10% for the Developers, 86 for the Marketing Team and 6% for Human Resource. Your Program should initially display a menu from which the employee chooses his/her department. Depending on the Department chosen the salary/bonuses…
I really need help with the Resource Allocation Graph. Thank You sir.
In response to popular demand, Dan’s established two research groups A and B composed of his n graduate students. Each of these students is a member of exactly one of the two groups at any given time. The students are numbered from 1 to n in some arbitrary order. To measure the success of his research groups, Dan assigns a citation score to each of them. Initially, both groups have citation score 0. Throughout the semester, events of the following two types happen: Studentxpublishesapaperinwhichtheycitestudenty’swork(youcan assume all of the students have been around long enough to have prior research that can be cited). As a result, If x and y are in the same group, their group’s citation score increases by 1. If x and y are in different groups, y’s group’s citation score increases by 5. Danchangesstudentx’sgroup(fromAtoBorfromBtoA)tohavethem work on different projects. To assess the overall success of the research groups, Dan needs to calculate their final citation scores at…