Reference no: EM131742686

Problem M Your company is planning the next 5 months of production and you are to develop the high level (aggregate) plan. You should try to end period 5 with zero inventory if possible. The costs are given in the table below. The marketing department says the plan cannot have any items on backorder at any time. Management choses to chase demand but will allow up to 2,000 bottles per period to be made using overtime and up to 500 bottles per period using subcontractors The number of employees per period is given; each employee can produce 2,000 bottles per period Note: If you have employees on the regular shift, you must allow them to produce product The forecast is given below. Warehouse B reports that you have a beginning inventory of 6,000 bottles. Period 1 2 3 4 5 Totals Forecast (bottles) 14,500 15,200 14,900 15,900 15,555 76,055 Number of employees 7 7 6 6 6 Output Regular Overtime Subcontractor Output – Forecast Inventory Beginning Ending Average Backlog Costs Regular @ $2.90 / bottle Overtime @ $3.45 / bottle Subcontractor @ $4.04 / bottle Hire / Lay Off @ $1,250 each Inventory @ $0.55 / bottle Backlog @ $1.00 / bottle Total Costs: