Check my 2 3 points 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 as total sales for the two operating departments for the year 2017 Department Direct Expenses Square Feet Sales Advertising $ 15,000 1,080 Administrative 28.000 990 Shoes 123,800 3,338 $166,480 Clothing 18,000 3,608 93,500 Shipped The advertising department developed and distributed 240 advertisements during the year of these, 72 promoted shoes and 168 promoted clothing. Utilities expense of $45,000 is an indirect expense to all departments eBook Print Complete a departmental expense allocation spreadsheet for Marathon Running Shop. The sprealsheet should assign (1) direct expenses to each of the four departments, (2) the $45,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department's expenses to the two operating departments on the basis of the number of ads placed that promoted a department's products, and (4) the administrative department's expenses to the two operating departments based on the amount of sales. References Utenties Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Coat Numerator Denominator % of Tot 0 0 0 Department Advertising Administrative Shoes Clothing Totals 0 0 0 Advertising Allocation Base Department Shoes Clothing Totals Cost to be Allocated cost Percent of Allocation Base Allocated Numerator Denominator of Total 0 0 0 Cost to be located cost Administrative Allocation Base Allocated Percent of Allocation Base Numeror Denominator of Tonal 0 Department 0 Clothing Total 0 MARATHON RUNNING SHOP Departmental Expense Allocation Spreadsheet For Year Ended December 31, 2017 Expense Totals Advertising Administrative Shoes Clothing 0 0 0 0 Direct expenses Indirect utiles expenses Total dept. cop Service Dept. Expenses Advertising Dept Administrative Dept Total expenses alocated 0 0 S 0 $ 08 08 $ Check my work 1 Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging. In a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow. 3 points Indirect Expense Supervision Utilities Insurance Total Cost Allocation Base $ 84,400 Number of employees 69,000 square feet occupied 32,000 Value of assets in use $185,400 cBook Departmental data for the company's recent reporting period follow. Hint Department Materials Personnel Manufacturing Packaging Total Employees 38 19 76 57 190 Square Feet 64,750 9,250 92,500 18,500 185,800 Asset Values $ 7,900 4,740 45,820 20,540 $79,680 Print References 1. Use this information to allocate each of the three indirect expenses across the four departments. 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments, Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a summary table that reports the indirect expenses assigned to each of the four departments. Supervision Utilities Insurance Total $ 0 0 0 Materials Personnel Manufacturing Packaging Totals 0 $ OS 0 $ 0 $ 0 Required 1