Page 1 of 1
Simulation of Walton's bookstore Cost data Unit cost Unit price Unit refund # of iterations 5000 Demand -normal distribu
Posted: Wed Mar 09, 2022 9:06 am
by answerhappygod
- Simulation Of Walton S Bookstore Cost Data Unit Cost Unit Price Unit Refund Of Iterations 5000 Demand Normal Distribu 1 (56.62 KiB) Viewed 50 times
Simulation of Walton's bookstore Cost data Unit cost Unit price Unit refund # of iterations 5000 Demand -normal distribution Mean 175 Standard Deviati 50 $7.50 $10.00 $2.50 -$742.50 $375.00 $299.48 17.2% 8.6% Decision variable Order quantity 150, Data Table ? x min profit max profit mean profit Prob(profit<200) Prob(losing mor Prob(50<profit<200) Possible Q $ (742.5) $ 375.0 $ 299.5 17.2% 6.4% 8.6% 120 $ (712.5) $ 300.0 $ 273.7 8.3% 2.5% 5.0% 130 $ (597.5) $ 325.0 $ 288.7 10.3% 3.5% 5.3% 140 $ (722.5) $ 350.0$ 292.8 14.2% 5.2% 7.4% 1500 $ (877.5) $ 375.0$ 298.6 17.8% 6.8% 8.9% 160 $ (740.0) $ 400.0$ 301.0 19.6% 8.7% 8.6% 1701 $ (700.0) $ 425.0$ 292.9 23.8% 11.5% 9.4% 180 $ (810.0) $ 450.0 $ 277.6 28.0% 13.5% 11.2% 190 $ (972.5$ 475.0 $ 260.7 33.4% 16.5% 13.1% 200 $ (1.225.0) $ 500.0$ 245.0 36.6% 19.2% 13.2% 210 $ (930.0) $ 525.0 $ 220.3 42.0% 23.0% 14.6% Summary measures for simulation below Average profit $299.48 Stdev of profit $154.48 Minimum profit $742.50 Maximum profit $375.00 Prob(profit<200) 17.2% Prob(losing money 6.4% Prob(50<profit<20 8.6% δΈ Row input cell: Column input cell: SB59 Possible Q 120 130 140 150 160 170 180 190 200 210 1 OK Cancel