I cant complete balance Sheet and Cost of Goods manufactured Schedule. please help!

Tools Data Excel File Edit View insert Format Autover Besu. ome Insert Draw Page Layout Formulas no Calibri (Bodyl 2 -A A Window Help Group Project View Data Review Conditional Formatting 22 x fx 92000 Credit Pacific Coast Paracord Leash Co. Unadjusted Trial Balance June and July, 2019 Account Debit Credit Assets: 5 Cash 8,050 Accounts Receivable 4,500 Inventory 6,000 Land 10,000 O Supplies 900 1 Equipment 4,550 2 Prepaid Insurance 2,000 3 Delivery Equipment 1,000 4 Prepaid Advertising 8,000 5 Accum. Dep. - Equip. 6,550 6 Accum. Dep. - Del. Equip. 3,500 7 Red Rope Inventory 2,000 8 Blue Rope Inventory 2,000 9 Yellow Rope Inventory 2,000 O Finished Goods 4,900 1 Work in Process 12,950 2 Factory Overhead 11,800 3 F G H Pacific Coast Paracord Leash Co. Adjusted Trial Balance June and July, 2019 Account Debit Cash 8,050 Accounts Receivable 4,500 Inventory 6,000 Land 10,000 Supplies 900 Equipment 4,550 Prepaid Insurance 2,000 Delivery Equipment 1,000 Prepaid Advertising 8,000 Accum. Dep. - Equip Accum. Dep. - Del. Equip Red Rope Inventory 2,000 Blue Rope Inventory 2,000 Yellow Inventory 2,000 Finished Goods Work in process 12,950 Factory Overhead 11,800 Accounts Payable Wares Pavable 6.550 3.500 4,900 16,050 26.000 esc B IU . A 7W 4 5 5 6 Excel Window Help Et View Insert Format Tools Date AGE . so 22 92000 350 16 050 26,000 20.000 16.000 3.000 5.500 20.000 16,000 20,100 3,000 5.500 Unearned Rent Common Stock Retained Earnings Dividends Stock Dividends Fees Earned Sales Wages Expense Depreciation Expense - Eq. Depreciation - Del. Eg Utsties Expense Equip Repair Expense Mise Expense Supplies Expense Rent wense Cost of Goods Sold 10,400 950 4,000 4 Accounts Payable 5 Wages Payable 5 Unearned Rent Stockholder's Equity Common Stock Retained Earnings O Dividends 1 Stock Dividends 2 Revenue i rom Earned A sales 5 Expenses 5 Wages Expense 7 Depreciation Expense- Depreciation Exp. - Del U s Expense t o Repair pense 1 Misc Expense 2 Supplies Expense Rent Expense 4 Cost of Goods Sold 20,100 2.000 10.400 550 1,200 4.000 2.000 500 500 55 2.700 1,200 113,100 113, 100 7,700 113,100 113,100 Tools Data Excel File Edit View insert Format Autover Besu. ome Insert Draw Page Layout Formulas no Calibri (Bodyl 2 -A A Window Help Group Project View Data Review Conditional Formatting 22 x fx 92000 Credit Pacific Coast Paracord Leash Co. Unadjusted Trial Balance June and July, 2019 Account Debit Credit Assets: 5 Cash 8,050 Accounts Receivable 4,500 Inventory 6,000 Land 10,000 O Supplies 900 1 Equipment 4,550 2 Prepaid Insurance 2,000 3 Delivery Equipment 1,000 4 Prepaid Advertising 8,000 5 Accum. Dep. - Equip. 6,550 6 Accum. Dep. - Del. Equip. 3,500 7 Red Rope Inventory 2,000 8 Blue Rope Inventory 2,000 9 Yellow Rope Inventory 2,000 O Finished Goods 4,900 1 Work in Process 12,950 2 Factory Overhead 11,800 3 F G H Pacific Coast Paracord Leash Co. Adjusted Trial Balance June and July, 2019 Account Debit Cash 8,050 Accounts Receivable 4,500 Inventory 6,000 Land 10,000 Supplies 900 Equipment 4,550 Prepaid Insurance 2,000 Delivery Equipment 1,000 Prepaid Advertising 8,000 Accum. Dep. - Equip Accum. Dep. - Del. Equip Red Rope Inventory 2,000 Blue Rope Inventory 2,000 Yellow Inventory 2,000 Finished Goods Work in process 12,950 Factory Overhead 11,800 Accounts Payable Wares Pavable 6.550 3.500 4,900 16,050 26.000 esc B IU . A 7W 4 5 5 6 Excel Window Help Et View Insert Format Tools Date AGE . so 22 92000 350 16 050 26,000 20.000 16.000 3.000 5.500 20.000 16,000 20,100 3,000 5.500 Unearned Rent Common Stock Retained Earnings Dividends Stock Dividends Fees Earned Sales Wages Expense Depreciation Expense - Eq. Depreciation - Del. Eg Utsties Expense Equip Repair Expense Mise Expense Supplies Expense Rent wense Cost of Goods Sold 10,400 950 4,000 4 Accounts Payable 5 Wages Payable 5 Unearned Rent Stockholder's Equity Common Stock Retained Earnings O Dividends 1 Stock Dividends 2 Revenue i rom Earned A sales 5 Expenses 5 Wages Expense 7 Depreciation Expense- Depreciation Exp. - Del U s Expense t o Repair pense 1 Misc Expense 2 Supplies Expense Rent Expense 4 Cost of Goods Sold 20,100 2.000 10.400 550 1,200 4.000 2.000 500 500 55 2.700 1,200 113,100 113, 100 7,700 113,100 113,100