Question

Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: B U 2 العا 4 es 300 35 % 50 % А 1 Chapter 5: Applying Excel 2 Data 4 Beginning work in process inventory: 5 Units in process 6 Completion with respect to materials 7 Completion with respect to conversion 8 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 $ $ 3,105 11,741 15,300 $ 448,818 $ 1,194,534 700 90 % 50 %

Answer 1

a) 15,530 Units
b) 15,250 Units
c) $29.10
d) $79.10
e) $1,612,180
Statement of Equivalent production
Particulars	Direct Materials	%completion	Equivalent mat	Conversion	%completion	Equivalent Conv	Total
Inventory in process, Beginning	300.00	100%	300.00	300.00	100%	300.00
Started and completed in the period = 15300 -700	14,600.00	100%	14,600.00	14,600.00	100%	14,600.00
Transferred to finished goods in period
Inventory in process, Ending	700.00	90%	630.00	700.00	50%	350.00
Equivalent Units of production			15,530.00			15,250.00
Opening WIP Costs			3,105.00			11,741.00	14,846.00
Current Month Costs			448,818.00			1,194,534.00	1,643,352.00
Total costs			451,923.00			1,206,275.00	1,658,198.00
Cost per Equivalent units			29.10			79.10
Units completed and transferred out			14,900.00			14,900.00
Cost of Units completed and transferred out			433,590.00			1,178,590.00	1,612,180.00