Just please try to give the answer in excel format

Assume the following data for ABC Company Sales for November 2023 : On November 30 , a physical count reveals 15 units on hand. 2) Refer to Table 1. Calculate ending inventory for ABC Company Sales assuming the perpetual moving-weighted-average-cost method is being used. 3) Refer to Table 1. Calculate gross margin for ABC Company Sales assuming the perpetual moving-weighted-average-cost method is being used. 4) Refer to Table 1. Calculate ending inventory for ABC Company Sales assuming the perpetual FIFO cost method is being used. 5) Refer to Table 1. Calculate gross margin for ABC Company Sales assuming the perpetual FIFO cost method is being used