NEED EXCEL SOLVER!!!!! FOR FINAL ANSWER

National Wing Company (NWC) is gearing up for the new B-48 contract. NWC has agreed to produce 20 wings in April, 24 in May, and 30 in June. Currently, NWC has 100 fully qualified workers. A fully qualified 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. After another month, the apprentice becomes a qualified worker. Each trainer can train two recruits.

The production rate and salary per employee type is listed below.

Type of Employee	Production Rate (wings/month)	Wage per month
Production	0.6	$3,000
Trainer	0.3	$3,300
Apprentice	0.4	$2,600
Recruit	0.05	$2,200

At the end of June, NWC wishes to have no recruits or apprentices, but have at least 140 full-time workers.

Considering the above limitations, write a linear programming model to help NWC determine the number of employees in each type at each month (April, May, June) so as to minimize total wedge cost.

1.Define the Decision Variables

2.Define the Constraints