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 3 Gajah Sdn Bhd makes two products (Alpha and Beta) that require direct materials, direct labour and overhead. The operations for next month are: Alpha RM Beta Revenue Direct material Direct labour Overhead: Direct material related Direct labour related RM 300,000 60,000 95,000 Total RM 400,000 90,000 135,000 100,000 30,000 40,000 13,500 40,500 Required : a) Gajah uses a two-stage cost allocation system. It uses direct material costs to allocate direct materials related overhead and direct labour costs to allocate direct labour related overhead costs: i. Calculate the direct material related overhead rate for next month. ii. Calculate the direct labour related overhead rate for next month iii. What is the total overhead allocated to product Alpha next month? iv. What is the total overhead allocated to product Beta next month?
Question 1: Operations managers should use different techniques and models to make sure that they are operating the Operations function in the proper way. Triple Bottom Line (TBL) is one technique or model which evaluates the performance of an organization. Discuss how the Triple Bottom Line (TBL) model could assess the performance of the Operations function. Support your answer with relevant examples.
QUESTION 2 a. Describe any five risks that small businesses are exposed to in their operations.
QUESTION 2 No 2 Rock and Ventilation (RV) shaft of Deep Levels Gold Mining Ltd was designed to handle 255 000 tons of rock per month. The effective capacity of the mine is, however, only 245 000 tons of rock per month. 2.1 Calculate the efficiency of this shaft for the past month when 225 000 tons of rock were hoisted. 2.2 Calculate the productivity of employees per panel that produces 36 m2 per blast when 9 persons are required per panel.
Business Name: CV Water Refill Location: 3rd Street Chula Vista, CA 91911 Financial Management: a. Accounting (How will you manage your business accounting?): b. Professional Resources (List all to be used): c. Credit and Financing (List resources for financing your business venture): d. Billable Rate/Break-Even Sales
question atatched
Question 5 You are receiving an shipment and come across a box of shaving cream. What should you do? Please choose all that apply. Receive the shaving cream Raise an Andon CSecure it well with bubble wrap after scanning it in O Note is as Flammable on your workstation Submit
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 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.)
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.