Question: 1 5 . 8 . Generate a sensitivity chart. Based on this chart, which two activities have the largest impact on the project completion time?

15.8. Generate a sensitivity chart. Based on this chart, which two activities have the largest impact on the project completion time? The employees of General Manufacturing Corp. receive health insurance through a group plan issued by Wellnet. During the past year, 40 percent of the employees did not file any health insurance claims, 40 percent filed only a small claim, and 20 percent filed a large claim. The small claims were spread uniformly between 0 and $2,000, whereas the large claims were spread uniformly between $2,000 and $20,000. Based on this experience, Wellnet now is negotiating the corporations premium payment per employee for the upcoming year. To obtain a close estimate of the average cost of insurance coverage for the corporations employees, use Analytic Solver to perform 1,000 trials of a computer simulation of an employees health insurance experience on a spreadsheet. Generate a frequency chart and a statistics table.
Please show a screen shots of the excel spreadsheet and explain how everything is done

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!