Complete a departmental expense allocation spreadsheet for marathon running shop ..........

Marathon Running Shop has two service departments (advertising and administrative) 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 a total sales for the two operating departments for the year 2017 Direct Expenses 20,000 Square Sales Department Advertising Administrative 30,000 Shoes Clothing Feet 1,680 1,260 10,290 $179,800 128,000 19,000 7,770 130,200 The advertising department developed and distributed 130 advertisements during the year. Of these, 26 promoted shoes and 104 promoted clothing. Utilities expense of $75,000 is an indirect expense to all departments Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should assign (1) expenses to occupied, (3) the advertising department's expenses to the two operating departments on the basis of t promoted a department's products, and (4) the administrative department's expenses to the two operating departments based on amount of sales each of the four departments, (2) the $75,000 of utilities expense to the four departments on the basis of floor space the Cost to be Allocated Allocated Cost Utilities Allocation Base Numerator Denominator% of Total Department Advertising