ework 0 Saved Help Save & Exit Check my 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 Indirect Expense Cost Allocation Base Supervision $ 82,600 Number of employees Utilities 51,000 square feet occupied Insurance 23,000 Value of assets in use Total $156,600 Departmental data for the company's recent reporting period follow Department Materials Personnel Manufacturing Packaging Total Employees 24 6 4 42 120 Square Feet 22,000 11,000 55,000 22,000 110,000 Asset Values $ 6,100 1,330 36,600 16420 561,000 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. D D Required 1 Required 2 Use this information to allocate each of the three indirect expenses across the four departments, Allocation Base Percent of Allocation Base Numerator Denominato % of Total Cost to bo Allocated Allocated Cost 0 0 0 0 0 0 0 Allocation Base Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Department Materials Personnel Manufacturing Packaging Totals Insurance Department Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Tota! 0 0 0 0 0 0 0 Allocation Base Percent of Allocation Base Numerator Denominator % of Total Cost to be Allocated Allocated Cost 0 0 0 0 0 Allocation Base Manufacturing Packaging Totals Utilities Department Materials Personnel Manufacturing Packaging Totals Percent of Allocation Base Numerator Denominato % of Total Cost to bo Allocated Allocated Cost 0 0 0 0 0 0 0 Allocation Base Cost to be Allocated Allocated Cos Percent of Allocation Base Numerator Denominato % of Total 0 Insurance Department Materials Personnel Manufacturing Packaging Totals 0 0 0 0 0 R Required 2 > 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 Materials 0 Personnel 0 Manufacturing 0 Packaging 0 Totals $ 0 $ 0 $ 0 $ 0 Below are departmental income statements for a guitar manufacturer. The manufacturer is considering eliminating its electric guitar department since it has a net loss. The company classifies advertising, rent, and utilities expenses as indirect Electric $35,000 46,85e 38,150 WHOLESALE GUITARS Departmental Income Statements For Year Ended December 31, 2019 Acoustic Sales 5103,300 Cost of goods sold 44.975 Gross profit 58,325 Operating expenses Advertising expense 5,035 Depreciation expense-Equipment 10, 110 Salaries expense 19,700 Supplies expense 2.030 Rent expense 7,065 Utilities expense 2.905 Total operating expenses 46,025 Net Income (10) $ 11,400 4,320 8,520 17,100 1,750 6,010 2.500 40,300 $(2,150) 1. Prepare a departmental contribution report that shows cach department's contribution to overhead 2. Based on contribution to overhead, should the electric guitar department be eliminated? Complete this question by entering your answers in the tabs below: WHOLESALE GUITARS Income Statement Showing Departmental Contribution to Overhead For Year Ended December 31, 2019 Acoustic Dept. Electric Dept. Combined Direct expenses 0 0 0 Total direct expenses Departmental contributions to overhead Indirect expenses $ 0 $ 0 $ 0 Total Indirect expenses 0 0 1. Prepare a departmental contribution report that shows each department's contribution to overhead 2. Based on contribution to overhead, should the electric guitar department be eliminated? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Based on contribution to overhead, should the electric guitar department be eliminated? Based on contribution to overhead, should the electric guitar department be eliminated?