Complete the Perpetual Inventory card worksheets to reflect the June purchases and sales under the...

90.2K

Verified Solution

Question

Accounting

Complete the Perpetual Inventory card worksheets to reflect the June purchases and sales under the 3 different Inventory costing methods. You need to include totals for Purchases and Cost of Goods Sold Quantity and Total Cost and must show Ending Inventory total units and total cost. For the weighted average computations, round unit cost to the nearest penny and total cost to the nearest dollar.

Inventory Information
Inventory on hand at the beginning of June:
Units Cost / unit Total Cost
Purchase # 1 12 35 $420
Purchase # 2 14 40 560
26 $980
June 2019 transactions related to buying and selling gidgit inventory
1-Jun Sold 16 gidgits at $98 each on credit
6-Jun Purchased 25 gidgits at a cost of $45 per gidgit on credit
15-Jun Sold 27 gidgits at $105 each on credit
20-Jun Purchased 30 gidgits at a cost of $50 per gidgit on credit
24-Jun Sold 25 gidgits at $108 each on credit
The PHYSICAL count of gidgit inventory on hand at June 30, 2019 shows 10 gidgits at a LIFO cost of $980.
Beginning Inventory Units Cost / unit Cost
12 35 420
14 40 560
26 980
LIFO
Purchases Cost of Goods Sold Inventory on Hand
Unit Total Unit Total Unit Total
Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost
FIFO
Purchases Cost of Goods Sold Inventory on Hand
Unit Total Unit Total Unit Total
Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost
Weighted Avg
Purchases Cost of Goods Sold Inventory on Hand
Unit Total Unit Total Unit Total
Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost
KTZFIG Consulting & Sales and Sales Inc
PARTIALLY ADJUSTED TRIAL BALANCE
June 30 2019 Adjusting
Part Adj T/B June JEs Trial Balance & Bank Rec JEs Adusted TB
DR CR DR CR DR CR DR CR DR CR
Cash $241,768
Accounts Receivable 146,800
Allowance for Uncollectible Accounts $1,980
Supplies 64,789
Inventory 980
Prepaid Insurance 16,800
Land 61,400
Building 125,500
Accumulated Depr Building 5,670
Computer equipment 54,687
Accumulated Depr Comp Equip 1,750
Office Furniture 96,780
Accumulated Depr - Office Furniture 890
Accounts Payable 48,526
Interest Payable 3,200
Utilities Payable 8,952
Wages Payable 78,400
Long term Note Payable 90,000
Mortgage Payable 60,000
Common Stock 400,000
Retained Earnings 106,468
Dividends 6,000
Service Revenue 345,650
Tablet Sales Revenue 211,538
Cost of Goods Sold 154,760
Bad Debt Expense
Depreciation Expense Building 1,350
Depreciation Expense - Computer Equip 890
Depreciation Expense - Office Furn 650
Interest Expense 3560
Insurance Expense 38,950
Supplies expense 72,860
Bank fee (expense)
Utilities Expense 75,900
Wage Expense 198,600
Subtotals
Net Income
TOTALS $1,363,024 $1,363,024

Answer & Explanation Solved by verified expert
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