Create a cost-loaded spreadsheet like the one shown in Figure 7-5 . The spreadsheet should handle 12 weeks and 20 tasks.

Data From Figure 7-5

Transcribed Image Text:

Task Mobilization Cost Start Finish Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 2,000 Week 1 Week 1 2,000 Grubbing 5,000 Week 1 Week 1 5,000 Bridge Excavation 2,000 Week 2 Week 2 2,000 Install Prefabricated Bridge 47,000 Week 2 Week 2 47,000 Back Fill Bridge 2,000 Week 2 Week 2 2,000 Install Culverts 10,000 Week 3 Week 3 Rough Excavate Roadway 112,000 Week 3 Week 6 10,000 28,000 28,000 28,000 28,000 Install Sanitary Sewer 57,000 Week 6 Week 7 28,500 28,500 Install Water Lines 69,000 Week 7 Week 8 34,500 34,500 Install Storm Drains 15,000 Week 8 Week 8 15,000 Grade and Roll Sub Grade 12,000 Week 8 Week 9 6,000 6,000 Place and Compact Road Base 42,000 Week 9 Week 9 42,000 Place and Compact Asphalt 48,000 Week 9 Week 9 48,000 Grade Shoulders Clean Up Demobilize 3,000 Week 10 Week 10. 3,000 1,000 Week 10 Week 10 1,000 2,000 Week 10 Week 10 2,000 429,000 7,000 51,000 38,000 28,000 28,000 56,500 63,000 55,500 96,000 6,000