Instructions:

In the green cells please manually type in the equation (please show the equation for example. =B19+C19) and not put just a number. The yellow cells you can put just a number. Thank you! (PLEASE MAKE SURE TO DO REQUIREMENT 3 SCHEDULE AND REQUIREMENT 4 SCHEDULE)

Requirement 3:

Within the "Schedules" worksheet use the information you manually typed in to the "input Data" section to populate the whole multi-product contribution margin income statement- including total dollars, dollar per unit, and percent of sales values for football and baseball divisons, respectively, and total dollars and percent of sales values for the company as a whole. The results depict the most recent year-end's financial results

Requirement 4:

BREAKEVEN SCHEDULE

Within the "schedules" worksheet use any information from the "input data"section or with your populated "Requirement 3 schedule" on the "schedules" worksheet to populate the whole multi-product contribution margin income statement AT BREAKEVEN- including total dollars, dollars per unit, and percent of sales values for football and baseball divisions, respectively, and total dollars, and percent of sales values for the company as a whole.

Applicable to the company as a whole: 5 Net income earned during most recent period: 6 Contribution margin ratio: 7 Fixed costs incurred during most recent period 8 Statutory tax rate: 9 Operating income generated at breakeven: 10 Applicable to the Football Division 11 Selling price per football 12 Total variable cost dollars incurred by Football Division 13 Quantity of footballs sold during most recent period: 14 Applicable to the Baseball Division 1s Variable cost per baseball 65,000 15% 175,000 37% 18 952,088 64,000 3.24 Input Data plicable to the company as a whole: 3 Net income earned during most recent period 4 Contribution margin ratio s Fixed costs incurred during most recent period 6 Statutory tax rate 7 Operating income generated at breakeven 8 Applicable to the Football Division 9 Selling price per football 10 Total variable cost dollars incurred by Football Division 11 Quantity of footballs sold during most recent period 12 13 Variable cost per baseball 14 5 Requirement 3 Schedule: 16 17 18 19 Revenues 20 Variable Costs 21 Contribution Margin 22 Fixed Costs 23 Operating income 24 Income Tax 25 Net income 26 licable to the Baseball Division Footballs Baseballs Total Total $ | $ per Unit | % of Sales | Total $ | $ per Unit | % of Sales Total $ | % of Sales 28 Requirement 4 Schedule: 29 30 31 32 Revenues 33 Variable Costs 34 Contribution Margin 35 Fixed Costs 36 Operating income 37 Income Tax 38 Net income 39 Footballs Baseballs Total Total $ | $ per Unit | % of Sales | Total $ | $ per Unit | % of Sales Total $ | % of Sales