Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 6.34E
Sales and Service Revenues Budget March–-June 2018
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.
- 1. Calculate the cash that HealthMart expects to collect in April, May, and June 2018 from sales and service revenues. Show calculations for each month.
- 2. HealthMart has budgeted expenditures for May of $11,000 and requires a minimum cash balance of $250 at the end of each month. It has a cash balance on May 1 of $400.
- a. Given your answer to requirement 1, will HealthMart need to borrow cash to cover its payments for May and maintain a minimum cash balance of $250 at the end of May?
- b. Assume (independently for each situation) that (1) May total revenues might be 10% lower or that (2) total costs might be 5% higher. Under each of those two scenarios, show the total net cash for May and the amount HealthMart would have to borrow to cover its cash payments for May and maintain a minimum cash balance of $250 at the end of May. (Again, assume a balance of $400 on May 1.)
- 3. 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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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. Calculate the cash that HealthMart expects to collect in April, May, and June 2018 from sales and service revenues. Show calculations for each month.
Based on Robichek et al. (1965). The Korvair Department Store has $100,000 in available cash. At the beginning of each of the next six months, Korvair will receive revenues and pay bills as listed in the file P04_112.xlsx. It is clear that Korvair will have a short-term cash flow problem until the store receives revenues from the Christmas shopping season. To solve this problem, Korvair must borrow money. At the beginning of July, the company takes out a six-month loan. Any money borrowed for a six-month period must be paid back at the end of December along with 9% interest (early payback does not reduce the total interest of the loan). Korvair can also meet cash needs through month-to-month borrowing. Any money borrowed for a one-month period incurs an interest cost of 2.5% per month. Determine how Korvair can minimize the cost of paying its bills on time.
Al Bahr Corporation, a wholesaler, provided the following information
(photo)
Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale. Required: Determine the expected cash collection during April.
Chapter 6 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ch. 6 - What are the four elements of the budgeting cycle?Ch. 6 - Define master budget.Ch. 6 - Strategy, plans, and budgets are unrelated to ore...Ch. 6 - Budgeted performance is a better criterion than...Ch. 6 - Production managers and marketing managers are...Ch. 6 - Budgets meet the cost-benefit test. They force...Ch. 6 - Define rolling budget. Give an example.Ch. 6 - Outline the steps in preparing an operating...Ch. 6 - The sales forecast is the cornerstone for...Ch. 6 - Prob. 6.10Q
Ch. 6 - Define Kaizen budgeting.Ch. 6 - Prob. 6.12QCh. 6 - Explain how the choice of the type of...Ch. 6 - What are some additional considerations that arise...Ch. 6 - Prob. 6.15QCh. 6 - Master budget. Which of the following statements...Ch. 6 - Operating and financial budgets. Which of the...Ch. 6 - Production budget. Superior Industries sales...Ch. 6 - Responsibility centers. Elmhurst Corporation is...Ch. 6 - Cash budget. Mary Jacobs, the controller of the...Ch. 6 - Sales budget, service setting. In 2017 Hart Sons,...Ch. 6 - Sales and production budget. The Coby Company...Ch. 6 - Direct material budget. Dawson Co. produces wine....Ch. 6 - Material purchases budget. The McGrath Company has...Ch. 6 - Revenues, production, and purchases budgets. The...Ch. 6 - Revenues and production budget. Saphire, Inc.,...Ch. 6 - Budgeting; direct material usage, manufacturing...Ch. 6 - Budgeting, service company. Ever Clean Company...Ch. 6 - Budgets for production and direct manufacturing...Ch. 6 - Activity-based budgeting. The Jerico store of...Ch. 6 - Kaizen approach to activity-based budgeting...Ch. 6 - Responsibility and controllability. Consider each...Ch. 6 - Responsibility, controllability, and stretch...Ch. 6 - Cash flow analysis, sensitivity analysis....Ch. 6 - Budget schedules for a manufacturer. Hale...Ch. 6 - Budgeted costs, Kaizen improvements environmental...Ch. 6 - Revenue and production budgets. (CPA, adapted) The...Ch. 6 - Budgeted income statement. (CMA, adapted) Smart...Ch. 6 - Prob. 6.39PCh. 6 - Comprehensive problem with ABC costing. Animal...Ch. 6 - Cash budget (continuation of 6-40). Refer to the...Ch. 6 - Comprehensive operating budget. Skulas, Inc.,...Ch. 6 - Cash budgeting, budgeted balance sheet....Ch. 6 - Comprehensive problem; ABC manufacturing, two...Ch. 6 - Cash budget. (Continuation of 6-44) (Appendix)...Ch. 6 - Budgeting and ethics. Jayzee Company manufactures...Ch. 6 - Kaizen budgeting for carbon emissions. Apex...Ch. 6 - Comprehensive budgeting problem; activity-based...
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
- Northwestern Bank (NB) offers only checking accounts. Customers can write checks and use a network of automated teller machines. NB earns revenue by investing the money deposited; currently, it averages 4.1 percent annually on its investments of those deposits. To compete with larger banks, NB pays depositors 0.3 percent on all deposits. A recent study classified the bank’s annual operating costs into four activities. Activity Cost Driver Cost Driver Volume Using ATM Number of uses $ 1,893,600 3,156,000 uses Visiting branch Number of visits 1,641,600 342,000 visits Processing transactions Number of transactions 8,331,840 126,240,000 transactions Managing functions Total deposits 7,283,200 $ 598,445,000 in deposits Total overhead $ 19,150,240 Data on two representative customers follow: Emily Jacob ATM uses 40 130 Branch visits 5 45 Number of transactions 200 520 Average deposit $ 10,000 $ 10,000 Required: Compute the operating profit for…arrow_forwardNorthwestern Bank (NB) offers only checking accounts. Customers can write checks and use a network of automated teller machines. NB earns revenue by investing the money deposited; currently, it averages 4.1 percent annually on its investments of those deposits. To compete with larger banks, NB pays depositors 0.3 percent on all deposits. A recent study classified the bank’s annual operating costs into four activities. Activity Cost Driver Cost Driver Volume Using ATM Number of uses $ 1,929,600 3,216,000 uses Visiting branch Number of visits 1,857,600 387,000 visits Processing transactions Number of transactions 8,490,240 128,640,000 transactions Managing functions Total deposits 7,315,200 $ 612,270,000 in deposits Total overhead $ 19,592,640 Data on two representative customers follow: Emily Jacob ATM uses 40 130 Branch visits 5 45 Number of transactions 200 520 Average deposit $ 10,000 $ 10,000 Required: Compute the operating profit for…arrow_forwardRock Solid Bank and Trust (RSB&T) offers only checking accounts. Customers can write checks and use a network of automated teller machines. RSB&T earns revenue by investing the money deposited; currently, it averages 6.60 percent annually on its investments of those deposits. To compete with larger banks, RSB&T pays depositors 0.50 percent on all deposits. A recent study classified the bank’s annual operating costs into four activities. Activity Cost Driver Cost Driver Volume Using ATM Number of use $3,600,000 $4,800,000 uses Visiting branch Number of visits 2,160,000 360,000 visits Processing transaction Number of transactions 15,840,000 192,000,000 transactions Managing functions Total deposits…arrow_forward
- Dollar Saver Store is a local discount store with the following information: • October sales are projected to be $300,000. • Sales are projected to increase by 15%in November and another 30% in December and then return to the October level in January. • 20% of sales are made in cash while the remaining 80% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 1% transaction fee, and deposit the net amount (sales price less the transaction fee) in the store's bank account daily. The store does not accept checks. Because of the payment mechanisms, there is no risk of non-payment or bad-debts. • The store's gross profit is 25% of its sales revenue. For the next several months, the store wants to maintain an ending merchandise inventory equal to $12,000 plus 20%of the next month's cost of goods sold. All purchases for merchandise are made on account and paid in the…arrow_forwardRock Solid Bank and Trust (RSB&T) offers only checking accounts. Customers can write checks and use a network of automated teller machines. RSB&T earns revenue by investing the money deposited; currently, it averages 7.20 percent annually on its investments of those deposits. To compete with larger banks, RSB&T pays depositors 0.50 percent on all deposits. A recent study classified the bank’s annual operating costs into four activities. Activity Cost Driver Cost Driver Volume Using ATM Number of uses $ 4,500,000 6,000,000 uses Visiting branch Number of visits 2,700,000 450,000 visits Processing transaction Number of transactions 19,800,000 240,000,000 transactions Managing functions Total deposits 18,000,000 $ 1,125,000,000 in deposits Total overhead $ 45,000,000 Data on two representative customers follow. Customer A Customer B ATM uses 100 200 Branch visits 5 20 Number of transactions 40 1,500…arrow_forwardThe president of the retailer Prime Products has just approached the company's bank with a request for a $93,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $36,000. Accounts receivable on April 1 will total $179,200, of which $153,600 will be collected during April and $20,480 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forward
- The president of the retailer Prime Products has just approached the company's bank with a request for a $91,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $15,800. Accounts receivable on April 1 will total $176,400, of which $151,200 will be collected during April and $20,160 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forwardThe president of the retailer Prime Products has just approached the company's bank with a request for a $77,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $36,600. Accounts receivable on April 1 will total $187,600, of which $160,800 will be collected during April and $21,440 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forwardKent Corner Shoppe is a local convenience store with the following information: October sales were $250,000. Sales are projected to go up by 12% in November and another 30% in December and then return to the October level in January. 20% of sales are made in cash, while the remaining 80% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 2% transaction fee and deposit the net amount (sales price less the transaction fee) in the store’s bank account daily. Kent Corner Shoppe’s gross profit is 25% of its sales revenue. For the next several months, the store wants to maintain an ending merchandise inventory equal to $15,000+15%$15,000+15% of the next month’s cost of goods sold. The September 30 inventory was $43,125. Expected monthly operating expenses include: Wages of store workers are $9,200 per month Utilities expense of $1,000 in November and $1,500 in December Property tax expense of $2,000 per month Property and liability…arrow_forward
- The president of the retailer Prime Products has just approached the company's bank with a request for a $49,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $38,500. Accounts receivable on April 1 will total $148,400, of which $127,200 will be collected during April and $16,960 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forwardThe president of the retailer Prime Products has just approached the company's bank with a request for a $47,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $40,000. Accounts receivable on April 1 will total $145,600, of which $124,800 will be collected during April and $16,640 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forwardThe president of the retailer Prime Products has just approached the company's bank with a request for a $57,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $30,800. Accounts receivable on April 1 will total $159,600, of which $136,800 will be collected during April and $18,240 will be collected during May. The remainder will be uncollectible. ɔ. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Inventory management; Author: The Finance Storyteller;https://www.youtube.com/watch?v=DZhHSR4_9B4;License: Standard Youtube License