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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
