Question: answers in excel. complete formula and steps please here is the first question. base it here. please answer question 3 only. in excel with formula

answers in excel. complete formula and steps please
answers in excel. complete formula and steps
here is the first question. base it here. please answer question 3 only. in excel with formula please. thank you
answers in excel. complete formula and steps
Question 3 50 Points 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 B 4. 2 2 800 1 5 D 4 J E A 2 $ 2,000 G 1 500 3,000 H 1,500 1.300 1.200 3 2,000 1.000 K 2,500 F 2 1,500 2 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? b. How much incremental cost would be incurred if the client insisted that the audit be completed within 53 days? C. How much incremental cost would be incurred if the client insisted that the audit be completed within 56 days? Note: Allowable Crash days = Normal Time - Crash Time SAVE your EXCEL FILE as Surname Activity 1 Use the editor to format your answer Question 2 10 Points 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(s) A 12 G 6 B.E B 16 H 4 C.D.E 1 24 C.D.G D 12 FH E K 22 F.H F 12 L 1.) 13 14 9 A 24 a. Create a spreadsheet to calculate and summarize the earliest and latest start and finish times, the slack for each activity, and the critical activities. (use any method that will determine the ES, EF, LS, LF and Slack) b. What is the earliest time the audit can be completed? (rename sheet as national 1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!