Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

fork Lane Computers (YLC) has collected the following data of actual laptop sales in the past six nonths, from September 2022 (month 1) to February

image text in transcribed
fork Lane Computers (YLC) has collected the following data of actual laptop sales in the past six nonths, from September 2022 (month 1) to February 2023 (month 6). a) Cathy is a new manager of YLC, and she wants you to use a weighted moving average to forecast for the month of March with weights of 0.15,0.20, and 0.65 for December, January. and February, respectively. b) Calculate the sales forecast for the month of March using simple exponential smoothing with =0.25 when the forecast for the month of January is 242 units. c) Cathy also would like you to calculate the exponential smoothing with trend forecast of March for the above data using an (Alpha) a of 0.30 , a (delta) of 0.40 , a January forecast with trend [FIT Januar] of 350 units and an estimated January trend [TJanuary] of -2.5200 , respectively. d) Based on a certain forecasting method, Cathy forecasted sales for each month and the actual sales of each month data are summarized in the table below. Use Tracking Signal (TS) to evaluate the accuracy of the following forecasting method (from September to February). Assume that Cathy would flag the forecast/s with signals outside the \pm 36 . You must show your work by filling out the table. Is this a good or poor forecasting model? Briefly state your reason. [A simple YES or NO answer receives ZERO mark.]

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

MIS Essentials

Authors: David M Kroenke

1st Edition

0136075606, 9780136075608

More Books

Students also viewed these General Management questions

Question

Explain about operations on Data Structure?

Answered: 1 week ago

Question

Which of the following strait separate north america from Asia ?

Answered: 1 week ago

Question

Highest peak as well as active volcano of North America?

Answered: 1 week ago