PLEASE USE LINEAR PROGRAM AND EXCEL TO SOLVE THE QUESTION SHOW FORMULAS IN EXCEL. SHOW FORMULAS IN EXCEL. SHOW FORMULAS

[answerhappygod]

PLEASE USE LINEAR PROGRAM AND EXCEL TO SOLVE THEQUESTION
SHOW FORMULAS IN EXCEL. SHOWFORMULAS IN EXCEL. SHOW FORMULAS INEXCEL. SHOW FORMULAS IN EXCEL.
SHOW FORMULAS IN LINEAR PROGRAM. SHOW FORMULAS INLINEAR PROGRAM. SHOW FORMULAS IN LINEAR PROGRAM. SHOWFORMULAS IN LINEAR PROGRAM.
OR SEND BOTH FILES TO MYEMAIL [email protected]
A manufacturer makes a production plan subject to certainconstraints of resources with the goal of maximizing itsrevenues.
Air conditioner sells at $2900 per unit, smart TV sells at $3200per unit, Stereo sells at $7200 per unit, and Desktop sellsat $5400 per unit.
To produce one unit of AC, 4 units of Electronic components areneeded, 1 unit of Non-electronic components is needed, 2 units ofAssembly line time are needed; To produce one unit of Smart TV, 4units of Electronic components are needed, 2 units ofNon-electronic components are needed, 1 unit of Assembly line timeis needed;
To produce one unit of Stereo, 9 units of Electronic componentsare needed, 6 units of Non-electronic components are needed, and 5units of Assembly line time are needed;To produce one unit of Desktop, 3 units of Electronic componentsare needed, 3 units of Non-electronic components are needed, and 2units of Assembly line time are needed.
The available capacity for Electronic components is 4700 units;the capacity for Non-electronic components is 4500 units; thecapacity 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 productionplan?
(f) If 10 more units of Assembly time were available, howwould the optimal
revenue change?
(g) If the price of a Smart TV changes from $3200 to $4200per unit, how would the
optimal production plan change?