80.2K

Verified Solution

Link Copied!

Please help!!

Short-Term Business Decisions Using Excel to make business decisions and calculate optimum product mix. Magnolia Company produces leather 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 year, for a Total contribution margin of $2,242,500. Fixed overhead costs are $273,000 for Medina, $223,000 for Ballard, and $153,000 for Fremont during the year. However, some of the resources used in the manufacturing process are underutilized, leading the manager to believe that there could be alternate decisions or an alternative product mix for shoes that would increase the Total contribution margin. 18 | Magnolia has the following manufacturing constraints: 19 Ssume that Magnolia expects to produce and sell 4,000 pairs of Medina during the current year. One of Magnolia's sales representatives aas found a new customer that is willing to buy 500 additional pairs for a price of $335 per pair. If they accept the customer's offer, it will decrease sales to regular customers by 200 pairs. Should they accept this special order? Show all work/calculations to justify your decision. Assume that Magnolia expects to produce and sell 4,000 units during the current quarter. A supplier has offered to manufacture and deliver 4,000 units for a price of $190 per unit. Should Magnolia accept this offer? How much will profit's increase or decrease? Show all work/calculations to justily your decision

Answer & Explanation Solved by verified expert

See Answer