Question: Consider the following data on full-service restaurant sales. Calculate both the three-month and five-month moving averages for these data, and compare the forecasts by calculating

  1. Consider the following data on full-service restaurant sales. Calculate both the three-month and five-month moving averages for these data, and compare the forecasts by calculating the mean absolute percentage errors and MAPEs. The data are in millions of dollars.

Date

Sales (000,000)

Date

Sales (000,000)

Date

Sales (000,000)

Date

Sales (000,000)

Jan-02

6910

Aug-05

9035

Feb-09

9515

Sep-12

11743

Feb-02

6959

Sep-05

8271

Mar-09

10385

Oct-12

12129

Mar-02

7268

Oct-05

8328

Apr-09

10571

Nov-12

12003

Apr-02

7023

Nov-05

7987

May-09

10792

Dec-12

12794

May-02

7555

Dec-05

8383

Jun-09

10553

Jan-13

11811

Jun-02

7021

Jan-06

7532

Jul-09

11083

Feb-13

11523

Jul-02

7297

Feb-06

7943

Aug-09

10939

Mar-13

12957

Aug-02

7558

Mar-06

8685

Sep-09

10297

Apr-13

12423

Sep-02

6945

Apr-06

8502

Oct-09

11056

May-13

13741

Oct-02

7464

May-06

8977

Nov-09

10229

Jun-13

13250

Nov-02

7138

Jun-06

8716

Dec-09

10703

Jul-13

13673

Dec-02

7355

Jul-06

8978

Jan-10

10092

Aug-13

14329

Jan-03

6854

Aug-06

9548

Feb-10

10532

Sep-13

12465

Feb-03

6699

Sep-06

8675

Mar-10

11464

Oct-13

13026

Mar-03

7324

Oct-06

9032

Apr-10

11240

Nov-13

12606

Apr-03

7514

Nov-06

9005

May-10

11393

Dec-13

13281

May-03

7898

Dec-06

8921

Jun-10

11332

Jan-14

12953

Jun-03

7814

Jan-07

8688

Jul-10

11752

Feb-14

12926

Jul-03

8049

Feb-07

8640

Aug-10

11581

Mar-14

13709

Aug-03

8322

Mar-07

9592

Sep-10

11257

Apr-14

13324

Sep-03

7730

Apr-07

9332

Oct-10

11447

May-14

14042

Oct-03

8049

May-07

9976

Nov-10

10742

Jun-14

13669

Nov-03

7449

Jun-07

9460

Dec-10

11372

Jul-14

14572

Dec-03

7774

Jul-07

10071

Jan-11

10726

Aug-14

14149

Jan-04

6998

Aug-07

10517

Feb-11

10691

Sep-14

13268

Feb-04

7275

Sep-07

9539

Mar-11

11919

Oct-14

13918

Mar-04

8177

Oct-07

9850

Apr-11

11312

Nov-14

12992

Apr-04

8143

Nov-07

9227

May-11

12002

Dec-14

14312

May-04

8364

Dec-07

9699

Jun-11

12191

Jan-15

13202

Jun-04

8292

Jan-08

9147

Jul-11

12374

Feb-15

13260

Jul-04

8689

Feb-08

9114

Aug-11

12797

Mar-15

14359

Aug-04

8661

Mar-08

9972

Sep-11

11292

Apr-15

14368

Sep-04

8080

Apr-08

9825

Oct-11

11523

May-15

14687

Oct-04

8264

May-08

10423

Nov-11

11259

Jun-15

14445

Nov-04

7822

Jun-08

10203

Dec-11

12596

Jul-15

15142

Dec-04

8352

Jul-08

10458

Jan-12

11520

Aug-15

14905

Jan-05

7507

Aug-08

10541

Feb-12

11414

Sep-15

13982

Feb-05

7341

Sep-08

9844

Mar-12

12696

Oct-15

14575

Mar-05

8243

Oct-08

10455

Apr-12

12140

Nov-15

