Assume you are the project manager and based on your customer’s requirements you have determined there are four main tasks in a Dream Backyard project. Each phase has been assigned a TBC. Specifically, the customer wants a pool and spa built (Task 1 - $40,000); all plumbing, electrical, and mechanical installed (Task 2 - $23,000); a pool deck with planters and a raised fire pit (Task 3 - $15,000); and landscaping and clean up (Task 4 - $6,000). You estimate this will take 5 weeks to complete. The costs are budgeted as follows: Budgeted Per Week (in 000’s) TBC 1 2 3 4 5 Task 1 40 10 15 10 5 Task 2 23 6 10 5 2 Task 3 15 9 4 2 Task 4 6 3 3 What is the total cumulative TBC? What is TBC at the end of week 4? Assume 4 weeks have passed and these are the actual costs per week: Actual Costs Per Week (in 000’s) 1 2 3 4 Task 1 15 21 12 6 Task 2 2 5 6 3 Task 3 1 5 5 Task 4 2 What is the CAC at the end of week 4? Below is the cumulative percentage of work complete per task per week: Cumulative Percentage Complete 1 2 3 4 Task 1 40% 62% 85% 100% Task 2 15% 25% 75% 90% Task 3 2% 7% 45% Task 4 10% What are the CEV, CPI, and CV at the end or week 4? What is the SPI?

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

Related questions

Question

Assume you are the project manager and based on your customer’s requirements you have determined there are four main tasks in a Dream Backyard project. Each phase has been assigned a TBC. Specifically, the customer wants a pool and spa built (Task 1 - $40,000); all plumbing, electrical, and mechanical installed (Task 2 - $23,000); a pool deck with planters and a raised fire pit (Task 3 - $15,000); and landscaping and clean up (Task 4 - $6,000). You estimate this will take 5 weeks to complete. The costs are budgeted as follows: