Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Toro Cutlery Company has collected monthly sales information below: MONTH SALES MONTH SALES MONTH SALES January 17,000 May 102,000 September 29,000 February 14,000 June

The Toro Cutlery Company has collected monthly sales information below:


MONTHSALESMONTHSALESMONTHSALES
January17,000
May102,000
September29,000
February14,000
June32,000
October91,000
March36,000
July85,000
November80,000
April105,000
August40,000
December93,000


The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales.


What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. 

Forecast (January, 3-month MA):

Forecast (January, 4-month MA):

Forecast (January, 5-month MA):

What will the forecast be for January the following year using exponential smoothing with ɑ = 0.6? Assume the forecast for February this year is 17,000. 

Step by Step Solution

3.40 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

To calculate the moving average forecast we need to sum up the sales for the previous three four or ... 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

Principles of Supply Chain Management A Balanced Approach

Authors: Joel D. Wisner, Keah Choon Tan, G. Keong Leong

5th edition

1337406499, 133740649X, 9781337672016 , 978-1337406499

More Books

Students also viewed these Accounting questions