A manufacturer makes a production plan subject to certain constraints of resources with the goal of maximizing its revenues.

Air conditioner sells at $2900 per unit, smart TV sells at $3200 per unit, Stereo sells at $7200 per unit, and Desktop sells at $5400 per unit.

To produce one unit of AC, 4 units of Electronic components are needed, 1 unit of Non-electronic components is needed, 2 units of Assembly line time are needed; To produce one unit of Smart TV, 4 units of Electronic components are needed, 2 units of Non-electronic components are needed, 1 unit of Assembly line time is needed;

To produce one unit of Stereo, 9 units of Electronic components are needed, 6 units of Non-electronic components are needed, and 5 units of Assembly line time are needed; To produce one unit of Desktop, 3 units of Electronic components are needed, 3 units of Non-electronic components are needed, and 2 units of Assembly line time are needed.

The available capacity for Electronic components is 4700 units; the capacity for Non-electronic components is 4500 units; the capacity for the assembly line time is 2500 units.

(a) Formulate this into a linear program

(b) Use Excel to solve the problem

(c) What is the optimal production plan?

(d) Which constraints are binding?

(e) What is the revenue under the optimal production plan?

(f) If 10 more units of Assembly time were available, how would the optimal

revenue change?

(g) If the price of a Smart TV changes from $3200 to $4200 per unit, how would the

optimal production plan change?