Requirement 3 G H 2 3 a. Total contribution margin using SUMPRODUCT Using the formula in cell F16 (Total contribution margin) of the Product Mix template, create formulas in the blue shaded cells for 4. 5 b. Machine hours used using SUMPRODUCT 6 8. 9 10 formulas where appropriate to Requirement 4 The objective and constraints headings are the green shaded cells, fill in the formulas in the blue shaded areas. Requirement 5 the constraints Use Excel's Solver to compute the number of pairs of shoes for each of the three models in order to maximize the contribution margin, given Shoe Maximize: Total Total Medina Ballard contribution Fremont contribution margin using margin SUMPRODUCT 12 13 14 15 16 17 TRANSPOR Number of Pairs Sales price per pair 385 250 180 Variable expenses per pair 175 50 45 Contribution margin per pairi 210 200 135 0 Contribution margin % 55% 80% 75% 18 19 Machine Hours 20 Machine Hours per pair of shoes Medina Ballard 21 22 22 Cutting 0.15 0.15 Instructions ENTERANSWERST ENTERANSWERS2 Ready Accessibilitate Type here to search Fremont 0.20 Machine Hours used Machine Hours used using SUMPRODUCT 0 Subject to Constraints Constraint as a Non-negat Resources available Constraint single formula 1,800 022-H22 constrains D