Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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.
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 33Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started