3rd year, Operations & Production Planning Question: Please use the info. below and Linear programming, to come up with the most optimal aggregate Production plan via EXCEL. you may need to set up constraints Costs Regular Time Labour 15 Overtime Labour 22 Subcontracting cost (per unit) 74 Inventory carrying cost (per unit per month) 3 Material cost (per unit) 40 Selling Price (per unit) 125 Hiring Cost (per new employee) 1000 Lay-off cost (per laid off employee) 2000 Starting Inventory 5000 Desired Ending Inventory 5000 Overtime Limit (number of units produced per employee) 10 Production Capacity (per employee per month) 80 units Starting Workforce 250 workers Labour hours per unit
