Project Management Question

3) For the project in the excel file and the MS Project files attached below, answer the following questions: You can use MS Project and then export your answers.

a) What are the Work Packages on the critical path?

b) Calculate the ES and LS budgets for this project. Schedule all activities to start at their ES time and then at their LS times to answer this question.

c) Calculate the actual budget based on the planned schedule.

d) As of 4/26, what is the status of the project? Is it on time, on budget, etc. Use the percent complete column to answer this. Show all calculations.

e) What is the forecasted completion time and cost of this project if efficiencies do not change.

f) What must our efficiencies be to finish on schedule and on budget.

MS Project files

Excel file

Task Mode Task Name Duration Predecessors Baseline Cost Add New Colul 1 1 3,4 3 3 5,6 5,6 start Summary #1 Task 1 task a task c task d task b Task 2 Summary #2 Task 3 taks m task n taska Task 4 Task 5 - Summary #3 Task 6 Task 7 Start Finish Thu 3/26/20 Thu 3/26/20 Thu 3/26/20 Wed 4/29/20 Thu 3/26/20 Fri 4/3/20 Thu 3/26/20 Wed 4/1/20 Mon 4/6/20 Wed 4/15/20 Fri 4/10/20 Wed 4/15/20 Thu 4/16/20 Fri 4/24/20 Mon 4/27/20 Wed 4/29/20 Fri 4/10/20 Mon 5/11/20 Fri 4/10/20 Tue 4/14/20 Tue 4/21/20 Mon 4/27/20 Tue 4/21/20 Tue 4/28/20 Thu 4/30/20 Fri 5/1/20 Mon 5/4/20 Thu 5/7/20 Fri 5/8/20 Mon 5/11/20 Mon 4/27/21 Mon 5/11/20 Mon 4/27/20 Wed 4/29/20 Mon 4/27/20 Tue 4/28/20 Thu 4/30/20 Thu 5/7/20 Mon 5/11/20 Mon 5/11/20 o days 25 days 7 days 5 days 8 days 4 days 7 days 3 days 22 days 3 days 5 days 6 days 2 days 4 days 2 days 11 days 3 days 2 days 6 days o days 3 $0.00 $0.00 $2,500.00 $3,400.00 $2,100.00 $1,100.00 $9,555.00 $1,100.00 $0.00 $2,300.00 $1,700.00 $11,445.00 $2,900.00 $6,700.00 $5,900.00 $0.00 $9,450.00 $10,250.00 $7,500.00 $0.00 10 10 8,12,11 13 14 7 1 7 Task 8 IT 17,18 19,15 finish B G K item 3 c D Task Name Duration 1 start O days 2 Summary #1 22 days 3 Task 1 7 days 4 task a 5 days 5 taskc 8 days 6 task d 4 days 7 task b 7 days 8 Task 2 3 days 9 Summary #2 25 days 10 Task 3 3 days 11 taks m 5 days 12 task n 6 days 13 taska 2 days 14 Task 4 4 days 15 Task 5 2 days 16 Summary #3 10 days 17 Task 6 3 days 18 Task 7 2 days 19 Task 8 6 days 20 finish o days 5,6 E Planned Start Planned Finish Thu 3/26/20 Thu 3/26/20 Thu 3/26/20 Wed 4/29/20 Thu 3/26/20 Fri 4/3/20 Thu 3/26/20 Wed 4/1/20 Mon 4/6/20 Wed 4/15/20 Fri 4/10/20 Wed 4/15/20 Thu 4/16/20 Fri 4/24/20 Mon 4/27/20 Wed 4/29/20 Fri 4/10/20 Mon 5/11/20 Fri 4/10/20 Tue 4/14/20 Tue 4/21/20 Mon 4/27/20 Tue 4/21/20 Tue 4/28/20 Thu 4/30/20 Fri 5/1/20 Mon 5/4/20 Thu 5/7/20 Fri 5/8/20 Mon 5/11/20 Mon 4/27/20 Mon 5/11/20 Mon 4/27/20 Wed 4/29/20 Mon 4/27/20 Tue 4/28/20 Thu 4/30/20 Thu 5/7/20 Mon 5/11/20 Mon 5/11/20 G H Predecessors planned cost actual cost percent complete $0.00 $0.00 1 $2,500.00 $2,350.00 100 1 $3,400.00 $3,500.00 100 3,4 $2,100.00 $2,200.00 100 3 $1,100.00 $1,105.00 100 5,6 $9,555.00 $10,100.00 80 $1,100.00 $500.00 0 $0.00 3 $2,300.00 $2,200.00 100 10 $1,700.00 $1,500.00 20 10 $11,445.00 $9,000.00 50 8,12,11 $2,900.00 $0.00 0 13 $6,700.00 $0.00 0 14 $5,900.00 $0.00 0 7 7 $9,450.00 $10,250.00 $7,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 O O O 0 17,18 19,15 0 Question 1: Calculate the early start and late start budgets for this project. question 2 calculate the actual budget based on the schedule question 3 as of 4/26, how is the project doing? Over budget? Late? question 4. what do our forecasted completion times and costs question 5 what does our efficiency need to be to finish on budget and on schedule. Task Mode Task Name Duration Predecessors Baseline Cost Add New Colul 1 1 3,4 3 3 5,6 5,6 start Summary #1 Task 1 task a task c task d task b Task 2 Summary #2 Task 3 taks m task n taska Task 4 Task 5 - Summary #3 Task 6 Task 7 Start Finish Thu 3/26/20 Thu 3/26/20 Thu 3/26/20 Wed 4/29/20 Thu 3/26/20 Fri 4/3/20 Thu 3/26/20 Wed 4/1/20 Mon 4/6/20 Wed 4/15/20 Fri 4/10/20 Wed 4/15/20 Thu 4/16/20 Fri 4/24/20 Mon 4/27/20 Wed 4/29/20 Fri 4/10/20 Mon 5/11/20 Fri 4/10/20 Tue 4/14/20 Tue 4/21/20 Mon 4/27/20 Tue 4/21/20 Tue 4/28/20 Thu 4/30/20 Fri 5/1/20 Mon 5/4/20 Thu 5/7/20 Fri 5/8/20 Mon 5/11/20 Mon 4/27/21 Mon 5/11/20 Mon 4/27/20 Wed 4/29/20 Mon 4/27/20 Tue 4/28/20 Thu 4/30/20 Thu 5/7/20 Mon 5/11/20 Mon 5/11/20 o days 25 days 7 days 5 days 8 days 4 days 7 days 3 days 22 days 3 days 5 days 6 days 2 days 4 days 2 days 11 days 3 days 2 days 6 days o days 3 $0.00 $0.00 $2,500.00 $3,400.00 $2,100.00 $1,100.00 $9,555.00 $1,100.00 $0.00 $2,300.00 $1,700.00 $11,445.00 $2,900.00 $6,700.00 $5,900.00 $0.00 $9,450.00 $10,250.00 $7,500.00 $0.00 10 10 8,12,11 13 14 7 1 7 Task 8 IT 17,18 19,15 finish B G K item 3 c D Task Name Duration 1 start O days 2 Summary #1 22 days 3 Task 1 7 days 4 task a 5 days 5 taskc 8 days 6 task d 4 days 7 task b 7 days 8 Task 2 3 days 9 Summary #2 25 days 10 Task 3 3 days 11 taks m 5 days 12 task n 6 days 13 taska 2 days 14 Task 4 4 days 15 Task 5 2 days 16 Summary #3 10 days 17 Task 6 3 days 18 Task 7 2 days 19 Task 8 6 days 20 finish o days 5,6 E Planned Start Planned Finish Thu 3/26/20 Thu 3/26/20 Thu 3/26/20 Wed 4/29/20 Thu 3/26/20 Fri 4/3/20 Thu 3/26/20 Wed 4/1/20 Mon 4/6/20 Wed 4/15/20 Fri 4/10/20 Wed 4/15/20 Thu 4/16/20 Fri 4/24/20 Mon 4/27/20 Wed 4/29/20 Fri 4/10/20 Mon 5/11/20 Fri 4/10/20 Tue 4/14/20 Tue 4/21/20 Mon 4/27/20 Tue 4/21/20 Tue 4/28/20 Thu 4/30/20 Fri 5/1/20 Mon 5/4/20 Thu 5/7/20 Fri 5/8/20 Mon 5/11/20 Mon 4/27/20 Mon 5/11/20 Mon 4/27/20 Wed 4/29/20 Mon 4/27/20 Tue 4/28/20 Thu 4/30/20 Thu 5/7/20 Mon 5/11/20 Mon 5/11/20 G H Predecessors planned cost actual cost percent complete $0.00 $0.00 1 $2,500.00 $2,350.00 100 1 $3,400.00 $3,500.00 100 3,4 $2,100.00 $2,200.00 100 3 $1,100.00 $1,105.00 100 5,6 $9,555.00 $10,100.00 80 $1,100.00 $500.00 0 $0.00 3 $2,300.00 $2,200.00 100 10 $1,700.00 $1,500.00 20 10 $11,445.00 $9,000.00 50 8,12,11 $2,900.00 $0.00 0 13 $6,700.00 $0.00 0 14 $5,900.00 $0.00 0 7 7 $9,450.00 $10,250.00 $7,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 O O O 0 17,18 19,15 0 Question 1: Calculate the early start and late start budgets for this project. question 2 calculate the actual budget based on the schedule question 3 as of 4/26, how is the project doing? Over budget? Late? question 4. what do our forecasted completion times and costs question 5 what does our efficiency need to be to finish on budget and on schedule