10-8 - Higgins Plumbing and Heating Data Table Sales...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Higgins Plumbing and Heating Data Table Sales Distribution Week Sales Sales Run 1 5 0 4 0.12 0.00 0.12 1 6.74 19 2 4 0 5 0.10 0.12 0.22 2 6.74 19 3 7 0 6 0.18 0.22 0.40 3 6.74 19 4 5 0 7 0.24 0.40 0.64 4 6.74 19 5 9 1 8 0.16 0.64 0.80 5 6.74 19 6 4 0 9 0.14 0.80 0.94 6 6.74 19 7 5 0 10 0.06 0.94 1.00 7 6.74 19 8 6 0 8 6.74 19 9 10 1 Supply each week = 8 9 6.74 19 10 7 0 10 6.74 19 11 7 0 (a) 11 6.74 19 12 4 0 Based on 1 replication: 12 6.74 19 13 7 0 Average sales = 6.74 13 6.74 19 14 9 1 No. of stockout weeks = 19 14 6.74 19 15 10 1 15 6.74 19 16 8 0 Based on 200 replications: 16 6.74 19 17 7 0 Average sales = 6.74 17 6.74 19 18 9 1 P(>20 stockout weeks) = 0.0% 18 6.74 19 19 7 0 19 6.74 19 20 6 0 (b) 20 6.74 19 21 6 0 Expected sales = 6.88 21 6.74 19 22 5 0 22 6.74 19 23 10 1 Calculations set to Manual. 23 6.74 19 24 6 0 Press F9 to recalculate. 24 6.74 19 25 6 0 25 6.74 19 26 6 0 26 6.74 19 27 5 0 27 6.74 19 28 8 0 28 6.74 19 29 7 0 29 6.74 19 30 5 0 30 6.74 19 31 4 0 31 6.74 19 32 8 0 32 6.74 19 33 6 0 33 6.74 19 34 7 0 34 6.74 19 35 9 1
Background image of page 1
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.

Ask a homework question - tutors are online