College accounting, chapters 1-9
23rd Edition
ISBN: 9781337794787
Author: HEINTZ, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 14, Problem 6RQ
To determine
List the four steps required to prepare an end-of-period spreadsheet.
Expert Solution & Answer

Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers.
Jerry,
Incorporated Kate Company
Number of orders
Units per order
sales returns:
Number of returns
Total units returned
Number of sales calls.
3
2,000
60
360
1
60
5
140
4
Colleen sells its products at $290 per unit. The firm's gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and
no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30
months, the firm has determined the following activity costs:
Activity
Sales calls
Order processing
Deliveries
Sales returns
Sales salary
Cost Driver and Rate
$ 700 per visit
460 per order
100 per order
210 per return and $5 per unit returned
80,000 per month
Complete this question by entering your answers in the tabs below.
Required 1
Required 2
Using customers as the cost objects, classify the activity costs into cost categories…
Journal Entries
Rocky Mountain Tours Co. is a travel agency. The nine transactions recorded by Rocky Mountain Tours during June 20Y2, its first month of operations, are
indicated in the following T accounts:
Cash
(1) 40,000 (2) 4,000
(7) 13,100 (3) 5,000
(4) 6,175
(6) 6,000
(9) 1,500
Equipment
(3) 15,000
Dividends
(9) 1,500
Accounts Receivable
Accounts Payable
Service Revenue
(5) 20,500 (7) 13,100
(6) 6,000 (3) 10,000
(5) 20,500
Supplies
(2) 4,000 (8) 2,200
Common Stock
(1) 40,000
Operating Expenses
(4) 6,175
(8) 2,200
Prepare the nine journal entries from which the postings were made. Journal entry explanations may be omitted. If an amount box does not require an
entry, leave it blank.
Innovative Consulting Co. has the following accounts in its ledger: Cash, Accounts Receivable, Supplies, Office Equipment, Accounts Payable, Common
Stock, Retained Earnings, Dividends, Fees Earned, Rent Expense, Advertising Expense, Utilities Expense, Miscellaneous Expense.
Journalize the following selected transactions for October 2012 in a two-column journal. Journal entry explanations may be omitted. If an amount box does
not require an entry, leave it blank.
Oct. 1. Paid rent for the month, $2,500.
4. Paid advertising expense, $1,000.
5. Paid cash for supplies, $1,800.
6. Purchased office equipment on account, $11,500.
12. Received cash from customers on account, $7,500.
20. Paid creditor on account, $2,700.
27. Paid cash for miscellaneous expenses, $700.
30. Paid telephone bill for the month, $475.
31. Fees earned and billed to customers for the month, $42,400.
31. Paid electricity bill for the month, $900.
31. Paid dividends, $1,500.
Chapter 14 Solutions
College accounting, chapters 1-9
Ch. 14 - Under the periodic inventory system, the beginning...Ch. 14 - Under the periodic inventory system, the ending...Ch. 14 - The cash received in advance before delivering a...Ch. 14 - Unearned revenue is adjusted into an expense...Ch. 14 - Sales Returns and Allowances is classified as a...Ch. 14 - Under the periodic inventory system, what account...Ch. 14 - Under the periodic inventory system, what account...Ch. 14 - Under the periodic inventory system, what account...Ch. 14 - Unearned revenue is classified as what type of...Ch. 14 - Under the perpetual inventory method, what account...
Ch. 14 - Prepare the cost of goods sold section for Josephs...Ch. 14 - The Venice Theatre sold and collected cash of...Ch. 14 - Information relating to inventory for Janie Par...Ch. 14 - Using the spreadsheet provided below, prepare the...Ch. 14 - Prob. 5CECh. 14 - A firm is preparing to make adjusting entries at...Ch. 14 - What spreadsheet amounts are used to compute cost...Ch. 14 - Why are both the debit and credit amounts in the...Ch. 14 - What is an unearned revenue?Ch. 14 - Give three examples of unearned revenue.Ch. 14 - Prob. 6RQCh. 14 - Prob. 7RQCh. 14 - A firm is preparing to make adjusting entries at...Ch. 14 - ADJUSTMENT FOR MERCHANDISE INVENTORY USING T...Ch. 14 - ADJUSTMENT FOR MERCHANDISE INVENTORY USING T...Ch. 14 - CALCULATION OF COST OF GOODS SOLD: PERIODIC...Ch. 14 - CALCULATION OF COST OF GOODS SOLD: PERIODIC...Ch. 14 - ADJUSTMENT FOR UNEARNED REVENUES USING T ACCOUNTS...Ch. 14 - MERCHANDISE INVENTORY ADJUSTMENTS: PERIODIC...Ch. 14 - DETERMINING THE BEGINNING AND ENDING INVENTORY...Ch. 14 - JOURNALIZE ADJUSTING ENTRIES FOR A MERCHANDISING...Ch. 14 - JOURNAL ENTRIES UNDER THE PERPETUAL INVENTORY...Ch. 14 - ADJUSTMENTS FOR A MERCHANDISING BUSINESS:...Ch. 14 - JOURNALIZE ADJUSTING ENTRY FOR INVENTORY...Ch. 14 - PREPARATION OF ADJUSTMENTS ON A SPREADSHEET FOR A...Ch. 14 - WORKING BACKWARD FROM ADJUSTED TRIAL BALANCE TO...Ch. 14 - ADJUSTMENT FOR MERCHANDISE INVENTORY USING T...Ch. 14 - ADJUSTMENT FOR MERCHANDISE INVENTORY USING T...Ch. 14 - CALCULATION OF COST OF GOODS SOLD: PERIODIC...Ch. 14 - CALCULATION OF COST OF GOODS SOLD: PERIODIC...Ch. 14 - ADJUSTMENT FOR UNEARNED REVENUES USING T ACCOUNTS...Ch. 14 - MERCHANDISE INVENTORY ADJUSTMENTS: PERIODIC...Ch. 14 - DETERMINING THE BEGINNING AND ENDING INVENTORY...Ch. 14 - JOURNALIZE ADJUSTING ENTRIES FOR A MERCHANDISING...Ch. 14 - JOURNAL ENTRIES UNDER THE PERPETUAL INVENTORY...Ch. 14 - ADJUSTMENTS FOR A MERCHANDISING BUSINESS:...Ch. 14 - JOURNALIZE ADJUSTING ENTRY FOR INVENTORY...Ch. 14 - Prob. 12SPBCh. 14 - WORKING BACKWARD FROM ADJUSTED TRIAL BALANCE TO...Ch. 14 - A friend of yours recently opened Abracadabra, a...Ch. 14 - Jason Tierro, an inventory clerk at Lexmar...Ch. 14 - John Neff owns and operates Waikiki Surf Shop. A...Ch. 14 - Block Foods, a retail grocery store, has agreed to...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Cash Accounts Receivable Supplies Prepaid Insurance Equipment Notes Payable Accounts Payable Debit Balances Credit Balances 20,350 37,000 1,100 200 171,175 36,000 26,000 Common Stock 50,000 Retained Earnings 94,150 Dividends 15,000 Fees Earned 429,850 Wages Expense 270,000 Rent Expense 63,000 Advertising Expense 25,200 Miscellaneous Expense 5,100 608,125 636,000arrow_forwardOn October 1, 20Y6, Jay Crowley established Affordable Realty, which completed the following transactions during the month: Oct. 1 Jay Crowley transferred cash from a personal bank account to an account to be used for the business in exchange for common stock, $40,000. 2 Paid rent on office and equipment for the month, $4,800. 3 Purchased supplies on account, $2,150. 4 Paid creditor on account, $1,100. 10 5 Earned sales commissions, receiving cash, $18,750. 6 Paid automobile expenses (including rental charge) for month, $1,580, and miscellaneous expenses, $800. 7 Paid office salaries, $3,500. 8 Determined that the cost of supplies used was $1,300. 9 Paid dividends, $1,500.arrow_forwardReese, a calendar-year taxpayer, uses the cash method of accounting for her sole proprietorship. In late December, she received a $20,000 bill from her accountant for consulting services related to her small business. Reese can pay the $20,000 bill anytime before January 30 of next year without penalty. Assume Reese’s marginal tax rate is 32 percent this year and will be 37 percent next year, and that she can earn an after-tax rate of return of 12 percent on her investments. a. What is the after-tax cost if she pays the $20,000 bill in December? b. What is the after-tax cost if she pays the $20,000 bill in January 30? Use Exhibit 3.1. (Round your answer to the nearest whole dollar amount.) Exhibit 3.1 below 4% 5% 6% 7% 8% 9% 10% 11% 12% Year 1 .962 .952 .943 .935 .926 .917 .909 .901 .893 Year 2 .925 .907 .890 .873 .857 .842 .826 .812 .797 Year 3 .889 .864 .840 .816 .794 .772 .751 .731 .712 Year 4 .855 .823 .792 .763 .735 .708 .683 .659 .636 Year 5…arrow_forward
- Manny, a calendar-year taxpayer, uses the cash method of accounting for his sole proprietorship. In late December he performed $20,000 of legal services for a client. Manny typically requires his clients to pay his bills immediately upon receipt. Assume Manny’s marginal tax rate is 37 percent this year and next year, and that he can earn an after-tax rate of return of 12 percent on his investments. a. What is the after-tax income if Manny sends his client the bill in December? b. What is the after-tax income if Manny sends his client the bill in January? Use Exhibit 3.1. (Round your answer to the nearest whole dollar amount.) Exhibit 3.1 below 4% 5% 6% 7% 8% 9% 10% 11% 12% Year 1 .962 .952 .943 .935 .926 .917 .909 .901 .893 Year 2 .925 .907 .890 .873 .857 .842 .826 .812 .797 Year 3 .889 .864 .840 .816 .794 .772 .751 .731 .712 Year 4 .855 .823 .792 .763 .735 .708 .683 .659 .636 Year 5 .822 .784 .747 .713 .681 .650 .621 .593 .567 Year 6 .790 .746…arrow_forwardRocky Mountain Tours Co. is a travel agency. The nine transactions recorded by Rocky Mountain Tours during June 20Y2, its first month of operations, are indicated in the following T accounts: Cash (1) 40,000 (2) 4,000 (7) 13,100 (3) 5,000 (4) 6,175 (6) 6,000 (9) 1,500 Equipment (3) 15,000 Dividends (9) 1,500 Accounts Receivable Accounts Payable Service Revenue (5) 20,500 (7) 13,100 (6) 6,000 (3) 10,000 (5) 20,500 Supplies (2) 4,000 (8) 2,200 Common Stock (1) 40,000 Operating Expenses (4) 6,175 (8) 2,200 a. Prepare an unadjusted trial balance. List all the accounts in the order of Assets, Liabilities, Stockholders' equity, Revenues, and Expenses. Place the amounts in the proper columns. If an entry is not required in an amount box, leave it blank.arrow_forwardTransactions and T Accounts The following selected transactions were completed during July of the current year: 1. Billed customers for fees earned, $112,700. 2. Purchased supplies on account, $4,500. 3. Received cash from customers on account, $88,220. 4. Paid creditors on account, $3,100. a. Journalize these transactions in a two-column journal, using the appropriate number to identify the transactions. Journal entry explanations may be omitted. If an amount box does not require an entry, leave it blank. (1) Accounts Receivable Fees Earned (2) Supplies Accounts Payable (3) Cash Accounts Receivable (4) Accounts Payable Casharrow_forward
- Isabel, a calendar-year taxpayer, uses the cash method of accounting for her sole proprietorship. In late December she received a $20,000 bill from her accountant for consulting services related to her small business. Isabel can pay the $20,000 bill anytime before January 30 of next year without penalty. Assume her marginal tax rate is 37 percent this year and next year, and that she can earn an after-tax rate of return of 12 percent on her investments. a. What is the after-tax cost if Isabel pays the $20,000 bill in December? b. What is the after-tax cost if Isabel pays the $20,000 bill in January? Use Exhibit 3.1. (Round your answer to the nearest whole dollar amount.) c. Based on requirements a and b, should Isabel pay the $20,000 bill in December or January? multiple choice December Januaryarrow_forwardAnswer correctly plz otherwise unhearrow_forwardFinancial accountingarrow_forward
- When privately-held Toys "R" Us filed for bankruptcy in fall 2017, it disclosed that it had $5 billion in debt and was spending about $400 million per year for interest on that debt. Toys "R" Us net debt was $109.0 million in 2005, just before being taken over by private equity buyers in 2005. In that takeover, the company incurred $5.3 billion in debt. Sales revenue in the twelve months before the buyout in 2005 were $11.2 billion. Sales in the twelve months ending October 2017 were $11.1 billion. During the bankruptcy and store closing announcement in March 2018, the Toys "R" Us CEO stated that the company had fallen behind on the general upkeep and condition of its stores, which contributed to the decline in sales. It has also faced intense competition from other retailers, such as Amazon.com and Walmart. Toys "R" Us had had plans during 2017 to invest in technology, upgrade its stores to have toy testing areas, and create other features that would draw customers into the stores,…arrow_forwardAnswer? financial accountingarrow_forwardThe privately-held Toys "R" Us filed for bankruptcy in fall 2017, it disclosed that it had $5 billion in debt and was spending about $400 million per year for interest on that debt. Toys "R" Us net debt was $109.0 million in 2005, just before being taken over by private equity buyers in 2005. In that takeover, the company incurred $5.3 billion in debt. Sales revenue in the twelve months before the buyout in 2005 were $11.2 billion. Sales in the twelve months ending October 2017 were $11.1 billion. During the bankruptcy and store closing announcement in March 2018, the Toys "R" Us CEO stated that the company had fallen behind on the general upkeep and condition of its stores, which contributed to the decline in sales. It has also faced intense competition from other retailers, such as Amazon.com and Walmart. Toys "R" Us had had plans during 2017 to invest in technology, upgrade its stores to have toy testing areas, and create other features that would draw customers into the stores, but…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning