Indirect Expense Supervision Utilities Insurance Cost Allocation Base S 82,Number of employees 50,000 square feet occupied 22. see value of assets in 5155,00 Total Departmental data for the company's recent reporting period follow Department Employees Materials Personnel Manufacturing 63 Packaging Total Square Feet 25. De 5.ee 55. 15.ee 100.ee Asset Values $ 6,eee 1.200 37, Bee 15, eee See 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 olgned to each of the four departments Complete this question by entering your answers in the tabs below. Required quired 2 Use this information to allocate each of the three indirect expenses across the four departments. Alcantion Base Cost to be Allocated Allocated Coct Parent of Allocation Base Numerator Denontor of Total Bupervision expenses Department Materials Personnel Manufacturing Packaging Alication Base Cost to be Allocated Allocated Cost Utas Department Fargento Allocation Base Numer Denon of Total Personnel Inge Alication Bace P Cost to be Allocated Alloosted Cott u Denominator re of Total Department Numer Manbarung