Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Operations Management

Authors: William J. Stevenson

11th Edition

978-0073525259, 0073525251

More Books

Students also viewed these General Management questions

Question

What are the key advantages of a PPP?

Answered: 1 week ago