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

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.65 and 0.25 respectively.

c) For exponential smoothing, use an = 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).

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

Auditing Humor And Other Oxymorons

Authors: Mr Mike Jacka

1st Edition

0991280903, 978-0991280902

More Books

Students also viewed these Accounting questions

Question

What is the difference between character I/O and binary I/O?

Answered: 1 week ago