15-1A. (Sales mix and break-even point) CheeMortal music store sells four kinds of musical instruments—pianos, violins, cellos, and flutes. The current sales mix for the store and the contribution marginratio (unit contribution margin divided by unit sales price) for these product lines are as follows:contribution on margins32%40%38%51%Total sales for the next year are forecast to be $250,000. Total fixed costs will be $50,000.a. Prepare a table showing (1) sales, (2) total variable costs, and (3) the total contributionmargin associated with each product line.b. What is the aggregate contribution margin ratio indicative of the sales mix? (Round offto two decimals.)c. At this sales mix, what is the break-even point in dollars?if possible can answer be submitted in an excel document?
Looking for a Similar Assignment? Order now and Get 20% Discount! Use Code GET20