Quarterly demand for smartphones at a retailer is as shown. Year 1 2 3 4 Quarter I || IV I || ||| IV I || ||| IV I || ||| IV Demand 513 932 1,509 1,902 693 1,163 1,857 2,469 846 1,439 2,271 3,079 1,070 1,751 2,785 3,613 (a) Using the data from Years 1 and 2, calculate your initialization of seasonal factors. (b) Using the data from Years 1 and 2, and utilizing linear regression to assist in calculating D_hat, calculate the initialization of the Level and Trend Year 2 Quarter IV. (c) Using the initialization values from parts (a) and (b) initial estimates for level, trend, and seasonal factors, forecast the demand for Years 3 and 4 using Winter's method with alpha=0.05, beta = 0.10, and gamma = 0.15. (d) Evaluate the MAD, MAPE, and MSE for the forecast (for Years 3 and 4).

Quarterly demand for smartphones at a retailer is as shown. Year 1 2 3 4 Quarter I || IV I || ||| IV I || ||| IV I || ||| IV Demand 513 932 1,509 1,902 693 1,163 1,857 2,469 846 1,439 2,271 3,079 1,070 1,751 2,785 3,613 (a) Using the data from Years 1 and 2, calculate your initialization of seasonal factors. (b) Using the data from Years 1 and 2, and utilizing linear regression to assist in calculating D_hat, calculate the initialization of the Level and Trend Year 2 Quarter IV. (c) Using the initialization values from parts (a) and (b) initial estimates for level, trend, and seasonal factors, forecast the demand for Years 3 and 4 using Winter's method with alpha=0.05, beta = 0.10, and gamma = 0.15. (d) Evaluate the MAD, MAPE, and MSE for the forecast (for Years 3 and 4).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

What are your preferred methods of receiving information? Does your answer differ depending on the type of information being sent?
Explain Low-Level Coding
How can senders and receivers be courteous during communications?
As a consequence of advancements in networking technology, businesses dependent on IT face either greater or reduced danger. Why?
Which of the authorized relationships in Florida offers the least amount of representation but the most flexibility in terms of what kind of relationship the other party to an in-house residential transaction can have? transaction broker no brokerage both single agent and transaction broker single agent
Is there anything that companies need to be aware of in terms of the law when it comes to using mobile phones?
Identify the primary advantages and problems that information systems give the educational sector in Ghana, particularly in light of the epidemic that was caused by the COVID 19 virus.
Identify ways to make college campuses healthier
Why is the appearance of the Inspector of considerable importance at meetings and negotiation sessions?
Several issues may arise if a customer's email provider read their communications.
What strategies, if any, are available for addressing the ethical challenges posed by contemporary modes of communication and information exchange, such as computers and the internet?