Simkin's Hardware Store (Using Crystal Ball)

Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values.

ing bility O 01 N 01 01 01 WN + OOOOOO AVON 01 OOON O O O O 1974 ON w w 01 oo o W 01 10 5 Simkin's Hardware Store (Using Crystal Ball) Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values. Dem Distribution End Place Lea Arrive Hold- Stock- Begi Units Avail Dem- Deman End Stock inv + order d on out Orde Total Deman Proba- Day niny rec inv and d filled iny out Order ? time day cost cost r cost cost d 1 7 7 2 2 5 0 5 1 3 5 $0.10 $0 $20 $20.10 0 0.05 2 5 5 3 3 2 12 0 0 $0.04 $0 $0 $0.04 1 0.10 2 2 1 1 11 0 0 0 $0.02 $0 $0 $0.02 2 0.20 4 1 3 1 0 2 10 0 0 $0.00 $16 $0 $16.00 3 0.40 5 10 10 3 3 7 0 0 0 $0.14 $0 $0 $0.14 4 0.15 6 7 7 3 3 4 0 1 1 8 $0.08 $0 $20 $20.08 0.10 7 4 0 4 3 3 1 11 0 0 0 $0.02 $0 $0 $0.02 8 1 10 11 5 5 6 0 6 0 0 0 $0.12 $0 $0 $0.12 Order quantity, Q 6 0 6 3 3 0 3 2 12 $0.06 $0 $20 $20.06 Reorder point, R 10 3 0 3 3 3 0 0 10 0 0 0 $0.00 $0 $0 $0.00 11 0 0 0 4 0 0 4 10 0 0 0 $0.00 $32 $0 $32.00 Min leadtime 12 0 10 10 3 7 0 7 0 0 0 $0.14 $0 $0.14 Max leadtime 13 7 0 7 3 3 4 0 4 1 2 16 $0.08 $0 $20 $20.08 14 4 0 4 3 3 1 0 11 0 0 0 $0.02 $0 $0 $0.02 Holding cost 15 1 0 1 1 1 0 0 10 0 0 0 $0.00 $0 $0.00 (per unit per day) 16 0 10 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 17 7 0 7 4 4 3 0 3 1 1 19 $0.06 $0 $20 $20.06 Stockout cost 18 3 0 3 4 3 0 1 10 0 0 0 $0.00 $8 $0 $8.00 (per unit) 19 10 10 1 1 9 0 9 0 0 0 $0.18 $0 $0 $0.18 20 0 3 3 6 0 6 0 0 0 $0.12 $0 $0 $0.121 Order cost 21 6 0 6 4 4 2 0 2 1 1 23 $0.04 $0 $20 $20.04 (per order) 22 2 0 2 2 0 3 10 0 0 0 $0.00 $24 $0 $24.00 23 10 10 2 2 8 0 8 0 0 0 $0.16 $0 $0 $0.16 24 8 3 3 5 0 5 1 2 27 $0.10 $0 $20 $20.10| 25 5 0 1 1 4 0 14 0 0 0 $0.08 $0 $0 $0.08 Total per month = $1.70 $80 $140 $221.70 O DO ON 3 $0 1 3 $0.02 $0 $8 c 01 00 ON O O OVO $20 01 OOONOW O NN A 01 ONO O O AO CO O NO O o ing bility O 01 N 01 01 01 WN + OOOOOO AVON 01 OOON O O O O 1974 ON w w 01 oo o W 01 10 5 Simkin's Hardware Store (Using Crystal Ball) Calculations set to Manual. Run model using Crystal Ball to recalculate simulation values. Dem Distribution End Place Lea Arrive Hold- Stock- Begi Units Avail Dem- Deman End Stock inv + order d on out Orde Total Deman Proba- Day niny rec inv and d filled iny out Order ? time day cost cost r cost cost d 1 7 7 2 2 5 0 5 1 3 5 $0.10 $0 $20 $20.10 0 0.05 2 5 5 3 3 2 12 0 0 $0.04 $0 $0 $0.04 1 0.10 2 2 1 1 11 0 0 0 $0.02 $0 $0 $0.02 2 0.20 4 1 3 1 0 2 10 0 0 $0.00 $16 $0 $16.00 3 0.40 5 10 10 3 3 7 0 0 0 $0.14 $0 $0 $0.14 4 0.15 6 7 7 3 3 4 0 1 1 8 $0.08 $0 $20 $20.08 0.10 7 4 0 4 3 3 1 11 0 0 0 $0.02 $0 $0 $0.02 8 1 10 11 5 5 6 0 6 0 0 0 $0.12 $0 $0 $0.12 Order quantity, Q 6 0 6 3 3 0 3 2 12 $0.06 $0 $20 $20.06 Reorder point, R 10 3 0 3 3 3 0 0 10 0 0 0 $0.00 $0 $0 $0.00 11 0 0 0 4 0 0 4 10 0 0 0 $0.00 $32 $0 $32.00 Min leadtime 12 0 10 10 3 7 0 7 0 0 0 $0.14 $0 $0.14 Max leadtime 13 7 0 7 3 3 4 0 4 1 2 16 $0.08 $0 $20 $20.08 14 4 0 4 3 3 1 0 11 0 0 0 $0.02 $0 $0 $0.02 Holding cost 15 1 0 1 1 1 0 0 10 0 0 0 $0.00 $0 $0.00 (per unit per day) 16 0 10 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 17 7 0 7 4 4 3 0 3 1 1 19 $0.06 $0 $20 $20.06 Stockout cost 18 3 0 3 4 3 0 1 10 0 0 0 $0.00 $8 $0 $8.00 (per unit) 19 10 10 1 1 9 0 9 0 0 0 $0.18 $0 $0 $0.18 20 0 3 3 6 0 6 0 0 0 $0.12 $0 $0 $0.121 Order cost 21 6 0 6 4 4 2 0 2 1 1 23 $0.04 $0 $20 $20.04 (per order) 22 2 0 2 2 0 3 10 0 0 0 $0.00 $24 $0 $24.00 23 10 10 2 2 8 0 8 0 0 0 $0.16 $0 $0 $0.16 24 8 3 3 5 0 5 1 2 27 $0.10 $0 $20 $20.10| 25 5 0 1 1 4 0 14 0 0 0 $0.08 $0 $0 $0.08 Total per month = $1.70 $80 $140 $221.70 O DO ON 3 $0 1 3 $0.02 $0 $8 c 01 00 ON O O OVO $20 01 OOONOW O NN A 01 ONO O O AO CO O NO O o