Question: 1 5 . 8 . Generate a sensitivity chart. Based on this chart, which two activities have the largest impact on the project completion time?
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, percent of the employees did not file any health insurance claims, percent filed only a small claim, and percent filed a large claim. The small claims were spread uniformly between and $ whereas the large claims were spread uniformly between $ and $ 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
