Engineering Principles
Autor: karthik kumar • March 17, 2016 • Course Note • 555 Words (3 Pages) • 738 Views
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.
- (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 |
- 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.
- 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.
- 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 |
...