Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The monthly sales for Telco Batteries Inc. were as follows: MONTHSALES JANUARY20 FEBRUARY21 MARCH15 APRIL14 MAY13 JUNE16 JULY17 AUGUST18 SEPTEMBER20 OCTOBER20 NOVEMBER21 DECEMBER23 1)Plot the
The monthly sales for Telco Batteries Inc. were as follows:
MONTHSALES
JANUARY20
FEBRUARY21
MARCH15
APRIL14
MAY13
JUNE16
JULY17
AUGUST18
SEPTEMBER20
OCTOBER20
NOVEMBER21
DECEMBER23
1)Plot the monthly sales data
2)Forecast January sales using each of the following;
1. nave method
2. A 3-month moving average
3. A 6-months weighted average using .1,.1,.2,.2, and .3, with the heaviest weights applied to the most recent months.
4. Exponential smoothing using an a = .3 and a September forecast of 18.
5. A trend projection.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started