in excel

Q#1 For Dingo Dongo Co there are given following cost and inventory data for the year just completed: Costs incurred: Direct labor cost Purchases of raw materials Manufacturing overhead Advertising expense Sales salaries...... Depreciation, office equipment.. $70,000 $118,000 $80,000 $90,000 $50,000 $3,000 Beginning of the Year End of the Year Inventories: Raw materials Work in process ...... Finished goods. $7,000 $10,000 $20,000 $15,000 $5,000 $35,000 Required: a. Prepare a schedule of cost of goods manufactured. (3 points) b. Prepare the cost of goods sold section of Dingo Dongo Company's income statement for the year. (2 points)