Question: Sales for refrigerators are given in the table below. Using a 3-month moving average, forecast sales for February the following year. Calculate the MAD for

  1. Sales for refrigerators are given in the table below. Using a 3-month moving average, forecast sales for February the following year. Calculate the MAD for this model.

3-Month

Absolute

Month

Sales

Moving Average

Deviation

January

11

February

14

March

16

April

10

May

15

June

17

July

11

August

14

September

17

October

12

November

14

December

16

January

11

February

Use the weighted moving average to forecast sales for February the following year . Calculate the MAD for this model.

Which model is better?

Month

Sales

3-Month Weighted Moving Average

Absolute Deviation

January

11

February

14

March

16

April

10

May

15

June

17

July

11

August

14

September

17

October

12

November

14

December

16

January

11

February

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 Accounting Questions!

Q:

Week Four Homework Assignment Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several competitors who...

Q:

If a good brokerage forecasts that a stock is likely to rise, many investors tend to buy that stock and there could be a substantial increase in demand for that stock because of the forecast. Look at...

Q:

3. Number new bicycle sales at a local bicycle shop are shown in the following table. a. Develop a 3-month moving average forecast and compute the MAD. b. Develop a 4-month moving average forecast...

Q:

Based upon the following historical data, calculate the following forecasts for each given forecasting method and then choose the best one to do the forecasts for the future. Actual Month Demand 1 6...

Q:

The monthly sales (in millions of dollars) of Turner, Inc. for eleven months are given below. Month Actual Sales A January 14 February 16 March 18 April 23 May 24 June 18 July 21 August 16 September...

Q:

2) The monthly sales for Gatsby Generators Ltd were as follows: Month Sales January 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 November 21 December 23...

Q:

Question 1 The primary purpose of the mean absolute deviation (MAD) in forecasting is to: measure forecast accuracy estimate the trend line eliminate forecast errors seasonally adjust the forecast...

Q:

The Peterson Perpetual Prot Mutual Fund has recorded the funds average prices over the past 12 months; these data may be found in the table on the following page. Given recent market volatility,...

Q:

show with excel steps please!! Baltimore County Home Depot sales for refrigerators is given in the table for a 12 month period. a. Forecast Using a three month moving average b. Forecast Using simple...

Q:

1.(3 points)Buckeye Shoe Store predicted June shoe sales would be 650 pairs.Buckeye Shoe Store actually sold 690 pairs of shoes in June.Using a smoothing constant of = 0.15, forecast the July shoe...

Q:

Nine-to-Five Limited engages in retail industry specialising in selling sportswear. Nine-to-Five Limited received a bank statement issued by the Good Bank on 5 June 2021 and found that the monthly...

Q:

What additional factors must be considered when evaluating international investment opportunities when compared to domestic ones? In what ways is appraisal of investments with an international...

Q:

Which transaction would occur in a dealer market? a . Investor sells $ 2 5 , 0 0 0 of Government of Canada bonds. b . Investor purchases 1 0 0 preferred shares on the TSX . c . Investor sells 5 0 0...

Q:

Rose Distributing Company completed the following merchandising transactions in the month of April. At the beginning of April, the ledger of Rose showed Cash of $9,000 and Owners Capital of $9,000....

Q:

At the beginning of year 1, Northern Sun, Inc., a food processing concern, is considering a new line of frozen entrees. The accompanying table shows projected cash outflows and inflows. Assume that...

Q:

Ranger Sportswear planned to produce 40,000 fleece jackets in its Metairie, Louisiana factory. Fixed overhead costs for the factory were budgeted to be $500,000. The company actually spent $485,000...

Q:

A retailer is considering the purchase of 100 units of a specific item from either of two suppliers. Their offers are as follows: A: $390 a unit, total of $39,000, 1/10, n/30, plus freight of $750....

Q:

The U.S. government is in the midst of spending more than $1 billion on seven buildings containing more than 100,000 square feet of space to be used for study of infectious diseases. Prior to the...

Q:

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Q:

Conflicting organization and individual objectives Strathcona Paper rewards its managers based on the return on investment of the assets that they man- agethe higher the reported return on...

Q:

Evaluating the potential of economic value added The owner of a chain of fast-food restaurants has decided to use economic value added to evaluate the performance of the managers of each of the...

Q:

Transfer pricing and outside opportunities Deseronto Electronics manufac- LQ 6 tures motherboards for computers. The company is divided into two divi sions-manufacturing and programming. The...