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

Free

60.1K

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.

GIVE ANSWERS FOR TABLES BELOW- THE BOXES FILLED OUT ARE THE ONLYONES THAT NEED NUMBERS

Specific Identification
Available for SaleCost of Goods SoldEnding Inventory
Purchase DateActivityUnitsUnit CostUnits SoldUnit CostCOGSEnding Inventory- UnitsCost Per UnitEnding Inventory- Cost
Jan. 1Beginning inventory175$1750.000175$1,750.00$306,250
Jan. 20Purchase130$1170.00125$1170.00$146,2505$1,170.00$5,850
Jan. 30Purchase250$2125.00250$2125.00$531,250250$2,125.00$531,250
555375$677,500430

$843,350

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.0040@$10.00=$400.00
January 20130@$9.0040@$10.00=$400.00
130@$9.00=1,170.00
Average cost170@$9.24$1,570.00
January 25140@$9.24=$1,293.6030@$9.24=$277.20
January 30250@$8.5030@$9.24=$277.20
250@$8.50=2,125.00
Totals$2,643.60280@$8.58$2,402.20

Answer & Explanation Solved by verified expert
3.8 Ratings (765 Votes)

STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC SPECIFIC IDENTIFICATION METHOD
RECIEPTS COST OF GOODS SOLD BALANCE
DATE Activity Units Unit cost UNITS RATE AMOUNT $ UNITS RATE AMOUNT $
1-Jan Beg. Inv. 175 10 150 10 1500 25 10 250
20-Jan Purchases 130 9 125 9 1125 5 9 45
30-Jan Purchasses 250 8.5 250 8.5 2125
TOTAL 4800 555 275 2625 280 2420
STATEMENT SHOWING INVENTORY RECORD UNDER PERPETUAL WEIGHTED AVERAGE METHOD
RECIEPTS COST OF GOODS SOLD BALANCE
DATE UNITS RATE AMOUNT $ UNITS RATE AMOUNT $ UNITS RATE AMOUNT $
1-Jan 175 10 1750
10-Jan 135 10 1350 40 10 400
20-Jan 130 9 1170 40 10 400
130 9 1170
AVERAGE 170 9.24 1570
25-Jan 140 9.24 1294 30 9.24 276
30-Jan 250 8.5 2125 30 9.24 276
250 8.5 2125
AVERAGE 280 8.575 2401
TOTAL 380 3295 275 2644 280 8.575 2401

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