CE Required information [The following information applies to the questions displayed below] Conroy Company manufactures two products-8100 and A200. The company provided the following information with respect to these products B100 2,800 $1,200 2,000 $2,100 Estimated customer demand (in units) Selling price per unit Variable expenses per unit 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: hours per unit) (hours per unit) Capacity in hours 4.000 6.000 5,000 Fabrication Molding Machining Assemble & Pack The company is trying to decide what product mix will maximize profits. Given that its fixed costs will not change regardless of the chosen mix, the company plans to identify the product mix that maximizes its total contribution margin. Click here to download the Excel template, which you will use to answer the questions that follow. 4. In the Excel template, navigate to the "Requirement 4" tab. Using Solver a. Calculate the maximum contribution margin the company can earn given the capacities of its four manufacturing departments b. How many units of each product would the company produce to earn the contribution margin from requirementa? c. Is your answer to requirement a greater than less than or equal to your answer from 37 d. Which of the following best explains the reason for the answer to requirement 4c? The company is trying to decide what product mix will maximize protits. Given that its fixed costs WILL M y regardless of the chosen mix, the company plans to identify the product mix that maximizes its total contribution me Click here to download the Excel template, which you will use to answer the questions that follow. 4. In the Excel template, navigate to the "Requirement 4" tab. Using Solver: a. Calculate the maximum contribution margin the company can earn given the capacities of its four manufacturing dep b. How many units of each product would the company produce to earn the contribution margin from requirement 4a? c. Is your answer to requirement 4a greater than, less than or equal to your answer from 3d? d. Which of the following best explains the reason for the answer to requirement 4c? Complete this question by entering your answers in the tabs below. Req 4A Reg 4B Req 4C Req 4D Calculate the maximum contribution margin the company can earn given the capacities of its four manufacturing departments. The maximum contribution margin is Req4B > 12T ** a. Calculate the maximum contribution margin the company can earn given the capacities of its for b. How many units of each product would the company produce to earn the contribution margin fr C. Is your answer to requirement 4a greater than, less than or equal to your answer from 3d? d. Which of the following best explains the reason for the answer to requirement 4c? Complete this question by entering your answers in the tabs below. Reg 4A Req 4B Req 4C Req 4D How many units of each product would the company produce to earn the contribution margin from require B100 Units produced A200 1,000
