Please place in grid if it is not too much to ask. Thanks.

Exercise 22-3 Service department expenses allocated to operating departments LO P2 Advertising department expenses of $38,900 and purchasing department expenses of $38,900 of Cozy Bookstore are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows Sales 180,000 108,000 Purchase Orders Department Books Magazine:s Newspapers Total 984 600 816 2,400 72,000 360,000 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments Answer is not complete. Complete this question by entering your answers in the tabs below Allocation of Alloc of Serv Exp Dept Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Cost to be tising Allocation Base Department Sales 01 Numerator Denominator | %of Total Books Magazines Newspapers Totals OS asing Allocation Base Department Number of orders Numerator Denominator | % of Total Books Magazines Newspapers Totals Exercise 22-3 Service department expenses allocated to operating departments LO P2 Advertising department expenses of $38,900 and purchasing department expenses of $38,900 of Cozy Bookstore are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows Department Books Magazines Newspapers Total Sales 180,00e 108,000 Purchase Orders 984 600 816 2,400 72,000 360,000 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Answer is not complete. Complete this question by entering your answers in the tabs below Allocation of Exp Alloc of Serv Dept Complete the spreadsheet by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. (Amounts to be deducted should be indicated with minus sign.) COZY BOOKSTORE Departmental Expense Allocation Spreadsheet Expense Advertising Purchasing Books Magazines Newspapers Total department 555,000 38,900 38,900 221,900 144300 111,000 nses Service Dept Expenses Advertising Dept. Purchasing Dept. Total expenses 555,000 38,900 38,900 $ 221,900 allocated 144,300 111,000