$4.$ In the Excel workbook, navigate to the $$Requirement $4$ tab. Using Solver:

Calculate the maximum contribution margin the company can earn given the capacities of its four manufacturing departments.

How many units of each product would the company produce to earn the contribution margin from requirement $4$a$?$

Is your answer to requirement $4$a greater than, less than, or equal to your answer from $3$d$?$

Which of the following best explains the reason for the answer to requirement $4$c$?$

Create a formula in cell B$11$ that translates B$100$s contribution margin per unit in cell B$10$ to its contribution margin per hour of the constraining resource. What is B$100$s contribution margin per hour of the constraining resource that you identi