Question

5 GRADED 0 Saved Requirement 2: Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 5: Applying Excel eBook Print 5 eferences 300 65 $ 3 Data 4 Beginning work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion Costs in the beginning work in process inventory: Materials cost Conversion cost 11 Units started into production during the period 12 Costs added to production during the period: Materials cost Conversion cost Ending work in process inventory: Units in process Completion with respect to materials Completion with respect to conversion 1,504 13,460 18,100 $ 600,412 $ 1,236,193 300 30 %

Answer 1

Since method is not given i have used Weighted Average Method

	Physical Flow	% Materials	Material	% Conversion	Conversion
Units to account for
Beginning Work in process	300
Units started	18100
Total Units to account for	18400
Units accounted for
Units transferred	18100	100%	18100	100%	18100
Equivalent units in ending WIP	300	10%	30	30%	90
Total units accounted for	18400
Equivalent units of production			18130		18190
	Material	Conversion	Total
Cost of beginning work in process	$            1,504	$             13,460	$          14,964
Cost added during the production	$       600,412	$       1,236,193	$    1,836,605
Total Cost	$       601,916	$       1,249,653	$    1,851,569
Equivalent units of production	18130	18190
Cost per Equivalent unit	$            33.20	$               68.70
	Material	Conversion	Total
Ending Work in process inventory
Equivalent units	30	90
Cost per Equivalent unit	$            33.20	$               68.70
Cost of Ending Work in process inventory	$               996	$               6,183	$            7,179
Units completed and transferred out
Units transferred	18100	18100
Cost per Equivalent unit	$            33.20	$               68.70
Cost of Units transferred	$       600,920	$       1,243,470	$    1,844,390
Costs to be accounted for
Cost of beginning work in process	$         14,964
Cost added during production	$   1,836,605
Total Costs to be accounted for	$   1,851,569
Costs accounted for as follows
Cost of Ending work in process	$            7,179
Cost of Units transferred	$   1,844,390
Total Costs accounted for	$   1,851,569

a. 18130 units
b. 18190 units
c. $33.20 per unit
d. $68.70 per unit
e. $1844390