Tiffany's Toothpick Tower Tiffany's Toothpick Tower Company manufactures toothpicks for wholesale. The following is information regarding Tiffany's
Question:
Tiffany's Toothpick Tower Tiffany's Toothpick Tower Company manufactures toothpicks for wholesale. The following is information regarding Tiffany's sales over the past year follows: Time Period Actual Sales (in thousands, S000) 1425 1458 1505 1640 1550 1580 1612 1628 1670 1705 1730 1 2 3 4 5 6 7 8 9 10 11 12 1. Using Excel - recreate this spreadsheet and using formulas calculate using a 3. month moving average the forecast for month 12. 2. Using Excel - continuing with same spreadsheet do the following: a. Use the answer to #1 above as the "Actual" for month 12 b. Create a new column and calculate a weighted average forecast for months 4 through 12, using the weights 3, 5, and 9. (Remember: At these weights - what are you dividing by???) c. Create two new columns showing the AIA-FI for both the Moving Average and the Weighted Moving Average d. Determine the MAD for these forecasts. 3. Using Excel - and again using the above data along with your 3-month moving average calculation for month 12 - find SLOPE and INTERCEPT and using the Linear Regression method forecast sales for year 2 This is independent from #2 above. Only the given data above along with month 12 answer to #1) is to be used.
Fundamental Accounting Principles
ISBN: 978-0071051507
Volume I, 14th Canadian Edition
Authors: Larson Kermit, Tilly Jensen