solve the rest .

h 22 Homework i Saved m. Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should expenses to each of the four departments, (2) the $57,000 of utilities expense to the four departments on the ba occupied, (3) the advertising department's expenses to the two operating departments on the basis of the numbe promoted a department's products, and (4) the administrative department's expenses to the two operating depar amount of sales. 5.66 oints Utilities Allocation Base Percent of Allocation Base Cost to be Allocated Cost Allocated Department Floor space occupied Numerator Denominator % of Total eBook 0 770 11.00 $ 57,000 $ 6,270 Advertising Administrative 7,000 7,000 840 12.00 57,000 6,840 Print Shoes 0 57,000 0 0 57,000 Clothing Totals 0 $ 57,000 References Advertising Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Department Number of ads Numerator Denominator % of Total Shoes 48 240 20.00 $ 16,270 $ 3,254 13,016 Clothing 192 240 80.00 16,270 Totals 100.00 $ 16,270 Administrative Department Shoes Clothing Totals Cost to be Allocation Base Percent of Allocation Base Allocated Cost Allocated Sales Numerator Denominator % of Total $ 192,000 $ 240,000 80.00 $ 18,840 $ 15,072 48,000 240,000 20.00 18,840 3,768 100.00 $ 18,840 MARATHON RUNNING SHOP Departmental Expense Allocation Spreadsheet For Year Ended December 31, 2019 Expense Totals Advertising Administrative Shoes Clothing $ 175,000 $ 10,000 $ 12,000 $ 134,000 $ 19,000 57,000 6,270 6,840 18,810 25.080 Direct expense Indirect utilities expenses 232,000 16,270 18,840 152,810 44,080 Total dept. exp. Service Dept. Expenses Advertising Dept. Administrative Dept. (16,270) 3.254 13,016 (18,840) 15,072 3,768 Total expenses allocated $ 232,000 $ 0 $ 0 $ 171,136 $ 60,864 movgvi Screen Recorder h 22 Homework i Saved m. Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The spreadsheet should expenses to each of the four departments, (2) the $57,000 of utilities expense to the four departments on the ba occupied, (3) the advertising department's expenses to the two operating departments on the basis of the numbe promoted a department's products, and (4) the administrative department's expenses to the two operating depar amount of sales. 5.66 oints Utilities Allocation Base Percent of Allocation Base Cost to be Allocated Cost Allocated Department Floor space occupied Numerator Denominator % of Total eBook 0 770 11.00 $ 57,000 $ 6,270 Advertising Administrative 7,000 7,000 840 12.00 57,000 6,840 Print Shoes 0 57,000 0 0 57,000 Clothing Totals 0 $ 57,000 References Advertising Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Department Number of ads Numerator Denominator % of Total Shoes 48 240 20.00 $ 16,270 $ 3,254 13,016 Clothing 192 240 80.00 16,270 Totals 100.00 $ 16,270 Administrative Department Shoes Clothing Totals Cost to be Allocation Base Percent of Allocation Base Allocated Cost Allocated Sales Numerator Denominator % of Total $ 192,000 $ 240,000 80.00 $ 18,840 $ 15,072 48,000 240,000 20.00 18,840 3,768 100.00 $ 18,840 MARATHON RUNNING SHOP Departmental Expense Allocation Spreadsheet For Year Ended December 31, 2019 Expense Totals Advertising Administrative Shoes Clothing $ 175,000 $ 10,000 $ 12,000 $ 134,000 $ 19,000 57,000 6,270 6,840 18,810 25.080 Direct expense Indirect utilities expenses 232,000 16,270 18,840 152,810 44,080 Total dept. exp. Service Dept. Expenses Advertising Dept. Administrative Dept. (16,270) 3.254 13,016 (18,840) 15,072 3,768 Total expenses allocated $ 232,000 $ 0 $ 0 $ 171,136 $ 60,864 movgvi Screen Recorder