Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

Susie Jacobs provides cleaning service to local businesses. One of her employees is a computer science major and has offered to build a database, but he is not sure how to design an accounting system. She has contacted your company to design a database to help her track her revenues. If she likes the system, she will have you design more of the system. Jacobs' Cleaning Service currently employs 22 students on a part-time basis. She has 47 businesses under contract. Businesses sign up for the service and Susie enters their customer information into the system. Customers call in on a weekly basis if they want to request services (i.e. regular cleaning, carpet cleaning, window cleaning). When a customer call is received, the bookkeeper records the services requested on a service request form. Employees report for work each evening and the supervisor gives them jobs to perform in completing the service requests. The supervisor lists out all of the services to be performed for a business that night and the jobs to be completed by each employee on a service completion form. Susie owns all of the janitorial equipment used in the business and has an inventory of cleaning supplies. In addition to recording the actual hours used to complete each job they are assigned, employees must record the equipment and supplies used  to complete all of their work on the service completion form. In this way, the completion form serves as thebasis for computing employee payroll as well as for reducing inventory balances in supplies and tracking  equipment usage. Each night, when the service is completed and the completion form filled out, employees leave one copy of the service completion form at the business to verify to the business owner that services were performed (something like an invoice) and return a second copy to the bookkeeper who enters the information into an Excel spreadsheet. The company's accounts receivable balance is automatically updated when the service completion form is entered. At the end of each month, the bookkeeper prints customer statements based on information from the service requests and service completion forms. Statements list the service request, service completion and individual services performed during the month as well as the cost for each service. Customers remit their payments by mail. The bookkeeper records these cash receipts. Susie deposits all payments received for a given day in the bank and records the deposit in the Excel-based accounting records showing the checking account number, total amount of the deposit, and associated cash receipts.

Additional Information:

1. Descriptive information about standard services performed by Jacobs' is shown in a separate resource data table.

2. A resource table showing the various employee services/jobs (Cleaning, Supervisory, etc.) that can be performed is also maintained and is used when recording employee services performed for the service completions.

3. Each service completion form lists information for only one business. Several services may be listed on each service completion form. Each service completion for must have at least one employee working on at least one job, but may have more than employee. Some services require no equipment or supplies; others require many different supplies and equipment. Adapted from Stacy E. Kovar, Kansas State University 2

4. Cash receipts are applied to the appropriate service completion form through a procedure in the accounting spreadsheet. Each receipt can apply to more than one service completion form, with each service completion being payable with multiple cash receipts.
5. A sample Service Completion Form is provided at the bottom of this document.

Requirements:


1. Prepare a document or hybrid flowchart that shows all the recording, maintenance and reporting explicitly mentioned above
2. Prepare an REA data model for Jacobs' Cleaning Service revenue cycle.
3. Convert the REA diagram into a set of database tables. Note that you do not have to implement the tables in Access.
4. Prepare a report for Susie's Cleaning Service. Be sure to describe all diagrams and tables.
5. Bill your client for the hours worked by partner (one invoice only).

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M946698

Have any Question? 


Related Questions in Accounting Basics

1 here is a very detailed article on asset

1. Here is a very detailed article on asset valuation. http://www.investopedia.com/articles/stocks/07/allocate_assets.asp What have you found interesting in this article? How can this help you as you progress with your a ...

Assignmentpaper 1excel spreadsheet and 1-2 pagesconsider

Assignment Paper #1 Excel Spreadsheet and 1-2 pages Consider the following scenario: Andre has asked you to evaluate his business, Andre's Hair Styling. Andre has five barbers working for him. (Andre is not one of them.) ...

Individual project instructionsobjectiveyour objective is

Individual Project Instructions OBJECTIVE Your objective is to use analytical tools to understand and improve business performance and to present your analysis using effective data visualizations in a dashboard format. F ...

Discussion questions 1 and 2dq 1 accounting equationas you

Discussion Questions 1 and 2 DQ #1: Accounting Equation As you have learned in this week's readings, the Accounting Equation is Assets = Liabilities + Owners' Equity. Is the accounting equation true in all instances? Pro ...

Internet case-citizen-centric reportingalthough citizens

Internet Case-Citizen-Centric Reporting Although citizens should be concerned about the performance of government, in truth, few citizens typically review the financial information provided by their government. In part, ...

Mnc paper and presentationgoogle company paper and

MNC Paper and Presentation: GOOGLE COMPANY Paper and Presentation will consist of research to write a paper on an annual SEC 10-K report filed by a public multinational corporation with the U.S. Securities and Exchange C ...

1 fair value determination of goodwill and calculating the

1) Fair value determination of goodwill and calculating the premium paid over market value in a merger: Using fair value accounting for goodwill, under FAS 141R, determine the amount of goodwill that "the acquiring compa ...

Mcreath corporation is a leading producer of fresh frozen

McReath Corporation is a leading producer of fresh, frozen, and made from concentrate citrus drinks. The firm was founded in 1922 by Charles McReath, an army veteran who settled in Jacksonville, Florida, after World War ...

Question 1if total liabilities are 1000 and total assets

Question 1 If total liabilities are $1,000 and total assets are $8,000, owner's equity must be A. $7,000. B. $3,000. C. $10,000. D. $13,000. Question 2 If total assets are $30,000 and total liabilities are $18,000, capit ...

Part a -exercise 1 - california graphics is a us

Part A - Exercise 1 - California Graphics is a U.S. corporation with $200 million of U.S.-source income and $10 million of foreign-source income. In addition, California Graphics has three-quarters ownership of a Canadia ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro