use the info. below and Linear programming, to come up with the most optimal aggregate Production plan
Fantastic news! We've Found the answer you've been seeking!
Question:
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 | 2 |
| MAX overtime per month per employee, HOURS | 20 |
| # of working days per month | 20 |
| # of hours per day | 8 |
Expert Answer:
In order to create the most optimal aggregate production plan using the information provided and the linear programming approach in Excel several step... View the full answer
Related Book For 
Posted Date:
