Question

In: Accounting

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 in process, May 31, 2019 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. Riley 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 two decimal places. Use rounded answers for subsequent calculations. Round other answers to the nearest whole number.

Riley Manufacturing Corporation Department 1
Flow of Units and Equivalent Units Calculations, May 2019
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 2 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

Show work

Solutions

Expert Solution

UNITS TO ACCOUNT FOR:
Beginning Work in Process units 2,000
Add: Units Started in Process 40,000
Total Units to account for: 42,000
UNITS TO BE ACCOUNTED FOR:
Units completed 39000
Ending Work in Process 3,000
Total Units to be accounted for: 42,000
Equivalent Units:
UNITS Material Cost Conversion
% Completion Units % Completion Units
Units completed 39000 100% 39,000 100% 39,000
Ending Work in Process 3000 100% 3,000 60% 1,800
Total Equivalent units 42000 42,000 40,800
TOTAL COST TO ACCOUNT FOR:
Material Conversion
Beginning cost of WIP 9800 16480
Cost added   2,95,120 5,01,680
Total Cost to account for: 3,04,920 5,18,160
Equivalent Units 42,000 40,800
Cost per Equivalent unit 7.26 12.7
TOTAL COST ACCOUNTED FOR:
Units completed (39000 units)
Equivalent unit Cost per EU Total Cost
Material 39,000 7.26 283140
Conversion Cost 39,000 12.7 495300
Total cost of units transferred out 778440
Ending Work in process (3000 units)
Equivalent unit Cost per EU Total Cost
Material 3,000 7.26 21780
Conversison Cost 1,800 12.7 22860
Total cost of Ending Work in process: 44,640
Total cost accounted for 8,23,080

Related Solutions

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