Homework Help is Here – Start Your Trial Now!
Business
Management
Status Report: Ending Period 2 Task % Complete 1 Finished Cumulative Totals Status Report: Ending Period 3 Task % Complete 1 Finished 2 0% 3 10% 4 20% Cumulative Totals Status Report: Ending Period 4 Task % Complete 1 Finished 2 40% 3 40% 4 40% Cumulative Totals Status Report: Ending Period 5 Task % Complete 1 Finished 2 Finished 3 50% 4 60% 5 25% Cumulative Totals Status Report: Ending Period 6 Task % Complete 1 Finished 2 Finished 3 80% 4 75% 5 50% Cumulative Totals EV AC 1500 PV 2000 1500 2000 CV SV EV AC PV CV SV 2000 1500 2000 0 200 500 2200 EV AC PV CV SV 2000 1500 2000 1000 800 1500 4800 EV AC PV CV SV 2000 1500 2000 2000 800 1500 400 6200 EV AC PV CV SV 2000 1500 2000 2000 2100 1800 600 8000 1. Complete the NWD, Schedule table, and baseline budget table. Calculate the status report for periods 1-6. Calculate the indicies and plot EV, AC, PV, SPI, CPI, PCIB, AND EACf for period 6. Indicate the BAC and EACf on the graph. Write a short 2-3 sentence summary of the status of the project, forecasts, and recommended actions. 2 6 5 Exercise 13-50 7 LEGEND ES ID EF SL SL LS DUR LF Schedule Information Activity Dur ES 20 123456 Total LF SL PV 20 20 24 2 2 7 3 6 2 11 3 5 30 270 25 4 4 11 3 16 6 4 7 11 0 20 Baseline Budget Needs - Labor Hours (x 100) Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 0 10 10 16 8 5 5 10 3 25 10 10 2 2 1 4 4 4 4 5 5 6 4 7 2 11 13 0 10 Total PV by period Cumulative PV by period 145 Status Report: Ending Period 1 Task 1 % Complete 50% Cumulative Totals 5 5 EV AC PV CV SV 500 1000 500 1000

Status Report: Ending Period 2 Task % Complete 1 Finished Cumulative Totals Status Report: Ending Period 3 Task % Complete 1 Finished 2 0% 3 10% 4 20% Cumulative Totals Status Report: Ending Period 4 Task % Complete 1 Finished 2 40% 3 40% 4 40% Cumulative Totals Status Report: Ending Period 5 Task % Complete 1 Finished 2 Finished 3 50% 4 60% 5 25% Cumulative Totals Status Report: Ending Period 6 Task % Complete 1 Finished 2 Finished 3 80% 4 75% 5 50% Cumulative Totals EV AC 1500 PV 2000 1500 2000 CV SV EV AC PV CV SV 2000 1500 2000 0 200 500 2200 EV AC PV CV SV 2000 1500 2000 1000 800 1500 4800 EV AC PV CV SV 2000 1500 2000 2000 800 1500 400 6200 EV AC PV CV SV 2000 1500 2000 2000 2100 1800 600 8000 1. Complete the NWD, Schedule table, and baseline budget table. Calculate the status report for periods 1-6. Calculate the indicies and plot EV, AC, PV, SPI, CPI, PCIB, AND EACf for period 6. Indicate the BAC and EACf on the graph. Write a short 2-3 sentence summary of the status of the project, forecasts, and recommended actions. 2 6 5 Exercise 13-50 7 LEGEND ES ID EF SL SL LS DUR LF Schedule Information Activity Dur ES 20 123456 Total LF SL PV 20 20 24 2 2 7 3 6 2 11 3 5 30 270 25 4 4 11 3 16 6 4 7 11 0 20 Baseline Budget Needs - Labor Hours (x 100) Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 0 10 10 16 8 5 5 10 3 25 10 10 2 2 1 4 4 4 4 5 5 6 4 7 2 11 13 0 10 Total PV by period Cumulative PV by period 145 Status Report: Ending Period 1 Task 1 % Complete 50% Cumulative Totals 5 5 EV AC PV CV SV 500 1000 500 1000

Practical Management Science
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
See similar textbooks
icon
Related questions
Question

Fill out the satus report please

