ALL WORK MUST EB COMPLETED IN EXCEL

You are estimating costs for installing undersea cable in the Persian Gulf (aka the Arabian Gulf). You have the following information concerning installation costs:The material cost per kilometer for cable is $100,000. You are installing 100 kilometers of cable.The cost per kilometer for installation depends on the sea conditions (sea state).What would be the estimated cost of the project if you knew with certainty that, during the time you were installing the cable, you would encounter sea state I 25% of the time and sea state II 75% of the time?

Run a Crystal Ball calculation of the total estimated cost of the project, assuming the probability of sea state 1 is normally distributed with a mean of 25% and a standard deviation of 5%. Only sea states I and II are possible. Post your result, including your cost forecast.

What is your mean expected cost?Whatestimatedcostprovidesyou95%assurancethatyouractualcostwillbelessthanthatamount?

1. A project is in its 50^th week and has an actual cost of $300,000 for the work performed to date. The budgeted cost of that work is $400,000. It expected to have completed $500,000 worth of work by this time. The budget for the entire project is $1,000,000. What is the:
   1. CV
   2. SV
   3. CPI
   4. EAC(providetwopossiblevalues.Showtheformulasyouuseincalculatingeach)
2. You have prepared an initial estimate of $2,000,000 to develop a software application for your organization. However, after you think about it a while, you vaguely remember from an old course you took at UMUC that estimates aren?t the same as reality. So, you do a bit more analysis and come up with the following table. How much reserve should you add to your initial estimate in order to have a 90% chance of success?

Activity	Most Likely	Optimistic	Pessimistic
Labor	$1,000,000	$800,000	$1,500,000
Commercial SW and Licenses	$500,000	$450,000	$550,000
Subcontracts	$500,000	$450,000	$600,000

The estimates include all applicable burdens. All activities have assumed a triangular distribution. You may use any method you require, but show your work in an attachment.

1. You are preparing a project to lay fiber optic cable. The first task is to mobilize the team. You estimate this will take one week and cost $3000. The second task is to lay the cable. This will take three weeks and will cost $45,000. The total length of the cable is 15 miles. The last task, which will take one week, is to terminate and test the cable. You budget $5000 for this. At the end of the first week, you have completed mobilization, but it cost a total of $4500. At the end of the third week, you have completed five miles of cable at a total cost of $28,000 (installation only). It takes you a total of 10 weeks to complete the entire project, for a total cost of $65,000.
   1. At the end of week 1:

What is your SPI?

What is your CPI?

What is your EAC?

1. 1. At the end of week 3:

What is your SPI?

What is your CPI?

What is your EAC?

1. 1. At the end of the project:

What is your SPI?

What is your CPI?

What is your EAC?

1. A task has a normal duration of 9 days and a crash duration (the minimum duration) of 7 days. Its normal cost (total for 9 days) is $6000 and its crash cost is $10,000 (total for 7 days). What is the crash cost per day?
   1. $14000
   2. $7000
   3. $5000
   4. $2000
   5. $1000
2. A task is expected to take 20 hours of labor at $25 per hour (direct cost). The required material cost is $500. The organization adds a fee of 30% to all direct labor costs to account for overhead. It does not add any fee on top of material costs. The total task cost is:
   1. $500
   2. $1,150
   3. $1,250
   4. $1,300
   5. $1,500
3. Using MSP, develop the project plan described in the attached file ?FINAL QUESTION 11?. Calculate and enter TE for task durations when developing your plan.
   1. Submit your resulting MSP file.
   2. What is the expected duration?
   3. What is the expected cost?

ALL WORK MUST EB COMPLETED IN EXCEL 1. You are estimating costs for installing undersea cable in the Persian Gulf (aka the Arabian Gulf). You have the following information concerning installation costs: The material cost per kilometer for cable is $100,000. You are installing 100 kilometers of cable. The cost per kilometer for installation depends on the sea conditions (sea state). Sea State I II Cost/kilometer $25,000 $75,000 a. What would be the estimated cost of the project if you knew with certainty that, during the time you were installing the cable, you would encounter sea state I 25% of the time and sea state II 75% of the time? b. Run a Crystal Ball calculation of the total estimated cost of the project, assuming the probability of sea state 1 is normally distributed with a mean of 25% and a standard deviation of 5%. Only sea states I and II are possible. Post your result, including your cost forecast. c. What is your mean expected cost? d. What estimated cost provides you 95% assurance that your actual cost will be less than that amount? 2. A project is in its 50th week and has an actual cost of $300,000 for the work performed to date. The budgeted cost of that work is $400,000. It expected to have completed $500,000 worth of work by this time. The budget for the entire project is $1,000,000. What is the: a. CV b. SV c. CPI d. EAC (provide two possible values. Show the formulas you use in calculating each) 3. You have prepared an initial estimate of $2,000,000 to develop a software application for your organization. However, after you think about it a while, you vaguely remember from an old course you took at UMUC that estimates aren't the same as reality. So, you do a bit more analysis and come up with the following table. How much reserve should you add to your initial estimate in order to have a 90% chance of success? Activity Labor Commercial SW and Licenses Subcontracts Most Likely $1,000,000 $500,000 Optimistic $800,000 $450,000 Pessimistic $1,500,000 $550,000 $500,000 $450,000 $600,000 4. 5. 6. 7. The estimates include all applicable burdens. All activities have assumed a triangular distribution. You may use any method you require, but show your work in an attachment. You are preparing a project to lay fiber optic cable. The first task is to mobilize the team. You estimate this will take one week and cost $3000. The second task is to lay the cable. This will take three weeks and will cost $45,000. The total length of the cable is 15 miles. The last task, which will take one week, is to terminate and test the cable. You budget $5000 for this. At the end of the first week, you have completed mobilization, but it cost a total of $4500. At the end of the third week, you have completed five miles of cable at a total cost of $28,000 (installation only). It takes you a total of 10 weeks to complete the entire project, for a total cost of $65,000. e. At the end of week 1: i. What is your SPI? ii. What is your CPI? iii. What is your EAC? f. At the end of week 3: i. What is your SPI? ii. What is your CPI? iii. What is your EAC? g. At the end of the project: i. What is your SPI? ii. What is your CPI? iii. What is your EAC? A task has a normal duration of 9 days and a crash duration (the minimum duration) of 7 days. Its normal cost (total for 9 days) is $6000 and its crash cost is $10,000 (total for 7 days). What is the crash cost per day? h. $14000 i. $7000 j. $5000 k. $2000 l. $1000 A task is expected to take 20 hours of labor at $25 per hour (direct cost). The required material cost is $500. The organization adds a fee of 30% to all direct labor costs to account for overhead. It does not add any fee on top of material costs. The total task cost is: m. $500 n. $1,150 o. $1,250 p. $1,300 q. $1,500 Using MSP, develop the project plan described in the attached file \"FINAL QUESTION 11\". Calculate and enter TE for task durations when developing your plan. r. Submit your resulting MSP file. s. What is the expected duration? t. What is the expected cost