Question

In: Accounting

Review the chart of accounts in Ch 2. In Excel, create a four column chart of...

Review the chart of accounts in Ch 2. In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following:

  • List at least 16 accounts.
  • At least 6 account titles should be customized for your specific company.
  • Assign a three digit account number to your accounts following the example chart of accounts.
  • Group and title the accounts, as in the example, as Assets, Liabilities, Owner’s Equity, Revenue and Expense.
  • In the last two columns, state what the normal balance of the account is (debit or credit), and state how the account is increased (debit or credit).

Your four columns should have the following titles:

  • Account number
  • Account title
  • normal balance
  • increases with

The example below is for the cash line

Account number Account title Normal Balance Increases with
101 Cash Debit Debit

:

Examples of businesses in pathways could be:

  • AHCD: Dance, Theater, Film production, Social media, Graphics design or architecture business
  • Business: Accounting office, caterer, advertising firm, dry cleaner, restaurant, any business is acceptable
  • Education: K-12 tutoring, Child care, Charter schools
  • Health Sciences: Dr. or Dentist office, PT office, Hospital, Insurance co,
  • IMCT: Engineering Co., Aviation maintenance, Aviation distribution, Supply Chain Management
  • Public Safety: Law office, PI, Equipment providers for the industry
  • STEM: Engineering Co., Vet. Office, Computer Services co.
  • SGSHS: Psychology office, Non-profit agencies, Social Media
  • I NEED TO BE ABLE TO COPY AND PASTE. DO NOT SCAN IT PLEASE.

THANK YOU IN ADVANCE.

Solutions

Expert Solution


Related Solutions

Review the chart of accounts in Ch 2. In Excel, create a four column chart of...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following: List at least 16 accounts. At least 6 account titles should...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of...
Review the chart of accounts in Ch 2. In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following: List at least 16 accounts. At least 6 account titles should...
Emergency Chart Create a chart of medical emergencies and the level of required care. Column one,...
Emergency Chart Create a chart of medical emergencies and the level of required care. Column one, medical emergencies that can be treated in a medical office setting and column two medical emergencies that require a higher level of care; such as, ambulance transportation to a hospital. Create a medical office protocol to determine if the emergency requires higher level and the steps for office personal to follow. Mod 5 Assign 1
Use the data in the following table to create a fraction nonconforming (p) chart. The column...
Use the data in the following table to create a fraction nonconforming (p) chart. The column of np represents the number of non-conforming units. Is the process in control? (5 points) Sample n np p 1 100 7 0.07 2 100 10 0.10 3 100 12 0.12 4 100 4 0.04 5 100 9 0.09 6 100 11 0.11 7 100 10 0.10 8 100 18 0.18 9 100 13 0.13 10 100 21 0.21 Question 2 A bank's manager...
In Excel, create a 2x30 data table with the left column representing a population of prey...
In Excel, create a 2x30 data table with the left column representing a population of prey and the right column representing a population of predators. Use the population model presented below. Let the starting values of the model parameters be: r = 1.3, k = 1, s = .5, v = 1.6, and u = .7 Let the starting population of P = 1.1 and Q = .4 Difference equations: P[t + 1] = P[t](1 + r(1 – P[t]/K)) -...
Create a simple Chart of Accounts for an owner/ operator business such as a lawn mowing...
Create a simple Chart of Accounts for an owner/ operator business such as a lawn mowing round and also mention how the opening balance for each cost centre/ account can be established? Discuss in 80–100 words.
What is a chart of accounts? Why is it important to develop a chart of accounts?...
What is a chart of accounts? Why is it important to develop a chart of accounts? What impact on a company would there be if a company's chart of accounts has errors or one was not developed? Provide 3 specific examples.
Please finish the following assignment in Excel. Ignoring price, create a chart that displays the seasonality...
Please finish the following assignment in Excel. Ignoring price, create a chart that displays the seasonality of cranberry sales. Ignoring price, create a chart that shows whether there is an upward trend in sales. Determine average sales per quarter, breaking it down based on whether your price was higher or lower than the competitor’s price. You can use the following function to transform the price into a category variable:  “=IF(J14<K14,"Higher Price", "Lower Price")” Year Quarter Units Competitor Price My Price 2006...
create a GANNT chart for your company's public 15th anniversary party...preferably on excel
create a GANNT chart for your company's public 15th anniversary party...preferably on excel
Create General Ledger entries based on the information given. Chart of accounts: 1001 Cash 1006 Accounts...
Create General Ledger entries based on the information given. Chart of accounts: 1001 Cash 1006 Accounts Receivable 1019 Merchandise Inventory 1124 Office supplies 1125 Store supplies 1128 Prepaid insurance 1163 Office equipment 1164 Accumulated Depreciation - Office equipment 1165 Store equipment 1166 Accumulated Depreciation - Store equipment 2001 Accounts payable 3001 Skip Slider, Capital 3002 Skip Slider, Withdrawals 4013 Sales 4014 Sales discounts 4015 Sales returns and allowances 5002 Cost of goods sold 6012 Depreciation expense - Office equipment 6013...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT