Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1: Following table shows the weekly sales of smart phones at electronic retail store: Week Number of smart phones Sold Forecast using 3 period moving

image text in transcribedimage text in transcribed 1: Following table shows the weekly sales of smart phones at electronic retail store: Week Number of smart phones Sold Forecast using 3 period moving average Error Forecast using exponential smoothing (with a=0.4) Error 1 23 14 Strikethrough -23456 7 8 26 33 29 20 Answer the following questions based on the data given above. Show all your calculations. a. What is the expected sales for the 7th week based on 3 period moving average? What is the forecast for the 8th week using the same method if the actual sales for week 7 happens to be 25? (15 Points) ANSWER: Week 7: Week 8: b. What is the expected sales for the 7th week based on exponential smoothing with a = 0.4? (15 Points) ANSWER: Week 7: c. Which of the above two forecasting method is better based on MSE? Why? (20 Points)

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

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

More Books

Students also viewed these Accounting questions