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 11 2 3 4 5 Y Y16 Y17 Y18 Y19 200 218 211 227 235 = = = = = 6 7 8 9 10 Forecast for period 16 + 231 247 250 252 267 it 12 13 14 15 281 275 287 288 307 b.Use trend-adjusted smoothing with a = .2 and 3 = .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.)

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 11 2 3 4 5 Y Y16 Y17 Y18 Y19 200 218 211 227 235 = = = = = 6 7 8 9 10 Forecast for period 16 + 231 247 250 252 267 it 12 13 14 15 281 275 287 288 307 b.Use trend-adjusted smoothing with a = .2 and 3 = .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.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Question 16 MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost = SR 17 per unit per month Average pay rate = SR 10 per hour Labor-hours to produce a unit = 4 hours per unit Daily working hours = 8 hours a) Using excel, caleulate the total cost of the following plan : - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. (Answer in Field ) Attach your solutions.
A strong attraction for both a hotel guest and employee is to know the hotel is known for which of the following? Question 7 options: a) Being an employer of choice b) Being a high cost hotel c) Being a good service hotel d) Being a hotel with high turnover
Please help me. Thankyou.
Question attached
question 1 Terminator, Inc., manufactures a motorcycle part in lots of 250 units. The raw materials cost for the part is $150, and the value added in manufacturing 1 unit from its components is $280, for a total cost per completed unit of $430. The lead time to make the part is 3 weeks, and the annual demand is 4,200 units. Assume 50 working weeks per year. a. How many units of the part are held, on average, as cycle inventory? nothing units. (Enter your response as an integer.) What is its value? $_______.(Enter your response as an integer.) b. How many units of the part are held, on average, as pipeline inventory? nothing units. (Enter your response as an integer.) What is its value? $________________ (Enter your response as an integer.)
Please do not give solution in image format thanku
H1.
Question 5: Quality Control and Inspection a) Describe the importance of quality control and inspection in ensuring product/service quality. b) Discuss the different types of quality control techniques, such as statistical process control and acceptance sampling, and explain how they can be used in an organization to monitor and control quality. Bonus Question Explain how the u Explain how the use of technology, such as automation, artificial intelligence, and data analytics, can impact operations management and total quality management in organizations. Provide examples of how organizations can leverage these technologies to improve their operations and quality management practices.
QUESTION 4a. Differentiate between design capacity and capacity utilization. b. Briefly describe three capacity expansion strategies. \