xcel/Tableau Assignment 1 Compute the equivalent units of production using the weighted-average method 2. Compute the cost per equivalent tusing the weighted average method 3. Assign costs to units using the weighted average method 4. Prepare o cott reconciliation report B . FILE HOME X Cat Process Costing using the Weighted Average MethodExce PAGE LAYOUT FORMULAS DATA REVIEW VE INSERT % TU-11 Alignment Number Conditional Formatas Cel Formatting Table Styles Ses Hayword, Inc. uses weighted average costing and A1 4 1 GON . 51 500 56.70 5912,150 450 DON 23 M 1 3 HOME Process Costing using the Weighted-Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE INSERT Calibri -11 A A % Paste BIU- Cells A. Alignment Number Conditional format as Cell Formatting Table Styles Styles pboard Font Book A1 v Hayword, Inc. uses weighted average costing and has two d D Materials Convention ACK 55 16 Cost of beginning work in procent 37 Cost added during the period Total quitwits of production Cost per unit erences 41 61 Augno Mixing Department Costs of Ending Work in Processinentory and the Units Transferred Out Materials Convention Ending work in processary quantit of production Cat per equivalent unit Cost of ending work in procesory Total Unit completed and transferred out Units transferred to the deatment 54 Corned out 34 Proseccion Ming Departman se Contact Cabed for Cowat begon in proceso Nicon and production arring the period Sheet1 HEADY Co Prey @ xcel/Tableau Assignment 1 Compute the equivalent units of production using the weighted-average method 2. Compute the cost per equivalent tusing the weighted average method 3. Assign costs to units using the weighted average method 4. Prepare o cott reconciliation report B . FILE HOME X Cat Process Costing using the Weighted Average MethodExce PAGE LAYOUT FORMULAS DATA REVIEW VE INSERT % TU-11 Alignment Number Conditional Formatas Cel Formatting Table Styles Ses Hayword, Inc. uses weighted average costing and A1 4 1 GON . 51 500 56.70 5912,150 450 DON 23 M 1 3 HOME Process Costing using the Weighted-Average Method - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE INSERT Calibri -11 A A % Paste BIU- Cells A. Alignment Number Conditional format as Cell Formatting Table Styles Styles pboard Font Book A1 v Hayword, Inc. uses weighted average costing and has two d D Materials Convention ACK 55 16 Cost of beginning work in procent 37 Cost added during the period Total quitwits of production Cost per unit erences 41 61 Augno Mixing Department Costs of Ending Work in Processinentory and the Units Transferred Out Materials Convention Ending work in processary quantit of production Cat per equivalent unit Cost of ending work in procesory Total Unit completed and transferred out Units transferred to the deatment 54 Corned out 34 Proseccion Ming Departman se Contact Cabed for Cowat begon in proceso Nicon and production arring the period Sheet1 HEADY Co Prey @