The monthly sales for Yazici Batteries, Inc., were as follows:

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
icon
Related questions
Question
i need the answer quickly
The monthly sales for Yazici Batteries, Inc., were as follows:
MONTH
SALES
January
20
February
21
March
15
April
14
May
13
June
16
July
17
August
18
September
20
October
20
November
21
December
23
a) Plot the monthly sales data
b) Forecast January sales using each of the following:
i) Naive method
ii) A 3-month moving average
iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the
heaviest weights applied to the most recent months
IV) Exponential smoothing using a = .3 and a September forecast of 18
v) A trend projection
c) With the data given, which method would allow you to forecast next
March's sales?
Transcribed Image Text:The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 November 21 December 23 a) Plot the monthly sales data b) Forecast January sales using each of the following: i) Naive method ii) A 3-month moving average iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months IV) Exponential smoothing using a = .3 and a September forecast of 18 v) A trend projection c) With the data given, which method would allow you to forecast next March's sales?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing