i am so confused please help!

Multiple Choice 23-3 Excel Spreadsheet: SA 23-2 Spreadsheet Tutorials: Decentralized Operations, Absolute and Relative Cell References SA 23-2: Service department charges Bass Company locates central service department expenses from the accounting, travel, and purchasing departments to the Retail Commercial and Municipal Divisions. The expenses for the departments for the year ended December 31, 20x1 are: Accounting $264,000 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 Number of transactions Travel Number of travel requests Purchasing Number of purchase orders The use of services by the three divisions is as follows: Service Usage Purchasing Division Accounting 250 trav, reg 1.500 puchord Retail 22.400 trans 12,500 Commercial Municipal 3,000 purch, ord. 40,000 trans 500 trare (revious Next > V orprogress true Q Paused Trave 94.000 Purchasing 192,000 Total The activity base used by each service department in allocating service department expenses to the divisions was determined as follows: Department Activity Base Accounting Number of transactions ber of travel requests Number of purchase orders Purchasing The use of services by the three divisions issu s Service Usage Division Accounting Purchasing 22.400 trans 250 trave 1,500 purch ord Municipal 5,100 40,000 trans 500rre 3.000 surchard with the following .. Open the cele b. Prepare report showing the service department charges t ed to each c. When you have completed the report, perform a "save as replacing the entire team SA232 your first name voor strame) In problem SA 23:2. what are the accounting charges for the Municipal Division a. 147,840 2.500 C. 83,340 33.560 Previous Next