show all working in excel

2. The following table summarizes the accounts balances for Bowen & Bowen in 2019. A Bowen & Bowen Beginning of 2019 End of 2019 Direct material inventory $ 85,472 $ 96,354 Work-in-process inventory 36,954 $ 25,638 Finished-goods inventory $ 25,874 S 40,523 Purchases of direct materials $ 62,452 Direct manufacturing labor $ 48,569 Indirect manufacturing labor $ 36,544 Plant insurance $ 9,852 Plant utilities $ 6,350 Property tax on plant building $ 2,450 Idle time 1,500 Depreciation-plant, building, and equipment $ 19,542 Repairs and maintenance-plant 9,654 Marketing, distribution, and customer service costs 136,540 General and administrative costs $ 216,543 Required: 0 Prepare a schedule for the cost of goods manufactured for 2019 (19 points) Prepare the income statement for 2019 assuming revenue total $984,786. (11 points) AAWA