?Cul Copy Conditional Format as Cell Imset Delee Fomat Formatting TableStyles Styles Cipbeard AL Requirement i the formula in cell 112 (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 SUMPER Total Total Medina Ballard Fremont contribution margin using sUMPRODUCT Sales price per pair Coetsibutlion magin per pair0200 135 Note: Cell F12 is zero while all pairs of shoes are zero. Once Solver solves for the optimam number of shces that will maximize total contribuition margin, F12 will be updated with the new Total contribution margin. , toetribution margin % Machine Hours Machine Hours oer oair of shoes instructions Product Mix Subiect to Constraints: ?Cul Copy Conditional Format as Cell Imset Delee Fomat Formatting TableStyles Styles Cipbeard AL Requirement i the formula in cell 112 (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 SUMPER Total Total Medina Ballard Fremont contribution margin using sUMPRODUCT Sales price per pair Coetsibutlion magin per pair0200 135 Note: Cell F12 is zero while all pairs of shoes are zero. Once Solver solves for the optimam number of shces that will maximize total contribuition margin, F12 will be updated with the new Total contribution margin. , toetribution margin % Machine Hours Machine Hours oer oair of shoes instructions Product Mix Subiect to Constraints