Question: 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

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?

Day Customers 260 243 232 277 270 285 248 254

Step by Step Solution

★★★★★

3.27 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a b MAD 11406 190 c d MAD 12627 1803 e The forecast using exponential smoothing with tr... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

483-M-S-F (268).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Answer the following questions using the data from the Excel file AOL. xlsx described in Problem 16.30: From Problem a. Forecast the advertising revenue for each quarter in 2013 using seasonal dummy...

Answer the following questions using the data from the Excel file chlorine. xlsx described in Problem 16.32. From Exercise a. Forecast the tons of chlorine shipped each day next week using...

Answer the following questions using the data from the Excel file cafeteria. xlsx described in Problem 16.34. From Exercise a. Forecast the food services sales for each day next week using seasonal...

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 Daves store on Day 9 using a...

Answer the following questions using the data from the Excel file Great Smoky Mountain. xlsx from Problem 16.47. a. Using a four period simple moving average, forecast the number of visitors each...

Answer the following questions using the data from the Excel file grade inflation by semester. xlsx described in Problem 16.41: a. Forecast the average GPA for each semester during 2014 using a...

Answer the following questions using the data from the Excel file S& P 500. xlsx described in Problem 16.51: a. Forecast the S& P Index for the end of January 2013 using a trend projection. b. Check...

TVM with Excel Assignment # 2 Life is messy and deciding how to allocate capital resources is complicated. So , unlike the highly simplified problems used in class ( and in the online examples,...

The sweatshop scandal of the 1990s, which revealed that Nike used forced child labor to manufacture its products, greatly damaged the company. Nike has ever since been plagued with the claims of...

1. Chapter 7 -- Problems 9, 12, 31, & 55. 2. Use the Excel data file in Canvas for Problems 12, 31, and 55. 3. Submit your work by the due date (TBA). No late submission nor redo assignment will be...

Andy Hardy, SS# 063-74-8921, is a Grade 2 Machinist who earns $18 per hour. On Monday, June 10 through Wednesday, June 12, he worked four hours per day on each of Jobs AX20 and AX25. On Thursday, he...

Can an amphiprotic substance be a weak acid and a weak base at the same time? If so, explain why and give an example.

Alicia sold her personal residence to Rick on June 3 0 for $ 4 3 0 , 0 0 0 . Before the sale, Alicia paid the real estate tax of $ 6 , 4 5 0 for the calendar year. For income tax purposes, the...

Exercise 6 (LO 4) Three-level acquisition, intercompany asset sale. Company S-1 acquires an 80% interest in the common stock of Company S-2 for $440,000 on January 1, 20X1. The price is equal to the...

A study by Peter D. Hart Research Associates for the Nasdaq Stock Market revealed that 43% of all American adults are stockholders. In addition, the study determined that 75% of all American adult...

According to Reuters, a survey undertaken by the National Center for Health Statistics revealed that about 25% of U.S. households have only a cell phone (no land line).According to the FCC, 65% of...

A study by Becker Associates, a San Diego travel consultant, found that 30% of the traveling public said that their flight selections are influenced by perceptions of airline safety. Thirty-nine...

Your company has earnings per share of $4. It has 1 million shares outstanding, each of which has a price of $42. You are thinking of buying TargetCo, which has earnings of $3 per share, 1 million...

Aluminum Building Products Company (ABPC) is considering investing in either of the two mutually exclusive projects described as follows: Project 1. Buying a new set of roll-forming tools for its...

Here's the Taylor series of expansion about where the terms of order 2 and higher have been discarded to create a linear approximation to . This operation is easy for basic functions such as . When...