AllFreePapers.com - All Free Papers and Essays for All Students
Search

Engineering Principles

Autor:   •  March 17, 2016  •  Course Note  •  555 Words (3 Pages)  •  738 Views

Page 1 of 3

Grade____________

[pic 1]

BUS5461

Production/Operations Management

HW 2

Spring 2016

Feb 4, 2016

Due: Feb 18, 2016

Your Name_______________________________

I have neither given nor received unauthorized aid on this quiz.

Signature_____________________________________

                                                                        

Note: The following questions require the use of Excel. Where forecast and error series are requested, your answers should be in tabular form. Display your answers as directed by each question.

  1. (Moving average and weight moving average) As the buyer of sugar and cocoa for Sweeter Sweets you are responsible for ensuring a steady supply of each for the production of candy. Unfortunately, El Niño and La Niña weather patterns over the last year have negatively impacted the quantity of cocoa available on the market. Your supplier, South American Cocoa Unlimited, has promised to supply the needed cocoa if you provide an accurate forecast for the next month. Sweeter Sweets cocoa usage in thousands of pounds for the last twelve months is shown below.

MONTH

DEMAND

1

39

2

40

3

39

4

34

5

45

6

54

7

50

8

45

9

47

10

45

11

50

12

43

  1. Using a 3-month simple moving average, estimate the forecast of cocoa consumption for months 4-12; then generate a forecast for month 13. Your spreadsheet should contain columns for month, actual demand, forecast, error, and absolute error. Display your answer to one decimal place.
  2. Create a second forecast using a 3-month weighted moving average with weights of .5, .3, and .2 (from the most recent to the least recent respectively) for months 4-12; then generate a forecast for month 13. Display your answer to one decimal place.
  3. Compute the Mean Absolute Deviation (MAD) for the forecasting methods in parts (a) and (b). Display your answer to one decimal place. Based on these error calculations, which forecast methodology, should you use to place your order for cocoa? During a weekly status meeting your supervisor asks you to explain why you selected the forecasting method. What do you tell her?

Question 1 a)

Month

Demand

Forecast

Error

Absolute

t

At

Ft

Dt-Ft

Error

1

39

2

40

3

39

4

34

39

(5)

5.3333333

5

45

38

7

7.3333333

6

54

39

15

14.666667

7

50

44

6

5.6666667

8

45

50

(5)

4.6666667

9

47

50

(3)

2.6666667

10

45

47

(2)

2.3333333

11

50

46

4

4.3333333

12

43

47

(4)

4.3333333

13

?

46

5.7037037

MAD

Question 1 b)

w1

w2

w3

0.5

0.3

0.2

Month

Demand

Forecast

Error

Absolute

T

At

Ft

Dt-Ft

Error

1

39

2

40

3

39

4

34

39

-5.30

5.30

5

45

37

8.30

8.30

6

54

41

13.50

13.50

7

50

47

2.70

2.70

8

45

50

-5.20

5.20

9

47

48

-1.30

1.30

10

45

47

-2.00

2.00

11

50

46

4.40

4.40

12

43

48

-4.90

4.90

13

?

46

5.29

MAD

...

Download as:   txt (7 Kb)   pdf (216.8 Kb)   docx (53.9 Kb)  
Continue for 2 more pages »