F G H J K L M 0 P 11-39 Product mix, constrained resource. Westford Company produces three products, A110, B382, and C657. Unit data for the three products follows: Selling price Variable costs Direct materials Labor and other costs Product A110 B382 C657 $84 $56 70 225 24 15 9 28 27 40 All three products use the same direct material, Bistide. The demand for the products far exceeds the direct materials available to produce the products. Bistide costs $3 per pound and a maximum of 5,000 pounds is available each month. Westford must produce a minimum of 200 units of each product. 1. How many units of product A110, B382, and C657 should Westford produce? 2. What is the maximum amount Westford would be willing to pay for another 1,000 pounds of Bistide? Total YouTube Video for a Nested MAX and IF Function http://youtu.be/F5YPNWbZ Constraints FS + MacBook A F6 F7 114 FB F9 F10 F11 F12 1 Product Mix and Constrained Resources 2 3 4 Selling price J 9 E A110 8382 C657 $ 84 $ 56 $ 70 24 5 15 $ 9 28 S 27 S 40 5 Variable costs: 6 Direct materials 7 Labor and other costs 8 9 Cost of Bistide (DM) per pound 10 Pounds of Bitside available 5,000 11 Minimum units of each product 200 12 13 Pounds of DM per unit 14 15 16 Selling price 17 Variable costs: 18 Direct materials 19 Labor and other costs 20 Total variable cost 22 Contribution margin 24 Pounds of DM per unit 25 Contribution margin per pound 26 11-39 F C657. Unit c A110 B382 C657 $ 84 $ 52 $ 70 All three produ materials availa $ 222 24 15 9 available each 28 27 40 1. How many 52 S 42 $ 49 2. What is the $ 32 $ 10 $ 21 27 Pounds required for minimum production 29 Allocate remaining pounds to: 30 31 Units produced 32 Total Contribution Margin 33 34 For each product, what is the maximum price per Ready Special Orders Total YouTube Vi http://yout Allocating Constrained Resource Using Solver for Constraints + MacBo