BUS472 Unit 5 Assignment TemplateInstructions: Fill in the only the yellow fields:
1. S-Curve
Develop a simple S-curve for the expected cumulative budget expenditures for this project:
Activities
Cumulative
10
4
4
20
8
12
Duration (in days)
30 40 50 60
12 20 10
8
24 44 54 62
70
6
68
80
2
70
Hint: Highlight the table above and insert a line chart within the yellow space below, ensure to only show
cumulative data
2. Earned Value Management
A. Using the plan data in the table below, complete the table by calculating the cumulative planned and cumulative actual
monthly budgets through the end of June. Complete the earned value column on the right. Assume the project is planned for a
12-month duration and $250,000 budget.
Activity
Jan Feb Mar Apr May Jun Plan
Staffing 8
7
15
Blueprinting
4
6
10
Prototype
2
8
10
Full Design
3
8
10 21
Construction
2
30 32
Transfer
10 10
Monthly Plan:
Cumulative:
Monthly Actual: 10 15 6
14 9
40
Cumul. Actual:
B. Using the above data, calculate the following values:
Schedule Variances
Planned Value
Earned Value
Schedule Performance Index
Estimated Time to Completion
Cost Variances
Actual Cost of Work Performed
Earned Value
Cost Performance Index
Estimated Cost to Completion
% Complete
100%
100%
70%
67%
25%
0%
Earned Value
7
Total:
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
