Question

In: Accounting

Prepare a cost of production report for the Machining Department for May using the FIFO method...

Prepare a cost of production report for the Machining Department for May using the FIFO method of costing.


Phillips Company needs to prepare a cost of production report for the machining department. The follow data has been provided:

1. Work in process, May 1, had 90,000 units that were 40% completed and the following costs:
   Direct materials       $72,720
   Direct labor       $108,000
   Overhead       $36,000

2. During the month of May, 180,000 units were completed and transferred to the next department and the following costs were added to production:
   Direct materials       $216,000
   Direct labor       $144,000
   Overhead       $162,000

3. On May 31, there were 45,000 partially completed units in process. These units were 80% complete.

Solutions

Expert Solution

  • Various elements of Cost of Production report are provided below

Costs Charged to Production:

Cost of beginning WIP

$                     216,720.00

Costs incurred this period

$                     522,000.00

Total Cost to account for

$                     738,720.00

Total costs accounted for

$                     738,720.00

Difference due to rounding cost/unit

$                                      -  

Units Reconciliation

Units to account for:

Beginning WIP

                                90,000

Units started this period

                              135,000

Total Units to account for

                              225,000

Total Units accounted for:

Completed & Transferred out

                              180,000

Ending WIP

                                45,000

Total Units accounted for

                              225,000

EUP - FIFO Method

Units

% Material

EUP Materials

% Conversion

EUP - Conversion

Units of ENDING WIP

                                45,000

100.0%

                   45,000

80.0%

                             36,000

Units STARTED & COMPLETED

                                90,000

100%

                   90,000

100%

                             90,000

Units of beginning WIP

                                90,000

0.00%

                            -  

60%

                             54,000

Equivalent Units of Production

                 135,000

                           180,000

COST per EUP

Material

Conversion

Cost incurred this period

$       216,000.00

$                  306,000.00

Total Costs

Costs

$       216,000.00

Costs

$                  306,000.00

Equivalent units of production

EUP

                 135,000

EUP

                           180,000

Cost per EUP

$                1.6000

$                          1.7000

COST ASSIGNMENT & RECONCILIATION

Cost Transferred out:

EUP

Cost per EUP

Total Cost

Cost of Beginning WIP

           216,720.00

Cost to complete beginning WIP-

- Direct Materials

                                          -  

                                 1.60

                            -  

- Conversion

                          54,000.00

                                 1.70

             91,800.00

Total cost to complete beginning WIP

           308,520.00

Cost of Units started & completed this period:

EUP

Cost per EUP

Total Cost

- Direct Materials

                          90,000.00

                                 1.60

           144,000.00

- Conversion

                          90,000.00

                                 1.70

           153,000.00

Total costs started & Completed this period

           297,000.00

Total cost of work finished this period

                605,520.00

Costs of Ending WIP:

EUP

Cost per EUP

Total Cost

- Direct Materials

                                45,000

$                              1.60

$          72,000.00

- Conversion

                                36,000

$                              1.70

$          61,200.00

Total cost of ending WIP

$             133,200.00

Total costs accounted for

$             738,720.00


Related Solutions

Using the Microsoft Excel, kindly prepare a cost production report under the FIFO Method. Paper Needs...
Using the Microsoft Excel, kindly prepare a cost production report under the FIFO Method. Paper Needs Inc, has the following production data for the month of June 20xx. DEPARTMENT I DEPARTMENT II QUANTITY SCHEDULE Units Percentage of completion Units Percentage of completion Work-in process, beginning 15,000 2/3 complete    9,000 1/3 complete Transferred to next department 30,000 ? Work-in process, end    5,000 2/5 complete    8,000 7/8 complete COST ANALYSIS DEPARTMENT I DEPARTMENT II Work-in process, beginning Cost from...
Using the Microsoft Excel, kindly prepare a cost production report for Department I and Department II...
Using the Microsoft Excel, kindly prepare a cost production report for Department I and Department II using the Weighted Average Method. Paper Needs Inc, has the following production data for the month of June 20xx. DEPARTMENT I DEPARTMENT II QUANTITY SCHEDULE Units Percentage of completion Units Percentage of completion Work-in process, beginning 15,000 2/3 complete    9,000 1/3 complete Transferred to next department 30,000 ? Work-in process, end    5,000 2/5 complete    8,000 7/8 complete COST ANALYSIS DEPARTMENT I...
Prepare a production cost report using the weighted average method and show the journal entry for...
Prepare a production cost report using the weighted average method and show the journal entry for transferring units from the molding to the welding department. I think I have it done correctly, but would like to see! Work in process beginning:    Units in process 24,000    Stage of completion for materials 80%    Stage of completion for labor and overhead 30%    Costs in work in process inventory: Materials $172,460 Labor 68,900 Overhead 141,300    Total costs in beginning...
Prepare a Production Cost Report: FIFO Method (LO 8-2, 4, 5) Lansing, Inc. provides the following...
Prepare a Production Cost Report: FIFO Method (LO 8-2, 4, 5) Lansing, Inc. provides the following information for one of its department’s operations for June (no new material is added in Department T): WIP inventory—Department T Beginning inventory (15,000 units, 60% complete with respect to Department T costs) Transferred-in costs (from Department S) $ 116,000 Department T conversion costs 53,150 Current work (35,000 units started) Prior department costs 280,000 Department T costs 209,050 The ending inventory has 5,000 units, which...
Discuss the steps used to prepare a production report under the FIFO and Weighted Average Cost...
Discuss the steps used to prepare a production report under the FIFO and Weighted Average Cost methods.
FIFO METHOD – PRODUCTION REPORT (MUST SHOW CALCULATIONS OR NO CREDIT) The accounting and production records...
FIFO METHOD – PRODUCTION REPORT (MUST SHOW CALCULATIONS OR NO CREDIT) The accounting and production records for the company show the following information: Work in Process, June 1                                                                                                                             10,000 units (Direct materials 100% complete; labor & overhead 70% complete) Units started                                                                                                                                   60,000 units Work in Process, June 30                                                                                                          4,000 units (Direct materials 100% complete; labor & overhead 60% complete) SUMMARY OF COSTS – Work-in-Process Account: June 1, beginning inventory, materials                                                                                           $ 32,000 June 1, beginning inventory, labor & overhead                                                                         $ 36,000 June, added costs: materials...
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...
Cost of Production Report: Weighted average method The increases to Work in Process—Roasting Department for Highlands...
Cost of Production Report: Weighted average method The increases to Work in Process—Roasting Department for Highlands Coffee Company for May as well as information concerning production are as follows: Work in process, May 1, 1,150 pounds, 40% completed$1,700 Coffee beans added during May, 10,900 pounds28,600 Conversion costs during May12,504 Work in process, May 31, 800 pounds, 80% completed_ Goods finished during May, 11,250 pounds_ Prepare a cost of production report for May, using the Weighted average method. Assume that direct...
Cost of Production Report: Average Cost Method Use the average cost method with the following data:...
Cost of Production Report: Average Cost Method Use the average cost method with the following data: Work in process, January 1, 7,000 units, 10% completed $45,080 Materials added during January from Weaving Department, 132,300 units 828,198 Direct labor for January 213,267 Factory overhead for January 167,967 Goods finished during January (includes goods in process, January 1), 129,500 units — Work in process, January 31, 9,800 units, 70% completed — Prepare a cost of production report for the Cutting Department of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT