Prepare and upload a 1-page cost model for this project using spreadsheet software. Use the following work breakdown structure (WBS), and document your assumptions in preparing the cost model. Assume a labor rate of $100 per hour for the project manager and $60 per hour for other project team members. Assume that none of the work is outsourced, labor costs for users are not included, and there are no additional hardware costs. The total estimate should be $200,000.   Project management Requirements definition Website design Registration for recreational programs Registration for classes and programs Tracking system Incentive system Website development Registration for recreational programs Registration for classes and programs Tracking system Incentive system Testing Training, rollout, and support   Using the cost model you created in the first task, prepare a cost baseline by allocating the costs by WBS for each month of the project. Assume that you have completed 3 months of the project. The BAC was $200,000 for this 6-month project. You can also make the following assumptions: PV=$120,000 EV=$100,000 AC=$90,000 What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project? Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned? Use the SPI to estimate how long it will take to finish this project.   How do I calculate this for a baseline?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 21P
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%
  • Prepare and upload a 1-page cost model for this project using spreadsheet software. Use the following work breakdown structure (WBS), and document your assumptions in preparing the cost model. Assume a labor rate of $100 per hour for the project manager and $60 per hour for other project team members. Assume that none of the work is outsourced, labor costs for users are not included, and there are no additional hardware costs. The total estimate should be $200,000.

 

  1. Project management
  2. Requirements definition
  3. Website design
  4. Registration for recreational programs
  5. Registration for classes and programs
  6. Tracking system
  7. Incentive system
  8. Website development
  9. Registration for recreational programs
  10. Registration for classes and programs
  11. Tracking system
  12. Incentive system
  13. Testing
  14. Training, rollout, and support

 

  • Using the cost model you created in the first task, prepare a cost baseline by allocating the costs by WBS for each month of the project.
  • Assume that you have completed 3 months of the project. The BAC was $200,000 for this 6-month project. You can also make the following assumptions:
  • PV=$120,000
  • EV=$100,000
  • AC=$90,000
  1. What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?
  2. Use the CPI to calculate the estimate at completion (EAC) for this project. Is the project performing better or worse than planned?
  3. Use the SPI to estimate how long it will take to finish this project.

 

  • How do I calculate this for a baseline?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,