Question 4: Blend corporation produces two types of blenders. The blenders are produces using a special metal. Due to global supply chain problems, the supply of the metal is limited and Blend is able to obtain only 20,000 pounds. Which blender should Blend produce given the following information? Deluxe Basic Unit selling price $95 $75 Unit variable costs 57 45 Unit contribution margin $38 $30 Number of pounds of metal per blender 4 2.5 1. Assume that there is no shortage in metal and ample demand. Which Blender should Blend produce? 2. Assume that Blend must produce at least 2,000 of each model to remain competitive. With the constraint of 20,000 pounds of metal, how many units of each blender will blend produce? 3. How much will total contribution margin be when profit is maximized under the constraint of 20,000 pounds and a 2,000 minimum production?

ONLY USE EXCEL TO ANSWER THIS QUESTION