Help with Accounting Homework due soon.

I have accounting homework due soon by Monday which is based on FIFO and LIFO. Please show all work on the excel file so I can check my sheet to see if I did it right. I unfortunately don't have much funds right now.