The Artisan Wines is a retail store selling vintage wines. On December 31, 2019,
ID: 2399140 • Letter: T
Question
The Artisan Wines is a retail store selling vintage wines. On December 31, 2019, the firm’s general ledger contained the accounts and balances below. All account balances are normal.
Required:
Prepare a classified income statement for the year ended December 31, 2019. The company does not classify its operating expenses as selling expenses and general and administrative expenses.
Prepare a statement of owner’s equity for the year ended December 31, 2019. No additional investments were made during the year.
Prepare a classified balance sheet as of December 31, 2019.
Analyze:
What is the inventory turnover for Artisan Wines?
Explanation / Answer
Answers
Operating Revenue
Sales
$ 148,970.00
Less: Sales Discounts
$ 150.00
Net Sales
$ 148,820.00
Cost of Goods Sold
Merchandise Inventory Jan 1, 2019
$ 14,500.00
Purchases
$ 88,500.00
Freight In
$ 175.00
Delivered cost of purchases
$ 88,675.00
Purchase Returns & Allowances
$ (950.00)
Net delivered cost of purchases
$ 87,725.00
Goods available for sale
$ 102,225.00
Less: Merchandise Inventory Dec 31, 2019
$ 11,500.00
Cost of Goods Sold
$ 90,725.00
Gross Profit on Sales
$ 58,095.00
Operating Expenses
Wages Expenses
$ 24,000.00
Supplies expenses
$ 175.00
Depreciation expenses - Store Equipment
$ 3,000.00
Rent Expenses
$ 12,700.00
Advertising expense
$ 460.00
Payroll Taxes expenses
$ 2,862.25
Depreciation expenses - Office Equipment
$ 950.00
Total Operating Expenses
$ 44,147.25
Income from Operations
$ 13,947.75
Other Income
Seminar Fees Income
$ 3,000.00
Other Expense
Interest Expense
$ (187.50)
Net Non operating expenses
$ 2,812.50
Net Income for the year
$ 16,760.25
Beginning Balance - Vincent Capital
$ 34,950.00
Add: Net Income
$ 16,760.25
Less: Drawings
$ 13,610.00
Increase in capital balance
$ 3,150.25
ENding Balance - Vincent Capital
$ 38,100.25
ASSETS
Current Assets:
Cash
$ 27,886.00
Accounts receivables
$ 450.00
Prepaid Advertising
$ 920.00
Supplies
$ 75.00
Merchandise Inventory
$ 11,500.00
Total Current Assets
$ 40,831.00
Plant & Equipment:
Store Equipment
$ 22,500.00
Accumulated Depreciation - Store Equipment
$ (5,500.00)
$ 17,000.00
Office Equipmentr
$ 4,500.00
Accumulated Depreciation - Office Equipment
$ (2,400.00)
$ 2,100.00
Total Plant & Equipment
$ 19,100.00
Total ASSETS
$ 59,931.00
LIABILITIES & OWNER'S EQUITY
Current Liabilities:
Notes Payable due 2020
$ 17,500.00
Accounts Payable
$ 2,205.00
Wages Payable
$ 500.00
Social Security Tax Payable
$ 31.00
Medicare Tax Payable
$ 7.25
Unearned Seminar Fees
$ 1,500.00
Interest Payable
$ 87.50
Total Current Liabilities
$ 21,830.75
Owner's Equity:
Ending Balance - Capital
$ 38,100.25
Total LIABILITIES & OWNER'S EQUITY
$ 59,931.00
A [See Income Statement]
Cost of Goods Sold
$ 90,725.00
B [See Income Statement]
Beginning Inventory
$ 14,500.00
C [See Income Statement]
Ending Inventory
$ 11,500.00
D = B+C
Total of inventory
$ 26,000.00
E=D/2
Average Inventory
$ 13,000.00
F = A / E
Inventory Turnover ratio
6.98 times
Operating Revenue
Sales
$ 148,970.00
Less: Sales Discounts
$ 150.00
Net Sales
$ 148,820.00
Cost of Goods Sold
Merchandise Inventory Jan 1, 2019
$ 14,500.00
Purchases
$ 88,500.00
Freight In
$ 175.00
Delivered cost of purchases
$ 88,675.00
Purchase Returns & Allowances
$ (950.00)
Net delivered cost of purchases
$ 87,725.00
Goods available for sale
$ 102,225.00
Less: Merchandise Inventory Dec 31, 2019
$ 11,500.00
Cost of Goods Sold
$ 90,725.00
Gross Profit on Sales
$ 58,095.00
Operating Expenses
Wages Expenses
$ 24,000.00
Supplies expenses
$ 175.00
Depreciation expenses - Store Equipment
$ 3,000.00
Rent Expenses
$ 12,700.00
Advertising expense
$ 460.00
Payroll Taxes expenses
$ 2,862.25
Depreciation expenses - Office Equipment
$ 950.00
Total Operating Expenses
$ 44,147.25
Income from Operations
$ 13,947.75
Other Income
Seminar Fees Income
$ 3,000.00
Other Expense
Interest Expense
$ (187.50)
Net Non operating expenses
$ 2,812.50
Net Income for the year
$ 16,760.25
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.