Analyze the following scenario: River County is planning several capital;acquisitions for the coming year. These include the purchase of two new garbage;trucks at $150,000 each, one new bulldozer at $240,000, three new riding lawn;mowers at $16,000 each, and construction of an activity center in the part for;$650,000. The expected lifetime of the various capital items is 10 years for;the garbage trucks, 8 years for the bulldozer, 5 years for the lawn mowers, and;40 years for the activity center. Prepare a capital budget for the items to be;acquired, showing their estimated lifetimes, and their per unit and total costs.;Clearly label the calculations for the required components of the capital;budget using Excel. Use formulas to show the interrelationships and format the;cells to insert a comma if there is more than three numbers and round to the;nearest whole number. Explain your budget to the county council.;Submit to your instructor your two-to-three page Word document (not including;the title and reference pages) and your Excel worksheet. Your paper should be;formatted according to APA style as outlined in the approved APA style guide;and you must cite at least two scholarly sources in addition to the textbook.
Paper#27440 | Written in 18-Jul-2015Price : $42