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

answer using Solver on excel pls, show what you put answer using Solver on excel pls, show what you put 11-37 Product

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

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!