4) 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.

1. What are the Work Packages on the critical path?
2. 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.
3. Calculate the actual budget based on the planned schedule.
4. 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.
5. What is the forecasted completion time and cost of this project if efficiencies do not change.
6. What must our efficiencies be to finish on schedule and on budget.

Excel file

MS project file

item Hm Task Name Duration Planned Start Planned Finish 1 start o days Thu 3/26/20 Thu 3/26/20 2 Summary #1 22 days Thu 3/26/20 Wed 4/29/20 3 Task 1 7 days Thu 3/26/20 Fri 4/3/20 4 task a 5 days Thu 3/26/20 Wed 4/1/20 5 taskc 8 days Mon 4/6/20 Wed 4/15/20 6 task d 4 days Fri 4/10/20 Wed 4/15/20 7 task b 7 days Thu 4/16/20 Fri 4/24/20 8 Task 2 3 days Mon 4/27/20 Wed 4/29/20 9 Summary #2 25 days Fri 4/10/20 Mon 5/11/20 10 Task 3 3 days Fri 4/10/20 Tue 4/14/20 11 taks m 5 days Tue 4/21/20 Mon 4/27/20 12 task n 6 days Tue 4/21/20 Tue 4/28/20 13 taska 2 days Thu 4/30/20 Fri 5/1/20 14 Task 4 4 days Mon 5/4/20 Thu 5/7/20 15 Task 5 2 days Fri 5/8/20 Mon 5/11/20 16 Summary #3 10 days Mon 4/27/20 Mon 5/11/20 17 Task 6 3 days Mon 4/27/20 Wed 4/29/20 18 Task 7 2 days Mon 4/27/20 Tue 4/28/20 19 Task 8 6 days Thu 4/30/20 Thu 5/7/20 20 finish o days Mon 5/11/20 Mon 5/11/20 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 5,6 $1,100.00 $500.00 $0.00 3 $2,300.00 $2,200.00 100 10 $1,700.00 $1,500.00 10 $11,445.00 $9,000.00 50 8,12,11 $2,900.00 $0.00 0 13 $6,700.00 $0.00 14 $5,900.00 $0.00 0 O O o 7 O O 7 0 $9,450.00 $10,250.00 $7,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 0 17,18 19,15 0 Task Mode Duration Start Finish Predecessors Baseline Cost 1 1 3,4 3 5,6 5,6 Task Name start Summary #1 Task 1 task a task c task d task b Task 2 - Summary #2 Task 3 taks m task n task a Task 4 Task 5 - Summary #3 Task 6 Task 7 3 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 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/24 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 $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 7 Task 8 17,18 19,15 finish item Hm Task Name Duration Planned Start Planned Finish 1 start o days Thu 3/26/20 Thu 3/26/20 2 Summary #1 22 days Thu 3/26/20 Wed 4/29/20 3 Task 1 7 days Thu 3/26/20 Fri 4/3/20 4 task a 5 days Thu 3/26/20 Wed 4/1/20 5 taskc 8 days Mon 4/6/20 Wed 4/15/20 6 task d 4 days Fri 4/10/20 Wed 4/15/20 7 task b 7 days Thu 4/16/20 Fri 4/24/20 8 Task 2 3 days Mon 4/27/20 Wed 4/29/20 9 Summary #2 25 days Fri 4/10/20 Mon 5/11/20 10 Task 3 3 days Fri 4/10/20 Tue 4/14/20 11 taks m 5 days Tue 4/21/20 Mon 4/27/20 12 task n 6 days Tue 4/21/20 Tue 4/28/20 13 taska 2 days Thu 4/30/20 Fri 5/1/20 14 Task 4 4 days Mon 5/4/20 Thu 5/7/20 15 Task 5 2 days Fri 5/8/20 Mon 5/11/20 16 Summary #3 10 days Mon 4/27/20 Mon 5/11/20 17 Task 6 3 days Mon 4/27/20 Wed 4/29/20 18 Task 7 2 days Mon 4/27/20 Tue 4/28/20 19 Task 8 6 days Thu 4/30/20 Thu 5/7/20 20 finish o days Mon 5/11/20 Mon 5/11/20 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 5,6 $1,100.00 $500.00 $0.00 3 $2,300.00 $2,200.00 100 10 $1,700.00 $1,500.00 10 $11,445.00 $9,000.00 50 8,12,11 $2,900.00 $0.00 0 13 $6,700.00 $0.00 14 $5,900.00 $0.00 0 O O o 7 O O 7 0 $9,450.00 $10,250.00 $7,500.00 $0.00 $0.00 $0.00 $0.00 $0.00 0 17,18 19,15 0 Task Mode Duration Start Finish Predecessors Baseline Cost 1 1 3,4 3 5,6 5,6 Task Name start Summary #1 Task 1 task a task c task d task b Task 2 - Summary #2 Task 3 taks m task n task a Task 4 Task 5 - Summary #3 Task 6 Task 7 3 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 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/24 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 $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 7 Task 8 17,18 19,15 finish