Question

Consider the following actual demand for a soft drink at a local Burger King restaurant. What...

Consider the following actual demand for a soft drink at a local Burger King restaurant.

What is the demand forecast for Friday using simple exponential smoothing method with alpha=0.2 and assume Tuesday’s forecast follows Naïve forecast? Please round to the nearest whole number if necessary.

DAY- ---DEMAND

Monday ---88

Tuesday ---73

Wednesday ---78

Thursday--- 65

Friday ----?

Select one:

a. 75

b. 80

c. 82

d. 72

e. 68

Homework Answers

Answer #1

Note: In case of any doubt, please in the comment section. Also, please rate. Thank you.

Answer: B (80)

Rationale:

Given that Tuesday's forecast follows a naive approach.

Therefore, Forecast for Tuesday = Demand of Monday

Therefore, Forecast for Tuesday = 88

Given exponential smoothing (a) = 0.2

Forecast using exponential smoothing is given by formula:

F(t+1) = (a × Demand(t)) + (1 - a) × Forecast(t)

Day Demand Forecast
Tuesday 73 88
Wednesday 78 (73×0.2) + (0.8×88) = 85
Thursday 65 (78×0.2) + (0.8×85) = 83.6
Friday (65×0.2) + (0.8×83.6) = 79.88

Forecast for Friday = 79.88

Forecast for Friday = 80 (rounded off to nearest whole number)

Forecast for Friday = 80

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem 5:  Below is 4 weeks of sales data for a restaurant that is open 5 days...
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...
Your manager is trying to determine what forecasting method to use. Based upon the following historical...
Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. - PLEASE show all work in Excel including formulas. a. Calculate the simple three-month moving average forecast for periods 4-12. b. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-12. c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F1)...
** Note ** Execute the following query before completing steps 1 and 2: INSERT INTO Employees...
** Note ** Execute the following query before completing steps 1 and 2: INSERT INTO Employees (LastName, FirstName, BirthDate, Notes) VALUES ('Smith','Mary','1980-10-15','John is a student at Nashville State.'); 1. Using the record you just created in the Note above, write a query to update the LastName field to Jones. 2. Using the record you just created in the Note above, write a query to delete that record. 3. Write a query using the Products table that will return the sum...