Chapter 151. Resolve the composite example assuming that a minimum demand of 200 units for each composite must be met.

2.Assuming unlimited demand and limited resources, find a feasible solution that earns $1 billion in profit.

294xis Read-Onlyl-Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in From Access From Web From Tet Sources Connections Al-Edit Link Solver - Data Analysis rom Other Existing Refresh Sort Filter Text to Flash Remove Data Consolidate What-If Relationships Group Ungroup Subtotal Advanced Col Get bternal Data Sort &Filter Solver Parameters D12 XxSUMPRODUCT(09:19,SD$2:$I$2) Set Objective Max Min value of: Pounds made 200 200 200 200 200 200 4500 Labor 1600 Raw Material By Changing Variable Cells: DS2 SIS2 2.5 0.3 S 12 50 $ 11.00$ 9.00$ 7.00$ 6.00$ 3.00 S 650$ 5.70 360$ 280 $ 2.20 120 977 1084 055 3 2 26 08 Unt price Variable cost Subject to the Constraints: SDS14:SDS15 SFS14:SFS15 SD$2-SI52200 928 1041 Unit proft cont S 600$ 5.30$ 5.40$ 4.20$ 3.80$ 1.8 13 Labor Used Raw Material Used 4400 e- 1820 15 16 17 18 600 Reset All is no feasble 20 21 Select a Solving Method: Simplex LP Solving Method Select the GRG Nonlinear engine for Solrer Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine tor Solver problems that are non-smooth. 31 32 E 8:35 AM 11/13/2015 294xis Read-Onlyl-Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in From Access From Web From Tet Sources Connections Al-Edit Link Solver - Data Analysis rom Other Existing Refresh Sort Filter Text to Flash Remove Data Consolidate What-If Relationships Group Ungroup Subtotal Advanced Col Get bternal Data Sort &Filter Solver Parameters D12 XxSUMPRODUCT(09:19,SD$2:$I$2) Set Objective Max Min value of: Pounds made 200 200 200 200 200 200 4500 Labor 1600 Raw Material By Changing Variable Cells: DS2 SIS2 2.5 0.3 S 12 50 $ 11.00$ 9.00$ 7.00$ 6.00$ 3.00 S 650$ 5.70 360$ 280 $ 2.20 120 977 1084 055 3 2 26 08 Unt price Variable cost Subject to the Constraints: SDS14:SDS15 SFS14:SFS15 SD$2-SI52200 928 1041 Unit proft cont S 600$ 5.30$ 5.40$ 4.20$ 3.80$ 1.8 13 Labor Used Raw Material Used 4400 e- 1820 15 16 17 18 600 Reset All is no feasble 20 21 Select a Solving Method: Simplex LP Solving Method Select the GRG Nonlinear engine for Solrer Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine tor Solver problems that are non-smooth. 31 32 E 8:35 AM 11/13/2015