The Hospital for Ordinary Surgery uses pharmaceuticals for its patients. It started the year on January 1, with an inventory of 1,000 doses of an antibiotic drug that cost $17 per dose. On January 2, it purchased another 300 does for $21 each. From January 3 through June 30 it used 800 doses. On July 1, it bought 500 more doses at $23 each. From July 2 through the end of the year it used 400 doses. What is the inventory value at the end of the year, assuming FIFO? What is the value assuming LIFO? Clearly label the calculations of the inventory amounts using Excel. Use formulas to calculate the FIFO and LIFO inventories and format the cells to insert a comma if there is more than three numbers and round to the nearest whole number. Explain the advantages and disadvantages of FIFO and LIFO inventory methods and your analysis of which method is best for this scenario in a Word document not to exceed two pages. Submit both your Excel sheet and your two page Word document.

Please see the attached announcement. We won't do your homework for you, but will help you with explanations, definitions, and concepts.

https://www.askmehelpdesk.com/finance-accounting/announcement-font-color-ff0000-u-b-read-first-expectations-homework-help-board-b-u-font.html

I think this link might help you understand this question. If you'll read through this and then try to do the homework, we can check it for you and help you where needed. Thanks.

https://www.askmehelpdesk.com/finance-accounting/how-calculate-using-fifo-lifo-524811.html

Beg Balance: 1000 x 17 = 17000
Purchases: 300 x 21 = 6300
Balance: = 23300
Used 1: 800 x 17 = 13600
Balance: (200 x 17)+ (300 x 21) = 9700
Purchases: 500 x 23 = 11500
Balance: (200 x 17)+(300 x 21)+(500 x 23)= 21200
Used 2: (200 x 17)+ (200 x 21) 7600
Balance : (100 x 21)+ (500 x 23) 13600 ---- Ending Balance