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 screen shots of the excel spreadsheet and explain how everything is done. You need to use the anlytics solver on Excel fo this question

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!