this is all one question. i have screenshot and mentioned the excel pages as well how its supposed to be solved. pls someone help me solve this

Profit center responsibility reporting 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, 2049, 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 15,200,000 5,900,000 Cost of Goods Sold-Winter Sports Division Cost of Goods Sold-Summer Sports Division 8,800,000 Sales Expense-Winter Sports Division Sales Expense-Summer Sports Division Administrative Expense-Winter Sports Division 720,000 1,600,000 850,000 1,340,000 Administrative Expense-Summer Sports Division Advertising Expense 1,125,000 Transportation Expense 312,000 Accounts Receivable Collection Expense 207,000 900,000 Warehouse Expense The bases to be used in allocating expenses, together with other information, are as follows: a. Advertising expense-incurred at headquarters, charged back to divisions on the basis of usage: Winter Sports Division, $363,000; Summer Sports Division, $762,000. b. Transportation expense-charged back to divisions at a charge rate of $6.00 per bill of lading: Winter Sports Division, 18,000 bills of lading; Summer Sports Division, 34,000 bills of lading. c. Accounts receivable collection expense-incurred at headquarters, charged back to divisions at a charge rate of $3.00 per invoice: Winter Sports Division, 25,000 sales invoices; Summer Sports Division, 44,000 sales invoices. a. Advertising expense-incurred at headquarters, charged back to divisions on the basis of usage: Winter Sports Division, $363,000; Summer Sports Division, $762,000. b. Transportation expense-charged back to divisions at a charge rate of $6.00 per bill of lading: Winter Sports Division, 18,000 bills of lading; Summer Sports Division, 34,000 bills of lading. c. Accounts receivable collection expense-incurred at headquarters, charged back to divisions at a charge rate of $3.00 per invoice: Winter Sports Division, 25,000 sales invoices; Summer Sports Division, 44,000 sales invoices. d. Warehouse expense-charged back to divisions on the basis of floor space used in storing division products: Winter Sports Division, 63,000 square feet; Summer Sports Division, 87,000 square feet. 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. TH 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 Winter Sports Division Summer Sports Division Sales $ 8,000,000 $ 15,200,000 Cost of goods sold 5,900,000 8,800,000 Gross profit Divisional selling and administrative expenses: 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 Winter Sports Division Summer Sports Division Sales 8,000,000 15,200,000 Cost of goods sold 5,900,000 8,800,000 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 Accounts receivable collection expense Warehouse expense Total support department allocations 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 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 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 ITD] Number of sales invoices Accounts receivable collection expense Warehouse rate per sq. ft. $ Number of square feet Warehouse expense D E F G H B Profit center responsibility reporting 1 2 Championship Sports Inc. operates two divisionsthe Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: MODEMOS DATA Sales-Winter Sports Division $8,000,000 SalesSummer Sports Division 15,200,000 Cost of Goods Sold-Winter Sports Division 5,900,000 Cost of Goods Sold-Summer Sports Division 8,800,000 10 Sales Expense-Winter Sports Division 720,000 Sales Expense-Summer Sports Division 1,600,000 12 Administrative Expense-Winter Sports Division 850,000 13 Administrative Expense Summer Sports Division 1,340,000 14 Advertising Expense 1,125,000 15 Transportation Expense 312,000 16 Accounts Receivable Collection Expense 207,000 17 Warehouse Expense 900,000 18 19 The bases to be used in allocating expenses, together with other information, are as follows: 20 Arial C2 Merge .00 .0 ZY C37 fx A B D E F G H 1 20 21 DATA Winter Sports Summer Sports 22 Division Division a. Advertising expenseincurred at headquarters, charged back to $363.000 $762,000 23 divisions on the basis of usage: 24 25 b. Transportation expense-charged back to divisions, bills of lading 18,000 34,000 Charge rate, per bill of lading $6.00 26 C. Accounts receivable collection expense-incurred at headquarters, 25,000 44,000 Charge rate, per invoice $3.00 27 charged back to divisions, sales invoices: 28 d. Warehouse expense-charged back to divisions on the basis of floor 63,000 87,000 29 space used in storing division products, square feet: 30 Using formulas and cell references, perform the required analysis, and input your answers into the C, D, and E columns. Transfer the numeric results for the green entry cells (C37:039, C41:044, C46:051, C57:066, E57, E60, E63, E66) into the appropriate fields in 31 CNOWv2 for grading. 32 33 Championship Sports Inc. 34 Divisional Income Statements 35 For the Year Ended December 31, 2049 Winter Sports Summer Sports 36 Division Division Formulas 37 Sales 38 Cost of goods sold A Sofit A Data + Arial 10 B v ... Merge v Currency Ev 21 C37 fx A B D E F G H Formulas 94%B48%89555 33 Championship Sports Inc. 34 Divisional Income Statements 35 For the Year Ended December 31, 2049 Winter Sports Summer Sports 36 Division Division 37 Sales 38 Cost of goods sold 39 Gross profit 40 Divisional selling and administrative expenses 41 Divisional selling expenses 42 Divisional administrative expenses 43 Total divisional selling and administrative expenses 44 Operating income before support department allocations 45 Support department allocations: 46 Advertising expense 47 Transportation expense 48 Accounts receivable collection expense 49 Warehouse expense 50 Total support department allocations 51 Operating income 52 File Home Insert Draw Page Layout Formulas Data Review View Help Editing V Arial 10 B 3 Merge Currency 60 00 .00 .0 # > - C37 E F G H Total Formulas A B D 47 Transportation expense 48 Accounts receivable collection expense 49 Warehouse expense 50 Total support department allocations 51 Operating income 52 53 Championship Sports Inc. 54 Support Department Allocations 55 For the Year Ended December 31, 2049 Winter Sports Summer Sports 56 Division Division 57 Advertising expense 58 Transportation rate per bill of lading 59 Number of bills of lading 60 Transportation expense 61 Accounts receivable collection rate 62 Number of sales invoices 63 Accounts receivable collection expense 64 Warehouse rate per sq. ft. 65 Number of square feet 66 Warehouse expense 67 68 69 70