Please follow format and show method

24-3 The following is a partially completed lower section of a departmental expense allocation spreadsheet for Cozy Bookstore. It reports the total amounts of direct and indirect expenses allocated to its five departments. Complete the spreadsheet by allocating the expenses of the two service dep advertising and purchasing) to the three operatin Expense Books dept Magazines Newspaper Dept AcsAdvertisingPurchasing Allocation Base deptB Dept $698,00024,000 dept Balance otal ervice dvertisin urchasin otal e otal Expenses allocated to operating expenses artment Cost $34,000 $425,000 $90,000 $125,000 artment Cost ent-Sales artment Purchase Orders enses allocated to $0 $0 Advertising and purchasing department expenses 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 Orders 516 360 324 ooks $495,000 $198,000 $207,000 otal $900,0001,200 Expense Advertising Purchasing Books dept MagazinesNewspaper Dept Allocation Base Acct Balance $698,000 Dept deptB dept otal ervice dvertisin urchasin otal e otal Expenses allocated to operating expenses artment Cost $24,000 $34,000 $425,000 $90,000 $125,000 artment Cost artment-Sales artment Purchase Orders enses allocated to Show c tations below Ex 24-3Ex 24-4Ex 24-5 Ex 24-6Ex 24-7Ex 24-8 Total Expenses allocated to operating expenses Show computations below Sales % Allocated S News Total Purchase Allocated S Purchasing Books Department Ne Total