Can someone help me fill in the rest of this spreadsheet?

Determine the missing amounts in each of the following independent cases. Case A Case B Case C $ 20,000 $ 15,000 Beginning inventory, raw material Ending inventory, raw material Purchases of raw material 30,000 90,000 100,000 70,000 Direct material 85,000 95,000 100,000 125,000 160,000 250,000 520,000 345,000 340,000 35,000 20,000 35,000 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 5,000 350,000 525,000 50,000 40,000 370,000 25,000 545,000 330,000 480,000 255,000 170,000 Gross margin Selling and administrative expenses Income before taxes 75,000 90,000 150,000 40,000 Income tax expense 45,000 Net income 55,000