Westcoast Purveyors had 316 computer system in stock at the end of the year. Inventory records show the following information: Date Qty Cost Total Cost January 1 Beginning Inventory 50 $1,468 $73,400 June 21 Purchase 50 1,192 59,600 August 1 Purchase 300 884 265,200 October 23 Purchase 200 1,216 243,200 November 16 Purchase 100 1,424 142,400 Total available for sale 700 $775,800 Using the LIFO method of inventory pricing, calculate the dollar value of the ending inventory.
Westcoast Purveyors had 316 computer system in stock at the end of the year. Inventory records show the following information: Date Qty Cost Total Cost January 1 Beginning Inventory 50 $1,468 $73,400 June 21 Purchase 50 1,192 59,600 August 1 Purchase 300 884 265,200 October 23 Purchase 200 1,216 243,200 November 16 Purchase 100 1,424 142,400 Total available for sale 700 $775,800 Using the LIFO method of inventory pricing, calculate the dollar value of the ending inventory.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question
Westcoast Purveyors had 316 computer system in stock at the end of the year. Inventory records show the following information:
Date | Qty | Cost | Total Cost | |
---|---|---|---|---|
January 1 | Beginning Inventory | 50 | $1,468 | $73,400 |
June 21 | Purchase | 50 | 1,192 | 59,600 |
August 1 | Purchase | 300 | 884 | 265,200 |
October 23 | Purchase | 200 | 1,216 | 243,200 |
November 16 | Purchase | 100 | 1,424 | 142,400 |
Total available for sale | 700 | $775,800 |
Using the LIFO method of inventory pricing, calculate the dollar value of the ending inventory.
Step 1
The last-in, first-out (LIFO) method assumes that the items purchased last are sold or removed from inventory first. The items in inventory at the end of the year are matched with the cost of items of the same type that were purchased earliest. Therefore, items included in the ending inventory are considered to be those from the beginning inventory plus those acquired first from purchases. This method involves taking physical inventory at the end of the year or accounting period and assigning cost in the same order in which the purchases were received. The annual inventory is given below.
Date | Qty | Cost | Total Cost | |
---|---|---|---|---|
January 1 | Beginning Inventory | 50 | $1,468 | $73,400 |
June 21 | Purchase | 50 | 1,192 | 59,600 |
August 1 | Purchase | 300 | 884 | 265,200 |
October 23 | Purchase | 200 | 1,216 | 243,200 |
November 16 | Purchase | 100 | 1,424 | 142,400 |
Total available for sale | 700 | $775,800 |
There are 316 computer systems in stock at the end of the year. There were 50 systems on January 1, and 50 more systems acquired on June 21 for a total of
50 + 50 = 100
systems. This is less than the 316 computer systems in the inventory at the end of the year. We are concerned about
316 − 100 = computer systems
that have not yet been accounted for, so we will consider the acquisition on August 1.There were 300 computer systems acquired on August 1. This is the number of computer systems that have not yet been accounted for. Therefore, the ending inventory of 316 computer systems is made up of all the computer systems acquired in January and June, and that were acquired on August 1.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education