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

Set up a spreadsheet to solve Problem 1.

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 ($) 1,000 4,000 24,000 1,000 8,000 12,000 1,000 1,000 1,000 TASK START FINISH Mobilization Grubbing Rough Excavate Roadway Grade and Roll Sub Grade Place and Compact Road Base Place and Compact Asphalt Grade Shoulders Clean Up Demobilize 4 4 5 6