80.2K

Verified Solution

Link Copied!

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

See Answer