Busn278

Submitted by: Submitted by

Views: 298

Words: 507

Pages: 3

Category: Business and Industry

Date Submitted: 11/03/2013 07:36 PM

Report This Essay

Question 1. (TCO 1) Budgets are prepared for: (Points : 4) |

       an organization

       a department

       a product

       All of the above

|

Question 2. (TCO 2) Using the table “Paint Sales Time Series”, calculate the forecast for paint sales (in thousands) for Week 11 using a three day moving average. 

  Paint Sales Time Series |

Week | Sales (000’s of gallons) |

1 | 6 |

2 | 8 |

3 | 10 |

4 | 9 |

5 | 11 |

6 | 12 |

7 | 10 |

8 | 8 |

9 | 7 |

10 | 9 |

(Points : 4) |

       8

       9

       10

       11

|

Question 3. (TCO 2) Using the table “Paint Sales Time Series”, calculate the mean absolute deviation for a three day moving average. 

  Paint Sales Time Series |

Week | Sales (000’s of gallons) |

1 | 6 |

2 | 8 |

3 | 10 |

4 | 9 |

5 | 11 |

6 | 12 |

7 | 10 |

8 | 8 |

9 | 7 |

10 | 9 |

(Points : 4) |

       2.67

       1.76

       2.54

       3.67

|

Question 4. (TCO 2) Using the table “Gasoline Sales Time Series”, calculate the forecast for gasoline sales (in thousands) for Week 13 using a three day weighted moving average. Use a weight of .60 for the most recent observation, .30 for the second most recent, and .10 for the third most recent.

  Gasoline Sales Time Series |

Week | Sales (000’s of gallons) |

1 | 17 |

2 | 21 |

3 | 19 |

4 | 23 |

5 | 18 |

6 | 16 |

7 | 20 |

8 | 18 |

9 | 22 |

10 | 20 |

11 | 15 |

12 | 22 |

(Points : 4) |

       18.40

       18.60

       19.40

       19.70

|

Question 5. (TCO 2) Using the table “Paint Sales Time Series”, calculate the forecast for paint sales (in thousands) for Week 11 using exponential smoothing and a smoothing constant of .20. 

  Paint Sales Time Series |

Week | Sales (000’s of gallons) |

1 | 6 |

2 | 8 |

3 | 10 |

4 | 9 |

5 | 11 |

6 | 12 |

7 | 10 |

8 | 8 |

9 | 7 |

10 | 9 |

(Points : 4) |

       6.40

       7.97

       8.64

       9.17

|

The continuous budget approach provides...