Question:

I need help with the steps of this problem - even Chegg was not detailed enough.

I need step-by-step instruction. for example, I do not know what cell I use the PsiUniform formula in.

If you have Frontline Solver and can provide help by 9am this morning (november 2), please respond

fromSpreadsheet Modeling and Decision Analysis(7th Edition), chapter 12, problem 3

Feel free to ask questions, if any. Thank you

Hungry Hungry Dawg Dawg Restaurants Restaurants Initial Conditions: Number of Covered Employees 18,533 Average Claim per Employee $250 Amount Contributed per Employe $125 Number of Employee Avg Claim Month EmployeesContributions per Emp. 1 19,605 $2,450,607 $251.58 2 19,113 $2,389,120 $254.17 3 19,026 $2,378,243 $257.78 4 18,966 $2,370,770 $262.01 5 18,655 $2,331,845 $261.27 6 19,733 $2,466,582 $261.87 7 19,759 $2,469,840 $268.47 8 20,732 $2,591,545 $272.92 9 20,621 $2,577,617 $274.68 10 21,042 $2,630,224 $278.98 11 21,367 $2,670,816 $280.16 12 22,258 $2,782,252 $280.10 Assumptions: Max Decrease 3.0% Max Increase 7% Mthly Increase1.0% Std Dev $3 Constant Total Company Claims Cost $4,932,101 $2,481,494 $4,857,921 $2,468,801 $4,904,475 $2,526,232 $4,969,326 $2,598,557 $4,873,918 $2,542,074 $5,167,417 $2,700,835 $5,304,650 $2,834,810 $5,658,246 $3,066,701 $5,664,063 $3,086,446 $5,870,224 $3,239,999 $5,986,026 $3,315,209 $6,234,462 $3,452,209 Total Company Cost $34,313,367 insufficient funds? P(insufficient funds) month seasonal factor 1 2 3 4 5 6 7 0.8 0.85 0.87 0.92 0.93 1.15 1.2 Uniform Normal 8 9 10 11 12 1.18 1.03 0.95 0.98 1.14 Confidence Intervals Confidence Intervals Sample Mean Sample Standard Deviation Sample Size Significance Level #NAME? #NAME? 5000 5% 95% LCL for the population mean 95% UCL for the population mean #NAME? #NAME? Target Proportion 95% Lower Confidence Limit 95% Upper Confidence Limit 0.900 0.892 0.908 Page 3