Purchase Solution

Forecasting Methods

Not what you're looking for?

Ask Custom Question

Scenario: Suppose that you are the operations manager for ABC Manufacturing, a small manufacturing company founded three years ago. ABC has been manufacturing and selling an electric motor for the past year, but the company has not always had sufficient workers assigned to manufacturing this electric motor in order to satisfy demand. ABC's president asked you to plan for the production of this motor for the next six months.

You have decided you will use a level aggregate plan for the electric motor, meaning that you will manufacture the same number of units each month. ABC's president has told you that some customers order this motor well in advance of when needed, and thus it is allowable to have backorders, if needed. You know there are currently 150 units in inventory (starting inventory = SI), and ABC's marketing manager estimates that the demand for the motor (in units) for each of the next six months (M = 6) will be 240, 225, 265, 270, 260, and 275 (D1, D2, D3, D4, and D5 respectively).

You have decided you would like to reduce average inventory level of several products (including this one), and you want to have 50 units in inventory six months from now (ending inventory = EI).

Describe the operations management issue in the ABC Manufacturing scenario and describe how you would approach an analysis. Then complete the following problems based on the scenario and provide answers to the algebraic equations.

1. Refer to the ABC Manufacturing scenario to complete the following:

Provide the algebraic equation for the monthly aggregate production rate (APR, using SI, EI, D1, D2, D3, D4, D5, and M as variables).
Calculate and provide the numerical monthly aggregate production rate rounded to a whole number.

2. Production employees at ABC work an average of 168 hours per month (HPM), and manufacturing the electric motor involves 3.5 total hours of work per unit (HPU).

Provide the algebraic equation for the number of workers (W) needed to meet the above aggregate production rate (using W, APR, HPM, and HPU as variables).
Calculate and provide the numerical number of workers needed.

3. One subcomponent in this electric motor is also used in two other products manufactured by ABC. ABC's president has told you that the company expects to use 5,400 (annual quantity = AQ) of these subcomponents during the next 12 months, with a consistent demand for them month-to-month (and a consistent demand during each month, with the business day daily demand, DQ, being 22). He has further told you that it costs $10 to place an order (order cost = OC) for this subcomponent (regardless of the quantity ordered), that the annual holding cost is $2 per unit (unit holding cost = UHC). Finally, he has stated that out of 21 business days per month, there is a five business day lead time (LT = 5) associated with ordering this subcomponent.

Provide the algebraic equation for the economic order quantity (EOQ, using AQ, OC, and UHC as variables).
Calculate and provide the numerical economic order quantity rounded to the closest whole number.

4. Refer to the ABC Manufacturing scenario to complete the following:

Provide the algebraic equation for the reorder point (RP, using DQ and LT as variables).
Calculate and provide the numerical EOQ, rounded to the closest whole number.

5. Historically, ABC has based its production on estimates from the company's marketing manager. While that has generally been successful, you have decided you would like to factor in an operations management approach to estimating demand.

Describe the following forecasting methods. Provide the math associated with each method.
Naïve.
Simple mean.
Simple moving average.
Weighted moving average.
Exponential smoothing.
Linear trend line.

Purchase this Solution

Solution Summary

The solution describes the various forecasting methods.

Solution Preview

Scenario: Suppose that you are the operations manager for ABC Manufacturing, a small manufacturing company founded three years ago. ABC has been manufacturing and selling an electric motor for the past year, but the company has not always had sufficient workers assigned to manufacturing this electric motor in order to satisfy demand. ABC's president asked you to plan for the production of this motor for the next six months.
You have decided you will use a level aggregate plan for the electric motor, meaning that you will manufacture the same number of units each month. ABC's president has told you that some customers order this motor well in advance of when needed, and thus it is allowable to have backorders, if needed. You know there are currently 150 units in inventory (starting inventory = SI), and ABC's marketing manager estimates that the demand for the motor (in units) for each of the next six months (M = 6) will be 240, 225, 265, 270, 260, and 275 (D1, D2, D3, D4, and D5 respectively).
You have decided you would like to reduce average inventory level of several products (including this one), and you want to have 50 units in inventory six months from now (ending inventory = EI).
Describe the operations management issue in the ABC Manufacturing scenario and describe how you would approach an analysis. Then complete the following problems based on the scenario and provide answers to the algebraic equations.
In the given scenario, firm needs intermediate range capacity planning. We have to estimate the manpower requirement based upon demand forecasts. We can go for level aggregate plan which can provide us constant workforce and can help up ...

Solution provided by:
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution


Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.