3a-3-e please

Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes blended tropical fruit drinks in two stages. Fruit juices are extracted from fresh fruits and then blended in the Blending Department. The blended juices are then bottled and packed for shipping in the Bottling Department. The following information pertains to the operations of the Blending Department fo June. Percent Completed Materials Conversion 408 708 Work in process, beginning Started into production Completed and transferred out Work in process, ending Units 52,000 273,500 263,500 62,000 75% 258 I Work in process, beginning Cost added during June Materials Conversion $ 17,500 $ 5,300 $ 187,100 $ 111,880 Required: 1. Calculate the Blending Department's equivalent units of production for materials and conversion in June. 2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. 3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for June. 4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June. 5. Prepare a cost reconciliation report for the Blending Department for June Required: 1. Calculate the Blending Department's equivalent units of production for materials and conversion June. 2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. 3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for June. 4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June. 5. Prepare a cost reconciliation report for the Blending Department for June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Calculate the Blending Department's equivalent units of production for materials and conversion in June. Materials Conversion Equivalent units of production 310,000 279.000 Required: 1. Calculate the Blending Department's equivalent units of production for materials and conversion in June. 2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. 3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for June. 4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June. 5. Prepare a cost reconciliation report for the Blending Department for June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. (Round your decimal places.) Materials Conversion Cost per equivalent unit $ 0.66 $ 0.42 Required: 1. Calculate the Blending Department's equivalent units of production for materials and conversion in June 2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. 3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for June. 4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June. 5. Prepare a cost reconciliation report for the Blending Department for June. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 1 Required 2 Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in (Round your intermediate calculations to 2 decimal places.) Materials Conversion Total 6,510 $ 37,200 Jln CASS 30.690 ed Required: 1. Calculate the Blending Department's equivalent units of production for materials and conversion in June. 2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June. 3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for June. 4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June. 5. Prepare a cost reconciliation report for the Blending Department for June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, con total for June. (Round yqur intermediate calculations to 2 decimal places.) Materials Conversion Total $ Cost of units completed and transferred out 173,910 110,670 $ 284,580 Hed Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Prepare a cost reconciliation report for the Blending Department for June. (Round your intermediate calculation places.) ices Blending Department Cost Reconciliation Costs to be accounted for: Cost of beginning work in process inventory Costs added to production during the period Total cost to be accounted for Costs accounted for as follows: Cost of ending work in process inventory Cost of units completed and transferred out Total cost accounted for $ 22,800 298,980 $ 321.780 $ 37,200 284,580 $ 321.780 figures. Use these Inventory T-accounts for Sunspot Beverages month of June as directed in the requirements below. WIP-Blending 22800 WIP-Bottling Bal 6/1 I Raw Material Inventory Bal 6/1 120,000 Finished Goods Inventory Bal 6/1 -0- Bal 6/30 98,000 Bal 6/30 -0- 3) Process costing of second department: Follow the steps below to perform the costing analysis for the Bottling department. Refer to VPW 3 Packet for examples on how to complete the tables. a) Step 1 part 1: Account for physical units. Complete the tables below using #****#NUMBER #***## of units, NOT dollars!!!!!! Units in Bottling June 1 Units transferred in from Blending during June Units "to account for" Physical units for BOTTLING Units completed and transferred out during June Units in Bottling June 30 Units "accounted for Note: the 3rd row should be the first 2 rows added together. The units "to account for should equal the units "accounted for" equivalent W#NUMBER### of units, NOT dollars!!! For each of the 4 cost categories for Bottling Department, complete the table below to determine the equivalent units. Hint: All units "completed and transferred to Finished Goods" and units in "ending WIP-Bottling inventory" are 100% complete with respect to transferred in" costs (costs from Blending department) and bottle costs. Equivalent Units (ACCOUNTED FOR) Transferred in Other Materials (Blending costs) Bottles Conversion Equivalent units in ending WIP- Bottling inventory Equivalent units completed and transferred to Finished Goods" Total Equivalent units accounted for Note: The 3 row should be the first two rows added together. The 3 row for "Other" and Conversion WILL NOT equal the other columns in this table, nor will they equal the 3 row in the table for step 1 in a) above. c) Step 2 part 1: Make sure you complete the table Determine Costs to account for. These are SSSSDOLLARSSSSS not number of units. Costs to account for" is the sum of the beginning WIP-Bottling balance plus the costs that would have been added/assigned to the WIP-Bottling department during June. This information is summarized in the table above. Complete the table below using the information provided above. Bottling Department: Summary of Costs to be accounted for WIP-Bottling Costs Added Total Costs to be Cost Category beginning during June accounted for Transferred in from Blending $ 55,000 from 1b iv Cost of Bottles 111,000 from 2b i Other Material Costs 18,000 Efrom 2b ii Conversion Costs 80,500 from 2c Total $ 264,500 Note: The costs transferred IN that were transferred into Bottling once completed and transferred OUT" of the Blending department I d) Step 2 part 2: Calculate cost per equivalent unit. Answers will be SSSDOLLARSSS per ####NUMBER### of units. Use the totals in b) and e) above to calculate the cost per equivalent unit for each cost category. Use 4 decimal places to minimize rounding differences. Cost per Equivalent Unit Transferred in Bottle Costs Other Material Conversion Total Costs to be accounted for 3(c) Equivalent units 3(b) Cost Per Equivalent Unit e) Step 3: Allocate costs to units. Multiply the Cost per Equivalent for each cost category in step 4 time the equivalent units for "completed and transferred to Finished Goods" and "ending Inventory" to complete the table below. ROUND YOUR ANSWERS TO NEAREST WHOLE DOLLARS. Add the cost categories together across to the Total Column. Total each column to the bottom row "costs accounted for. The total in the bottom right box should be the total of the numbers above it AND the total of the numbers to its left. (It may be off a few dollars for rounding). Your answer represents $$$$DOLLARSSSSS$ not units. Round your answers to the nearest whole dollar. Costs accounted for in dollars I Other Material Transferred in Bottles Costs Total Conversion WIP -Ending balance Costs of goods completed and transferred out Total Costs accounted for Note: The total "costs accounted for" in the bottom row should equal (off a few $s for rounding the totals "costs to account for" in the bottom row of the table in step 3