Question

In: Accounting

Welding department Units WIP, October 1 (85% material; 60% conversion) 4,300 Units started in October 10,000...

Welding department
Units
WIP, October 1 (85% material; 60% conversion) 4,300
Units started in October 10,000
Units completed and transferred to assembling 9,500
WIP, October 31 (75% material, 40% conversion) 4,800
Costs
WIP, October 1
Materials (85% complete) $673,500
Conversion (60% complete) $341,640
WIP value, October 1 $1,015,140
Costs incurred in October
Materials $864,960
Conversion $463,840
Costs incurred in October $1,328,800
Total costs $2,343,940
What is the value of goods transferred out of welding in October?
What is the ending value of welding WIP on October 31?
What is the cost of a single, completed unit transferred out of welding?

Solutions

Expert Solution

Using Weighted Average Method:

Cost Assignment and Reconciliation
Cost of units transferred out EUP Cost/ EUP Total Cost
Direct Materials 9500 $ 117.44 $ 11,15,677.10
Conversion 9500 $   70.53 $   6,70,057.79
Total costs transferred out $ 17,85,734.89
Cost of ending work in process EUP Cost/ EUP Total Cost
Direct Materials 3600 $ 117.44 $   4,22,782.90
Conversion 1920 $   70.53 $   1,35,422.21
Total cost of ending work in process $   5,58,205.11
Total costs accounted for $ 23,43,940.00
Cost of units transferred out per unit = $ 1785734.89 / 9500
= $ 187.97

Workings:

Equivalent Units of Production (EUP) - Weighted Average Method
Units % Mat. EUP- Mat. % Conv. EUP- Conv.
Units completed and transferred out 9500 100% 9500 100% 9500
Units in ending inventory 4800 75% 3600 40% 1920
Equivalent units of production 13100 11420
Cost per Equivalent Unit of Production
Materials Conversion
Beginning costs $   6,73,500.00 $ 3,41,640.00
During the month costs $   8,64,960.00 $ 4,63,840.00
Total cost Costs $ 15,38,460.00 Costs $ 8,05,480.00
÷ Equivalent units of production EUP 13100 EUP 11420
Cost per equivalent unit of production $            117.44 $            70.53

Using FIFO Method:

Cost of Transferred Out Inventory
Units Costs
Direct Material 5845 $ 12,08,776.99 ($ 673500 + 5845 x $ 91.58)
Conversion 6920 $    7,04,737.47 ($ 341640 + 6920 x $ 52.47)
Total $ 19,13,514.46
Cost of Ending WIP
Units Cost/eq. units Costs
Direct Material 3600 $               91.58 $ 3,29,683.01
Conversion 1920 $               52.47 $ 1,00,743.53
Total $4,30,426.54

Workings:

A) Statement of equivalent production Degree of completion
Direct Material Conversion
a) Particulars Units Particulars Units % Units % Units
Opening WIP 4300 Transfer to next process:
Material Introduced 10000 From O/p WIP 4300 15% 645 40% 1720
From Current Intro 5200 100% 5200 100% 5200
Closing WIP 4800 75% 3600 40% 1920
14300 14300 9445 8840
Statement of cost per equivalent production
Element of costs Units Costs Cost/eq. units
Direct Material 9445 $     8,64,960.00 $                91.58
Conversion 8840 $     4,63,840.00 $                52.47
$             144.05

Related Solutions

