Requirement 3 B D E F G H Using the formula in cell F16 (Total contribution margin) of the Product Mix template, create formulas in the blue shaded cells for a. Total contribution margin using SUMPRODUCT b. Machine hours used using SUMPRODUCT 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 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 the constraints. Shoe Maximize: Medina Ballard Fremont Total contribution Total contribution margin margin using SUMPRODUCT Number of Pairs Sales price per pair 385 250 180 Variable expenses per pair 175 50 45 Contribution margin per pair 210 200 135 #VALUE! Contribution margin % 55% 80% 75% Machine Hours Machine Hours per pair of shoes Medina Ballard Fremont Machine Machine Hours used using Resources