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, 2099, the end of the fiscal year, after all adjustments, including those for Inventories, were recorded and posted $10,500,000 13,600,000 6,300,000 7.888.000 1,680,000 1.904.000 Sales-Winter Sports Division Sales --Summer Sports Division Cost of Goods Sold-Winter Sports Division Cost of Goods Sold-Summer Sports Division Sales expense -- Winter Sports Division Sales expense-Summer Sports Division Administrative Expense - Winter Sports Division Administrative Expense-Summer Sports Division Advertising Expense Transportation Exponse Accounts Receivable Collection Expense Warehouse Expense 1,050.000 1.210,400 482.000 240,000 120,500 1,200,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.900: Summer Sports Division, $265,100 B. Transportation expense-charged back to divisions at a charge rate of $8.00 per bill of lading: Winter Sports Division, 14.400 bits of lading: Summer Sports Division, 15,600 bill of lading C. Accounts receivable collection expense-incurred at headquarters, charged back to divisions at a charge rate of $5.00 per invoice Winter Sports Division, 9,640 sales invoices: Summer Sports Division, 14,460 sales invoices. D. Warehouse expense-charged back to divisions on the basis of floor space used in storing division products: Winter Sports Division, 94,000 square feet: Summer Sports Division, 106,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 fit in where needed. 2. Provide supporting calculations for service department charges XSport Sporting Goods Co, Divisional Income Statements For the Year Ended December 31, 2049 Winter Sports Division Summer Sports Division 3 5 (Label) 9 10 (Label) 11 12 13 14 15 16 12. Provide supporting calculations for service department charges Service Department Charges Winter Sports Division Summer Sports Division Total Advertising expense S 5 S 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 S Warehouse rate per sq. ft. S Number of square feet Warehouse expense $ S
