Please help me experts to solve this problem.Thank you. Consider the following information pertaining to projection Z.Project tasksRequirement gatheringArchitecture designCircuit designPackage designTestingDuration1 month1 month1 month2 monthsBudget$20,000$20,000$30,000$60,000$20,0001 monthThe status of the project at the end of month 5 is as follows.TasksStatusRequirement gatheringArchitecture designCircuit designPackage designTestingCompleted. Spent $22,000.Completed. Spent $19,500.Completed. Spent $30,500.75% complete. Spent $48,000 to date.Not started yet.i)Calculate the following for this project.1. Cost variance2. Schedule variance3. Cost performance index4. Schedule performance indexii) Determine if the project is ahead/behind schedule and if it is over/under budget.iii) Determine what the project will most likely costs at completion?

Earned value analysis is a concept that helps in managing the project effectively and efficiently.…

Calculate the following for this project. 1. Cost variance 2. Schedule variance 3. Cost performance index 4. Schedule performance index ii) Determine if the project is ahead/behind schedule and if it is over/under budget. iii) Determine what the project will most likely costs at completion?

Calculate the following for this project. 1. Cost variance 2. Schedule variance 3. Cost performance index 4. Schedule performance index ii) Determine if the project is ahead/behind schedule and if it is over/under budget. iii) Determine what the project will most likely costs at completion?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

