Highways
Spreadsheet Series



Resources

Evaluation

Task

You are part of a accounting team for Southwest Building and Roadwork Inc.  Your company has just won a bid to resurface a section of highway between Zuni Pueblo and Grants along a section of highway 53.  It must meet federal and state requirements or it will have to be done again.  You will need to prepare a spreadsheet because there may be changes in cost/amount of materials.
    

Here are the particulars of the contract:
Length of road  ............................5 Miles
Location........................................ between Pine Hill turnoff & El Moro turnoff.
Starting date.................................18 August 2009
Completion date...........................2   October 2009

Materials Required:

Course gravel -------------------------- 400 tons per mile
Fine gravel--------------------------------285 tons per mile
Asphalt-------------------------------------100 standard load
Equipment rental------------------------Total machines
Fuel & Lubricants-----------------------245 gal per day
Personnel Pay----------------------------128
 Cost per tone     $5.00
 Cost per tone     $8.75
 Cost per load     $32.00
 Equipment  Cost   $750.00 per day
 Fuel cost @ $2.25
Ave cost per person  $250

      
You boss, Mr. Matarazzo, (a very nice person) needs to be able to tell the Board of  Directors, the approximate cost of the project using the figures above.  Do not be surprised if there are changes.

He will want to see:

Be careful,  both yours and Mr. Matarazzo's job depend upon good data.  As a result, don't be surprised if your boss wants to know how you arrived at the figures you have.


Process

How many days do you have?
For the aggarates - break it down