Using the following data, calculate the planned and actual monthly budgets through the end of...
50.1K
Verified Solution
Link Copied!
Question
Accounting
Using the following data, calculate the planned and actual monthly budgets through the end of June. Assume the project is planned for a 12-month duration and $250,000 budget. All costs are in $000.
Activity
Jan
Feb
Mar
Apr
May
Jun
Plan
% C
Value
Staffing
8
7
15
100
Blueprinting
4
6
10
100
Prototype Devlpmt
2
8
10
70
Full Design
3
8
10
21
67
Construction
2
30
32
25
Transfer
10
10
0
Monthly Plan
Cumulative
Monthly Actual
10
15
6
14
9
40
Cumul. Actual
Using the data from above, calculate the following values (show your work):
Schedule Variances
Planned Value of Work Scheduled (PV)
Earned Value (EV)
Schedule Performance Index (SPI)
Estimated Time to Completion
Cost Variances
Actual Cost of Work Performed (AC)
Earned Value (EV)
Cost Performance Index (CPI)
Estimated Cost to Completion
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!