Purchase Solution

Accounting: Inventory valuation with LIFO and FIFO.

Not what you're looking for?

Ask Custom Question

FIFO and LIF0

Analyze the following scenario: 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.

Purchase this Solution

Solution Summary

The problem deals with determining the cost of ending inventory under both LIFO and FIFO rules.

Solution provided by:
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution


Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Operations Management

This quiz tests a student's knowledge about Operations Management

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.