Assur uevegn Lo. uses a perpetual inventory system. It began operations on July 1. Assume that the Company uses the Average Cost method. Here is an optional Excel spreadsheet AvE.Cost_ACCT215,PT Studies. Final. Exam, F2022 wisk that can be used to prepare your calculations. Your instructor will not review the spreadsheet. REQUIRED: Please answer the following questions related to the information provided for the month's transactions. Round your final answers to the nearest dollar. What is the Cost of Goods Sold for the month using the Average Cost method? (1 mark) What is the ending inventory amount that would appear on the Company's Statement of Financial Position (Balance Sheet) using the Welghted Average mothod? (1 mark) What is the ending inventory amount that would appear on the Company's Statement of Financial Position (Balance Sheet) using the Weighted Average method? (1 mark) What is the journal entry that the Company would prepare on July 28 using the Weighted Average method? Assume this was a cash transaction. (1 mark) Dr. Cr. A) $ A) $ A) What is the inventory value as at July 10 using the Weighted Average method? (1) mark) Inventory =$