PLEASE POST ALL FORMULAS AND SOLUTIONS SO THAT I MAY BETTER UNDERSTAND

IF YOU ARE USING EXCEL, COULD YOU PLEASE SHOW CELL FORMULAS AS WELL!! ~~THANK YOU IN ADVANCE!

14. You are the manager of a project to improve a billing process at your firm. Table 7.70 contains the data you will need to conduct a cost analysis of the project. Indirect costs are $1,600 per week, and penalty costs are $1,200 per week after week 12. a. What is the minimum-cost schedule for this project? b. What is the difference in total project costs between the earliest completion time of the project using normal times and the minimum-cost schedule you derived in part (a)? Table 7.7 Data for the Billing Process Project Activity Immediate Predecessor(s) Normal Time (wks) Crash Time (wks) Normal Cost ($) Crash Cost ($) 4 1 5,000 8,000 B - 5 3 8,000 10,000 C A 1 1 4,000 4,000 D B 6 3 6,000 12,000 E B, C 6 4,000 7,000 F D 7 09 4,000 7,000