I have a project due soon in my accounting class. It is the same


Question Description:

35

I have a project due soon in my accounting class. It is the same project as the one you guys have on your site already about the AC speed project. Almost all the numbers are the same except for a few different transactions could you help me complete this project with the transactions provided by Friday? please advise ACCT202_PracticeSet_W15_Student_File(1).xlsm Project Academic Integrity Statement I understand that this is an individual, not a team, project; that I am expected to do my own work on the project. I may discuss project requirements in general terms with others, but I am not permitted to collaborate with anyone or copy anyone’s work, manually or electronically, in full or in part. I also understand that I am not permitted to supply anyone with the results of my work or to provide them with any assistance that compromises another student’s completion of the project through his or her own efforts. If I have any questions about these requirements, I will promptly ask my instructor for clarification I understand that any violation of this project academic integrity statement will lead, at minimum, to a failing grade for the project. By entering my name and student ID number below, I am attesting that I have read, understood, and will personally adhere to this project’s academic integrity statement. Student Name: Student ID Number: Date: AC Speed Corporation Sales Journal Date Invoice No. A/R Account Debited Post A/R – DR Ref Sales – CR CGS – DR Inv – CR Unadjusted Trial Balance Acct. No. Account Title 100 Cash 102 Accounts Receivable 103 Allowance for Doubtful Accounts 104 Merchandise Inventory 105 Office Supplies 106 Prepaid Insurance 140 Land 145 Building 146 Accumulated Depreciation – Building 151 Equipment & Furniture – Warehouse 152 Accumulated Depreciation – Equip & Furn. – Warehouse 153 Equipment & Furniture – Office 154 Accumulated Depreciation – Equip & Furn. – Office 201 Accounts Payable 202 Wages Payable 203 Interest Payable 204 Dividends Payable 205 Unearned Rent 250 Notes Payable 251 Bonds Payable 252 Mortgage (Warehouse) Payable 300 Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding 301 Paid In Capital – Excess of Par 330 Retained Earnings 340 Treasury Stock 500 Sales 510 Sales Discounts 511 Sales Returns & Allowances 600 Cost of Goods Sold 700 Wage Expense (hourly workers) 701 Salaries Expense (Exempt Staff) 702 Marketing Expense 703 Travel and Entertainment Expense 704 Bad Debt Expense 705 Property Tax Expense 706 Office Maintenance & Repair Expense 707 Legal Expenses 708 Insurance Expense 709 Utilities Expense 710 Office Supplies Expense 711 Telecommunications Expense 712 Depreciation Expense – Equip & Furniture – Warehouse 713 Depreciation Expense – Equip & Furniture – Office 800 Rent Income 900 Interest Expense Total Net Income (Loss) Total Total Dr. Adjustments Cr. Dr. Cr. Adjusted Trial Balance Dr. Cr. Income Statement Dr. Bal. Sheet Stmt. Own. Equity Cr. Dr. Cr. Adjusted Trial Balance Acct. No. Account Title Dr. Cr. Cash 299,000 0 Accounts Receivable 948,800 0 0 16,800 601,856 0 2,240 0 15,680 0 Land 2,000,600 0 Building 1,500,000 Allowance for Doubtful Accounts Merchandise Inventory Office Supplies Prepaid Insurance Accumulated Depreciation – Building Equipment & Furniture – Warehouse 1,500,000 11,200 0 0 2,128 9,520 0 Accumulated Depreciation – Equip & Furn. – Office 0 1,792 Accounts Payable 0 812,432 Wages Payable 0 0 Interest Payable 0 0 Dividends Payable 0 0 Unearned Rent 0 0 Notes Payable 0 0 Bonds Payable 0 0 Mortgage (Warehouse) Payable 0 124,000 Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding 0 65,000 Paid In Capital – Excess of Par 0 1,545,000 Retained Earnings 0 1,171,744 Treasury Stock 0 0 Sales 0 8,850,000 Sales Discounts 0 0 Sales Returns & Allowances 0 0 7,656,000 0 Wage Expense (hourly workers) 120,000 0 Salaries Expense (Exempt Staff) 360,000 0 Mark

Answer

35