I need this exercise for each method FIFO,LIFO and weighted average in differents tables.

and the last required in another different table.

Problem 2 A company made the following merchandise purchases and sales during the month of July purchased 380 purchased 270 sold 500 purchased 300 sold 250 purchased 250 $15 each $20 each $55each $24each $55each $30 each units at July 1 July 5 July 9 July 14 July 20 July 30 units at units at units at units at units at Additional information: a. Administrative expenses were $10.200 for the month of July. b. The income tax rate for the company is 3000. c. There was no beginning inventory