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
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.
please give me answer in excel.
Bulldogs Inc. deals with various clients throughout the city and is attempting to collect its accounts receivable more efficiently. A major bank has offered a lock-box system for Bulldogs at a cost of P180,000 per year. Bulldogs averages 300 receipts daily at an average of P5,000 each. Short-term interest is at 8% annually. What reduction in average collection time would be needed to justify the lock-box system? (Use a 360-day year)No need to type the word "Days" just the number e.g. X.XX
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
- Inc. deals with various clients throughout the city and is attempting to collect its accounts receivable more efficiently. A major bank has offered a lock-box system for Bulldogs at a cost of P180,000 per year. Inc. averages 300 receipts daily at an average of P5,000 each. Short-term interest is at 8% annually. What reduction in average collection time would be needed to justify the lock-box system? (Use a 360-day year)arrow_forwardIt typically takes Law Corporation 8 days to receive and deposit customer remissions. Law is considering a lockbox system and anticipates that the system will reduce the float time to 5 days. Average daily cash receipts are P220,000. The rate of return is 10 percent. Requirement: What is the reduction in cash balances associated with implementing the system? What is the rate of return associated with the earlier receipt of the funds? What should be the maximum monthly charge associated with the lockbox proposal?arrow_forwardFrom past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?arrow_forward
- The XYZ customer service branch maintains a disbursement account which is funded by the main office. The branch needs funds for daily disbursements of P40,000 and a minimum balance of P20,000. The cost to transfer funds from the main office to the branch averages P300. The return on money marketable securities is 5%. If the entity uses a 250-day year for financial analysis, how much is the optimal cash amount to be requested by the branch each time?arrow_forwardHow do you get the last addition loan and ending cash balance?arrow_forwardPlease Do Not Give Solution In Image Format And Fast Answering Please And explain proper steps by Step.?arrow_forward
- Nonearrow_forwardSmith Inc. currently fills mail orders from all over the country and receipts were received in its head office. The company's average accounts receivable is P3,125,000 and is financed by a bank loan with 10% interest. Smith is considering a regional lockbox system to speed up collections. This system is projected to reduce the average accounts receivable by 15%. The annual cost of the lockbox system is P25,000. What is the estimated net annual savings in implementing the lockbox system? A. 22,985 B. 28,455 C. 25,750 D. 21,875arrow_forwardPrepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…arrow_forward
- Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Donearrow_forwardPlease help me. Thankyou.arrow_forwardA CARDBOARD BOX FACTORY pays its suppliers 40 days after making the purchase and receiving the goods. The average collection period is 45 days, i.e. its customers settle their debt with the company in that time; and the average inventory age is based on the inventory turnover which is 10 times a year. The company spends about $1.23 million in operating cycle investments. With this data we need to calculate: The operating cycle.The cash conversion cycle.The cash turnover.The minimum cash balance.You plan to make modifications to your policies so that you can decrease your PPC by 10 days, and decrease your EPI by 2 times (before converting it to days). Negotiations with your supplier have been unsuccessful and the payment term has been reduced by 10 days. With these data you have to calculate: Re-calculate the Operating Cycle, the SCC, RC and SMC introducing the proposed changes.Calculate the opportunity cost that the changes will cause, if the company's interest rate is 8%.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Inventory management; Author: The Finance Storyteller;https://www.youtube.com/watch?v=DZhHSR4_9B4;License: Standard Youtube License