Purchase Solution

Inventory calculations

Not what you're looking for?

Ask Custom Question

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