13838

Apr-05

8269

Nov-08

9715

May-12

12857

Dec-15

15478

May-05

8615

Dec-08

10338

Jun-12

12685

 

 

Jun-05

8549

Jan-09

9583

Jul-12

12873

 

 

Jul-05

8902

 

 

Aug-12

13357

 

 

Step by Step Solution

★★★★★

3.48 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The first year and the last year are shown below for the three period moving average Date Sales 000000 MA3 MA3 Forecast Error Absolute Error Absolute ... View full answer

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 Forecasting Predictive Analytics Questions!

Q:

Plot the data presented in Exercise 7 to examine the possible existence of trend and seasonality in the data. Prepare three separate exponential smoothing models to forecast the full-service...

Q:

The following are the summary account balances from the statement of financial position of Granger Inc. as at October 31, 2014. The accounts are followed by a list of transactions for the month of...

Q:

The Coca-Cola Company and Home Depot have been very profitable companies, typically trading at high multiples of earnings, book values, and sales. This case asks you to value the two companies using...

Q:

Consider the following data on full-service restaurant sales. Calculate both the three-month and five-month moving averages for these data, and compare the forecasts by calculating the...

Q:

Consider the following data on full-service restaurant sales. Calculate both the three-month and five-month moving averages for these data, and compare the forecasts by calculating the mean absolute...

Q:

SECTION B (60 MARKS) Answer ALL questions in this section. QUESTION 3 (20 Marks) Use the information provided below to answer the following questions. INFORMATION: A health club has three employees...

Q:

5 (20 Marks) Study the information provided below and answer the following questions. The Table below shows the number of Cinco 160W solar panels sold monthly by Mfeka Enterprises during the 2022...

Q:

5 (20 Marks) Study the information provided below and answer the following questions. The Table below shows the number of Cinco 160W solar panels sold monthly by Mfeka Enterprises during the 2022...

Q:

Study the information provided below and answer the following questions. The Table below shows the number of Cinco 160W solar panels sold monthly by Mfeka Enterprises during the 2022 financial year....

Q:

The Table below shows the number of Cinco 160W solar panels sold monthly by Mfeka Enterprises during the 2022 financial year. Table: Monthly Sales Data of Solar Panels Monthly sales (units) Jan Feb...

Q:

Examine the pros and cons of hiring an inside sales staff, or outsourcing sales to a prominent sports sales company, to manage ticket sales at a Division I college athletic department.

Q:

The pressure in an automobile tire depends on the temperature of the air in the tire. When the air temperature is 25°C, the pressure gage reads 210 kPa. If the volume of the tire is 0.025 m3,...

Q:

Evaluate the integral: x ^ 3 sqrt ( 1 + 4 9 x ^ 2 ) dx + C

Q:

Running process 3 for an hour costs $14 and requires two barrels of crude 2 and three barrels of gas

Q:

Blue is the owner of all of the shares of an S corporation, and Blue is considering receiving a salary of $110,000 from the business. She will pay the 7.65% FICA taxes on the salary, and the S...

Q:

Bob Roman, the major owner of an S corporation, approaches you for some tax planning help. He would like to exchange some real estate in a like-kind transaction under 1031 for real estate that may...

Q:

Keystone, your tax consulting client, is considering an expansion program that would entail the construction of a new logistics center in State Q. List at least five questions you should ask in...

Q:

Eachyear, Fortune Magazine publishes an article titled"The International500" that provides a ranking by sales of the top 500 firms outside the United States. Suppose that you want to examine various...

Q:

Which of the following statements related to preferred stock is correnct? (can be more than one) A. Preferred shareholders normally receive one vote per share of stock owned. B. Preferred...

Q:

Let a2 a1a0 and b2b1b0 be a 3-bit binary numbers, and let c3c2c1c0 = a2 a1a0 + b2b1b0 be 4-bit binary number. For example, 1011 = 101 + 110. Write Boolean expressions for c2, c1, c0.