scenario: River County

profileneel
 (Not rated)
 (Not rated)
Chat

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. 

    • 8 years ago
    river county
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      river_county_and_capital_budgeting.docx
    • attachment
      capital_budgeting.xlsx