P25-34 Makdi CRITICAL THINKING Using Excel P25-33 Using Excel to calculate optimum product mix plan e Downloxd an Excel terylate for thus proluem ontne vi MyAccowstvwgtatb or at http www pearserhighered. comtorn Magnolia Company produces leather shoes in three models Medira, Balard, and Fiemont Currently, Magriolia ing 4,000 pairs of Medina, 6,000 pars of Ballard, and 1,500 pars of Fremont during the year, for a total contn of $2.242,500 However, some of the resuces used in the manulacturing process are undkrutazed, lea believe that there could be an altenative product mie for shoes that would increase the total contribution marg seff all shoes produced sonhighered.comMongren or this is manufactur gn leading the manager to Majnolia ca The curent product mix is 1. Pre tho Shoe Ballard tMedina6,000 4,000 1 38 Fremont Total Contribution Margin 2. Wh doe Pairs of shoes Sales price per pair Variable costs per pair Contribution margin per pair Contribution margin ratio 175 210 55% 1 250 50 200 80% 1,500 5 180 45 135 75% 2,242,500 defore yo Magnolia has the following manufacturing constraints Machine hours required per pair of shoes Ballard 0.15 0.10 0.10 Total machine hours available 1,800 2,100 2,400 Total machine hours used Medina 0.15 0.25 Fremont 0.20 0.10 0.10 Process Cutting P25-34 Makdi CRITICAL THINKING Using Excel P25-33 Using Excel to calculate optimum product mix plan e Downloxd an Excel terylate for thus proluem ontne vi MyAccowstvwgtatb or at http www pearserhighered. comtorn Magnolia Company produces leather shoes in three models Medira, Balard, and Fiemont Currently, Magriolia ing 4,000 pairs of Medina, 6,000 pars of Ballard, and 1,500 pars of Fremont during the year, for a total contn of $2.242,500 However, some of the resuces used in the manulacturing process are undkrutazed, lea believe that there could be an altenative product mie for shoes that would increase the total contribution marg seff all shoes produced sonhighered.comMongren or this is manufactur gn leading the manager to Majnolia ca The curent product mix is 1. Pre tho Shoe Ballard tMedina6,000 4,000 1 38 Fremont Total Contribution Margin 2. Wh doe Pairs of shoes Sales price per pair Variable costs per pair Contribution margin per pair Contribution margin ratio 175 210 55% 1 250 50 200 80% 1,500 5 180 45 135 75% 2,242,500 defore yo Magnolia has the following manufacturing constraints Machine hours required per pair of shoes Ballard 0.15 0.10 0.10 Total machine hours available 1,800 2,100 2,400 Total machine hours used Medina 0.15 0.25 Fremont 0.20 0.10 0.10 Process Cutting