70.2K

Verified Solution

Link Copied!

please help! thanks!

Multiple Choice 23-4 Excel Spreadsheet: SA 23-2 Spreadsheet Tutorials: Decentralized Operations, Absolute and Relative Cell References SA 23-2: Service department charges Bass Company allocates central service department expenses from the accounting, travel, and purchasing departments to the Retail, Commercial, and Municipal Divisions. The expenses for the three service departments for the year ended December 31, 20X1 are: Accounting $264,000 Travel 94,000 Purchasing 192,000 Total $550.000 The activity base used by each service department in allocating service department expenses to the divisions was determined as follows: Department Activity Base Accounting Travel Number of transactions Number of travel requests Number of purchase orders Purchasing The use of services by the three divisions is as follows: Service Usage Division Travel Accounting 22,400 trans. 12,500 Purchasing 1,500 purch, ord. 250 trav, req. Commercial Municipal 5.100 3,000 purch. ord. 40,000 trans. 500 trav. reg. a. Open the Excel file SA23-2. Previous Next Purchasing 192,000 Total $550,000 The activity base used by each service department in allocating service department expenses to the divisions was determine Department Activity Base Accounting Number of transactions Travel Number of travel requests Number of purchase orders Purchasing The use of services by the three divisions is as follows: Service Usage Division Accounting Travel Purchasing 250 trav. reg 1.500 purch, ord. 000 Commercial 22,400 trans. 12.500 5.100 Municipal Total 40,000 trans 500 travre 3,000 purch, ord a Open the Excel file SA23-2. b. Prepare a report showing the service department charges allocated to each division c. When you have completed the report, perform a "save as," replacing the entire file name with the following: S423-2. Iyour first name initiallyour last name) in problem SA 23-2, what are the department charges for the Retail Division? a. 47,000 b. 96,000 c. 290,840 d. 147,840 Previous

Answer & Explanation Solved by verified expert

See Answer