Required information [The following information applies to the questions displayed below] Ozuna Company uses ajoborder costing system with a plantwide predetermined overhead rate based on direct labor hours. For job costing purposes, it uses an average direct labor wage rate of $20 per hour. The company has been struggling financially; accordingly, it has asked you to conduct a job profitability study beginning with a thorough critique of its existing cost system. To keep the scope of your project manageable. you have chosen a subset of 12jobs from the manyjobs completed by the company during the year. Your goal is to complete the table shown below and comment on the insights that it provides: Direct Applied Total Job Gross Job Sales Materials Direct Labor Overhead Cost Margin 1 $2,466 E E E E E 2 $5,466 E E E E E 3 $9,666 E E E E E 4 $1,456 E E E E E 5 $2,299 ? ? ? ? i 6 $?,866 E E E E E 2 $1,?66 E E E E E 8 $1,666 E E E E E 9 $8,666 E E E E E 16 $4,166 E E E E E 11 $3,266 E E E E E 12 $2,866 E E E E E Click here to download the Excel template. which you will use to answer the questions that follow. 4 Eli,43U ." i' ." " ." 5 $2,269 P P P P P 9 $7,969 P P P P P 7 $1,?66 P P P P P 8 $1,969 P P P P P 9 $8,969 P P P P P 19 $4,169 P P P P P 11 $3,269 P P P P P 12 $2,869 P P P P P Click here to download the Excel template. wl'ich you will use to answer the questions that follow. Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on VLOOKUP in Excel. Required: 3. Go to the tab titled \"Estimated MOH.": 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 BB9] as the basis for this year's estimates.) 3b. anc 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]? 3b. The estimated indirect materials cost in Molding is 3c. The estimated utilities cost in Fabrication is m Account Equipment depreciation: Molding Equipment depreciation: Fabrication Equipment depreciation: Assembly Equipment depreciation: Materials Handling Equipment depreciation: Other Production suprvision: Molding Production supervision: Fabrication Production supervision: Assembly Indirect labor: Maintenance & Repairs Indirect labor: Materials Handling Indirect labor: Engineering Indirect labor: Raw Materials Purchasing Indirect labor: Quality Control Indirect labor: Packaging & Shipping Indirect materials: Molding Indirect materials: Fabrication Indirect materials: Assembly Utilities: Molding Utilities: Fabrication Utilities: Assembly Utiltiies: Plant lighting and other equipment Utilities: Heating and cooling Property insurance mmmmmmmmmmmmmmmmmmmmmmm Last Year Actual Amount Cost Behavior 400,000 Fixed 300,000 Fixed 50,000 Fixed 15,000 Fixed 10,000 Fixed 60,000 Fixed 65,000 Fixed 58,000 Fixed 72,000 Fixed 68,000 Fixed 170,000 Fixed 93,000 Fixed 38,000 Fixed 99,000 Fixed 18,000 Variable 13,000 Variable 8,000 Variable 24,000 Variable 20,000 Variable 6,000 Variable 12,000 Fixed 24,000 Fixed 26,000 Fixed mmmmmmmmmmmmmm This Year Estimated Amount 400,000 300,000 50,000 15,000 10,000 63,000 68,250 60,900 75,600 71,400 178,500 97,650 39,900 103,950 12,240 24,480 20,520 Cost Behavio Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Variable Variable Variable Variable Variable Variable Fixed Fixed Fixed Property insurance 26,000 Fixed 26,520 Fixed un Liability insurance 18,000 Fixed 18,360 Fixed Medical insurance 45,000 Fixed S 51,750 Fixed Workers' compensation insurance 13,000 Fixed S 14,300 Fixed Other salaries: Plant manager 165,000 Fixed S 173,250 Fixed Other salaries: Accounting 89,000 Fixed $ 93,450 Fixed Other salaries: Administrative support 56,000 Fixed un 58,800 Fixed Other salaries: Janitorial S 48,000 Fixed S 50,400 Fixed Other salaries: Security and grounds maintenance 44,000 Fixed 46,200 Fixed Property taxes S 18,000 Fixed S 18,540 Fixed Payroll taxes: Direct labor S 79,000 Variable Variable Payroll taxes: Other S 165,000 Fixed S 173,250 Fixed Total Manufacturing Overhead $ 2,389,000 $ 2,295,690 Total direct labor hours 41,400 42,500 Plantwide predetermined overhead rate