Championship Sports Inci 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 59,300,000 Sales Summer Sports Division 16,200,000 Cost of Goods Sold-Winter Sports Division 4,400,000 Cost of Goods Sold-Summer Sports Division 9,100,000 Sales Expenser Winter Sports Division 780,000 Sales Expense-Summer Sports Division 1,300,000 Administrative Expense-Winter Sports Division 770,000 Administrative Expense-Summer Sports Division 1,430,000 Advertising Expense 1,077,000 Transportation Expense 230,000 Accounts Receivable Collection Expense 66,000 Warehouse Expense 852,000 The bases to be used in abocating expenses, together with other information are as follows: Advertising expense-incurred at headquarters, Chiaroed back to divisions on the basis of usage! Winter Sports Division, 3333,000, Summer Sports Division, 5744,000, b. Transportation expense-charged back to divisions of a charge rate of $5.00 per bill of lading: Winter Sports Division, 16,000 bill of lading Summer Sports Division, 30,000 bills of Isding Accounts receivable collection expense-uncutred at beadquarters, charged back to divisions at a charge rate of $1.00 per invoice Winter Sports Division, 24,000 sales invoices Summer Sports Division, 42,000 ale Inc. d. Warehouse expense charged back to dwisions on the basis of floor space used in storing division products Winter Sports Division, 61,000 square feet: Summet Sports Division 1,000 square feet The information to be collected in the Microsoft Excel Online Open the spreadsheet, perform the required analysis, and input your answers in the questions below Divisional Income Statements For the Year Ended December 31, 2019 Winter Sports Summer Sports Division Division 9,300,000 16,200,000 Castel goods sold 4,400,000 9,100,000 Grosso 4,900,000 7,100,000 Divisional selling and administrative experies: Divisional selling expenses 780,000 1,300,000 Divisional administrative expenses 170,000 V 1,430,000 Total divisional selling and administrative expenses 1,550,000 2,720,000 Operating income before support department allocations Support department allocations Advertising expere Transportation mpense Accounts receivable collection experise Warehouse expense Total support department allocations Operating income Provide supporting computation 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 Summer Sports Winter Sports Division 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. it. Number of square feet Warehouse expense
