Question: *please do in Excel and show formulas because I don't understand the formulas, thank you. Excel spreadsheet - Create an Excel spreadsheet depicting Exhibit 4.6


*please do in Excel and show formulas because I don't understand the formulas, thank you.
Excel spreadsheet - Create an Excel spreadsheet depicting Exhibit 4.6 in Example 4.2 in the textbook. To obtain credit you must use formulas for all computations of the "Expected Time" and "Activity Variance". exhibit 4.6 Activity Expected Times and Variances Activity Designation Time Estimates a b Expected Times (ET) Activity Variance (4) a + 4m + b Activity 6 A 10 22 28 21 9 B 4 4 10 5 1 C 4 6 14 7 2.7778 Design Build prototype Evaluate equipment Test prototype Write report Write methods report D 1 2 3 2 0.1111 E 1 5 9 5 1.7778 F 7 8 9 8 0.1111 Write final report N 2 N 2 0Step 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
