Tableau DA 16-3 (Static): Mini-Case, Preparing and using a production cost report LO P2Monsta Cola hires us to help assign and report costs. The company has two departments: mixing and bottling. To aid our analysis, thefollowing Tableau Dashboard is provided with information for the mixing department. The company uses the weighted averagemethod.Work in Process Inventory (In Units)Beginning inventoryUnits started this periodUnits completed and transferredEnding inventory0100,000200,000300,000400,000500,000600,000700,000800,000Work in Process Inventory Percent CompleteBeginningEnding100%80%- Work in Process Inventory Percent Complete Beginning =G [T1009% - Direct Materials Conversion Direct Materials Conversion Work in Process Inventory CostsBeginning Inventory Costs Inventory Costs Added During Month Work in Process Inventory CostsBeginning Inventory Costs Inventory Costs Added During Month Conversion Conversion Direct Materials Direct Materials "++ View on Tableau Public 1. Prepare a production cost report for the mixing department. 2. Assume the mixing department budgeted conversion costs of $2.80 per equivalent unit for the month. Were the mixingdepartment's actual conversion costs per equivalent unit above or below budgeted amounts? 3. If an error is made and the percent complete for units in ending inventory is overstated, what effect does this have on current periodfinancial statements? Complete this question by entering your answers in the tabs below. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a production cost report for the mixing department. (Round "Cost per EUP" to 2 decimal places.) Unit Reconciliation _ Units to account for Total units to account for Units accounted for Total units accounted forEquivalent Units of Production (EUP) Conversion Equivalent units of productionCost per EUP Units% CompleteEUP% CompleteEUPEquivalent units of productionCost per EUPDirect MaterialsConversionTotal costsCostsCostsEquivalent units of productionEUPEUPCost per equivalent unit of productionCost AssignmentCompleted and transferred outEUPCost per EUPTotal costDirect materialsConversionEnding work in processEUPCost per EUPTotal costDirect materialsConversionTotal costs accounted for