Set up a spreadsheet to solve Problem 2. Determine the estimated cost of the work performed each week given the taskswith their associated costs and

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.

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