I need help with the adjusting journal entry for this problem. Please help!!

b) Complete the accounting worksheet using Columns F and G to record cost of goods sold and adjust inventory.

A physical count of inventory taken at 12/31/2112 was $8,000.

Earthshine, Inc. Accounting Worksheet As of December 31, 2012 Unadjusted Balance Dr Cr 25,000 125,000 75,000 5,000 3,500 18,000 17,500 3,500 175,000 17,500 25,000 7,000 Account Description Cash Short-Term Investments Accounts Receivable Allowance for Doubtful Accounts Prepaid Insurance Inventory Equipment Equipment - AVD Building Building - A/D Land Note Receivable Accounts Payable Salaries and Wages Payable Payroll Tax Payable Property Tax Payable Uneamed Revenue Loan Payable Mortgage Payable Deferred Tax Liability Common Stock Additional Paid-In Capital Retained Eamings Dividends Sales Revenue Sales Discounts Sales Retums and Allowances Miscellaneous Income Purchases Purchases Discounts Purchases Returns and Allovances Freight-in Cost of goods sold Salaries and Wages Expense Payroll Tax Expense Rent Expense Insurance Expense Freight-Out Property Tax Expense Office Supplies Expense Maintenance and Repairs Expense Bad Debt Expense 32,000 12,000 1,200 3,500 5,000 8,000 135,000 6,000 10,000 40,000 85,000 20,000 1,525,000 10,000 7,000 3,500 613,000 7,000 2,000 19,500 591,185 45,800 24,000 9,000 6,750 3,500 2,750 3,750 23,750 Depreciation Expense Interest Expense Miscellaneous Expense Income Tax Expense Totals 7,500 4,050 1,750 36,915 1,901,200 1,901,200