LE 6A Customer Demand Sim Basics KEY

Your Name What is your team name? Purpose Each team member understands how to do calculations for th 1 Forecast demand a. Download demand for last 50 days onto the tab below labeled "Da b. Average demand = 12.24 jobs a day c. Standard deviation of demand = 3.4378446024 jobs/day d. Put scatter diagram of demand with trendline below 15 20 25 Demand

2 From the "Data" sheet enter the average demand for 10 day periods requested For example, the average 10 demand on Day 10 is the average demand from z= 0.50 1.00 DAY 10 20 30 40 50 3 Make a line graph of "Average Demand", "Maximum Demand and "Average Paste below. 4 Download the job completion data onto the "Data" sheet. Average Demand Maximum Demand Average Demand + 0.5 standard deviation Average Demand + 1 standard deviation 0 10 20 30 40 50 60 0 5 10 15

LE 6ACustomer Demand Sim Basics he simulation. ata"

d Day 1 through Day 10 1.50 2.00 3.00 AverMaximum Demand ### #N/A ### #N/A ### #N/A ### #N/A ### #N/A e Demand + 1.5 Standard Deviation" Average Demand + 1.5 standard deviation Average Demand + 2.0 standard deviation Average Demand + 3.0 standard deviation

1 6 0 0 Job Arrivals 2 8 0 0 1 13 6 3 11 0 0 2 15 14 4 10 0 0 3 8 25 5 12 0 0 4 19 35 6 10 0 0 5 14 47 7 11 0 0 6 15 57 8 10 0 0 7 12 68 9 11 0 0 8 14 78 10 10 0 0 9 10 89 11 12 0 0 10 6 99 12 12 0 0 11 11 111 13 11 0 0 12 15 123 14 10 0 0 13 10 134 15 14 0 0 14 14 144 16 10 0 0 15 13 158 17 10 0 0 16 11 168 18 7 0 0 17 14 178 19 9 0 0 18 17 185 20 6 0 0 19 13 194 21 9 0 0 20 18 200 22 11 0 0 21 9 209 23 11 0 0 22 16 220 24 9 0 0 23 14 231 25 10 0 0 24 16 240 26 9 0 0 25 4 250 27 11 0 0 26 10 259 28 9 0 0 27 6 270 29 11 0 0 28 10 279 30 10 0 0 29 7 290 31 12 0 0 30 9 300 32 11 0 0 31 15 312 33 12 0 0 32 13 323 34 12 0 0 33 20 335 35 12 0 0 34 16 347 36 14 0 0 35 15 359 37 12 0 0 36 11 373 38 10 0 0 37 12 385 39 11 0 0 38 12 395 40 10 0 0 39 11 406 41 10 0 0 40 12 416 42 11 0 0 41 14 426 43 11 0 0 42 8 437 44 10 0 0 43 14 448 45 11 0 0 44 12 458

13 28 36 55 69 84 96 110 120 126 137 152 162 176 189 200 214 231 244 262 271 287 301 317 321 331 337 347 354 363 378 391 411 427 442 453 465 477 488 500 514 522 536 548 0 10 20 30 40 50 60 0 5 10 15 20 25 Chart Title

556 569 577 586 601 612