Set up a spreadsheet to solve Problem 2. Determine the estimated cost of the work performed each
Question:
Set up a spreadsheet to solve Problem 2.
Determine the estimated cost of the work performed each week given the tasks—with their associated costs and schedules—shown in the following table.
When a task spans more than one week, the costs should be divided equally among theweeks.
Transcribed Image Text:
WEEK COST ($) 2,200 19,600 TASK START FINISH Excavation Footings and Foundation Waterproofing Backfill and Under Slab Gravel Slab on Grade Masonry Structural Steel Joist and Deck Hollow Metal Doors and Hardware Overhead Doors Skylights Roof Insulation Membrane Roofing Heating Electrical Cleanup 900 2,000 22,300 54,000 2,400 11,900 2,100 10,100 5,800 5,600 13,000 15,600 29,800 1,000 4 4 8 8 9 9 10 10 10 10 12 12 12
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 60% (10 reviews)
Task Cost Dur Start Finish Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 ...View the full answer
Answered By
Michael Owens
I am a competent Software Engineer with sufficient experience in web applications development using the following programming languages:-
HTML5, CSS3, PHP, JAVASCRIPT, TYPESCRIPT AND SQL.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Construction accounting and financial management
ISBN: 978-0135017111
2nd Edition
Authors: Steven j. Peterson
Question Posted:
Students also viewed these Finance questions
-
Determine the estimated cost of the work performed each week given the taskswith their associated costs and schedulesshown in the following table. When a task spans more than one week, the costs...
-
Determine the estimated cost of the work performed each week given the taskswith their associated costs and schedulesshown in the following table. When a task spans more than one week, the costs...
-
Set up a spreadsheet to solve Problem 1. Determine the estimated cost of the work performed each week given the taskswith their associated costs and schedulesshown in the following table. When a task...
-
Find the minimum and maximum values of (x, y) = x 2 y on the ellipse 4x 2 + 9y 2 = 36.
-
In atoms there is a finite, though very small, probability that, at some instant, an orbital electron will actually be found inside the nucleus. In fact, some unstable nuclei use this occasional...
-
A plumb bob (a mass m hanging on a string) is deflected from the vertical by an angle due to a massive mountain nearby (Fig. 5-44). (a) Find an approximate formula for θ in terms of the mass of...
-
What adverse effects on the domestic economy may follow from (a) a depreciation of the exchange rate and (b) an appreciation of the exchange rate?
-
The management team of Magnificent Modems, Inc. (MMI), wants to investigate the effect of several different growth rates on sales and cash receipts. Cash sales for the month of January are expected...
-
Why do you think neither Nespresso nor Sara Lee jumped at the opportunity to complete the development of Handpresso?
-
Hallam, Price, and Katsarou (2002) investigated the influence of background noise on classroom performance for children aged 10 to 12. In one part of the study, calming music led to better...
-
Determine the total estimated cost at completion and estimated cost to complete for the project in Problem 6, assuming the cost performance index remains the same through the remainder of the job. In...
-
Determine the annual cost, average hourly cost, and burden markup of an hourly employee given the following information. Assume the employee takes full advantage of the 401(k) benefit. The employees...
-
On May 1, Interstate Distribution Company is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest...
-
Discuss major theoretical or empirical developments in the evolution of organizational behaviour.
-
How did the COVID- 19 pandemic affect worldwide air transportation supply and demand?
-
What is the diference between behaviourism and psychoanalysis?
-
What factors drive long- term global and regional air travel demand? Supply?
-
Discuss the difference between reinforcement and socialization in the context of a behavioural perspective on personality.
-
A particle moves in a straight line with the given velocity (in meters per second). Find the displacement and distance traveled over the time interval, and draw a motion diagram like Figure 3 (with...
-
The MIT Sloan School of Management is one of the leading business schools in the U.S. The following table contains the tuition data for the masters program in the Sloan School of Management. a. Use...
-
In 2019, Ollie Lingo and his wife have several endowment life insurance policies. On the first, which begins payment in 2020, but was fully paid by 2010, a dividend of $200 is declared and paid. On...
-
Due to a recession, the inflation rate expected for the coming year is only 3 percent. However, the inflation rate in Year 2 and thereafter is expected to be constant at some level above 3 percent....
-
Suppose you and most other investors expect the inflation rate to be 7 percent next year, to fall to 5 percent during the following year, and then to remain at a rate of 3 percent thereafter. Assume...
-
Define each of the following terms: a. PV; i; INT; FVn; PVAn; FVAn; PMT; m; iNom b. FVIFi,n; PVIFi,n; FVIFAi,n; PVIFAi,n c. Opportunity cost rate d. Annuity; lump sum payment; cash flow; uneven cash...
-
Company C issues $10 million of five-year, 10 per cent, semi-annual coupon debentures to the public (which pay interest each six months). The market also requires a rate of return of 10 per cent....
-
You are presented with a trial balance as of the end of 2018 and must add the transactions and activities that occurred in the first quarter of 2019 as listed below. You can add accounts to the trial...
-
At the beginning of the year, Teal Corporation had E & P of $210,000. On March 30, Teal sold an asset at a loss of $200,000. For the calendar year, Teal incurred a deficit in current E & P of...
Study smarter with the SolutionInn App