1

# Complete the following items for this assignment: 1. Read through the Case 13.1 Tree Trimming Project...

## Question

###### Complete the following items for this assignment: 1. Read through the Case 13.1 Tree Trimming Project...
Complete the following items for this assignment: 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. 2. 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 th 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)? 3. Discuss a strategy that you would use to communicate the status of the project to stakeholders. 4. Use Microsoft Excel to complete this item and include all calculations in your Excel file. Note that showing all calculations in Excel is required.
Case 13.1 Tree Trimming Project Wil 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. Isn't 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 x $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?
Available TABLE A2.2 Resources Availability and Pay Rates ܟ ܩ 10 Resource Marketing staff R&D Engineering Purchasing Quality engineers Designers Legal staff Production ction Abbrev MRKT R&D ENG PURCH QUAL DESIGN LEGAL PROD Hourly rate $80/hr$ 80/hr $100/hr$ 60/hr $80/hr$ 60/hr $120/hr$ 60/hr Include a Gantt chart with the schedule table after leveling outside of slack. Note: No splitting of activities is allowed. Note: No partial assignments (e.g., 50 percent). All resources must be assigned 100 percent. Part 3 Top management has accepted the July 19th completion schedule created at the end of Part 2. Prepare a brief memo that addresses the following questions: 1. How much will the project cost? What is the most expensive activity? 2. What does the cash flow statement tell you about how costs are distributed over the life span of the project? Include a monthly cash flow for the project.

#### Similar Solved Questions

##### Go to the internet and find anews article published within the last three months that discusses U.S. economic growth,...
Go to the internet and find anews article published within the last three months that discusses U.S. economic growth, summarize key points and post your response in the Discussions area. Reflection – the students also should include a paragraph in the initial response ...
##### Need help with question 9 please!!!!! Quantity of jets demanded Quantity of jets supplied Price of...
Need help with question 9 please!!!!! Quantity of jets demanded Quantity of jets supplied Price of Jet (millions) 140 120 110 100 90 80 70 60 50 40 20 100 150 200 250 300 350 400 450 500 600 1200 1000 900 800 700 600 500 400 300 200 0 2 2Z 2oo Irot unnly and demand curves. What are the equilibr...
##### You are visiting overnight with family relatives that you have not seen for some time. They...
You are visiting overnight with family relatives that you have not seen for some time. They have learned that you are studying nutrition and ask for some advice. The father of the family (your uncle, Bob) is obese and has recently been diagnosed as pre-diabetic, while the mother of the family (your ...
##### The Cherry corporation produces two models of notebook computers: model A at 8.4 inches and model...
The Cherry corporation produces two models of notebook computers: model A at 8.4 inches and model B at 10.7 inches. Let x be the number of A models and y the number of B models produced at a particular factory per week If the factory can produce at most 700 A and B models combined in a week, write i...
##### When an industry has many firms, the industry is an oligopoly if the firms sell differentiated...
When an industry has many firms, the industry is an oligopoly if the firms sell differentiated products, but it is monopolistically competitive if the firms sell identical products. perfectly competitive if the firms sell differentiated products, but it is monopolistically competitive if ...
##### How do you simplify #-\frac{15}{20} - \frac{4}{5}#?
How do you simplify #-\frac{15}{20} - \frac{4}{5}#?...
##### Let x deterrnine a randorm varable, and u use your kowledge of prabablity to prepare a...
Let x deterrnine a randorm varable, and u use your kowledge of prabablity to prepare a probability dstribution a probability dstribu A family has twa children and the number of boys is recorded (Assurme an equal chance of a bay or girl for each birth) Complete the prabability distribution P(x) Type ...
##### Ngs you will do during the next m P-16, What is wrong with this solution? The...
ngs you will do during the next m P-16, What is wrong with this solution? The ieversible liquid phase second ative thinking skills. that will increase your cre- order reaction kC is carried out in a CSTR、The entering concentration of A, CAP is 2 molar. and the exit concentration of A. CA is 0...
##### When conducting a hypothesis test about a single mean, at a given level of significance, holding...
When conducting a hypothesis test about a single mean, at a given level of significance, holding all other relevant factors constant, using a sample of n = 29 will result in a rejection region than using a sample of n = 10 TE Point Answer Tables Keypad Wider Neither answer above they will be the sam...
##### Answer given is No=-3500rpm Figure 4.8(C) shows the top half of a compound epicydic gearset. If...
Answer given is No=-3500rpm Figure 4.8(C) shows the top half of a compound epicydic gearset. If the input shaft . is rotating at 4500 rpm and the Annulus gear A, rotating at 4500 rpm, determine the speed and direction of the output shaft, o. Given number of teeth : A1 (internal) = 100 ; Su = 50; Az ...
##### Of ARKANSAS AT PINE BLUFF NA DEPARTMENT OF MATHEMATICS AND COMPUTER SCIENCE Linear Equations Name: 1....
of ARKANSAS AT PINE BLUFF NA DEPARTMENT OF MATHEMATICS AND COMPUTER SCIENCE Linear Equations Name: 1. Write the standard form equation of the line connecting the points (-2, 6) and (4,-4). 2. Write the slope-intercept form equation of the line connecting the points (-4, 4) and (4,10). Write the equa...
##### Question 9 Not yet answered Marked out of 2.00 P Flag question A particle starts from...
Question 9 Not yet answered Marked out of 2.00 P Flag question A particle starts from rest and travels along a straight line with an acceleration a = (30 – 0.2v) ft/s?, where v is in ft/s. Determine the time when the velocity of the particle is v = 30 ft/s. Select one a 3.32 s b. 305 None d. 1...
##### 3. (points 10) We have that XAB+A B.D+A B (does not have hi-Z for any input...
3. (points 10) We have that XAB+A B.D+A B (does not have hi-Z for any input combination). a) Determine appropriate values for In1, In2, In3, In4, In5, In6, In7 and In8 (fill the following table) In6 In7 In8 Inl In2 In3 In4 In5 b) Give an implementation for netl using 6 n-MOS transistors. Only A, B, ...