Explain the exponential smoothing methods

Assignment Help Accounting Basics
Reference no: EM132081057

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 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 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: EM132081057

Questions Cloud

Meeting these needs to minimize the potential for conflict : What measures can you take to assist in meeting these needs to minimize the potential for conflict?
Calculate the accounting rate of return : This machine, which has no residual value, has an estimated useful life of 10 years. For this machine, calculate the accounting rate of return
The characteristics that you are looking for in team member : Imagine you have been asked to create a team at work to meet a specific need within your company. Describe what type of group/team this will be.
National and international public airport systems : Consider airport safety, security, unionization, disadvantaged businesses, customer service, and national/international public airport systems.
Explain the exponential smoothing methods : Provide your forecast for Month 17 using the moving average, weighted moving average, and exponential smoothing methods as follows.
What is the minimum price that the division would consider : What is the minimum price that the division would consider on a "special order" of 1,000 chips to be distributed through normal channels
Describe two or three routine daily conflict : Describe two or three routine daily conflicts you have observed among employees.
Why is white-collar crime so hard to police : Why is white-collar crime so hard to police? Do you blame the new homeowners or the subprime lenders for the mortgage crisis?
How artificial intelligence is useful in risk planning : How artificial intelligence is useful in risk planning.

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd