The following questions use the data below A store wants to predict quarterly sales The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k 4 A B C D E F G H I 1 Time Actual Moving Dbl Moving 2 Year Qtr Period Sales Ave Ave Level Trend Forecast 3 1 1 1 368 4 2 2 168 5 3 3 530 6 4 4 784 462 50 7 2 1 5 770 563 00 8 2 6 354 609 50 9 3 7 1012 730 00 591 25 868 75 92 50 10 4 8 1244 845 00 686 88 1003 13 105 42 961 25 11 3 1 9 1326 984 00 792 13 1175 88 127 92 1108 54 12 2 10 986 1142 00 925 25 1358 75 144 50 1303 79 13 3 11 1624 1295 00 1066 50 1523 50 152 33 1503 25 14 4 12 2090 1506 50 1231 88 1781 13 183 08 1675 83 15 4 1 13 16 2 14 Refer to Exhibit 11 6 What formula should be entered in cell H9 to compute the trend using the double moving average model with k 4 a 2 (D9 F9) (4 1) b 2 (E9 F9) (4 2) c 2 (E9 F9) (4 1) d 2 (AVERAGE(E9,F9)) 4

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

Question: The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants

The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4.

	A	B	C	D	E	F	G	H	I
1			Time	Actual	Moving	Dbl Moving
2	Year	Qtr	Period	Sales	Ave	Ave	Level	Trend	Forecast
3	1	1	1	368
4		2	2	168
5		3	3	530
6		4	4	784	462.50
7	2	1	5	770	563.00
8		2	6	354	609.50
9		3	7	1012	730.00	591.25	868.75	92.50
10		4	8	1244	845.00	686.88	1003.13	105.42	961.25
11	3	1	9	1326	984.00	792.13	1175.88	127.92	1108.54
12		2	10	986	1142.00	925.25	1358.75	144.50	1303.79
13		3	11	1624	1295.00	1066.50	1523.50	152.33	1503.25
14		4	12	2090	1506.50	1231.88	1781.13	183.08	1675.83
15	4	1	13
16		2	14

Refer to Exhibit 11.6. What formula should be entered in cell H9 to compute the trend using the double moving average model with k = 4?

a. =2*(D9-F9)/(4-1)

b. =2*(E9-F9)/(4*2)

c. =2*(E9-F9)/(4-1)

d. =2*(AVERAGE(E9,F9))/4

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!

Exhibit 11.5 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the...

The following questions use these data Joes Sporting Goods wants to forecast quarterly sales figures using seasonal indices The store has collected 12 quarters of data and needs help analyzing the...

Exhibit 11.8 The following questions use these data. Joes Sporting Goods wants to forecast quarterly sales figures using Winters method. The store has collected 12 quarters of data and needs hel

A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the multiplicative seasonal effects model. What are predicted...

A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4. A B C D E F G H I 1...

A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the multiplicative seasonal effects model. A B C D E F G H I J...

When Greenway, Inc. sells 48,300 units, its total fixed cost is $159,390. What is its total fixed cost when it sells 49,800 units? Multiple Choice O $174,240 O $159,390 O $164,340 O $154,440

Tonya had the following items for last year: Salary .............. 40,000 Short-term capital gain ....... 12,000 Non-business bad debt ........ (10,000) Long-term capital loss ........ (5,000) For...

Jane transfers land with an adjusted basis of $ 1 0 0 , 0 0 0 and a fair market value of $ 2 5 0 , 0 0 0 to Giant Inc., a newly incorporated C corporation, for all its stock. Four days prior to the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...