Supply Chan

Lesson 05 count oning & Smoothing Methods Solutions Solved Problem #1: involve school text book Solved Problem #2: see textbook (manual example using seasonal relatives) Solved Problem #3: see textbook Solved Problem #4: see textbook (you do not perplex to do this caper manually, use the template and notice how the template answers differ meagrely from the seasonal relatives provided in the manual example) To avoid manually entering the data into the templates it can be copied and pasted from Data Sets on the Lesson Page. Use copy, paste special, values to transfer the data to the template. #1: A commercial bakery has recorded sales (in dozens) for tether products, as shown below. Blueberry Muffins 30 34 32 34 35 30 34 36 29 31 35 31 37 34 33 cinnamon buns 18 17 19 19 22 23 23 25 24 26 27 28 29 31 33

solar day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 a.

Cupcakes 45 26 27 23 22 48 29 20 14 18 47 26 27 24 22

Determine the Naïve betoken for day 16. Blueberry Muffins 33 Cinnamon buns 33

Day 16 b.

Cupcakes 22

What does the use of sales data rather than essential data imply? gross sales data does not sop up into account the demand which may have been greater than the certain sales. If the demand was actually greater than sales and the bakery could have met that demand, using sales would cause them to under forecast their in effect(p) business potential.





1

#2: National Scan, Inc., sells radio frequency archive tags. calendar monthly sales ($000) for a seven-month period were as follows: Month Feb Mar Apr May Jun Jul Aug a. Plot the monthly data.
Historical Data

Sales 19 18 15 20 18 22 20

25

20

15

10

5

0 0 1 2 3 4 Period Sales 5 6 7 8

b.

Forecast September sales volume in thousands of dollars using the spare-time activity methods: Show your answers in the space provided. 1. 2. 3. 4. 5. Naïve Five-month moving honest Weighted moving average using .60 for August, .30 for July, and .10 for June Exponential smoothing with a smoothing constant of .20 Linear trend equation. Naive 20...If you want to render a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper