Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: a. Forecast next year January sales using each of
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: a. Forecast next year January sales using each of the following methods: i. Nave method ii. A four-month moving average iii. A five-month weighted moving average using the weights 0.1,0.1,0.2,0.2, and 0.4 (the heaviest weights applied to the most recent months). iv. Exponential smoothing using an =0.3 and a August forecast of 51 . b. Plot the monthly sales data. What demand pattern do you see in the plot? c. Forecast next year January sales using the following methods: i. Linear regression (You can use excel to get slope and intercept) ii. Trend adjusted exponential smoothing model. Use =0.2,=0.25, for the month September forecast before trend adjustment =51, trend for the month September =1.2
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