Inventory calculations
Not what you're looking for?
You have the following information for Benton Inc. for the month ended October 31, 2007. Benton uses a periodic method for inventory.
Date Description Units Unit Cost or Selling Price
Oct 1 Beginning Inventory 60 $25
Oct 9 Purchase 120 27
Oct 11 Sale 100 35
Oct 17 Purchase 90 28
Oct 22 Sale 60 40
Oct 25 Purchase 80 29
Oct 29 Sale 120 40
Instructions
(a) Calculate (i) ending inventory, (ii) costs of goods sold, (iii)gross profit, and (iv) gross profit rate under each of the following methods.
(1) LIFO
(2) FIFO
(3) Average cost. (Round cost per unit to three decimal places.)
(b) Compare results for the three cost flow assumpitions.
Purchase this Solution
Solution Summary
The solution explains how to calculate ending inventory, CGS, gross profit using LIFO, FIFO, Average cost methods
Solution Preview
(a) Total cost of goods available for sale are 60 X 25 + 120 X 27 + 90 X 28 + 80 X 29 = $9,580
Total units available for sale = 60+120+90+80 = 350
Units sold = 100+60+120 = 280
Units in ending inventory = 350-280 = 70
Total sales = 100 X 35 + 60X40 + 120 X 40 = $10,700
(1) LIFO - In LIFO the latest units are assumed to be sold first. The ending inventory will consist of the earliest units. The ending ...
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
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.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce