XSport Sporting Goods Co. 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: $10,525,000 13,610,000 Sales-Winter Sports Division Sales-Summer Sports Division Cost of Goods Sold-Winter Sports Division Cost of Goods Sold-Summer Sports Division 6,280,000 7,868,000 1,650,000 Sales expense-Winter Sports Division Sales expense-Summer Sports Division 1,894,000 Administrative Expense-Winter Sports Division 1,002,000 1,204,400 479,000 Administrative Expense-Summer Sports Division Advertising Expense Transportation Expense Accounts Receivable Collection Expense Warehouse Expense 144,500 120,400 1.164,000 The bases to be used in allocating expenses, together with other essential information, are as follows: A. Advertising expense-incurred at headquarters, charged back to divisions on the basis of usage: Winter Sports Division, $216,300; Summer Sports Division, $262,700. B. Transportation expense-charged back to divisions at a charge rate of $5 per bill of lading: Winter Sports Division, 13,400 bills of lading; Summer Sports Division, 15,500 bills of lading. C. Accounts receivable collection expense-incurred at headquarters, charged back to divisions at a charge rate of $5 per invoice: Winter Sports Division, 9,69 sales invoices; Summer Sports Division, 14,430 sales invoices. D. Warehouse expense-charged back to divisions on the basis of floor space used in storing division products: Winter Sports Division, 91,000 square feet; Summer Sports Division, 103,000 square feet. Required: 1. Prepare a divisional income statement with two column headings: Winter Sports Division and Summer Sports Division. Refer to the list of Labels and Amount Descriptions for the exact wording of the answer choices for text entries. (Complete the Supporting Calculations tab first.) A colon (:) will fill in where needed. 2. Provide supporting calculations for service department charges. Score: 126/168 XSport Sporting Goods Co. Divisional Income Statements For the Year Ended December 31, 2049 2 Sales Winter Sports Division $10,505,000.00 6,280,000.00 $4,225,000.00 Summer Sports Division $13,610,000.00 7,868,000.00 $5,742,000.00 3 Cost of goods sold 4 Gross profit Divisional selling and administrative expenses: Divisional selling expenses 7 Divisional administrative expenses Total divisional selling and administrative expenses Income from operations before service departments charges 6 $1,650,000.00 1,002,000.00 $648,000.00 $1,894,000.00 1,204,400.00 $689,600.00 Divisional Income Statements Shaded cells have feedback. $1,650,000.00 1,002,000.00 $648,000.00 $1,894,000.00 1,204,400.00 $689,600.00 6 Divisional selling expenses 7 Divisional administrative expenses Total divisional selling and administrative expenses Income from operations before service departments charges 10 Total service department charges: 11 Advertising expense 11 Transportation expense 13 Accounts receivable collection expense 14 Warehouse expense 15 Total service department charges 16 Income from operations $216,300.00 $262,700.00 77,500.00 670,000.00 48,250.00 546,000.00 72,150,00 618,000.00 $4,128,750.00 $3,529,550.00 $695,450.00 $1,613,250,00
