Jan. 1 Beginning inventory Jan. 11: Sales Jan. 15:Purchase Jan. 17:Sales Jan. 21: Purchase Jan. 23: Sales Totals Cost of Goods Sold - Perpetual LIFO: 560: 840 890: Ending Inventory- Perpetual LIFO: 2,290; Calculate cost of goods sold for the January 11 sale of 450 units Calculate cost of goods sold for the January 17 sale of 670 units. $14 17 19 Units Sold 450 Total Cost of Goods Sold for January - 1,920 units Units in Ending Inventory Total Ending Inventory for January - 370 units $7,840 14,280 16.910 $39,030 @ units @ units @ units @ @ 450 670 800 1,920 Cost per unit $14 $14; Cost per unit $40 $40 $40: per unit = units@ units $18,000 26,800 32,000 $76,800 Cost of Goods Sold $6,300 Inventory Balance

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each
yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO.
Date
Jan. 1 Beginning inventory
Jan. 11: Sales
Jan. 15 Purchase
Jan. 17: Sales
Jan, 21:Purchase
Jan. 23: Sales
Totals
Units
purchased
Cost of Goods Sold - Perpetual LIFO:
560
840
890:
Ending Inventory-Perpetual LIFO:
2,290
Calculate cost of goods sold for the January
11 sale of 450 units.
Calculate cost of goods sold for the January
17 sale of 670 units.
Cost per
unit
$14
17
19
Units Sold
450
Total Cost of Goods Sold for January - 1,920 units
Units in
Ending
Inventory
Total Cost Units Sold Selling Price Total Sales
of Purchase
per unit
Total Ending Inventory for January - 370 units
$7,840
14,280
16,910
$39,030
units @
units
units@
450
670
800
1,920
Cost per
unit
$14
$14
Cost per
unit
$40:
$40
$40
per unit=
units @
units
$18,000
26,800
32,000
$76,800
Cost of
Goods Sold
$6,300
Inventory
Balance
Transcribed Image Text:REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Date Jan. 1 Beginning inventory Jan. 11: Sales Jan. 15 Purchase Jan. 17: Sales Jan, 21:Purchase Jan. 23: Sales Totals Units purchased Cost of Goods Sold - Perpetual LIFO: 560 840 890: Ending Inventory-Perpetual LIFO: 2,290 Calculate cost of goods sold for the January 11 sale of 450 units. Calculate cost of goods sold for the January 17 sale of 670 units. Cost per unit $14 17 19 Units Sold 450 Total Cost of Goods Sold for January - 1,920 units Units in Ending Inventory Total Cost Units Sold Selling Price Total Sales of Purchase per unit Total Ending Inventory for January - 370 units $7,840 14,280 16,910 $39,030 units @ units units@ 450 670 800 1,920 Cost per unit $14 $14 Cost per unit $40: $40 $40 per unit= units @ units $18,000 26,800 32,000 $76,800 Cost of Goods Sold $6,300 Inventory Balance
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
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.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education