Please Help me with this assignment. If possible please write all the entries in excel.

You applied for a vacant accounting position in a multi national merchandising company. Included, as part of the job interview routine. Calculate Cost of Sales - Periodic Inventory System SOLUTION - Cost of sales From the below accounts balances, prepare the cost of sales. Transportation in S 853 Purchase allowance returns S 4,653 Sales commission S 3.114 Purchases S 81.269 Transportation out S 3.894 Purchases discount S 4.117 Ending inventory S 10,723 Goods in transit, with company shippers* S 1.855 Beginning inventory S 10.116 Transit insurance for purchases, FOB shipping point S 877 not included in ending inventory figure above