Question

In: Accounting

Product Cost Report—Weighted Average Method Reston Manufacturing Corporation produces a cosmetic product in three consecutive processes....

Product Cost Report—Weighted Average Method

Reston Manufacturing Corporation produces a cosmetic product in three consecutive processes. The costs of Department 1 for May 2016 were as follows:

Cost of beginning inventory
Direct material $19,600
Conversion costs 33,180
Costs added in Department 1
Direct material $590,800
Direct labor 597,100
Manufacturing overhead 406,260 1,594,160

Department 1 handled the following units during May:

Units in process, May 1 2,000
Units started in Department 1 40,000
Units transferred to Department 2 39,000
Units in process, May 31 3,000

On average, the May 1 units were 30% complete. The May 31 units were 60% complete. Materials are added at the beginning of the process, and conversion costs occur evenly throughout the process in Department 1. Reston uses the weighted average method for process costing.

Required

Prepare the product cost report for Department 1 for May.

Round average cost per equivalent unit to four decimal places. Use rounded answers for subsequent calculations. Round other answers to the nearest whole number.

Reston Manufacturing Corporation Department 1
Flow of Units and Equivalent Units Calculations, May 2016
Equivalent Units
% Work
Done
Direct
Materials
% Work
Done
Conversion
Costs
Complete/Transferred Answer Answer% Answer Answer% Answer
Ending Inventory Answer Answer% Answer Answer% Answer
Total Answer Answer Answer
Product Cost Report
Direct
Materials
Conversion
Costs
Beginning Inventory $Answer $Answer $Answer
Current Answer Answer Answer
Total Costs to Account For $Answer $Answer $Answer
÷ Total Equivalent Units Answer Answer
Average cost / Equivalent unit (round four decimal places) $Answer $Answer
Complete / Transferred:
Direct Materials $Answer
Conversion costs Answer
Cost of Goods Manufactured $Answer
Ending Inventory:
Direct Materials $Answer
Conversion costs Answer
Cost of Ending Inventory $Answer
Total Costs Allocated $Answer

Solutions

Expert Solution

Reston Manufacturing Corporation Department 1
Flow of Units and Equivalent Units Calculations, May 2016
Equivalent Units
% Work Direct % Work Conversion
Done Materials Done Costs
Complete/Transferred 39000 100% 39000 100% 39000
Ending Inventory 3000 100% 3000 60% 1800
Total 42000 42000 40800
Product Cost Report
Direct Conversion
Materials Costs
Beginning Inventory $        52,780.00 $     19,600.00 $       33,180.00
Current $   15,94,160.00 $ 5,90,800.00 $ 10,03,360.00
Total Costs to Account For $   16,46,940.00 $ 6,10,400.00 $ 10,36,540.00
÷ Total Equivalent Units 42000 40800
Average cost / Equivalent unit (round four decimal places) $        14.5333 $          25.4054
Complete / Transferred:
Direct Materials $          5,66,799
Conversion costs $          9,90,811
Cost of Goods Manufactured $        15,57,609
Ending Inventory:
Direct Materials $             43,600
Conversion costs $             45,730
Cost of Ending Inventory $             89,330
Total Costs Allocated $        16,46,939

Related Solutions

