Championship Sports Inc. operates two divisions-the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 2019, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales-Winter Sports Division $8,000,000. Sales-Summer Sports Division 16,500,000 Cost of Goods Sold-Winter Sports Division 5,600,000 Cost of Goods Sold-Summer Sports Division 8,700,000 Sales Expense-Winter Sports Division 790,000 Sales Expense-Summer Sports Division 1,600,000 Administrative Expense-Winter Sports Division 840,000 Administrative Expense-Summer Sports Division 1,410,000 Advertising Expense 1,140,000 Transportation Expense 235,000 Accounts Receivable Collection Expense 65,000 Warehouse Expense 1,141,000 The bases to be used in allocating expenses, together with other information, are as follows: a. Advertising expense-incurred at headquarters, allocated to divisions on the basis of usage: Winter Sports Division, $396,000; Summer Sports Division, $744,000. b. Transportation expense-allocated to divisions at a rate of $5 per bill of lading: Winter Sports Division, 17,000 bills of lading; Summer Sports Division, 30,000 bills of lading. c. Accounts receivable collection expense-incurred at headquarters, allocated to divisions at a rate of $1 per invoice: Winter Sports Division, 23,000 sales invoices; Summer Sports Division, 42,000 sales invoices. d. Warehouse expense-allocated to divisions on the basis of floor space used in storing division products: Winter Sports Division, 66,000 square feet; Summer Sports Division, 97,000 square feet. croft Fyrel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below X Open spreadsheet Prepare a divisional income statement with two column headings: Winter Sports Division and Summer Sports Division. Do not round your intermediate calculations. Championship Sports Inc. Divisional Income Statements For the Year Ended December 31, 2019 Sales Cost of goods sold Gross profit Divisional selling and administrative expenses: Divisional selling expenses Divisional administrative expenses Total divisional selling and administrative expenses Operating income before support department allocations Support department allocations: Advertising expense Transportation expense Winter Sports Summer Sports Division Division 0000 00 Divisional administrative expenses Total divisional selling and administrative expenses Operating income before support department allocations Support department allocations: Advertising expense Transportation expense Accounts receivable collection expense Warehouse expense Total support department allocations Operating income Provide supporting computations for support department allocations. If required, round per unit amounts to two decimal places and final answers to the nearest dollar. Championship Sports Inc. Support Department Allocations For the Year Ended December 31, 2019 Winter Sports Division Summer Sports Division Total Advertising expense Transportation rate per bill of lading Number of bills of lading Transportation expense Provide supporting computations for support department allocations. If required, round per unit amounts to two decimal places and final answers to the nearest dollar. Championship Sports Inc. Support Department Allocations For the Year Ended December 31, 2019 Winter Sports Division Summer Sports Division Total Advertising expense Transportation rate per bill of lading Number of bills of lading Transportation expense Accounts receivable collection rate Number of sales invoices Accounts receivable collection expense Warehouse rate per sq. ft. Number of square feet Warehouse expense 0000