Question: answer using Solver on excel pls, show what you put 11-37 Product mix, constrained resource. Wechsler Company produces three products: A110, B382 and C657. All
11-37 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 C657 A110 $168 $112 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 468 CHAPTER 11 DECISION MAKING AND RELEVANT INFORMATION The demand for the products far exceeds the direct materials available to produce the products. Voxx costs S6 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, R3R2, and CAST should Wechsler produce? 2 What is the maximum amount Wechsler would be willing to pay for another 1,200 pounds of Voxx? Required inte
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
