3 Exercise 22-6 Departmental expense allocation spreadsheet LO P2 Marathon Running Shop has two cervice departments advertising and administratives and two operating departments shoes and clothing. The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as Total sales for the two operating departments for the year 2019 Det Direct Expenses Soare Feet Advertising $18,000 300 Administrative 18.000 15 Shoes 128.00 2.300 Clothing 16.00 2.ee 102, The advertising department developed and distributed 180 overtisements during the year of these. 54 promoted shoes and 126 promoted clothing. Uulities expense of $63.000 is an Indirect expense to al departments Complete a departmental expense allocation spreadsheet for Marathon Running Shop The spreadsheet should assign (1) direct expenses to each of the four departments, the 563.000 of the expense to the four departments on the basis of floor space occupied 3 the advertising department's expenses to the tivo operating departments on the basis of the number of ads placed that promoted a department's products and the administrative departments expenses to the two operating dopartments based on the amount of sales Utilities Allocation Base Patcente Allocation Base Cost to be Allocated Allocated Cost Numero Denominar of Total 0 0 Department Advertising Administrative Shoes Clothing Total Advertising Department Shoes Clothing Total Allocation Base Punt Allocations Cost to be Allocated Allocated Cost Numer Denom 0 0 Administrative Allocation Base Department Shoes Clothing Perfection Base Cost to be Allocated Allocated Cout Numerator Denom Sool 0 . MARATHON RUNNING SHOP Departmental Expense Allocation Spreadsheet For Year Ended December 31, 2013 Expense Total Shoes Clothing 0 0 Dr Indirecte se Toodete Service Dept Expenses Advertising Dept Admin Dept Tutal posted 5 0$ $