What is the minimum cost of crashing the following project that James Walters manages at Athabasca University by 4 days Activity Normal Time (days) Crash Time (days) Normal Cost Crash Cost Immediate Predecessor(s) A 5 4 $800 $1,000 — B 8 6 $200 $600 — C 5 4 $600 $650 — D 7 4 $750 $1,500 A E 6 4 $1,200 $1,650 C A. By how many days should each activity be crashed to reduce the project completion time by 4 days? Fill in the table below. (Enter your responses as whole numbers.) Activity Each Activity Should be Reduced BY (days) A 1 B 0 C 1 D 3 E 2 B. The total cost of crashing the project by 4 days is _____ (Enter your response as a whole number.) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You…
Consider a small Oil production firm with 5 competing oil production projects, A - E. The table below shows the estimated long-term profit (Net Present Value) for each project as well as the amount of investment capital required to start the project. You have been contacted to help select the best combination of projects to maximize the Net Present Value subject to the capital investment limit of $32 million. Production Project A B C D E Estimated Profit (millions) 25 20 19 28 21 Capital Required (millions) 11 8 14 19 13 Formulate a Binary Integer Programming (BIP) model on a spreadsheet. Solver the model using Solver.
Fowle Marketing Research, Inc. is faced with the problem of assigning three available project leaders (agents) to each of three new research studies (tasks). Fowle’s management realizes, however, that the time required to complete each study will depend on the experience and ability of the project leader assigned to the study. Since the three studies have been judged to have approximately the same priority, the company would like to determine the assignments that will minimize the total number of days required to complete all three. If a project leader is to be assigned to one and only one client, what assignments should be made (optimal solutions)? How many days are required (objective function value).With three project leaders and three clients, there are total of nine possible assignment alternatives. The alternatives and the estimated project completion times in days are summarized in Table Client Project Leader 1 2…
Troy and Tristan have decided to open a competitive Cheer and Dance business. Troy’s expertise is in business. He has a degree in Business Administration with a minor in Underwater Basket Weaving. Tristan, on the other hand, has a degree in Sports Management and has been coaching the Tesoro cheerleading team, while his girlfriend, Beatrix, has been coaching the dance team. The problem is that no one has much capital to invest. In fact, both are having a little trouble figuring out how they will be able to get the startup capital for the business. Fortunately, there are no other competitive Cheer and Dance companies in the area. Unfortunately, the potential buildings they have found to lease costs over $7,000 per month and they expect that utilities and water will cost approximately $650 per month. Liability insurance is expensive as well, estimated to be $2,000 per month due to possible injuries. What type of business organization should Troy ad Tristan adopt?
What is true about the assignment problem if the solution has reached the table below? Project A Project B Project C Project D Expert W 0 100 200 0 Expert X 0 0 200 300 Expert Y 0 100 300 0 Expert Z 200 100 0 0 a. The minimum number of vertical and horizontal lines needed to cross out 0s is three. b. Optimal assignment of projects cannot be determined yet. c. Optimal assignment of projects can now be determined.
During 2019, Susan incurred and paid the following expenses for Beth (her daughter), Ed (her father), and herself:Surgery for Beth $4,500Red River Academy charges for Beth:Tuition 5,100Room, board, and other expenses 4,800Psychiatric treatment 5,100Doctor bills for Ed 2,200Prescription drugs for Susan, Beth, and Ed 780Insulin for Ed 540Nonprescription drugs for Susan, Beth, and Ed 570Charges at Heartland Nursing Home for Ed:Medical care 5,000Lodging 2,700Meals 2,650 Beth qualifies as Susan’s dependent, and Ed would also qualify except that hereceives $7,400 of taxable retirement benefits from his former employer. Beth’s…
Finco has the following investments available:Investment A For each dollar invested at time 0, we receive $0.10 at time 1 and $1.30 at time 2. (Time 0 =now;time= 1 one year from now; and so on.)Investment B For each dollar invested at time 1, we receive $1.60 at time 2.Investment C For each dollar invested at time 2, we receive $1.20 at time 3.At any time, leftover cash may be invested in T-bills, whichpay 10% per year. At time 0, we have $100. At most, $50can be invested in each of investments A, B, and C. Formulate an LP that can be used to maximize Finco’s cash onhand at time 3.
Bob has worked for Company X for the past 12 years as a supervisor in the mailroom. He has 5 "communication distribution representatives (CDRs)" working for him. Bob is 58 years old and the CDRs are all in their 20's and 30's. He was recently notified that his department is being outsourced and his and the other mailroom positions will be eliminated by the end of the month. During this "notification period" impacted employees (including Bob) could apply for any internal positions open in the company. Company X had 2 customer service representatives (CDRs) open during the notification period. Although this would be considered a demotion, Bob decided to apply for the job in an effort to stay at the company. Out of the 5 CDRs, 3 decided to apply for the CSR positions as well. All internal candidates were interviewed and both positions were filled by the former CDR employees. Bob was very upset about this and demanded to know why he wasn't hired. The response provided to him by Matt Jones,…
Bob has worked for Company X for the past 12 years as a supervisor in the mailroom. He has 5 "communication distribution representatives (CDRs)" working for him. Bob is 58 years old and the CDRs are all in their 20's and 30's. He was recently notified that his department is being outsourced and his and the other mailroom positions will be eliminated by the end of the month. During this "notification period" impacted employees (including Bob) could apply for any internal positions open in the company. Company X had 2 customer service representatives (CDRs) open during the notification period. Although this would be considered a demotion, Bob decided to apply for the job in an effort to stay at the company. Out of the 5 CDRs, 3 decided to apply for the CSR positions as well. All internal candidates were interviewed and both positions were filled by the former CDR employees. Bob was very upset about this and demanded to know why he wasn't hired. The response provided to him by Matt Jones,…
develope a space matrix for macdonalds. Below are the instructions. The steps required to develop a SPACE Matrix are as follows: 1. Select a set of variables to define financial position (FP), competitive position (CP), stability position (SP), and industry position (IP). 2. Assign a numerical value ranging from +1 (worst) to +7 (best) to each of the variables that make up the FP and IP dimensions. Assign a numerical value ranging from -1 (best) to -7 (worst) to each of the variables that make up the SP and CP dimensions. On the FP and CP axes, make comparison to competitors. On the IP and SP axes, make comparison to other industries. 3. Compute an average score for FP, CP, IP, and SP by summing the values given to the variables of each dimension and then by dividing by the number of variables included in the respective dimension. 4. Plot the average scores for FP, IP, SP, and CP on the appropriate axis in the SPACE Matrix. 5. Add the two scores on the x-axis and plot the resultant…
A consulting firm has four projects to consider. Each project will require time (in days) in the next three months according to the table below. Project Time in first month Time in second month Time in third month Revenue A 6 8 6 22000 B 5 6 8 18000 C 8 7 6 16000 D 5 5 4 15000 Revenue from each project is also shown. There is 20 days’ time available in the first month, 22 days’ time available in the second month, and 22 days’ time available in the third month to do these projects. The management wants to select at most 3 projects. If project B is selected, then project C must also be selected. The objective of the firm is to maximize the total revenue. Formulate an integer optimization model for this problem by defining the decision variables, the objective function and all the constraints.…
A health Centre will be built to serve 7 communities. The geographical location of the communities and their population is shown in the table below. Communities A, X =2.5 (km), Y=4.5(km), Population( 000's)=2 Communities B, X =2.5 (km), Y=2.5(km), Population( 000's)=5 Communities C, X =5.5 (km), Y=4.5(km), Population( 000's)=10 Communities D, X =5 (km), Y=2(km), Population( 000's)=7 Communities E, X =8 (km), Y=5(km), Population( 000's)=10 Communities F, X =7 (km), Y=2(km), Population( 000's)=20 Communities G, X =9 (km), Y=2.5(km), Population( 000's)=14 There is a possibility of building the Centre in two communities, community C and F. Based on the Demand-Distance criterion what is your recommendation for the site of the Centre. The distances to be measured based on Rectilinear method. Based on…