Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 9, Problem 75P
1.
To determine
Present cash receipts schedule.
2. a.
To determine
Compute revised total sales, credit card sales and cash sales.
2. b.
To determine
Compute number of credit card transactions.
3.
To determine
Construct a revised schedule of cash receipts.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Schedule of Cash Receipts
Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus
and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.50 per
check; the amount per check averages $80. "Bad" checks that Rosita cannot collect make up 4 percent of check
revenue.
During a typical month, Rosita's has sales of $43,000. About 80 percent are cash sales. Estimated sales for the next
three months are as follows:
April
$30,000
May
43,000
June
59,000
Required:
Prepare a schedule of cash receipts for May and June. Round your intermediate computations and final answers to
the nearest whole dollar.
Rosita's Mexican Restaurant
Schedule of Cash Receipts
For the Months of May and June
May
June
Cash sales:
34,400
$ 47,200
Checks
8,825.75
11,800 X
Total
$4
Schedule of Cash Receipts
Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.70 per check; the amount per check averages $70. “Bad” checks that Rosita cannot collect make up 2 percent of check revenue.
During a typical month, Rosita's has sales of $43,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows:
April
$33,000
May
43,000
June
59,000
Required:
Prepare a schedule of cash receipts for May and June. Round your intermediate computations and final answers to the nearest whole dollar.
Rosita's Mexican RestaurantSchedule of Cash ReceiptsFor the Months of May and June
Â
May
June
Cash sales:
$fill in the blank 1
$fill in the blank 2
Checks
fill in the blank 3
fill in the blank 4
Total
$fill in the blank 5
$fill in the blank 6
1.
ABC Furniture Inc. has hired you to build a 3-month cash budget. It is currently August
1. ABC has $10,000 in the bank and owes $20,000 on its bank line of credit. The bank
charges .5% (.005) monthly on any outstanding balance the previous month. ABC
borrows as little as possible and repays back any outstanding loans as quickly as possible,
but must keep at least $10,000 in its account. ABC can borrow or pay back any amount
at the end of each month.
Projected cash receipts from customers for the next three months, respectively, are
$250,800, $280,000, and $275,000. Projected cash receipts from Notes Receivables are
$10,500, $20,000, and $31,500. Projected cash payments for merchandise are $187,600,
$182,000, and $190,000. Projected cash payments for operating expenses are $90,000,
$95,000, and $99,000.
Prepare cash budgets for August, September, and October in side-by-side columns. Show
how much cash will be borrowed or repaid each month according to the bank's rules
above. Show the…
Chapter 9 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
Ch. 9 - Define the term budget. How are budgets used in...Ch. 9 - Prob. 2DQCh. 9 - Explain how both small and large organizations can...Ch. 9 - Prob. 4DQCh. 9 - What is a master budget? An operating budget? A...Ch. 9 - Explain the role of a sales forecast in budgeting....Ch. 9 - All budgets depend on the sales budget. Is this...Ch. 9 - Why is goal congruence important?Ch. 9 - Why is it important for a manager to receive...Ch. 9 - What is participative budgeting? Discuss some of...
Ch. 9 - A budget too easily achieved will lead to...Ch. 9 - Explain why a manager has an incentive to build...Ch. 9 - Discuss the differences between static and...Ch. 9 - Explain why mixed costs must be broken down into...Ch. 9 - What is the purpose of a before-the-fact flexible...Ch. 9 - Prob. 1MCQCh. 9 - Which of the following is part of the control...Ch. 9 - Which of the following is not an advantage of...Ch. 9 - The budget committee a. reviews the budget. b....Ch. 9 - A moving, 12-month budget that is updated monthly...Ch. 9 - Which of the following is not part of the...Ch. 9 - Before a direct materials purchases budget can be...Ch. 9 - The first step in preparing the sales budget is to...Ch. 9 - Which of the following is needed to prepare the...Ch. 9 - A company requires 100 pounds of plastic to meet...Ch. 9 - A company plans to sell 220 units. The selling...Ch. 9 - Select the one budget below that is not an...Ch. 9 - A company has the following collection pattern:...Ch. 9 - The percentage of accounts receivable that is...Ch. 9 - Which of the following is not an advantage of...Ch. 9 - Prob. 16MCQCh. 9 - For performance reporting, it is best to compare...Ch. 9 - To create a meaningful performance report, actual...Ch. 9 - To help assess performance, managers should use a...Ch. 9 - A firm comparing the actual variable costs of...Ch. 9 - Preparing a Sales Budget Patrick Inc. sells...Ch. 9 - Preparing a Production Budget Patrick Inc. makes...Ch. 9 - Preparing a Direct Materials Purchases Budget...Ch. 9 - Preparing a Direct Labor Budget Patrick Inc. makes...Ch. 9 - Preparing an Overhead Budget Patrick Inc. makes...Ch. 9 - Preparing an Ending Finished Goods Inventory...Ch. 9 - Preparing a Cost of Goods Sold Budget Andrews...Ch. 9 - Preparing a Selling and Administrative Expenses...Ch. 9 - Preparing a Budgeted Income Statement Oliver...Ch. 9 - Preparing a Schedule of Cash Collections on...Ch. 9 - Preparing an Accounts Payable Schedule Wight Inc....Ch. 9 - Preparing a Cash Budget La Famiglia Pizzeria...Ch. 9 - Flexible Budget with Different Levels of...Ch. 9 - Performance Report Based on Budgeted and Actual...Ch. 9 - Preparing a Sales Budget Tulum Inc. sells powdered...Ch. 9 - Preparing a Production Budget Tulum Inc. makes a...Ch. 9 - Preparing a Direct Materials Purchases Budget...Ch. 9 - Preparing a Direct Labor Budget Tulum Inc. makes a...Ch. 9 - Preparing an Overhead Budget Tulum Inc. makes a...Ch. 9 - Prob. 40BEBCh. 9 - Preparing a Cost of Goods Sold Budget Lazlo...Ch. 9 - Preparing a Selling and Administrative Expenses...Ch. 9 - Preparing a Budgeted Income Statement Jameson...Ch. 9 - Preparing a Schedule of Cash Collections on...Ch. 9 - Pilsner Inc. purchases raw materials on account...Ch. 9 - Preparing a Cash Budget Olivers Bistro provided...Ch. 9 - Flexible Budget with Different Levels of...Ch. 9 - Performance Report Based on Budgeted and Actual...Ch. 9 - Planning and Control a. Dr. Jones, a dentist,...Ch. 9 - Use the following information for Exercises 9-50...Ch. 9 - Prob. 51ECh. 9 - Production Budget and Direct Materials Purchases...Ch. 9 - Production Budget Aqua-Pro Inc. produces...Ch. 9 - Direct Materials Purchases Budget Langer Company...Ch. 9 - Direct Labor Budget Evans Company produces asphalt...Ch. 9 - Sales Budget Alger Inc. manufactures six models of...Ch. 9 - Production Budget and Direct Materials Purchases...Ch. 9 - Schedule of Cash Collections on Accounts...Ch. 9 - Schedule of Cash Collections on Accounts...Ch. 9 - Cash Payments Schedule Fein Company provided the...Ch. 9 - Cash Budget The owner of a building supply company...Ch. 9 - Flexible Budget for Various Levels of Production...Ch. 9 - Use the following information for Exercises 9-63...Ch. 9 - Use the following information for Exercises 9-63...Ch. 9 - Prob. 65PCh. 9 - Operating Budget, Comprehensive Analysis Allison...Ch. 9 - Use the following information for Problems 9-67...Ch. 9 - Use the following information for Problems 9-67...Ch. 9 - Use the following information for Problems 9-67...Ch. 9 - Ryan Richards, controller for Grange Retailers,...Ch. 9 - Participative Budgeting, Not-for-Profit Setting...Ch. 9 - Cash Budget The controller of Feinberg Company is...Ch. 9 - Optima Company is a high-technology organization...Ch. 9 - Direct Materials and Direct Labor Budgets Willison...Ch. 9 - Prob. 75PCh. 9 - Prob. 76CCh. 9 - Prob. 77CCh. 9 - Budgetary Performance, Rewards, Ethical Behavior...
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
- Rosita Flores owns Rositas Mexican Restaurant in Tempe, Arizona. Rositas is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges 0.50 per check; the amount per check averages 75. Bad checks that Rosita cannot collect make up 3 percent of check revenue. During a typical month, Rositas has sales of 45,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows: Required: Prepare a schedule of cash receipts for May and June. (Round all amounts to the nearest dollar.)arrow_forwardSchedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.50 per check; the amount per check averages $75. "Bad" checks that Rosita cannot collect make up 3 percent of check revenue. During a typical month, Rosita's has sales of $45,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows: April $32,000 May 45,000 June 56,000 Rosita thinks that it may be time to refuse to accept checks and to start accepting credit cards. She is negotiating with VISA/MasterCard and American Express, and she would start the new policy on April 1. Rosita estimates that with the drop in sales from the "no checks" policy and the increase in sales from the acceptance of credit cards, the net increase in sales will be 30 percent. The credit cards do involve added costs as…arrow_forwardBudgeted Cash Receipts: Cash Discounts Allowed on Receivables Yeopay PlumbingSupply accepts bank credit cards and offers established plumbers charge accounts with terms of1/eom, n/45. Yeopay’s experience is that 25% of its sales are for cash and bank credit cards. Theremaining 75% are on credit. Of the cash sales, 40% pay cash and the remaining 60% pay with bankcredit cards. Yeopay receives payments from the bank on credit card sales at the end of the day.However, Yeopay has to pay 3% for these services. An aging schedule for accounts receivable showsthe following pattern on credit sales:20% pay in the month of sale.50% pay in the first month following the month of sale.15% pay in the second month following the month of sale.12% pay in the third month following the month of sale.3% are never collected.All accounts not paid by the end of the second month following the month of sale are considered overdue and are subject to a 2% monthly late charge. Yeopay has prepared the following…arrow_forward
- Case Study: Hassam runs a fruit stall at the local market and at the end of each day he banks the cash in the cash register. the cash register records each sale and can provide a total for each day but Hassam believes that often the staffs are too busy and do not always enter the sales in the cash register but simply put the cash in the till. the total from the cash register is produced each month for the budiness's accountant to prepare financial statements. Recently, Hassam employed a university student to work on weekends and he is concerned that after this the daily amount banked seems to have decreased even though Hassam feels that sales have not really changed. the student often talks about how he spends his evenings at the casino in the hope of winning enough to pay for his university studies so that he doesn't have to work every weekend. reqiured: please answer this question by listing to Hassam 5 controls he could put in place to minimize the risk of one of his employees…arrow_forwardAll sales at Alaska Company are on credit. The company is preparing a cash budget for November. The following information on accounts receivable collections is available from customer payment history: Percent of current month's sales collected this month Percent of prior month's sales collected this month Percent of sales two months prior to current month collected this month Percent of sales three months prior to current month collected this month The remaining 2 percent is not collected and is written off as bad debts. Sales to date are as follows: November (estimated) October September August $ 370,000 410,000 340,000 480,000 Required: What are the estimated cash receipts from accounts receivable collections in November? 30% 60 253arrow_forwardRosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.50 per check; the amount per check averages $80. “Bad” checks that Rosita cannot collect make up 2 percent of check revenue. During a typical month, Rosita's has sales of $44,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows: April $30,000 May 44,000 June 55,000 Required: Prepare a schedule of cash receipts for May and June. Round your intermediate computations and final answers to the nearest whole dollar. Rosita's Mexican RestaurantSchedule of Cash ReceiptsFor the Months of May and June  May June Cash sales: $fill in the blank 1 $fill in the blank 2 Checks fill in the blank 3 fill in the blank 4 Total $fill in the blank 5 $fill in the blank 6arrow_forward
- Almost all of the sales revenues of the oxygen equipment are credit card sales; cash sales are negligible. The credit card company deposits 97% of the revenues recorded each day into HealthMart’s account overnight. For the servicing of home oxygen equipment, 60% of oxygen services billed each month is collected in the month of the service, and 40% is collected in the month following the service. Q. Why do HealthMart’s managers prepare a cash budget in addition to the revenue, expenses, and operating income budget? Has preparing the cash budget been helpful? Explain briefly.arrow_forwardRecently Joeey Bidenless the owner of Not Trump Again Inc. has been looking at his books and realizes he needs help. Joeey has hired a recent graduate at a local university in accounting and wants Muchie Faucciie to prepare a cash budget for January. After examining the company’s records, you find the following: a) Cash balance on June 1st is $13,450.  b) Actual sales for November and December are as follows:                                      November                         December Cash sales                $35,000                               $45,000 Credit sales             $55,000                                $85,000 Total sales               $90,000                               $130,000  c) Credit sales are collected over a 3-month period as follows:  i) 50% in the month of sale ii) 30% in the second month iii) 15% in the third month  The sales collected in the third month are subject to a 1.25% late fee, but only half of the affected customers pay the late fee, and…arrow_forwardRecently Joeey Bidenless the owner of Not Trump Again Inc. has been looking at his books and realizes he needs help. Joeey has hired a recent graduate at a local university in accounting and wants Muchie Faucciie to prepare a cash budget for January. After examining the company’s records, you find the following: a) Cash balance on June 1st is $13,450.  b) Actual sales for November and December are as follows:                                      November                         December Cash sales                $35,000                               $45,000 Credit sales             $55,000                                $85,000 Total sales               $90,000                               $130,000  c) Credit sales are collected over a 3-month period as follows:  i) 50% in the month of sale ii) 30% in the second month iii) 15% in the third month  The sales collected in the third month are subject to a 1.25% late fee, but only half of the affected customers pay the late fee, and…arrow_forward
- Lois Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with the following summary information regarding expectations for the month of June. The balance in accounts receivable as of May 31 is $50,000. Budgeted cash and credit sales for June are $149,000 and $598,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Sixty percent of credit sales is collected in the month of sale, and the remainder is collected in the following month. Ms. Bragg's suppliers do not extend credit. Consequently, she pays suppliers on the last day of the month. Cash payments for June are expected to be $706,000. Ms. Bragg has a line of credit that enables the restaurant to borrow funds on demand; however, they must be borrowed on the last day of the month. Interest is paid in cash also on the last day of the month. Ms. Bragg desires to maintain a $39,000 cash balance before the interest payment. Her annual interest rate is 10 percent. Required…arrow_forwardRecently Joeey Bidenless the owner of Not Trump Again Inc. has been looking at his books and realizes he needs help. Joeey has hired a recent graduate at a local university in accounting and wants Muchie Faucciie to prepare a cash budget for January. After examining the company’s records, you find the following: a) Cash balance on January 1st is $13,450. b) Actual sales for November and December are as follows:                                     November                         December Cash sales                $35,000                               $45,000 Credit sales             $55,000                                $85,000 Total sales               $90,000                               $130,000 c) Credit sales are collected over a 3-month period as follows: i) 50% in the month of sale ii) 30% in the second month iii) 15% in the third month The sales collected in the third month are subject to a 1.25% late fee, but only half of the affected customers pay the late fee, and the…arrow_forwardThe Asian Garden, a local Thai restaurant, expects sales to be $720,000 in January. Its average customer restaurant bill is $45. Only 20% of the restaurant bills are paid with cash; 70% are paid with credit cards and 10% w cards. The transaction fees charged by the credit and debit card issuers are as follows: Credit cards: S0.40 per transaction + 2% of the amount charged Debit cards: $0.35 per transaction + 1% of the amount charged Read the requirements. Requirement 1. How much of the total sales revenue is expected to be paid in cash? The total sales revenue expected to be paid in cash isarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub