table Month , Sales, table 1 , , , 1 , 6 7 0 , 6 7 1 , 6 6 9 , 2 , 6 8 9 , 6 8 5 , 6 8 7 , 3 , 6 9 4 , 6 9 0 , 6 9 2 , 4 , 6 8 0 , 6 8 4 , 6 9 8 , 5 , 6 6 8 , 6 7 0 , 6 7 4 , 6 , 6 7 2 , 6 6 8 , 6 7 0 , 7 , 6 6 0 , 6 6 1 , 6 5 9 , 8 , 6 7 5 , 6 7 1 , 6 7 5 , 9 , 6 8 6 , 6 8 4 , 6 8 8 , 1 0 , 6 9 0 , 6 8 8 , 6 8 8 a Compute the MSE and MAD for each forecast Does either forecast seem superior Explain b Compute MAPE for each forecast c Prepare a naive forecast for periods 2 through 1 1 using the given sales data Compute each of the following ( 1 ) MSE, ( 2 ) MAD, ( 3 ) tracking signal at month 1 0 , and ( 4 ) 2 s control limits How do the naive results compare with the other two forecasts

The Answer is in the image, click to view ...

Question: table [ [ Month , Sales, table [ [ 1 ] , [ ] ] , ] , [ 1 , 6 7

\

table

[[

Month

,

Sales,

\

table

[[1], []],], [1, 670, 671, 669], [2, 689, 685, 687], [3, 694, 690, 692], [4, 680, 684, 698], [5, 668, 670, 674], [6, 672, 668, 670], [7, 660, 661, 659], [8, 675, 671, 675], [9, 686, 684, 688], [10, 690, 688, 688]]

.

Compute the MSE and MAD for each forecast. Does either forecast seem superior? Explain.

.

Compute MAPE for each forecast.

.

Prepare a naive forecast for periods

2

through

11

using the given sales data. Compute each of the following;

(1)

MSE,

(2)

MAD,

(3)

tracking signal at month

10,

and

(4) 2

s control limits

.

How do the naive results compare with the other two forecasts?

$\table[[Month,Sales,\table[[1],[]],],[1,670,671,669],[2,689,685,687],[3,694,690,692],[4,680,684,698],[5,668,670,674],[6,672,668,670],[7,660,661,659],[8,675,671,675],[9,686,684,688],[10,690,688,688]] a. Compute the MSE and MAD for each forecast. Does$

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!

what is the MAD for period 5-9? use the following data to answer the next five questions. Monthly sales for the past nine periods along with the associated forecasts are shown in the following table....

Monthly sales for the past nine periods along with the associated forecasts are shown in the following table. Month Sales Forecast 1 770 775 2 778 785 3 786 790 4 790 787 5 793 795 6 790 788 7 794...

Chapter 4, Problem 3, parts a-c Camp and Fevurly Financial Planners have forecasted revenues for the first six months of 2017, as shown in the following table. Month Sales November 2016 $44,160...

Problem 3 (30 points) XYZ Company has just entered the market with a new pocket computer. Although the company is starting with modest sales, it expects to grow before leveling off at 6000 units per...

1 - Using the data in following table, Month Sales January 9 0 8 February 1 2 3 5 March 8 0 4 April 1 0 1 9 May 1 1 5 1 June 1 3 8 3 July 8 9 4 August 1 2 5 5 September 1 0 8 7 October 1 3 8 2...

XY2 Company has just entered the market with a new pocket computer. Although the company is starting with modestes, i espects to grow before leaving off at 6000 per months on the following table...

Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. Month Sales Jan 400 Feb 380 Mar 418 Apr 365 a) Based on the given monthly sales data,...

Chapter 7 homework 1 - Using the data in following table, MONTH SALES January 9 0 8 February 1 2 3 5 March 8 0 4 April 1 0 1 9 May 1 1 5 1 June 1 3 8 3 July 8 9 4 August 1 2 5 5 September 1 0 8 7...

Storrs Cycles has just started seling the new Cyclone mountain bike, with monthly sales as shown in the table Month Sales Jan 407 Feb 376 Mar 414 Apr 375 a) Based on the given monthly sales data it...

Acme 3-D Printing Co. custom produces products for customers by using computerized 3D printing. An employee (clerk) at Acme takes orders from customers, each order contains the specifications for one...

Early in the twentieth century, Robert Goddard proposed sending a rocket to the moon. Critics objected that in a vacuum, such as exists between the Earth and the Moon, the gases emitted by the rocket...

In some cases, lenders require that borrowers obtain mortgage insurance. The purpose of such insurance is to: Decrease the effective interest rate on the loan Protect the fender from forses amoctated...

Roddy Ricch Company manufactures high-quallty cardooard bcoes, The company is deciding whether to continue to make boxes or buy them from an outside supplier. The per unit production of each box is...