You are a new accounting graduate, and this is your first week as a new hire...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a new accounting graduate, and this is your first week as a new hire at a large CPA firm in Atlanta. This week is dedicated to orientation and training for new employees. Your next training session is about the fundamentals of systems design and databases. The senior partner conducting this session is Ms. Karen Kennedy. She walks into the room, and introductions follow. She explains that every one of you will be dealing with databases throughout your careers at the firm, regardless of area of specialization. The new hires in this session, all accounting graduates except one from information systems, have a wide range of exposure to databases, from hardly any to advanced database courses. Ms. Kennedy wants to get a baseline of each employee's knowledge before proceeding, and she also wants to present a challenge to the new hires to test their critical thinking skills. She provides everyone with a simple general journal with three entries. She says: "This is not a team project, so each of you must come up with your own input for the class discussion after the break. I will give you hints on how to proceed by providing you with the business rules-a topic we just discussed." Ms. Kennedy provides you with the following business rules for this stage of the analysis: The journal entry number will reset to 1 at the beginning of the next fiscal year. For each journal entry resulting from an accounting transaction, the total of the debits must equal the total of the credits. The account number from the chart of accounts can't be used more than once for a single journal entry. 1 2 3 7/1/202X 7/1/202X 7/2/202X Traditional General Journal Entries Cash Accounts Receivable Sales Credit sale with down payment Cost of goods sold Inventory Cost of goods sold Accounts Payable Cash Payment of invoice Account 1001 1004 4001 5001 1030 2001 1001 Dr. 5,000 70,000 40,000 8,000 Cr. 75,000 40,000 8,000 Transform the general journal above into a single, two-dimensional, flat-file table with no empty cells and only one value in each cell. Abbreviate the explanations so that they fit neatly in each cell in the explanation column. Call this flat file of similar records Table 1. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List all debit entries before credit entries.) You are a new accounting graduate, and this is your first week as a new hire at a large CPA firm in Atlanta. This week is dedicated to orientation and training for new employees. Your next training session is about the fundamentals of systems design and databases. The senior partner conducting this session is Ms. Karen Kennedy. She walks into the room, and introductions follow. She explains that every one of you will be dealing with databases throughout your careers at the firm, regardless of area of specialization. The new hires in this session, all accounting graduates except one from information systems, have a wide range of exposure to databases, from hardly any to advanced database courses. Ms. Kennedy wants to get a baseline of each employee's knowledge before proceeding, and she also wants to present a challenge to the new hires to test their critical thinking skills. She provides everyone with a simple general journal with three entries. She says: "This is not a team project, so each of you must come up with your own input for the class discussion after the break. I will give you hints on how to proceed by providing you with the business rules-a topic we just discussed." Ms. Kennedy provides you with the following business rules for this stage of the analysis: The journal entry number will reset to 1 at the beginning of the next fiscal year. For each journal entry resulting from an accounting transaction, the total of the debits must equal the total of the credits. The account number from the chart of accounts can't be used more than once for a single journal entry. 1 2 3 7/1/202X 7/1/202X 7/2/202X Traditional General Journal Entries Cash Accounts Receivable Sales Credit sale with down payment Cost of goods sold Inventory Cost of goods sold Accounts Payable Cash Payment of invoice Account 1001 1004 4001 5001 1030 2001 1001 Dr. 5,000 70,000 40,000 8,000 Cr. 75,000 40,000 8,000 Transform the general journal above into a single, two-dimensional, flat-file table with no empty cells and only one value in each cell. Abbreviate the explanations so that they fit neatly in each cell in the explanation column. Call this flat file of similar records Table 1. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. List all debit entries before credit entries.)
Expert Answer:
Answer rating: 100% (QA)
JE number JE Date 1701202X 1701202X 1 701202X 2 701202X 2 701202X 3 702202X 3 702202X account ... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0077400163
6th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson
Posted Date:
Students also viewed these accounting questions
-
You just completed your first week as a sales rep at Acme Vacation Rentals, a firm specializing in finding vacation rental homes for high-income clients. You enjoy the work very much but are...
-
You run a merchandising business and this is your 2nd year of operations A few of the transactions for the year are provided below Your purchase 100 units of inventory from a supplier for $20 each,...
-
You are a new accounting intern at Thomas Bikes. Your boss gives you the following information and asks you to compute the cost of direct materials used (assume that the companys raw materials...
-
Paula makes the following acquisitions of ordinary shares in Indigent plc: She sells 500 shares on 28 March 2021. No shares are acquired within the next 30 days. (a) Show the s104 holding on 28 March...
-
NET Go to www.spss.com and click on Industries and Market Research. What services does the company provide?
-
Suppose that a lemonade stand's lemonade recipe consists of 2 cups of sugar, 3 cups of lemon juice, and 5 cups of water per batch. a) How much sugar and water should be added if they only use 1 cup...
-
Consider the simple linear regression model fit to the oxygen purity data in Problem 2.7. Problem 2.7 The purity of oxygen produced by a fractional distillation process is thought to be related to...
-
The Hamster Stop has $93,650 in the Accrued Payroll account. Hamster's weekly payroll is $156,000 and the accrual represents payroll for 3 days. If controls are strong, determine whether additional...
-
How much money needs to be set aside every year, for the next 7 years, to purchase a new office? The money is expected to earn 8% interest compounded annually and yearly inflation is expected to be...
-
Frank Thompson operates a small business that manufactures oversized backyard games. He runs the business as a sole proprietorship. The company uses a job order cost system using a first-in,...
-
The displacement of an object in SHM is given by y(t) = (8.0 cm) sin [(1.56 rad/s)t]. What is the frequency of the oscillations?
-
Alex Kiriakos has been offered $1,200 today, $11,000 in 12 years, or $26,650 in 25 years. If he can earn 12 percent on his money, which offer should he choose?
-
If youd like to have $5,000,000 at retirement in 45 years and you expect to earn 10 percent annually, which is around the average return over the past 50 years, what lump sum would you have to invest...
-
To what amount will the following investments accumulate? a. $6,000 invested for 12 years at 12 percent compounded annually b. $7,500 invested for 8 years at 8 percent compounded annually c. $6,400...
-
If Dewi Sukarno were offered \($1,082.70\) ten years from now in return for an investment of \($450\) currently, what annual rate of interest would she earn if she took the offer?
-
Anurag wants to earn $500,000 in 15 years by making equal semi-annual end-of-the-year deposits into a tax-deferred account paying 10 percent interest annually. What must Anurags semi-annual deposit...
-
Budgeted sales in units are as follows: Jan is 35,000 Feb is 26,000 March is 32,000 The companys policy is to have ending inventory of 10% of the following periods sales. What quantity of production...
-
A company pledges their receivables so they may Multiple Choice Charge a factoring fee. Increase sales. Recognize a sale. Collect a pledge fee. Borrow money. Failure by a promissory notes' maker to...
-
Suppose the Environmental Protection Agency is in the process of investigating Ozone Ruination Limited for possible environmental damage but has not proposed a penalty as of December 31, 2011, the...
-
What are the components of relevant information? What are the components of faithful representation?
-
SLR Corporation has 1,000 units of each of its two products in its year-end inventory. Per unit data for each of the products are as follows: Determine the balance sheet carrying value of SLR's...
-
Explain what it means to disestablish paternity. Identify some of the common arguments in favor of and against disestablishment.
-
Identify the three parties with the strongest interests in parentage determinations and describe the nature of those interests.
-
Describe the equitable parent doctrine and explain how it was applied by the Wisconsin Supreme Court in Ay val.
Study smarter with the SolutionInn App