question has been opened in a new tab. In order to continue your assignment, please save your Excel question. A company provides the following inventory records. Number of unite nold = 8+5000 Selisng prict per unit = $30.00 Required: 1. Based on the information given above, calculate cost of goods sold and ending inventory using the FiFO method. 2. Calculate cost of goods sold and ending inventory using the UIFO method. 3. Calculate cost of goods sold and ending inventory using the Weighted Average Method. 4. Calculate gross profit under all three methods. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. A company provides the following inventory records: Required: 1. Baied on the informution guen above, calculare cost of goods sold and ending inventory uing the fifo method: 2. Calculate cost of goods sold and endine imentory uting the tifo methed. 3. Calculate cost of roods sold and ending imventory using the Weighted Awerage Method 4. Calculate gross profit under all three methods: Requirement 1: Cost of Goods Sold and Ending Inventory under FiFo (Use cells A2 to E12 from the given information above to complete this question. To calculate the number of units sold within each batch, use the MiN function.) Requirement 2: Cost of Goods Sold and Ending inventory under UFO (Use cells A2 to E12 from the given information above to complete this question. To calculate the number of units sold within each batch, use the MIN function.) Requirement 3: Cost of Goods Sold and Ending Inventory under Weighted Average Requirement 3: Cost of Goods Sold and Ending Inventory under Weighted Average (a) Calculate the weighted-average unit cost. (Use cells A2 to E12 from the given information above to complete this question.) Weighted-average unit cost = (b) Calculate cost of goods sold and ending inventory using the weighted-average method. (Use cells A2 to E12 from the given information above to complete this question. In your formula, use cell 844 for the weighted-average unit cost.) Requirement 4: Gross Profit (Use cells A2 to E12 from the given information above to complete this question. All values should be input and displayed as positive amounts.) Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work Nothing in this area will be groded, but it will be submitted with your assignment