Need help on this case. Thank you

Beginning of the month - End of the year- August 1, 20xx August 31, 20XX $20 000 $30 000 $13.800 $10 000 $40 000 $41.400 Inventories: 2 Raw Materials 4 Work in process 5 Finished goods 6 Costs 7 Direct labor 18 Advertising 9 Raw materials purchased e Factory rent 21 Variable Overhead 2 Ford Overhead 23 Selling expenses 34 Arministrative expenses $90.000 $50,000 $100,000 $36.000 $35.000 $25.000 $140 000 $20.000 27 Required: There are 4 questions to this part that you will need to answer below. 29 #1: Use the Data information above to prepare a statement of Cost of Goods Manufactured in good form like the example from Cornerstone 2.2 using only Excel cell referencing Lotion Company Statement of Cost of Goods Manufactured For the Month ended August 31, 20XX 34 Direct materials 35 Beginning inventory 36 Add Purchases 37 Materials available 39 Less Ending inventory 29 Direct materials used in production 40 Direct labor Manufacturing overhead 42 Total manufacturing costs added 43 Add: Beginning work in process 44 Less Ending work in process 45 Cost of goods manufactured 48 #2: Compute the cost of producing one Lotion last month. Compute your answer using cell reference 51 43: Use the Data information above to prepare a statement of Cost of Goods Sold in good form like the example from Cornerstone 2.3 using only Excel cell referencing Lotion Company Statement of Cost of Goods Sold For the Month ended August 31, 20/0X Use the Data Information above to prepare an Income Statement in good form like the example from Cornerstone 2.4 using only Excel cell referencing Include a column showing the percent of each line item of sales. (Round your percentage answers to two significant digits, for example, 33.29%) Lobon Company Income Stament For the Month ended August 31, 20XX