Status Report: Ending Period 2 Task % Complete 1 Finished Cumulative Totals Status Report: Ending Period 3 Task % Complete 1 Finished 2 0% 3 10% 4 20% Cumulative Totals Status Report: Ending Period 4 Task % Complete 1 Finished 2 40% 3 40% 4 40% Cumulative Totals Status Report: Ending Period 5 Task % Complete 1 Finished 2 Finished 3 50% 4 60% 5 25% Cumulative Totals Status Report: Ending Period 6 Task % Complete 1 Finished 2 Finished 3 80% 4 75% 5 50% Cumulative Totals EV AC 1500 PV 2000 1500 2000 CV SV EV AC PV CV SV 2000 1500 2000 0 200 500 2200 EV AC PV CV SV 2000 1500 2000 1000 800 1500 4800 EV AC PV CV SV 2000 1500 2000 2000 800 1500 400 6200 EV AC PV CV SV 2000 1500 2000 2000 2100 1800 600 8000
Transcribed Image Text:Status Report: Ending Period 2 Task % Complete 1 Finished Cumulative Totals Status Report: Ending Period 3 Task % Complete 1 Finished 2 0% 3 10% 4 20% Cumulative Totals Status Report: Ending Period 4 Task % Complete 1 Finished 2 40% 3 40% 4 40% Cumulative Totals Status Report: Ending Period 5 Task % Complete 1 Finished 2 Finished 3 50% 4 60% 5 25% Cumulative Totals Status Report: Ending Period 6 Task % Complete 1 Finished 2 Finished 3 80% 4 75% 5 50% Cumulative Totals EV AC 1500 PV 2000 1500 2000 CV SV EV AC PV CV SV 2000 1500 2000 0 200 500 2200 EV AC PV CV SV 2000 1500 2000 1000 800 1500 4800 EV AC PV CV SV 2000 1500 2000 2000 800 1500 400 6200 EV AC PV CV SV 2000 1500 2000 2000 2100 1800 600 8000
1. Complete the NWD, Schedule table, and baseline budget table. Calculate the status report for periods 1-6. Calculate the indicies and plot EV, AC, PV, SPI, CPI, PCIB, AND EACf for period 6. Indicate the BAC and EACf on the graph. Write a short 2-3 sentence summary of the status of the project, forecasts, and recommended actions. 2 6 5 Exercise 13-50 7 LEGEND ES ID EF SL SL LS DUR LF Schedule Information Activity Dur ES 20 123456 Total LF SL PV 20 20 24 2 2 7 3 6 2 11 3 5 30 270 25 4 4 11 3 16 6 4 7 11 0 20 Baseline Budget Needs - Labor Hours (x 100) Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 0 10 10 16 8 5 5 10 3 25 10 10 2 2 1 4 4 4 4 5 5 6 4 7 2 11 13 0 10 Total PV by period Cumulative PV by period 145 Status Report: Ending Period 1 Task 1 % Complete 50% Cumulative Totals 5 5 EV AC PV CV SV 500 1000 500 1000
Transcribed Image Text:1. Complete the NWD, Schedule table, and baseline budget table. Calculate the status report for periods 1-6. Calculate the indicies and plot EV, AC, PV, SPI, CPI, PCIB, AND EACf for period 6. Indicate the BAC and EACf on the graph. Write a short 2-3 sentence summary of the status of the project, forecasts, and recommended actions. 2 6 5 Exercise 13-50 7 LEGEND ES ID EF SL SL LS DUR LF Schedule Information Activity Dur ES 20 123456 Total LF SL PV 20 20 24 2 2 7 3 6 2 11 3 5 30 270 25 4 4 11 3 16 6 4 7 11 0 20 Baseline Budget Needs - Labor Hours (x 100) Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 0 10 10 16 8 5 5 10 3 25 10 10 2 2 1 4 4 4 4 5 5 6 4 7 2 11 13 0 10 Total PV by period Cumulative PV by period 145 Status Report: Ending Period 1 Task 1 % Complete 50% Cumulative Totals 5 5 EV AC PV CV SV 500 1000 500 1000
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Principles of Management
Principles of Management
Management
ISBN:
9780998625768
Author:
OpenStax
Publisher:
OpenStax College
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Management, Loose-Leaf Version
Management, Loose-Leaf Version
Management
ISBN:
9781305969308
Author:
Richard L. Daft
Publisher:
South-Western College Pub
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
SEE MORE TEXTBOOKS