Problem 3-9 a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) New Period Accounts New Period New Accounts Period , 200 6 233 217 244 211 250 225 9 251 235 10 267 7 UAWN in WNP 281 275 284 288 317 14 15 Y = 16= Y17= Y18= Y19= b.Use trend-adjusted smoothing with a = .2 and B = .1 to smooth the new account data in part a. What is the forecast for period 16? Compute the initial trend estimate (T+) for Period 5 as follows: (Period 4 data - Period 1 data) / 3. Then compute the initial trend-adjusted forecast (TAF+) for Period 5 as follows: Period 4 data + Initial trend estimate for Period 5. Then compute all remaining values (including the St value for Period 5) using the textbook formulas or Excel template. (Round the "Trend"values (Tt) to 3 decimal places and all other intermediate forecast values (TAFt and St) to 2 decimal places. Round your final answer to 2 decimal places.) Forecast for period 16 Problem 3-10 After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 19 for the three periods from 1 to 4, for an average of +6.33 units. PeriodActual PeriodActual 1 2036 252 222 7 267 217 277 222 282 242 10 - Use a=.60 and B=.15, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10. (Round your intermediate calculations and final answers to 2 decimal places.) TAFt Period Problem 3-9 a. Obtain the linear trend equation for the following data on new checking accounts at Fair Savings Bank and use it to predict expected new checking accounts for periods 16 through 19. (Round your intermediate calculations and final answers to 2 decimal places.) New Period Accounts New Period New Accounts Period , 200 6 233 217 244 211 250 225 9 251 235 10 267 7 UAWN in WNP 281 275 284 288 317 14 15 Y = 16= Y17= Y18= Y19= b.Use trend-adjusted smoothing with a = .2 and B = .1 to smooth the new account data in part a. What is the forecast for period 16? Compute the initial trend estimate (T+) for Period 5 as follows: (Period 4 data - Period 1 data) / 3. Then compute the initial trend-adjusted forecast (TAF+) for Period 5 as follows: Period 4 data + Initial trend estimate for Period 5. Then compute all remaining values (including the St value for Period 5) using the textbook formulas or Excel template. (Round the "Trend"values (Tt) to 3 decimal places and all other intermediate forecast values (TAFt and St) to 2 decimal places. Round your final answer to 2 decimal places.) Forecast for period 16 Problem 3-10 After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 19 for the three periods from 1 to 4, for an average of +6.33 units. PeriodActual PeriodActual 1 2036 252 222 7 267 217 277 222 282 242 10 - Use a=.60 and B=.15, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10. (Round your intermediate calculations and final answers to 2 decimal places.) TAFt Period
