Question

In: Accounting

Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...

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 for June.

Percent Completed
Units Materials Conversion
Work in process, beginning 80,000 70% 40%
Started into production 392,500
Completed and transferred out 382,500
Work in process, ending 90,000 75% 25%


Materials Conversion
Work in process, beginning $ 31,500 $ 11,300
Cost added during June $ 337,500 $ 239,800


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.

Solutions

Expert Solution

Units

Reconciliation of Units

A

Opening WIP

                  80,000

B

Introduced

               392,500

C=A+B

TOTAL

               472,500

D

Transferred

               382,500

E=C-D

Closing WIP

                  90,000

Requirement 1

Statement of Equivalent Units

Material

Conversion Cost

Units

Complete %

Equivalent units

Complete %

Equivalent units

Transferred

         382,500

100%

                    382,500

100%

         382,500

Closing WIP

           90,000

75%

                       67,500

25%

           22,500

Total

         472,500

Total

                    450,000

Total

         405,000

Material

Conversion

Equivalent Units of Production

         450,000

               405,000

Requirement 2

Cost per Equivalent Units

COST

Material

Conversion Cost

TOTAL

Beginning WIP Inventory Cost

$              31,500

$                11,300

$           42,800

Cost incurred during period

$            337,500

$              239,800

$        577,300

Total Cost to be accounted for

$            369,000

$              251,100

$        620,100

Total Equivalent Units

               450,000

                 405,000

Cost per Equivalent Units

$   0.82

$ 0.62

Material

Conversion

Cost per equivalent Unit

$   0.82

$ 0.62

Requirement 3

Statement of cost

Cost

Equivalent Cost/unit

Ending WIP

Units

Cost Allocated

Material

$     0.82

                  67,500

$                55,350

Conversion Cost

$     0.62

                  22,500

$                13,950

TOTAL

$     620,100

TOTAL

$                69,300

Material

Conversion

Total

Cost of ending Inventory

$ 55,350

$   13,950

$    69,300

Requirement 4

Statement of cost

Cost

Equivalent Cost/unit

Transferred

Units

Cost Allocated

Material

$     0.82

            382,500

$                 313,650

Conversion Cost

$     0.62

            382,500

$                 237,150

TOTAL

$     620,100

TOTAL

$                 550,800

Material

Conversion

Total

Cost of Units Completed and Transferred out

$313,650

$ 237,150

$   550,800

Requirement 5

Reconciliation

Cost to be accounted for

Beginning Work In Progress:

Material

$         31,500.00

Conversion Cost

$         11,300.00

$ 42,800.00

Cost incurred during period:

Material

$       337,500.00

Conversion Cost

$       239,800.00

$ 577,300.00

Total Cost to be accounted for

$ 620,100.00

Cost accounted for

Cost of Units transferred

Equivalent Units

Cost per Equivalent Units

Cost accounted for

Material

                382,500

$     0.82

$        313,650.00

Conversion Cost

                382,500

$   0.62

$        237,150.00

$ 550,800.00

Cost of ending WIP

Equivalent Units

Cost per Equivalent Units

Cost accounted for

Material

                  67,500

$ 0.82

$          55,350.00

Conversion Cost

                  22,500

$ 0.62

$          13,950.00

$     69,300.00

Total Cost accounted for

$ 620,100.00


Related Solutions

Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 56,000 70% 40% Started into production 290,500...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 72,000 70% 40% Started into production 358,500...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 90,000 70% 40% Started into production 435,000...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 50,000 70% 40% Started into production 265,000...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 58,000 70% 40% Started into production 299,000...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 62,000 70% 40% Started into production 316,000...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 70,000 70% 40% Started into production 460,000...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 110,000 70% 40% Started into production 520,000...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 68,000 70% 40% Started into production 341,500...
Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes...
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 for June. Percent Completed Units Materials Conversion Work in process, beginning 125,000 55% 50% Started into production 199,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT