tran company

They are both manufactured totally
in two departments: A, which has a total capacity of 240 labour-hours per week; and
B, which has a capacity of 480 labour-hours per week. The labour requirements
(hours per unit) for each model are:
Model Y Model Z
Department A 1.0 0.8
Department B 0.5 2.0
The unit contribution of Model Y is $4 and for Model Z it is $5. The total production of
Y can be sold, but only a weekly maximum of 200 units of Model Z can be sold.
Required: How many of each radio should be manufactured? (Construct the basic
equations and solve graphically in Microsoft Excel)