kindly solve this question on Excel as soon as possible. i'll give u thumbs up. Urgent help required

Q.2 Piano, a blue point pencil making Company, which uses a periodic inventory system, had a beginning inventory on May 1, of 400 units of Product A at a cost of $7 per unit. During May, the following purchases and sales were made. Purchases Sales May 6375 units at $9 May 4275 units 14 250 units at $108 300 units 21 300 units at $1122 400 units 28 425 units at $1324 225 units Total 1,350 units Total 1,200 units Required: Compute the May 31 ending inventory and May cost of goods sold under (a) Average Cost, and (b) FIFO