Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at...

Free

70.2K

Verified Solution

Question

Accounting

Laker Company reported the following January purchases and salesdata for its only product.

DateActivitiesUnits Acquired at CostUnits sold at Retail
Jan.1Beginning inventory175units@$10.00=$1,750
Jan.10Sales135units@$19.00
Jan.20Purchase130units@$9.00=1,170
Jan.25Sales140units@$19.00
Jan.30Purchase250units@$8.50=2,125
Totals555units$5,045275units


The Company uses a perpetual inventory system. For specificidentification, ending inventory consists of 280 units, where 250are from the January 30 purchase, 5 are from the January 20purchase, and 25 are from beginning inventory.

Required:
1. Complete the table to determine the costassigned to ending inventory and cost of goods sold using specificidentification.
2. Determine the cost assigned to ending inventoryand to cost of goods sold using weighted average.
3. Determine the cost assigned to ending inventoryand to cost of goods sold using FIFO.
4. Determine the cost assigned to ending inventoryand to cost of goods sold using LIFO.

Weighted Average - Perpetual:
Goods PurchasedCost of Goods SoldInventory Balance
Date# of unitsCost per unit# of units soldCost per unitCost of Goods Sold# of unitsCost per unitInventory Balance
January 1175@$10.00=$1,750.00
January 10135@$10.00=$1,350.00
January 20130@$9.00@
130@$9.00=1,170.00
Average cost130@$1,170.00
January 25
January 30
Totals$1,350.00

Answer & Explanation Solved by verified expert
3.6 Ratings (521 Votes)

Solution 1:

Computation of ending inventory COGS under Specific Identification
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Jan 175 $10.00 $1,750 0 $0.00 $0.00 0 $0.00 $0.00 175 $10.00 $1,750.00
10-Jan 175 $10.00 $1,750 0 $0.00 $0.00 135 $10.00 $1,350.00 40 $10.00 $400.00
20-Jan 40 $10.00 $400.00 130 $9.00 $1,170.00 0 $0.00 $0.00 40 $10.00 $400.00
130 $9.00 $1,170.00
25-Jan 40 $10.00 $400.00 0 $0.00 $0.00 15 $10.00 $150.00 25 $10.00 $250.00
130 $9.00 $1,170.00 125 $9.00 $1,125.00 5 $9.00 $45.00
30-Jan 25 $10.00 $250.00 250 $8.50 $2,125.00 0 $0.00 $0.00 25 $10.00 $250.00
5 $9.00 $45.00 5 $9.00 $45.00
250 $8.50 $2,125.00
Total 275 $2,625.00 280 $2,420.00

Solution 2:

Computation of ending inventory COGS under Weighted Average Cost
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Jan 175 $10.00 $1,750 0 $0.00 $0 0 $0.00 $0 175 $10.00 $1,750
10-Jan 175 $10.00 $1,750 0 $0.00 $0 135 $10.00 $1,350 40 $10.00 $400
20-Jan 40 $10.00 $400 130 $9.00 $1,170 0 $0.00 $0 170 $9.24 $1,570
25-Jan 170 $9.24 $1,570 0 $0.00 $0 140 $9.24 $1,293 30 $9.24 $277
30-Jan 30 $9.24 $277 250 $8.50 $2,125 0 $0.00 $0 280 $8.58 $2,402
Total 275 $2,643 280 $2,402

Solution 3:

Computation of ending inventory COGS under FIFO
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Jan 175 $10.00 $1,750.00 0 $0.00 $0.00 0 $0.00 $0.00 175 $10.00 $1,750.00
10-Jan 175 $10.00 $1,750.00 0 $0.00 $0.00 135 $10.00 $1,350.00 40 $10.00 $400.00
20-Jan 40 $10.00 $400.00 130 $9.00 $1,170.00 0 $0.00 $0.00 40 $10.00 $400.00
130 $9.00 $1,170.00
25-Jan 40 $10.00 $400.00 0 $0.00 $0.00 40 $10.00 $400.00 30 $9.00 $270.00
130 $9.00 $1,170.00 100 $9.00 $900.00
30-Jan 30 $9.00 $270.00 250 $8.50 $2,125.00 0 $0.00 $0.00 30 $9.00 $270.00
250 $8.50 $2,125.00
Total 275 $2,650.00 280 $2,395.00

Solution 4:

Computation of ending inventory COGS under LIFO
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Jan 175 $10.00 $1,750.00 0 $0.00 $0.00 0 $0.00 $0.00 175 $10.00 $1,750.00
10-Jan 175 $10.00 $1,750.00 0 $0.00 $0.00 135 $10.00 $1,350.00 40 $10.00 $400.00
20-Jan 40 $10.00 $400.00 130 $9.00 $1,170.00 0 $0.00 $0.00 40 $10.00 $400.00
130 $9.00 $1,170.00
25-Jan 40 $10.00 $400.00 0 $0.00 $0.00 130 $9.00 $1,170.00 30 $10.00 $300.00
130 $9.00 $1,170.00 10 $10.00 $100.00
30-Jan 30 $10.00 $300.00 250 $8.50 $2,125.00 0 $0.00 $0.00 30 $10.00 $300.00
250 $8.50 $2,125.00
Total 275 $2,620.00 280 $2,425.00

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students