Develop a forecasting system for plastic pellet prices

Assignment Help Operation Management

Reference no: EM131894486

Question: 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 weight moving average and this blurred the weight for the most recent period. However, you can tell that the weights for the first and second most recent months are 0.65 and 0.25 respectively.

c) For exponential smoothing, use an a = 0.25, and the forecast for Month 7 is $0.41.

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 11 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).

Reference no: EM131894486

Questions Cloud

Provide him with five suggestions to promote weight loss : Explain the acronym BMI. What does it stand for? What does it measure? What values are associated with it? Name one advantage to using BMI.

Find out why ip addresses cannot replace cookies : Find out why IP addresses cannot replace cookies. Find out about Web mirroring, in which caching is done at the server site instead of the client site.

Which icmp messages contain part of the ip datagram : Which ICMP messages contain part of the IP datagram? Compare and contrast informational messages in ICMPv6 with informational messages in ICMPv4.

Draw a diagram to show the use of a proxy server : Draw a diagram to show the use of a proxy server that is installed in the LAN where the client is show the transactions between the client and proxy server.

Develop a forecasting system for plastic pellet prices : 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.

Calculate total amount of direct materials cost : Calculate the following - Total amount of direct materials cost in the finished goods inventory at Dec. 31, after all variances have been prorated

Find the capitalized cost of perpetual service : Find the capitalized cost of perpetual service using an annual interest rate of 4%.

What actions could the company or companies have : Topics relating to business law pop up every day in newspapers and magazines around the country. Find a newspaper or magazine article on a business law related

Regarding probability distributions : Which of the following is true regarding probability distributions? The more stocks you add to a portfolio the lower the beta.

User Account

All Pages