Question: Tycron Company produces 3 electrical products: clocks, radios and toasters.

Resource Requirements

Product Cost/unit Labor Hours

Clock $7.00 2

Radio 10.00 3

Toaster 5.00 2

The firm has a daily production budget of $2000 and a max of 660 hours of labor. Max daily demand is for 200 clocks, 300 radios and 150 toasters. Clocks sell for $15.00, radios for 20.00 and toasters for 12.00. The firm wants to know the optimal product mix that will maximize profit.

a. Formulate and solve using EXCEL. Send as an attachment.