### Develop model to more effectively plan production

Assignment Help Operation Management
##### Reference no: EM131153095

Elizabeth Burke wants to develop a model to more effectively plan production for the next year. Currently, PLE has a planned capacity of producing 9100 mowers each month, which is approximately the average monthly demand over the previous year. However, looking at the unit sales figure for the previous year, she observed that the demand for mowers has a seasonal fluctuation, so with this level production strategy there is over-production in some months, resulting in excess inventory buildup and underproduction in others, which may result in lost sales during peak demand periods. In discussing this with her, she explained that she could change the production rate by using planned overtime and under time (producing more or less than the average monthly demand), but this incurs additional cost, although it may offset the cost of lost sales or of maintaining excess inventory. Consequently, she believes that the company can save a significant amount by optimizing the production plan. Ms. Burke saw a presentation at a conference about a similar model that another company used but didn’t fully understand the approach. The power point notes didn’t have all the details but they did explain the variables and types of constraints used in the model. she thought they would be helpful to you in implementing an optimization model. Here are the highlights of the presentation. X^t=planned production in period t I^t=inventory held at the end of period t l^t=number of lost sales incurred in period t O^t=amount of overtime scheduled in period t U^t=amount of under time scheduled in period t R^t=increase in production rate from period t-1 to period t D^t=decrease in production rate from period t-1 to period t material in balance constraint: (X^t) + (I^t) – (I^t) + (L^t) =demand of the month Overtime /undertime constraint: (O^t)-(U^t) = (X^t)- normal production capacity Production rate-change constraint: (X^t) - (X^(t-1)) = (R^t) – (D^t) Ms. burke also provided the following data and estimates for the next year: unit cost production = \$70: inventory holding cost= \$1.40 per unit per month; lost sales cost=\$200 per unit; overtime cost =\$6.50 per unit; undertime cost is \$3.00 per unit; and production rate change cost = \$5.00 per unit. which applies to any increase or decrease in the production rate from the previous month. Initially 900 units are expected to be in inventory at the beginning of January, and the production rate for December 2012 was 9100 units. she believed that the monthly demand will not change substantially from last year so, the sales figures for last year in the PLE database should be used for the monthly demand forecast. Design a spreadsheet that provides detailed information on monthly production, inventory, lost cost, and the different cost categories and solve a linear optimization model for minimizing the total cost of meeting demand over the next year. compare the solution with the level of production strategy of producing 9100 units each month.

#### Eventually receive service in a first-in-first-out

Vincent’s barbershop. Vincent’s barbershop is very modest in size. It consists of a single barber’s chair where Vincent serves his customers and two other chairs for waiting c

#### What is the most that should be paid for this forecast

A market research firm will analyze market conditions and will provide a perfect forecast (they provide a money back guarantee). What is the most that should be paid for thi

#### Using project management tools

Assume that you were assigned the Project Manager role in March for implementing off-site training for five members of the Product Innovation team. The training must be comple

#### Calculate crew constraints to determine decision variables

AirPlains Airline is a new airline company that maintains a schedule of two daily flights each way between Salt Lake City, Denver, and Chicago. AirPlains Airline must strategi

#### Regarding the requests for roads and schools

Regarding the requests for roads and schools, does Chong understand exactly what the Mayor has asked of him? Is he correct to assume that this may be a request for a bribe? Wh

#### Include time of payment is instrument payable on demand

Every instrument that does not include a time of payment is an instrument payable on demand. An instrument will be considered bearer paper only after it is determined that it

#### Develop a process chart for installing a new memory board

Make an operations chart of one of the following: - Putting a new eraser in (or on) a pencil - Putting a paper clip on two pieces of paper - Putting paper in a printer  - Deve

#### Key trade-offs in determining the economic order quantity

What are the key trade-offs in determining the economic order quantity? In the early days of paint manufacturing, manufacturers of paint used to produce paint of appropriate c