Pront centresponsibility reporting Championship Sports the operates two division-the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as December 31, 2009, the end of the scal year after all adjustments, including those for inventaries, were recorded and posted Sales-Winter Sports Division 59,700,000 Se-Summer Sports Division 16,300,000 Cost of Goods Sold-Winter Sports Division 5.700,000 Cost of Goods Sold-Summer Sports Division 8/600,000 Sales Expense-Winter Sports Division 740.000 Sales Expense-Summer Sports Division 1.000.000 Administrative Expense-Winter Sports Division 850,000 Administrative Expense Sumer Sports Division 1,250,000 Advertising Expense 1,104,000 Transportation Expense 154,500 Accounts receivable Collection Expense 67.000 Warehouse Expense 917.000 The bases to be used in allocating expenses, together with other information, are as follow & Advertising expense-incurred at headquarters, charged back to divisions on the basis of usage: Winter Sports Division, $104,000; Summer Sports Division, $800,000 Transportation expense-charged back to divisions et a change rate of $3.00 per bill of lading Winter Sports Division, 19,000 bill of lading: Sunner Sports Division, 32,500 bits of lading Accounts receivable collection expense incurred at headquarters, charged back to visit at a charge rate of $1.00 per nice: Winter Sports Division, 23,000 sales invoices, Summer Sports Division, 44.000 sales invoices Warehouse expense-charged back to divisions on the basis of floor space used in storing division products Winter Sports Division, 50,000 square feets Summer Sports Division 1.000 square feet This information has been collected in the Microsoft Excel Online Open the spreadsheet perform the required analysis, and out your answers in the questions below Summer Sports Division $ 16,400,000 X 9,000,000 X $ 7,400,000 x Championship Sports Inc. Divisional Income Statements For the Year Ended December 31, 2049 Winter Sports Division Sales 8,900,000 x Cost of goods sold 5,000,000 x Gross profit 3,900,000 X Divisional selling and administrative expenses: Divisional selling expenses 650,000 x Divisional administrative expenses 800,000 x Total divisional selling and administrative expenses $ 1,450,000 X Operating income before support department allocations $ 2,450,000 X Support department allocations: Advertising expense 375,000 x Transportation expense 70,000 X Accounts receivable collection expense 25,000 x Warehouse expense 720,000 x Total support department allocations 1,190,000 x Operating income 1,260,000 x $ 1,200,000 X 1,450,000 x $ 2,650,000 x $4,750,000 X $ 715,000 X 122,000 x 43,000 X 1,080,000 x $ 1,960,000 X $ 2,790,000 X Provide supporting computations for support department allocations. If required, round per unit amounts to two decimal places ar Provide supp Total Advertising expense Transportation rate per bill of lading Number of bills of lading Transportation expense Championship Sports Inc. Support Department Allocations For the Year Ended December 31, 2019 Winter Sports Division Summer Sports Division 375,000 x 715,000 x 4 X 4 X 17,500 X 30,500 x $ 70,000 X $ 122,000 x Accounts receivable collection rate 1 25,000 X 43,000 X 25,000 x 43,000 x Number of sales invoices Accounts receivable collection expense Warehouse rate per sq. ft. Number of square feet Warehouse expense 12 X 60,000 X X Feedback