Obtain the linear trend equation

Assignment Help Operation Management

Reference no: EM131234499

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.) Period New Accounts Period New Accounts Period New Accounts 1 200 6 234 11 281 2 217 7 244 12 275 3 211 8 250 13 283 4 229 9 250 14 288 5 235 10 267 15 303 Y = + t Y16 = Y17 = Y18 = Y19 = b. Use trend-adjusted smoothing with α = .2 and β = .1 to smooth the new account data in part a. What is the forecast for period 16? Compute the initial trend estimate (Tt) for Period 5 as follows: (Period 4 data – Period 1 data) / 3. Then compute the initial trend-adjusted forecast (TAFt) 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

Reference no: EM131234499

Questions Cloud

Adjusted forecast to predict demand for packaged tours : The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: Period Demand Predicted 1 129 117 2 194 200 3 164 150 4 91 100 5 84 80 6 132 142 7 126 ..

What percentage of variation is explained by regression line : The following data were collected during a study of consumer buying patterns: Observation x y Observation x y 1 20 70 8 16 75 2 21 79 9 17 72 3 38 86 10 17 71 4 32 86 11 27 90 5 48 93 12 19 93 6 46 95 13 38 94 7 28 79 b. Obtain a linear regression li..

Radio frequency inventory-linear trend equation : National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 17 Mar. 18 Apr. 11 May. 22 Jun. 19 Jul. 21 Aug. 22 b. Forecast September sales volume using each of the fol..

Whole foods market performing from strategic perspective : How well is Whole Foods Market performing from a strategic perspective? Does Whole Foods enjoy a competitive advantage over its 3 chief rivals-Wild Oats, Fresh Market and Trader Joe's?

Obtain the linear trend equation : 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. What is the forecast for period 16? Then compute all remaining value..

Handling recalls and customer satisfaction : Toyota: Handling Recalls and Customer Satisfaction When Toyota launched its Lexus brand in 1989, it faced a steep uphill battle. The luxury car segment was dominated by Mercedes-Benz, which combined high performance with style and cutting-edge engine..

Are there unique challenges to communicating with groups : Analyze how communication in groups differs from individual communication. Are there unique challenges to communicating with groups? Provide examples. Use at least one resource to support your key points.

Use to minimize foreign exchange exposure : Briefly describe the tactics and strategies the organizations should use to minimize foreign exchange exposure. What was this agreement about? What financial institutions were established and for what purpose?

Cost of capital for the proposed investment project : The company’s stock is hundred percent owned by its several cofounders, and the current market price of each of the 500,000 shares of stock is $20. When you started your work, you were immediately assigned a big project. What is the weighted average ..

User Account

All Pages