Preparing a balance sheet, journal entry and ending inventory with cost of goods sold

Must be submitted to me as a Excel file

Please take a look at the file I have attached with all the instructions and problems. Please also note to separate each problem in its own tab