## 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.

## Answers

Answer As per the given information we can say that » wil is on the schedule. The money spend by the 5th day is directly Proportional to the labor of shearing his troos for the five days o - The estimates of the budget for 5 days also meet the amount of work done. → By the 5th day the crow shearing the fields have completed 25% of the total task/job to be completed. - This is said by taking or considering the Percentage of the work done ie (6000 trees) over the whole project work ire (Quooo trees) - This is the very first payout of wil to the workers - The money to be paid is 25% of budgeted cost of scheduled work. - If this trend is to be continued to the end of projet, wil will have completed ie in the work time and paid accomplished the workers in full. > This shows the planned value of Shearing field and wil would pay his crew by the end when they finish shearing.2. Wil can set up the schedule to finish the tasks in a less demanding way by regular checkpoints and milestones accompli. shed by the end of period. The milestones should be come with a set of ideas of deliverables to measure the work done For example the milestone can be as five and days deliverables as can be no. of trees he wants to be shorn.com we can say that when there is a certain amount of difference of cost incurred for a certain amount of work accomplished (to be and the actual budget is called cost varian -ce. This shows by which degree is the Project completed or falling behind in the estimated budget drawn one of

#### Similar Solved Questions

1 answers

##### 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 ...

1 answers

##### 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...

1 answers

##### 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 ...

1 answers

##### 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...

1 answers

##### Warwick's Co, a women's clothing store, purchased $22,000 of merchandise from a supplier on account, terms...

Warwick's Co, a women's clothing store, purchased $22,000 of merchandise from a supplier on account, terms FOB destination, 1/10, n/30. Warwick's returned $3,100 of the merchandise, recelving a credit memo. a. Journalize Warwick's Co.'s entry to record the purchase. Inventory 21,...

1 answers

##### 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 ...

1 answers

##### How do you simplify #-\frac{15}{20} - \frac{4}{5}#?

How do you simplify #-\frac{15}{20} - \frac{4}{5}#?...

1 answers

##### 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 ...

1 answers

##### 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...

1 answers

##### 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...

1 answers

##### 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 ...

1 answers

##### 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...

1 answers

##### 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...

1 answers

##### 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, ...

1 answers

##### Problem: The current in and the voltage across a 5 Hinductor are known to be zero...

Problem: The current in and the voltage across a 5 Hinductor are known to be zero fort <= 0. The voltage across the inductor is given by the graph in fort >= 0. A. Write the expressions that describe the current i(t) in piece-wise linear representation in suitable intervals. Find the current ...

1 answers

##### More time on the Internet: A researcher polled a sample of 1080 adults in the year...

More time on the Internet: A researcher polled a sample of 1080 adults in the year 2010, asking them how many hours per week they spent on the Internet. The sample mean was 9.62 with a standard deviation of 13.27. A second sample of 1037 adults was taken in the year 2012. For this sample, the mean w...

1 answers

##### Book: Computer Security: Principles and Practice, 4th Edition, Authors: William Stallings and Law...

Book: Computer Security: Principles and Practice, 4th Edition, Authors: William Stallings and Lawrie BrownWilliam Stallings • Lawrie Brown Problem: 27.11(12) – When you review the list of products evaluated against the Common Criteria, such as that found on the Common Criteria Portal webs...

1 answers

##### Why is it important to make patient education materials easy to comprehend 150 words.

Why is it important to make patient education materials easy to comprehend 150 words....