10-3 - 10-3A Simkin's Hardware Store Calculations set to...

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

View Full Document Right Arrow Icon
10-3A Page 1 Simkin's Hardware Store Calculations set to Manual. Press F9 to recalculate. Demand Distribution Day Demand 1 7 0 7 3 3 4 0 4 1 1 3 $0.08 $0 $20 $20.08 0 0.05 0 0.05 2 4 0 4 2 2 2 0 12 0 0 0 $0.04 $0 $0 $0.04 1 0.10 0.05 0.15 3 2 10 12 3 3 9 0 9 0 0 0 $0.18 $0 $0 $0.18 2 0.20 0.15 0.35 4 9 0 9 3 3 6 0 6 0 0 0 $0.12 $0 $0 $0.12 3 0.40 0.35 0.75 5 6 0 6 2 2 4 0 4 1 2 8 $0.08 $0 $20 $20.08 4 0.15 0.75 0.90 6 4 0 4 4 4 0 0 10 0 0 0 $0.00 $0 $0 $0.00 5 0.10 0.90 1.00 7 0 0 0 4 0 0 4 10 0 0 0 $0.00 $32 $0 $32.00 8 0 10 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 Order quantity, Q 10 9 7 0 7 3 3 4 0 4 1 2 12 $0.08 $0 $20 $20.08 Reorder point, R 5 10 4 0 4 4 4 0 0 10 0 0 0 $0.00 $0 $0 $0.00 11 0 0 0 3 0 0 3 10 0 0 0 $0.00 $24 $0 $24.00 Min leadtime 1 12 0 10 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 Max leadtime 3 13 7 0 7 2 2 5 0 5 1 1 15 $0.10 $0 $20 $20.10 14 5 0 5 3 3 2 0 12 0 0 0 $0.04 $0 $0 $0.04 Holding cost $0.02 15 2 10 12 3 3 9 0 9 0 0 0 $0.18 $0 $0 $0.18 (per unit per day) 16 9 0 9 3 3 6 0 6 0 0 0 $0.12 $0 $0 $0.12 17 6 0 6 2 2 4 0 4 1 3 21 $0.08 $0 $20 $20.08 Stockout cost $8 18 4 0 4 4 4 0 0 10 0 0 0 $0.00 $0 $0 $0.00 (per unit) 19 0 0 0 5 0 0 5 10 0 0 0 $0.00 $40 $0 $40.00 20 0 0 0 2 0 0 2 10 0 0 0 $0.00 $16 $0 $16.00 Order cost $20 21 0 10 10 0 0 10 0 10 0 0 0 $0.20 $0 $0 $0.20 (per order) 22 10 0 10 3 3 7 0 7 0 0 0 $0.14 $0 $0 $0.14 23 7 0 7 4 4 3 0 3 1 2 26 $0.06 $0 $20 $20.06 24 3 0 3 5 3 0 2 10 0 0 0 $0.00 $16 $0 $16.00 25 0 0 0 3 0 0 3 10 0 0 0 $0.00 $24 $0 $24.00 Total per month = $1.78 $152 $120 $273.78 Begin inv Units rec Avail inv Dem- and Demand filled End inv Stock out End inv + Order Place order ? Lead time Arrive on day Hold- ing cost Stock- out cost Order cost Total cost Proba- bility RN intvl lower limit RN intvl upper limit
Background image of page 1

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

View Full DocumentRight Arrow Icon
10-3B Data Table Page 2 Simkin's Hardware Store Data Table Calculations set to Manual. Press F9 to recalculate. Demand Distribution Day Demand Run Total cost 1 7 0 7 3 3 4 0 4 1 3 5 $0.08 $0 $20 $20.08 0 0.05 0 0.05 1 $1.42 $152 $120 $273.42 2 4 0 4 4 4 0 0 10 0 0 0 $0.00 $0 $0 $0.00 1 0.10 0.05 0.15 2 $1.42 $152 $120 $273.42 3 0 0 0 4 0 0 4 10 0 0 0 $0.00 $32 $0 $32.00 2 0.20 0.15 0.35 3 $1.42 $152 $120 $273.42 4 0 0 0 2 0 0 2 10 0 0 0 $0.00 $16 $0 $16.00 3 0.40 0.35 0.75 4 $1.42 $152 $120 $273.42 5 0 10 10 5 5 5 0 5 1 3 9 $0.10 $0 $20 $20.10 4 0.15 0.75 0.90 5 $1.42 $152 $120 $273.42 6 5 0 5 4 4 1 0 11 0 0 0 $0.02 $0 $0 $0.02 5 0.10 0.90 1.00 6 $1.42 $152 $120 $273.42 7 1 0 1 4 1 0 3 10 0 0 0 $0.00 $24 $0 $24.00 7 $1.42 $152 $120 $273.42 8 0 0 0 3 0 0 3 10 0 0 0 $0.00 $24 $0 $24.00 Order quantity, Q
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/10/2011 for the course INSY 4508 taught by Professor Graham during the Spring '10 term at Bentley.

Page1 / 11

10-3 - 10-3A Simkin's Hardware Store Calculations set to...

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