Short-Term Decisions Using Excel to calculate optimum product mix Magnolia Company ather shoes in three models: Medina, Ballard, and Fremont. Currently, Magnolia is manufacturing 4,000 pairs of Medina, 6,000 pairs of Ballard, and 1,500 pairs of Fremont during the 2,242,500. However, some of resources used in the manufacturing proces are leading the manager to believe that there could be an alternative product total contribution margin Magnolia can sell all shoes produced The cument product mix is Shoe Medina Balland Contribution Margin Pairs of Shoes 4,000 6,000 1,500 385 5 250 $ 380 Valable expenses per par 175 50 45 Contribution margin per pair 210 200 135 $2,242,500 bibution margin percentage 55% BON 75% . 9 Sewing 23 ALL the ENTER ANSWER Machine hours Total Machine fotal machine un Medina Ballard 015 015 030 0 1,800 635 010 010 2,100 035 0.10 0.10 10 2400 erences and fumul where appropriate to receive credit if you copy/pata from the instruction tab you