Assume: BB WIP, 40% complete 10,000 units Started 100,000 EB WIP, 60% complete 12,000 Costs Beginning...
Assume: BB WIP, 40% complete 10,000 units Started 100,000 EB WIP, 60% complete 12,000 Costs Beginning WIP: DM $30,000 Conversion Costs $6,000 Materials used during the period $220,000 Conversion costs incurred during the period $150,000 Using a FIFO basis, what is the value of a) goods transferred out b) ending WIP?
Percent Complete Costs Units Materials Conversion Materials Conversion Beginning WIP 2,000 10% 90% $5,000 $1,000 Started...
Percent Complete Costs Units Materials Conversion Materials Conversion Beginning WIP 2,000 10% 90% $5,000 $1,000 Started into production 40,000 $100,000 $200,000 Ending WIP 3,000 30% 80% Using the weighted average method of process costing, calculate the (1) number of units transferred out, (2) equivalent units of production with respect to materials and with respect to conversion, (3) the cost per equivalent unit for materials and for conversion, (4) ending WIP inventory value for materials and for conversion, and (5) the...
​WIP, beginning inventory​ 2/1/2017 ​52,000 units           Direct materials​ (100% complete)           Conversion costs​ (50% complete) Started during...
​WIP, beginning inventory​ 2/1/2017 ​52,000 units           Direct materials​ (100% complete)           Conversion costs​ (50% complete) Started during February ​170,400 units Completed and transferred out ​180,600 units ​WIP, ending inventory​ 2/28/2017 ​26,900 units           Direct materials​ (100% complete)           Conversion costs​ (20% complete) ​Costs:     ​ WIP, beginning​ inventory:           Direct materials ​$280,100           Conversion costs ​80,400      Direct materials added ​408,000      Conversion costs added ​264,400 What costs are allocated to the ending workminus−inminus−process inventory for direct materials and conversion​ costs, respectively, using the FIFO method of process​...
Department A had 4,000 units in work in process that were 60% completed as to conversion...
Department A had 4,000 units in work in process that were 60% completed as to conversion at the beginning of the period, 29,000 units of direct materials were added during the period, 31,000 units were completed during the period, and 2,000 units were 80% completed as to coversion at the end of the period. All materials are added at the beginning of the process. The first-in, first-out method is used to cost inventories. The number of equivalent units for Direct...
The following information is provided by Panther​ Company: WIP​ Inventory, January 1 0 units Units started...
The following information is provided by Panther​ Company: WIP​ Inventory, January 1 0 units Units started ​22,000 units Units completed and transferred out ​9,000 units WIP​ Inventory, December 31 ​13,000 units Direct materials $24,800 Direct labor $13,300 Manufacturing Overhead $11,300 The units were​ 80% complete for materials and​ 30% complete for conversion costs. How much are the total costs to be accounted for during the​ year? A. $24,600 B. $24,800 C. $38,100 D. $49,400
UNITS: beginning WIP inventory (20% complete as to CC) 5,000 units started 20,000 units completed and...
UNITS: beginning WIP inventory (20% complete as to CC) 5,000 units started 20,000 units completed and transferred out 15,000 ending WIP inventory (Mat 100%, CC 50% complete) 10,000 Costs: beginning inventory materials $ 4,000 CC $ 1,000 Current period: materials $ 16,000 CC $ 4,000 All materials are added at the beginning of the process Please show the calculations! doing it in excel! 1. What is your products equivalent units (EUP) for Mat & CC using weighted average? --> Materials...
Production Data Physical units Prior Material Prior Conversion Current Material Current Conversion BI Units 8 90%...
Production Data Physical units Prior Material Prior Conversion Current Material Current Conversion BI Units 8 90% 40% ? ? Units Started 50    Units completed & To 46 100%   100% EI Units   12 60% 30% Costs data: Materials Conversion Prior period costs (BI) $4,933,600 $910,400 Current Costs (added) $32,200,000 $13,920,000 Find the Equivalent Units, costs per Equivalent units, and Cost Reconciliation Cost Reconciliation Equivalent Units Total Cost Materials Conversion Cost accounted for as follows: Transferred to Finished Goods:     From...
The Carlberg Company has two manufacturing departments, assembly and painting. The assembly department started 10,000 units...
The Carlberg Company has two manufacturing departments, assembly and painting. The assembly department started 10,000 units during November. The following production activity unit and cost information refers to the assembly department’s November production activities. Assembly Department Units Percent of Direct Materials Added Percent of Conversion Beginning work in process 2,000 60 % 40 % Units transferred out 9,000 100 % 100 % Ending work in process 3,000 80 % 30 % Beginning work in process inventory—Assembly dept $ 1,581 (includes...
Prior Period Percent Current Period Percent Production Data Phsyical Untis Material Conversion Material Conversion Beg Units...
Prior Period Percent Current Period Percent Production Data Phsyical Untis Material Conversion Material Conversion Beg Units 8 90% 40% 10% 60% Units Started 50 Units Completed 46 100% 100% End Units 12 60% 30% Materials Conversion Costs Data: Prior Period Costs (BI) $4,933,600.00 $910,400.00 Current Costs (Added) $32,200,000.00 $13,920,000.00 Cost Reconciliation Equivalent Units (above) Total Cost Materials Conversion Cost accounted for as follows: Transferred to Finished Goods: Completed & transferred out: Work in process, Dec. 31:     Materials     Conversion...
Saba enterprises had 250 units in beginning WIP which were 80% complete with regard to conversion...
Saba enterprises had 250 units in beginning WIP which were 80% complete with regard to conversion costs. 9,250 units were added during the period. 8,000 units were completed.   Ending WIP was 100% complete with regard to material and 60% complete with regard to conversion. Beginning WIP amounted to $3,500 of which $1,000 was for conversion. Costs added amounted to $132,280 of which $94,870 was for materials. Required: 1. Compute cost of goods completed and cost of WIP ending using weighted...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT