Fig12-6 - #NAME? Hungry Dawg Restaurants This model colored...

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 $125 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
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: #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

This note was uploaded on 04/19/2011 for the course CBA 0060 taught by Professor Barrymitnick during the Spring '09 term at Pittsburgh.

Page1 / 3

Fig12-6 - #NAME? Hungry Dawg Restaurants This model colored...

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