Question Problem 3-20 (Algo) An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is Ft = 124 + 2.1t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) t Units Sold 11 148 12 149 13 148 14 145 15 153 16 152 17 152 18 159 19 161 20 165 Click here for the Excel Data File b. Assuming actual September usage of 64 percent, prepare a forecast for October usage. (Round your answer to 2 decimal places.)

6IU8PX The Asker · Management

Problem 3-20 (Algo)

An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is Ft = 124 + 2.1t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.)

t Units Sold
11 148
12 149
13 148
14 145
15 153
16 152
17 152
18 159
19 161
20 165

Click here for the Excel Data File



b. Assuming actual September usage of 64 percent, prepare a forecast for October usage. (Round your answer to 2 decimal places.)

More