Prepare Inventory valuation tables using FIFO and LIFO method. Also calculate the ending inventory and profit in both the methods at the end.

a) 1000 units @$40 each were in stock as on August 1, 2022

b) On August 3, 2022, purchased 500 units @ $50 each from Deeman Corp.

c) On August 10, Sold 800 units @ 60 each to Ceridian Corp

d) On August 15, sold 200 units @ 80 each to Tiny Incorporation

e) On August 25 purchased 800 units @ 70 each from Deeman Corp.

f) On August 31, sold 90 units @ $100 to Penthouse International.