help please

Excel File Edit View Insert Format Tools Data Window Help $ $ 100% [7 Sat 3:41 PM Q AutoSave . OFF YOU MUST RENAME AND UPLOAD THIS FILE - 1P91 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 AA 9 Wrap Text v General Insert v Ex Delete AY - O. Paste BIUV A Merge & Center v v % " Conditional Format Cell Sort & Find & Ideas Sensitivity Formatting as Table Styles Format Filter Select H34 X V fx tax payable D E F G H K M N Account Debit Credit The following data are available to determine adjusting entries: Cash 1,160.00 Accounts Receivable 2,320.00 1,218.00 of depreciation estimated during the period. Office Supplies 2,030.00 338.00 of supplies used up during the period. Prepaid Insurance 1,450.00 363.00 of salaries were earned by employees on September 30, but not yet paid nor recorded. Inventories 3,480.00 One-third of the revenue received in advance has been earned by September 30, 2020 Property, Plant and Equipment 12,180.00 Accumulated Depreciation 2,900.00 7 m The prepaid insurance balance relates to 6-month policy beginning on July 1, 2020. Income taxes for the year are calculated as 25 percent of accounting income before tax. Accounts Payable 2,030.00 Unearned Services Revenue 2,320.00 Required: Notes Payable, due in 2022 4,350.00 [15 Marks] Prepare the adjusting entries that are required at September 30, 2020. Round your answer to the nearest dollar. Contributed Capital 7,250.00 Retained Earnings 2,030.00 No Transaction General Journal Debit Credit Dividends Declared 580.00 A Depreciation expense 1,218.00 Services Revenue 7,250.00 Accumualted Depreciation 1,218.00 Other income 870.00 Operating Expense 2,900.00 2 B Supplies expense 338.00 Salaries Expenses 1,450.00 Supplies 338.00 Insurance expense 870.00 Utilities expense 580.00 3 C wages expense 363.00 Totals 29,000.00 29,000.00 wages payable 863.00 D E 6 F Tax expense tax payable 35 36 INSTRUCTION Part 1 Part 2 Part 3 + Ready + 115% Help L: 10 OF H W X PINSON O T Q V