Go to the tab titled "Estimated MOH.": ***Excel shown below in picture***
a. For each of the seven variable manufacturing overhead expenses (highlighted in yellow), create a formula that calculates the estimated amount of the expense for this year. (Hint: Use last year's actual amount of each expense and the actual total labor hours [cell B39] as the basis for this year's estimates.)
3b. and 3c. What is the estimated indirect materials cost in the Molding Department (cell E17) and the estimated utilities cost in the Fabrication Department (cell E21)?
nbers File Edit Insert Table Organize M Q Sun Sep 12 Format Arrange View Share Window Help ExcelAnalytics_JobOrderCosting_PlantwidePredetermined OverheadRates_Template 000 91% Zoom View Insert Table Chart Text Shape Media Comment Add Category VLOOKUP Collaborate Job Profitability e Format Organize Waterfall Chart + Pivot Table Direct Materials Requisitions Direct Labor Summary Estimated MOH Lost Year Account Equipment depreciation: Molding Equipment depreciation: Fabrication Equipment depreciation: Assembly Equipment depreciation: Materials Handling Equipment depreciation: Other Production supruislon: Melding Production supervision: Fabrication Production supervision: Assembly Indirect laber: Maintenance & Repairs Indirect labor. Materials Handling Indirect labor Engineering Indirect labor: Raw Materials Purchasine Indirect labor: Qualty Control Indirect labor: Packaging & Shipping Indirect materials. Molding Indirect materials. Fabrication Indirect materials Assembly Uites: Molding Uitles: Fabrication Ultes: Assembly Utilties: Plant lighting and other equipment Utilities: Heating and cooling Property insurance Liability insurance Medical insurance Workers' compensation insurance Other salaries: Plant manager Other salaries: Accounting Other salaries: Administrative support Other salaries: Janitorial Other salaries Security and grounds maintenance Property taxes Payroll taxes: Direct labor Payroll taxes: Other Total Manufacturing Overhead 8.000 This Year Estimated Amount Cost Behavior $ 400,000 Fixed $ 300,000 Fixed $ 50,000 Fixed $ 15,000 Fixed $ 10,000 Fixed $ 63,000 Fixed $ 68,250 Fixed $ 60,900 Fixed IS 75,600 Fixed $ S 71,400 Fixed $ 178,500 Fixed $ 97,650 Fixed IS 39,900 Fixed $ 103,950 Fixed Variable Variable Variable Variable Variable Variable $ 12. 240 Fixed $ 24,480 Hxed $ 26,520 Fixed $ 18,360 Fixed $ 51,750 Fixed $ 14,300 Fixed $ 173,250 Fixed 93,450 Fixed $ 58,800 Fixed IS $ 50,400 Fixed $ 46,200 Fixed $ 18,540 Fixed Variable S 172.250 Fixed $ 2.295.620 Actual Amount Cost Behavior $ 400,000 Fixed $ 300,000 Fixed $ 50,000 Fixed s 15,000 Fixed 10,000 Fixed S 60,000 Fixed S 65,000 Fixed $ 58.000 Fixed $ 72,000 Fixed $ 68000 Fixed $ 170.000 Fixed $ 93000 Fixed S 38.000 Fixed $ 99.000 Fixed $ 18,000 Variable $ 13.000 Variable $ Variable $ 24.000 Variable $ 20.000 Variable $ 6,000 Variable $ 12,000 Fixed $ 24,000 Fxed $ 26,000 Fxed $ 18.000 Fixed 45,000 Exed S $ 13,000 Fixed s 165,000 Fixed $ 89,000 Fixed $ 56,000 Fixed S 18.000 Fixed S 44,000 Fixed $ 18 000 Fixed $ 79,000 Variable $ Fixed $ 2.319 AM 41,400 42,500 Total direct labor hours Plantwide predetermined overhead rate
