Required information [The following information applies to the questions displayed below.] Conroy Company manufactures two products-B100 and A200. The company provided the following information with respect to these products: Estimated customer demand (in units) Selling price per unit B100 2,800 $1,200 A200 Variable expenses per unit $ 700 2,000 $2,100 $1,200 The company has four manufacturing departments-Fabrication, Molding, Machining, and Assemble & Pack. The capacity available in each department (in hours) and the demands that one unit of each of the company's products makes on those departments is as follows: Fabrication Molding Machining Assemble & Pack B100 (hours per unit) A200 (hours per unit) Capacity (in hours) 1 2 4,000 2 2 6,000 2 0 0 3 5,000 4,500 8. In the Excel template, navigate to the "Requirement 8" tab. Using Solver: a. What is the maximum contribution margin the company can earn with its available resources if it increases the price of B100 to $1,400? b. How many units of each product is the company producing to earn the contribution margin from requirement 8a? c. Is your answer to requirement 8a greater than, less than, or equal to your answer from requirement 7d? Complete this question by entering your answers in the tabs below. Req 8A Req 8B Req 8C What is the maximum contribution margin the company can earn with its available resources if it increases the price of B100 to $1,400? Maximum contribution margin $1,400? 1,400? How many units of each product is the company producing to earn the contribution margin from Is your answer to requirement 8a greater than, less than, or equal to your answer from requirem b. How many units of each product is the company producing to earn the contribution c. Is your answer to requirement 8a greater than, less than, or equal to your answer fr Complete this question by entering your answers in the tabs below. Req 8A Req 8B Req 8C How many units of each product is the company producing to earn the contribution margin from requii Product A200 Product B100 units units < Req 8A Req 8C > Complete this question by entering your answers in the tabs below. Req 8A Req 8B Req 8C Is your answer to requirement 8a greater than, less than, or equal to your answer from The answer from requirement 8a is the answer from requirement 7d. < Req 8B Req 8C >