Question: Complete answers please Use Excel for the answer please A national accounting firm has identified the following set of activities that must occur to carry
Complete answers please
A national accounting firm has identified the following set of activities that must occur to carry out an audit for one of their major clients. Activity Days Required Predecessor(s) Activity Days Required Predecssor (5) 12 G 6 B.E B 16 H 4 C.DE c 13 A 1 24 C.D.G D 14 A J 12 FH E 9 K 22 F.H F 12 L 8 1.J . Refer to the previous question. Suppose that each of the audit activities can be crashed by the amounts indicated in the following table Activity AllowableCrash Days Cost per Day Activity Allowable Crash Days Cost per Day 4 2 $ 2,000 G 1 500 B 3,000 H 2 1.500 2 800 1 5 1,300 D 4 1.200 J 3 2,000 E 2 1.000 K 2.500 F 2 1.500 L 1.200 Use EXCEL SOLVER to answer the following questions a. What is the earliest the audit could be completed (using crash time) and associated incremental cost for this earliest completion time? 4 2 Use Excel for the answer please

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