Product Cost Report—Weighted Average Method Riley Manufacturing Corporation produces a cosmetic product in three consecutive processes....
Product Cost Report—Weighted Average Method Riley Manufacturing Corporation produces a cosmetic product in three consecutive processes. The costs of Department 1 for May 2019 were as follows: Cost of beginning inventory Direct material $9,800 Conversion costs 16,480 Costs added in Department 1: Direct material $295,120 Direct labor 298,550 Manufacturing overhead 203,130 796,800 Department 1 handled the following units during May: Units in process, May 1, 2019 2,000 Units started in Department 1 40,000 Units transferred to Department 2 39,000 Units...
Product Cost Report—Weighted Average Method Reston Manufacturing Corporation produces a cosmetic product in three consecutive processes....
Product Cost Report—Weighted Average Method Reston Manufacturing Corporation produces a cosmetic product in three consecutive processes. The costs of Department 1 for May 2016 were as follows: Cost of beginning inventory Direct material $24,500 Conversion costs 41,475 Costs added in Department 1 Direct material $738,500 Direct labor 746,375 Manufacturing overhead 507,825 1,992,700 Department 1 handled the following units during May: Units in process, May 1 2,000 Units started in Department 1 40,000 Units transferred to Department 2 39,000 Units in...
Salanger Manufacturing Corporation produces a dandruff shampoo in three consecutive processes. The costs of Department 1...
Salanger Manufacturing Corporation produces a dandruff shampoo in three consecutive processes. The costs of Department 1 for June 2019 were as follows: Cost of beginning inventory Direct material $5,500 Conversion costs 12,740 Costs added in Department 1: Direct material $223,390 Direct labor 358,300 Manufacturing overhead 155,269 736,959 Department 1 handled the following units during June: Units in process, June 1 2,000 Units started in Department 1 45,000 Units transferred to Department 2 46,000 Units in process, June 30 1,000 On...
Transferred-In Cost Energetics Inc. produces a protein drink and uses the weighted-average method. The product is...
Transferred-In Cost Energetics Inc. produces a protein drink and uses the weighted-average method. The product is sold by the liter. The company has two departments: Mixing and Bottling. For July, the bottling department had 56,400 liters in beginning inventory (with transferred-in costs of $213,000) and completed 208,000 liters during the month. Further, the mixing department completed and transferred out 297,000 liters at a cost of $658,000 in July. Required: 1. Prepare a physical flow schedule for the bottling department. Energetics...
Weighted Average Method, Equivalent Units Goforth Company produces a product where all manufacturing inputs are applied...
Weighted Average Method, Equivalent Units Goforth Company produces a product where all manufacturing inputs are applied uniformly. Goforth produced the following physical flow schedule for April: Units to account for: Units in BWIP (40% complete) 300,000 Units started 660,000    Total units to account for 960,000 Units accounted for: Units completed: From BWIP 300,000 Started and completed 448,800 748,800 Units, EWIP (80% complete) 211,200 Total units accounted for 960,000 Required: Prepare a schedule of equivalent units using the weighted average method....
Gamma Manufacturing Co. Ltd. makes a product by way of three consecutive processes. The following data...
Gamma Manufacturing Co. Ltd. makes a product by way of three consecutive processes. The following data relates to process 2 for the month of May. (i) During May, 1,500 units valued at $226.50 each were transferred from process 1 to process 2. (ii) Other costs incurred during the month were: Direct material added                         $114,750 Direct manufacturing wages               $124,850 Manufacturing overheads                   $158,250 (iii) 200 units were scrapped during the period. Normal losses were estimated to be 81/3% of input...
Gamma Manufacturing Co. Ltd. makes a product by way of three consecutive processes. The following data...
Gamma Manufacturing Co. Ltd. makes a product by way of three consecutive processes. The following data relates to process 2 for the month of May. (i) During May, 1,500 units valued at $226.50 each were transferred from process 1 to process 2. (ii) Other costs incurred during the month were: Direct material added   $114,750 Direct manufacturing wages $124,850 Manufacturing overheads   $158,250 (iii) 200 units were scrapped during the period. Normal losses were estimated to be 81/3% of input during the...
Alpha Manufacturing Co. Ltd. makes a product by way of three consecutive processes. The following data...
Alpha Manufacturing Co. Ltd. makes a product by way of three consecutive processes. The following data relates to process 2 for the month of June. (i) Transfer in from Process 1, 1,500 units valued at $240.50 each. (ii) Other costs incurred during the month were: Direct material added $127,070 Direct manufacturing wages $131,450 Manufacturing overheads $168,175 (iii) 200 units were scrapped during the period. Normal losses were estimated to be 5% of input during the period. The scrap value of...
Create a model for a production cost report using the weighted average method for the month...
Create a model for a production cost report using the weighted average method for the month of May. You should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. Please include step by step directions(in a text box).After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”.  Create a production cost report using the same...
create a model for a production cost report using the weighted average method for the month...
create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users. After completion of the production cost report...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT