Need help with solution 4 (K, L, M)

ORIGINAL Smith Company manufactures fish tanks. One of the fish tanks that the company produces is a 2.6 gallon fish tank that the company GIVEN DATA sells for $37.50. The fish tanks are manufactured in an outdated fish tank manufacturing facility that is labor intense, relying heavily FOR on direct labor workers. Variable costs are high, totaling $22.50 per 2.6 gallon fish tank of which 60% is direct labor cost. Last year the SOLUTION 1 company sold 40,000 2.6 gallon fish tanks and had $480,000 in fixed expense associated with the 2.6 gallon fish tank. ADDITIONAL DATA FOR SOLUTION 2 Next year variable costs are estimated to increase by $3 per 26 gallon fish tank due to an increase in labor rates. Selling price will not change. DATA FOR Refer to ORIGINAL GIVEN DATA FOR SOLUTION 1 and build a new plant that next year will slash the original variable cost by 40% and SOLUTION 3 Increase fixed expense by 90%. DATA FOR SOLUTION 4 Refer to DATA FOR SOLUTION 3 On the sheet tab labeled SOLUTION 1, use the ORIGINAL GIVEN DATA FOR SOLUTION 1 on the sheet tab labeled DATA to: A Compute the contribution margin ratio B Compute break-even in number of 2.6 gallon fish tanks C Compute the degree of operating leverage at last year's level of sales On the sheet tab labeled SOLUTION 2, use the ADDITONAL DATA FOR SOLUTION 2 on the sheet tab labeled DATA to: D Compute the new contribution margin ratio E Compute the new break-even in number of 2.6 gallon fish tanks F Compute the number of 2.6 gallon fish tanks that will have to be sold next year to maintain the current operating income G compute the selling price per 2,6 gallon fish tank that would have to be charged in order to maintain the same contribution margin ratio as last year On the sheet tab labeled SOLUTION 3, use the DATA FOR SOLUTION 3 on the sheet tab labeled DATA to: H Compute the new contribution margin ration 1 Compute the new break-even in number of 2.6 gallon fish tanks Compute the number of 2.6 gallon fish tanks that will have to be sold next year to maintain the current operating income On the sheet tab labeled SOLUTION 4, use the DATA FOR SOLUTION 3 and DATA FOR SOLUTION 4 on the sheet tab labeled DATA to: K Assume the company sells the same number (40,000) of 2.6 gallon fish tanks as last year and prepare a contribution format income statement 1 Compute the degree of operating leverage M Explain whether or not you would be in favor of building the new plant 1