Refer to Table 6-3. Calculate MAD for all forecasting models. The model you would use for your forecast,

based on MAD is ________.

Fill in the blanks with correct word


Table 6-4. Solutions to Calculation of MAD
Time
Period
Actual
Sales
3 Month
Moving
Average
Absolute
Deviation
Weighted
Moving
Average
W=.1,.3,.
6
Absolute
Deviatio
n
Exponentia
l
Smoothing
F
t = 350
Absolute
Deviation
1 230 350
2 238 326 88
3 260 308 48
4 275 243 32 250 25 299 24
5 300 258 42 267 33 294 6
6 285 278 7 289 4 295 10
7 270 287 17 289 19 293 23
8 290 285 5 278 13 289 1
9 305 282 23 284 22 289 16
10 320 288 32 297 23 292 28
11 335 305 30 313 23 298 37
12 320 328 305
SUM = 188 159 282
n = 8 8 10
MAD 23.5 19.875 28.245
We would choose the Weighted Moving Average Model, as it has the lowest MAD of 19.875.

Business

You might also like to view...

Product line filling occurs when a company lengthens its product line beyond its current range

Indicate whether the statement is true or false

Business

The Income Summary account is used to:

A. Replace the Retained earnings account in some businesses. B. Adjust and update asset and liability accounts. C. Close the revenue and expense accounts. D. Determine the appropriate dividend amount. E. Replace the income statement under certain circumstances.

Business

Marie is a software developer who works freelance. She wants her customers to really value her work and so she consistently sets her prices higher than the competition. Sometimes she loses work because of this, but often she wins the contract. What kind of pricing is she using?

a. prestige pricing b. pre-emptive pricing c. product line pricing d. placement pricing e. price discrimination

Business

A payday loan is a reasonable option if you need a luxury item like a big screen TV

Indicate whether this statement is true or false.

Business