1. Read through the Case 13.1 Tree Trimming Project Case in Larson and Gray. Respond to Questions 1 and 2 of the case. Use Microsoft Excel to complete this item and include all calculations in your Excel file. Note that showing all calculations in Excel is required.

Tree Trimming ProjectWil Fence is a large timber and Christmas tree farmer who is attending a project man-agement class in the spring, his off season. When the class topic came to earned value, he was perplexed. Isnt he using EV? Each summer Wil hires crews to shear fields of Christmas trees for the coming Holiday season. Shearing entails having a worker use a large machete to shear the branches of the tree into a nice, cone-shaped tree. Wil describes his business as follows:A. I count the number of Douglas Fir Christmas trees in the field (24,000).B. Next, I agree on a contract lump sum for shearing with a crew boss for the whole field ($30,000).C. When partial payment for work completed arrives (5 days later), I count or estimate the actual number sheared (6,000 trees). I take the actual as a percent of the total to be sheared, multiply the percent complete by total contract amount for the partial payment [(6,000/$30,000 = 25%), (.25 $30,000 = $7500)].1. Is Wil over, on, or below cost and schedule? Is Wil using earned value?2. How can Wil set up a scheduling variance?

1. Complete Appendix Exercise 2 at end of Chapter 13 in Larson and Gray. Specifically, complete the table on pp. 509-510 in the textbook (note that SPI and CPI can be determined after the table is completed). Assume that cumulative EV, PV, CV, SV, SPI and CPI values are needed. Also, complete the table at the top of p. 511. At the end of Period 5, what is the status of this project (be specific)?

Given the information provided for development of a catalog product return process for periods 1 through 5, assign the PV values (using the rules) to develop a baseline for the project. Compute the SV, CV, SPI, and CPI for each period. Explain to the owner your assessment of the project at the end of period 5 and the future expected status of the project at the completion.

Chapter 13 Progress and Performance Measurement and Evaluation 509 FIGURE A13.1-2A 0 1 3 3 4 5 2 2 2 2 2 3 5 5 2 7 O 2. 2 2 5 6 7 7 10 1 1 1 1 0 0 1 2 3 3 4 7 7 3 10 Legend ES ID EF O 3 4 4 6 7 0 0 0 0 SL SL 0 4 4 4 3 7 LS DUR LF FIGURE A13.1-2B Schedule information Baseline budget needs Time period EV ACTI DURES Rule WP LF Total PV 1 2 3 4 5 6 7 8 9 10 2 1 3 O 5 2 30 3 2 2 0 1 20 Rule 1 = %complete 2 = 50/50 3=0/100 2 3 4 0 4 0 30 3 4 2 3 7 2 10 5 4 2 7 1 40 (2 (1 6 3 4 70 30 1 7 3 7 10 0 60 Total PV by period Cumulative PV by period EV PV CV SV Status Report: Ending Period 1 Task %Complete 1 40% 2 0% 3 30% Cumulative Totals AC 8 12 10 30 | | | EV PV CV SV Status Report: Ending Period 2 Task %Complete 1 80% 2 Finished 3 50% Cumulative Totals AC 20 18 12 50 | EV PV CV SV Status Report: Ending Period 3 Task %Complete 1 Finished 2 Finished 3 70% 4 0% 5 30% Cumulative Totals AC 27 18 15 5 8 73 EV AC PV CV SV 27 Status Report: Ending Period 4 Task %Complete 1 Finished 2 Finished 3 Finished 4 0% 5 60% Cumulative Totals 18 22 7 22 96 EV PV CV SV Status Report: Ending Period 5 Task %Complete 1 Finished 2 Finished 3 Finished 4 Finished 5 70% 6 30% Cumulative Totals AC 27 18 22 8 24 10 109 240 1 PVC 210 180 1 1 1 1 150 Dollars 120 90 1 60 1 30 0 1 2 3 4 5 6 7 8 9 10 11 12 Time periods Chapter 13 Progress and Performance Measurement and Evaluation 511 Period SPI CPI PCIB 1 2 3 4 5 SPI = EV/AC CPI = EV/AC PCIB = EV/BAC Chapter 13 Progress and Performance Measurement and Evaluation 509 FIGURE A13.1-2A 0 1 3 3 4 5 2 2 2 2 2 3 5 5 2 7 O 2. 2 2 5 6 7 7 10 1 1 1 1 0 0 1 2 3 3 4 7 7 3 10 Legend ES ID EF O 3 4 4 6 7 0 0 0 0 SL SL 0 4 4 4 3 7 LS DUR LF FIGURE A13.1-2B Schedule information Baseline budget needs Time period EV ACTI DURES Rule WP LF Total PV 1 2 3 4 5 6 7 8 9 10 2 1 3 O 5 2 30 3 2 2 0 1 20 Rule 1 = %complete 2 = 50/50 3=0/100 2 3 4 0 4 0 30 3 4 2 3 7 2 10 5 4 2 7 1 40 (2 (1 6 3 4 70 30 1 7 3 7 10 0 60 Total PV by period Cumulative PV by period EV PV CV SV Status Report: Ending Period 1 Task %Complete 1 40% 2 0% 3 30% Cumulative Totals AC 8 12 10 30 | | | EV PV CV SV Status Report: Ending Period 2 Task %Complete 1 80% 2 Finished 3 50% Cumulative Totals AC 20 18 12 50 | EV PV CV SV Status Report: Ending Period 3 Task %Complete 1 Finished 2 Finished 3 70% 4 0% 5 30% Cumulative Totals AC 27 18 15 5 8 73 EV AC PV CV SV 27 Status Report: Ending Period 4 Task %Complete 1 Finished 2 Finished 3 Finished 4 0% 5 60% Cumulative Totals 18 22 7 22 96 EV PV CV SV Status Report: Ending Period 5 Task %Complete 1 Finished 2 Finished 3 Finished 4 Finished 5 70% 6 30% Cumulative Totals AC 27 18 22 8 24 10 109 240 1 PVC 210 180 1 1 1 1 150 Dollars 120 90 1 60 1 30 0 1 2 3 4 5 6 7 8 9 10 11 12 Time periods Chapter 13 Progress and Performance Measurement and Evaluation 511 Period SPI CPI PCIB 1 2 3 4 5 SPI = EV/AC CPI = EV/AC PCIB = EV/BAC