Question

Case Case B 70,000 Caset 10,000 20,000 185,000 225,000 165,000 260,000 295,000 325,000 525,000 1,065,000 75,000 65,000 85,000 195,000 1,060,000 65,000 110,000 Beginning inventory, raw material Ending inventory, raw material Purchases of raw material Direct material used Direct labor Manufacturing overhead Total manufacturing costs Beginning inventory, work in process Ending inventory, work in process Cost of goods manufactured Beginning inventory, finished goods Cost of goods available for sale Ending inventory, finished goods Cost of goods sold Sales Gross margin Selling and administrative expenses Income before taxes Income tax expense Net income 3,000 200,000 1,060,000 125.000 125,000 215,000 15.000 1.115,000 1,010,000 290,000 515,000 515,000 235.000 50.000 325,000 85.000 146.000 30.000 < Prev 10 o 13

Answer 1

	Case A	B	C
Beginning Inventory	125,000	70,000	10,000
Ending Inventory	185,000	35,000	20,000
Purchase	225,000	260,000	55,000
Direct Material used	165,000	295,000	45,000
Direct labor	375,000	325,000	65,000
manufactuirng overhead	525,000	440,000	85,000
Total manufacturing costs	1,065,000	1,060,000	195,000
WIP Beginning inventory	75,000	65,000	8,000
Ending Inventory	80,000	110,000	3,000
Cost of goods manufactured	1,060,000	1,015,000	200,000
Beginning Inventory Finished Goods	125,000	125,000	15,000
Cost of goods available for sale	1,185,000	1,140,000	215,000
Ending Inventory	70,000	130,000	15,000
Cost of goods sold	1,115,000	1,010,000	200,000
Sales	1,630,000	1,525,000	290,000
Gross Margin	515,000	515,000	90,000
Selling and Admin Expense	190,000	235,000	40,000
Income before taxes	325,000	280,000	50,000
Income tax	85,000	146,000	20,000
Net Income	240,000	134,000	30,000

А В C D 1 Case A В с 2 Beginning Inventory 3 Ending Inventory 4 Purchase %3DВ5+B3-B4 70000 10000 EC2+C4-C5 20000 185000 225000 260000 =D3+D5-D2 295000 5 Direct Material used 165000 =D8-D6-D7 =B8-B5-B7 325000 65000 6 Direct labor 7 manufactuirng overhead 8 Total manufacturing costs 9 WIP Beginning inventory 10 Ending Inventory 11 Cost of goods manufactured 12 Beginning Inventory Finished Goods 13 Cost of goods available for sale 14 Ending Inventory 15 Cost of goods sold 16 Sales 525000 EC8-C5-C6 85000 1060000 1065000 195000 75000 65000 =D11+ D10 -D8 =B8+B9-B11 110000 3000 1060000 200000 -C8+C9-C10 -D13-D11 125000 -B11+B12 125000 215000 C11+C12 ЕB13-B15 C13-C15 15000 1115000 1010000 =D13-D14 =B15+ B17 EC17+C15 290000 17 Gross Margin 18 Selling and Admin Expense 515000 515000 =D16-D15 235000 D17-D19 B17-B19 325000 50000 =C17-C18 146000 19 Income before taxes 20 Income tax 21 Net Income 85000 D19-D21 -C19-C20 30000 -B19-B20