Question

Return to questio Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: B В с A Chapter 4: Applying Excel 1 2 2 3 Data 300 60 % 30 % 00 $ 7.994 $ 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion Costs in the beginning work in process inventory: 9 Materials cost 10 Conversion cost 11 Units started into production during the period 12 Costs added to production during the period: 13 Materials cost 14 Conversion cost 15 Ending work in process inventory: 16 Units in process 17 Completion with respect to materials 18 Completion with respect to conversion 7,257 16,800 $ 737,132 $ 1,343,389 700 60% 60 %

Answer 1

1.Equivalent unit of material

Particular	Unit (A)	% of completion(B)	Equivalent unit (A*B)_
Finished unit (300+16800-700)	16400	100%	16400
Closing Work in progress	700	60%	420
Equivalent unit of material			16820

2.Equivalent unit of conversion

Particular	Units	% of completion	Equivalent unit
Finished unit (300+16800-700)	16400	100%	16400
Closing Work in progress	700	60%	420
Equivalent unit of conversion			16820

3.Cost per equivalent unit of material-

=(Opening Work in progress cost of materials + Actual cost in process of material)/Equivalent unit of material

=(7994+737132)/16820

=44.30

4.Cost per equivalent unit of conversion

=(Opening work in progress cost of conversion+Actual cost in process of conversion)/ Equivalent unit of conversion

=(7257+1343389)/16820

=80.30

Cost of unit transferred out

Material = 16400 units* $44.30  

+ Conversion cost (16400 * $ 80.3)

=726520+1316920

=2043440