# Question: Answer the following questions using the data from the Excel

Answer the following questions using the data from the Excel file daily customers. xlsx described in Problem 16.38:

a. Forecast the number of customers who will visit Dave’s store on Day 9 using a two period weighted moving average with the weights 5 and 2.

b. Calculate the MAD for the forecast in part a.

c. Forecast the number of customers who will visit Dave’s store on Day 9 using exponential smoothing with trend adjustment and setting α = 0.1 and β = 0.3.

d. Calculate the MAD for the forecast in part c.

e. In which forecast do you have the most confidence?

a. Forecast the number of customers who will visit Dave’s store on Day 9 using a two period weighted moving average with the weights 5 and 2.

b. Calculate the MAD for the forecast in part a.

c. Forecast the number of customers who will visit Dave’s store on Day 9 using exponential smoothing with trend adjustment and setting α = 0.1 and β = 0.3.

d. Calculate the MAD for the forecast in part c.

e. In which forecast do you have the most confidence?

**View Solution:**## Answer to relevant Questions

Using the time series shown in Problem 16.3, answer the following questions: From Problem a. Forecast the demand for Period 9 using exponential smoothing with trend adjustment and setting α = 0.4 and β = 0.7. b. ...Answer the following questions using the data from the Excel file average bonus. xlsx from Problem 16.43. From Problem a. Using exponential smoothing with α = 0.5, forecast the average cash bonus for a financial investment ...Answer the following questions using the data from the Excel file Toys Unlimited. xlsx from Problem 16.49. a. Forecast Toys Unlimited sales for each quarter next year using a multiple regression with seasonal dummy ...General Motors (GM) is one of the world’s largest car and truck manufacturer and employs over 200,000 employees worldwide. In 1970, GM had captured nearly 60% of the U. S. market share. However, due to increased global ...Consider the following payoff table and probabilities for the states of nature: a. Choose the best alternative using decision making under risk. b. What is the expected value of perfect information?Post your question