In: Operations Management
National Wing Company (NWC) is gearing up for the new B-48
contract. Currently NWC has 100 equally qualified workers. Over the
next three months NWC has made the following commitments for wing
production:
Month |
Wing Production |
May |
20 |
June |
24 |
July |
30 |
Each worker can either be placed in production or can train new
recruits. A new recruit can be trained to be an apprentice in one
month. The next month, he, himself, becomes a qualified worker
(after two months from the start of training). Each trainer can
train two recruits. The production rate and salary per employee is
estimated below.
Employee |
Production Rate (Wings/Month) |
Salary Per Month |
Production |
.6 |
$3,000 |
Trainer |
.3 |
3,300 |
Apprentice |
.4 |
2,600 |
Recruit |
.05 |
2,200 |
At the end of July, NWC wishes to have no recruits or apprentices but have at least 140 full-time workers. Formulate and solve a linear program for NWC to accomplish this at minimum total cost.
(Please provide excel sheets)