Question

In: Accounting

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 are 20 percent complete with respect to Department T costs and 100 percent complete for prior department costs.
Required

Prepare a production cost report using FIFO.

Solutions

Expert Solution

Reconciliation of Units (Step 1)
% already completed % completed this period
Units Departments S Departments T Departments S Departments T
Beginning WIP 15000 100% 60% 0 40%
Units introduced 35000
Total Units to be accounted for 50000
Completed and Transferred unit 45000 0 0 100% 100%
Ending WIP 5000 0 0 100% 20%
Equivalent Units ( Step 20
Department S Department T
Units Transferred Total Units: % completed this period Equivalent Units % completed this period Equivalent Units
From WIP 15000 0 0 40% 6000
From units started / introduced 30000 100% 30000 100% 30000
TOTAL 45000 30000 36000
Department S Department T
Ending WIP Total Units: % completed this period Equivalent Units % completed this period Equivalent Units
TOTAL 5000 100% 5000 20% 1000
TOTAL EUP 50000 35000 37000
Cost per Equivalent unit and cost to be accounted for (Step 3)
Department S Department T Total
Cost incurred in current period 280000 209050 489050
Total Equivalent Units 35000 37000
Cost per equivalent units 8 5.65
Cost of Beginning WIP 116000 53150 169150
Total cost to be accounted for 658200
Cost Report (Step 4)
Cost of Units Transferred 45000 units
Equivalent Units Cost per Equivalent Units Cost of Units Transferred Total
A From Beginning WIP:
Department S 8 0
Department T 6000 5.65 33900 33900
B From units started & completed
Department S 30000 8 240000
Department T 30000 5.65 169500 409500
C = A + B 443400
D Cost of Beginning WIP 169150
E = C + D Total Cost of Units Transferred 612550
Cost of Ending WIP
Equivalent Units Cost per Equivalent Units 5000 units
F Department S 5000 8 40000
G Department T 1000 5.65 5650
H = F + G Total Cost of Ending WIP 45650
I = E + H Total Cost accounted for 658200
J Rounding Off Differences 0
K = I + J Total cost to be accounted for [equals to computed in STEP 3] 658200

Related Solutions

Problem 8-50 Prepare a Production Cost Report and Adjust Inventory Balances: Weighted-Average Method (LO 8-3, 4)...
Problem 8-50 Prepare a Production Cost Report and Adjust Inventory Balances: Weighted-Average Method (LO 8-3, 4) The records of Fremont Corporation’s initial and unaudited accounts show the following ending inventory balances, which must be adjusted to actual costs. Units Unaudited Costs Work-in-process inventory 215,000 $ 818,897 Finished goods inventory 26,000 366,250 As the auditor, you have learned the following information. Ending work-in-process inventory is 40 percent complete with respect to conversion costs. Materials are added at the beginning of the...
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...
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...
Comprehensive Problem 8-85 (LO 8-1, LO 8-2, LO 8-3, LO 8-4, LO 8-5) [The following information...
Comprehensive Problem 8-85 (LO 8-1, LO 8-2, LO 8-3, LO 8-4, LO 8-5) [The following information applies to the questions displayed below.] John and Sandy Ferguson got married eight years ago and have a seven-year-old daughter, Samantha. In 2019, John worked as a computer technician at a local university earning a salary of $152,000, and Sandy worked part-time as a receptionist for a law firm earning a salary of $29,000. John also does some Web design work on the side...
Comprehensive Problem 8-85 (LO 8-1, LO 8-2, LO 8-3, LO 8-4, LO 8-5) [The following information...
Comprehensive Problem 8-85 (LO 8-1, LO 8-2, LO 8-3, LO 8-4, LO 8-5) [The following information applies to the questions displayed below.] John and Sandy Ferguson got married eight years ago and have a seven-year-old daughter, Samantha. In 2019, John worked as a computer technician at a local university earning a salary of $152,000, and Sandy worked part-time as a receptionist for a law firm earning a salary of $29,000. John also does some Web design work on the side...
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.
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT