Question: Hello would like help solving this problem with solver in Excel. I'm not sure what to plug in for the set objective, by changing variable

 Hello would like help solving this problem with solver in Excel.

Hello would like help solving this problem with solver in Excel. I'm not sure what to plug in for the set objective, by changing variable cells, subject to constraints. Below is my work that I have.

I'm not sure what to plug in for the set objective, by

Product mix, constrained resource. Wechsler Company produces three products: A110, B382, and C657. All three products use the same direct material, Voxx. Unit data for the three products are: Product B382 $112 A110 $168 C657 140 Selling price Variable costs Direct materials Labor and other costs Quantity of Voxx per unit 48 56 8 lb. 30 54 5 lb. 18 80 3 lb. The demand for the products far exceeds the direct materials available to produce the products. Voxx costs $6 per pound, and a maximum of 5,000 pounds is available each month. Wechsler must produce a minimum of 200 units of each product. 1. How many units of product A110, B382, and C657 should Wechsler produce? A20 f B E F . 1 J K L L M N 0 P Q Products B382 C657 112 140 Solver Parameters 168 48 30 18 56 54 80 1 2 A110 3 Selling price 4 Direct materials 5 Labor & other costs 6 Contribution 7 Quantity of Voxx per unit (lbs) 8 Contribution/pound of mat. 9 Min 10 Number of units produced 11 Set Objective: $A$20 64 28 5 42 3 3 8 To: O Max O Min O Value of: 0 8 6 200 14 200 200 By Changing Variable Cells: 1 12 Subject to the Constraints: 13 Add Change Delete 14 6 per pound 15 Max of 5,000 pounds per month 16 minimum of 200 units of each must be produced 17 18 19 1. How many units of each product should be produced? 20 21 Reset All Load/Save 22 Make Unconstrained variables Non-Negative 23 GRG Nonlinear Select a Solving Method: Options 24 25 26 27 Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. 28 29 30 31 Help Solve Close 32 33

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!