Activity Normal Time (days) Normal Cost ($) Crash Time (days) Crash Cost ($) Immediate Predecessor(s) START 0 0 0 0 - A 7 50 6 180 START B 6 40 2 360 START C 4 70 2 310 B D 8 20 7 110 A, C E 2 30 2 30 A, C F 4 80 2 300 B G 4 50 2 130 D H 9 60 7 100 E, F FINISH 0 0 0 0 G, H

c) calculate the total cost for this project schedule

Please show me how to do step b and c on excel and explain. If it helps I'll gladly like! Thank you.

A B C D E F H J Crash Cost Activity Normal Time (days) Normal Cost ($) Crash Time (days) Max Crash Time Crash Cost/Day Immediate Predecessor (s) ($) 1 2 START 0 0 0 0 6 3 A 7 1 130 START 4 B 6 2 4 80 0 50 40 70 20 30 5 C 4 120 2 7 D 90 6 7 8 8 2 2 1 0 2 0 180 360 310 110 30 300 130 100 0 0 2 2 START B A, C A, C B D E, F G H F 4 80 G 4 2 50 60 2 7 110 40 20 H 9 2 FINISH 0 0 0 0 400 9 10 11 12 13 14 15 16 17 0 total cost 18 19 AEH overhead/day penalty/day if proj duraton > 50 70 ADG BCDG 16 days BCEH 22 21 19 BFH 18 You are in charge of a project at the local community center. The center needs to remodel one of the rooms in time for the start of a new program. Delays in the project mean that the center must rent other space at a nearby church at additional cost. Time and cost data for your project are contained in the table below. Your interest is in minimizing the cost of the project to the community center. Activity Normal Cost ($) Crash Cost ($) Normal Time (days) 0 Immediate Predecessor(s) START A 7 0 50 40 START START B Crash Time (days) 0 6 2 2 7 7 2 2 70 6 4 8 2 B D E F G G H H FINISH 4 0 180 360 310 110 30 300 130 100 0 20 30 80 50 60 0 0 AC AC B D D E, F G H 4 9 2 7 0 0 0 a. Using the normal times for each activity, what is the earliest date you can complete the project? The corresponding project duration using the normal times is 22 days. (Enter your response as an integer.) b. Suppose the variable overhead costs are $50 per day for your project. Also, suppose that the center must pay $70 per day for a temporary room on day 16 or beyond. Find the minimum-cost project schedule. Fill in the table below to show the proper schedule time for each activity after crashing) for completing the project at minimum cost. (Enter your responses as integers.) Activity Time (days) Activity Time (days) E B B DOOD W LUI DO00 G D H