Fig12-17 - $39,000,000 P(Cost >Target Value)...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Initial Conditions: Assumptions: Number of Covered Employees 18,533 Max Decrease 3.0% Max Increase 7% Uniform Average Claim per Employee $250 Mthly Increase 1.0% Std Dev $3 Normal Amount Contributed per Employee $132 Constant Number of Employee Avg Claim Total Company Month Employees Contributions per Emp. Claims Cost 1 #NAME? #NAME? #NAME? #NAME? #NAME? 2 #NAME? #NAME? #NAME? #NAME? #NAME? 3 #NAME? #NAME? #NAME? #NAME? #NAME? 4 #NAME? #NAME? #NAME? #NAME? #NAME? 5 #NAME? #NAME? #NAME? #NAME? #NAME? 6 #NAME? #NAME? #NAME? #NAME? #NAME? 7 #NAME? #NAME? #NAME? #NAME? #NAME? 8 #NAME? #NAME? #NAME? #NAME? #NAME? 9 #NAME? #NAME? #NAME? #NAME? #NAME? 10 #NAME? #NAME? #NAME? #NAME? #NAME? 11 #NAME? #NAME? #NAME? #NAME? #NAME? 12 #NAME? #NAME? #NAME? #NAME? #NAME? Total Company Cost #NAME? Target Value
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $39,000,000 P(Cost >Target Value) #NAME? Hungry Dawg Restaurants This model colored red different c company mig total compa G23) change uses RNGs (in the cells d) to randomly generate cost scenarios that the ght face. Note how the any cost value (cell es when you press F9. Confidence Intervals Page 3 Confidence Intervals Sample Mean #NAME? Sample Standard Deviation #NAME? Sample Size 5000 Significance Level 5% 95% LCL for the population mean #NAME? 95% UCL for the population mean #NAME? Target Proportion 0.900 95% Lower Confidence Limit 0.892 95% Upper Confidence Limit 0.908...
View Full Document

Page1 / 3

Fig12-17 - $39,000,000 P(Cost >Target Value)...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online