Question: Problem 5: Below is 4 weeks of sales data for a restaurant that is open 5 days a week (Tuesday-Saturday). a. Develop an Exponential Smoothing

Problem 5: Below is 4 weeks of sales data for a restaurant that is open 5 days a week (Tuesday-Saturday). a. Develop an Exponential Smoothing forecast. Use an alpha of .85 and assume the initial forecast for January is 975 b. Calculate the MAD for this forecast.
Actual
Day Demand
Tuesday 975
Wednesday 1225
Thursday 1445
Friday 1750
Saturday 2160
Tuesday 1500
Wednesday 750
Thursday 895
Friday 1500
Saturday 1445
Tuesday 1025
Wednesday 650
Thursday 850
Friday 980
Saturday 1500
Tuesday 750
Wednesday 650
Thursday 985
Friday 1200
Saturday 1460

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!

Q:

1) 2) A B C D E F G H 1 B) Calculate the Tracking signal values for the data. Do you recommend that they continue to use this forecasting method? Explain your position 3 4 1 5 Actual 6 Day Demand...

Q:

Instructions Respond to the following questions, and provide as much detail as possible. You will submit this assignment as a Microsoft Excel report. The first title tab must include your name and...

Q:

Consider the Analytics Exercise: Forecasting Supply Chain Demand - Starbucks Corporation PLEASE SHOW ALL ANSWERS AS I NEED TO COMPARE THIS WITH MY WORK. Part A ( 8 marks ) You will develop simple...

Q:

Question 1 Consider the "Analytics Exercise: Forecasting Supply Chain Demand-Starbucks Corporation" at the end of Chapter18 in your course textbook. Open a blank Excel workbook, and rename the second...

Q:

Solve the following problems. 1. The ABC distribution center sold the following number for pallets during the last two weeks. Day 1 2 3 4 5 6 7 Demand 107 121 117 111 94 99 104 Day 8 9 10 11 12 13 14...

Q:

Problem 19 (Forecasting): Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrolment for the last 8 years. Year Enrollment Year Enrollment 1 1.200 5 3,000 2...

Q:

G Show all work in this worksheet (with all calculation done using Excel - no manual calculations), then answer the questions in the Answers worksheet. Also, do not generate forecasts or error...

Q:

W 2 4 BUAD 3 0 6 - Murphy Assignment 2 Forecasting Due: Tues, 1 / 1 6 / 2 4 at 1 1 : 5 9 pm EST Background: Wes and Steve are partners in a lunch truck company that operates a central kitchen and...

Q:

Background: Wes and Steve are partners in a lunch truck company that operates a central kitchen and operates lunch trucks that travel to various locations in Philadelphia, Monday - Friday. The lunch...

Q:

W 2 4 BUAD 3 0 6 - Murphy Assignment 2 Forecasting Due: Tues, 1 / 1 6 / 2 4 at 1 1 : 5 9 pm EST Background: Wes and Steve are partners in a lunch truck company that operates a central kitchen and...

Q:

(a) Determine whether each of the following pairs of integers is congruent modulo 8. (i) 62,118 (ii) -43,-237 (iii) -90, 230 (b) Determine whether each of the following pairs of integers is congruent...

Q:

Victoria works for ABC Import in Manitoba. She worked 70 hours this bi-weekly pay period and is paid $15.00 per hour. This pay she will also receive a bonus of $500.00. What is Victoria's Employment...

Q:

an impairment loss hasthe effect of decreasing total assets decreasing retained earnings

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...