Question: Hello please answer all parts to this question sufficiently to receive a positive thumbs up rating. No Excel please. Thanks in advance! Question 1: The

Hello please answer all parts to this question
Hello please answer all parts to this question sufficiently to receive a positive thumbs up rating. No Excel please. Thanks in advance!
Question 1: The monthly sales for Telco Batteries, Inc. in a given year were as follows: Month Demand Jan. 46 Feb. 47 Mar. 50 Apr. 49 May 50 June 48 July 51 Aug. 49 Sep. 52 Oct. 53 Nov. 52 Dec. 54 a. Forecast next year January sales using each of the following methods: i. Naive method ii. A four-month moving average 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 a=0.2 and a September forecast of 50. b. Show the plot of the monthly sales data on excel. 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 a = 0.2, B = 0.3 for the month September stationary component is 50 and trend is 1.5 d. Forecast next year February sales using each of the following methods: i. Naive method il. A four-month moving average 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 a=0.2 and a September forecast of 50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!