Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A toy company buys large quantities of plastic pellets for use in the manufacture of its products.The production manager wants to develop a forecasting system

A toy company buys large quantities of plastic pellets for use in the manufacture of its products.The production manager wants to develop a forecasting system for plastic pellet prices. The price per pound of plastic pellets has varied as shown:

Month Plastic Pellets Price/Pound Month Plastic Pellets Price/Pound
1 $0.39 9 $0.35
2 $0.41 10 $0.38
3 $0.45 11 $0.39
4 $0.44 12 $0.43
5 $0.40 13 $0.37
6 $0.41 14 $0.38
7 $0.38 15 $0.36
8 $0.36 16 $0.39

Provide your forecast for Month 17 using the moving average, weighted moving average, and exponential smoothing methods as follows:

a) For the moving average, use a 4-period moving average.

b) Use a three-period weighted moving average. Unfortunately, you spilled water on the sheet with the weights to be used for the weighted moving average and this blurred the weight for the third most recent period. However, you can tell that the weights for the first and second most recent months are 0.7 and 0.2 respectively.

c) For exponential smoothing, use an = 0.30, and the forecast for Month 6 is $0.42.

d) Using the methods in a) through c), which method provides the better forecast for Month 17? Why?Your selection criteria must be based on the forecasts for Months 13 through 16 using one of the one of the numerical evaluation methods we have learned and used on homework assignments this term.

Provide your forecasts to three decimal places ($0.xxx).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Matching Supply with Demand An Introduction to Operations Management

Authors: Gerard Cachon, Christian Terwiesch

3rd edition

73525200, 978-0073525204

More Books

Students also viewed these General Management questions

Question

understand the selection bias in contemporary work psychology;

Answered: 1 week ago