Picture 1

Picture 2

Consumer Electronics makes a variety of small household appliances. Various models of toasters, coffee makers, and bread machines account for most of their production. The demand for each family for the next three months, the average number of each product a worker can produce in a month, and their average holding cost is in the Picture 2. All workers are paid $2000 per month. Hiring a new worker costs $1200 and laying off a worker costs $2500. A new worker goes through one month of on-the-job training, during which he or she can only produce half of the output of a trained worker. For stability, Consumer Electrics wants no more than a 15 percent change in work force in any month: currently, there are 55 workers. Backorders are not allowed. Develop and solve a model to determine an aggregate production plan for Consumer Electronics. (USING EXCEL)

ot make5.13) Compare it wilh hE SpICAUA led ronics makes a variety of small household appliances. Various models of toast- kers, and bread machines account for most of their production. The demand for each mpliL8. Consumer Elect ot make5.13) Compare it wilh hE SpICAUA led ronics makes a variety of small household appliances. Various models of toast- kers, and bread machines account for most of their production. The demand for each mpliL8. Consumer Elect