Prepare a schedule of cash receipts for May and June.
Explanation of Solution
Cash Receipts: The amount that a company expects to collect from customers during the month, quarter, or year is known as cash receipts.
Prepare a schedule of cash receipts for May and June:
RM Restaurant | ||
Schedule of Cash Receipts | ||
For the Months of May and June | ||
Particulars | May | June |
Cash sales: | 5,850 | 7,280 |
VISA/Master card: | 30,108 | 42,339 |
American Express | 5,897 | 8,292 |
Total | $41,855 | $57,911 |
Table (1)
Working note 1:
Calculate the revised sales estimates:
For April:
For May:
For June:
Working note 2:
Calculate the amount of cash sales:
For May:
For June
Working note 3:
Calculate the amount of cash collection from VISA/Master card:
For May:
Step 1: Calculate the amount of May fee:
Step 2: Calculate the amount of cash collected from VISA/Master card.
Calculate the amount of cash collection from VISA/Master card:
For June:
Step 1: Calculate the amount of June fee:
Step 2: Calculate the amount of cash collected from VISA/Master card.
Working note 4:
Calculate the amount of cash collection from American Express:
For May:
Step 1: Calculate the amount of May fee:
Step 2: Calculate the amount of cash collected from American Express.
Calculate the amount of cash collection from American Express:
For June:
Step 1: Calculate the amount of June fee:
Step 2: Calculate the amount of cash collected from American Express.
Want to see more full solutions like this?
Chapter 8 Solutions
Cornerstones of Cost Management (Cornerstones Series)
- Proposal #2 would establish local collection centers throughout the region to decrease the time it takes to convert credit payments that are mailed in by check to cash. It is estimated that establishing these collection centers would reduce the average collection time by 2 days. 1.If the company currently averages $50,000 in collections per day, how many dollars will this suggested cash management system free up? 2.If all freed up dollars would be used to pay down debt that has an interest rate of 8%, how much money could be saved each year in interest expense? 3 Do the numbers suggest that this new system should be implemented if its total annual cost is $7000? Explain.arrow_forwardSuppose you are planning on transferring your balance of $550 to another credit card. There are two options that you have nar- rowed it down to. One card has a 15% APR, and the other one has a 25% APR. You have carefully considered your budget and decided that you can afford to pay $75 per month until the bal- ance is paid in full. You have also decided that you will not make any additional purchases using the card until they have a $0 balance. Answer the following questions about the credit cards: How much longer will it take to pay off the card with 25% APR? How much more did you pay in total for the 25% APR card?arrow_forwardAnne Teak, the financial manager of a furniture manufacturer, is considering operating a lockbox system. She forecasts that 220 payments a day will be made to lockboxes with an average payment size of $3,300. The bank’s charge for operating the lockboxes is $0.58 a check. Assume an interest rate of 8% and a 365-day year. What reduction in the time to collect and process each check is needed to justify use of the lockbox system? (Do not round intermediate calculations. Round your answer to 2 decimal places.)arrow_forward
- Knights Technologies is considering changing its credit terms from 2/15, n/30 to 3/10, n/30 to speed collections. At present 40% of Knights paying customers take the 2% discount. Under the new terms, discount customers are expected to rise to 50%. Regardless of the credit terms, half of the customers who would not take discount are expected to pay on time, whereas the remainder will pay 10 days late. The change does not involve a relaxation of the credit standards; therefore, bad debts losses are not expected to rise above their present 2% level. However, the more generous cash discount terms are expected to increase sales from P2 million to P2.6 million per year. Knights variable cost ratio is 75%, the interest rate on funds invested in accounts receivable with production and credit sales is 9% and the firms marginal tax rate is 40%. All costs associated with production and credit sales are paid in the day of sales. What is the DSO before and after the change? Calculate the cost of…arrow_forwardLayaway Fees Compute the specified quantity. Layaway plans allow you, for a fee, to pay for an item over a period of time and then receive the item when you finish paying for it. In November 2011, Senator Charles E. Schumer of New York warned that the holiday layaway programs recently reinstated by several popular retailers were, when you took the fees into account, charging interest at a rate significantly higher than the highest credit card rates.t Suppose that you bought a $74 item on November 15 on layaway, with the final payment due December 15, and that the retailer charged you a $5 service fee. Thinking of the fee as interest, what simple interest rate r would you be paying for this layaway plan? (Round your answer to three decimal places.) %arrow_forwardKnights Technologies is considering changing its credit terms from 2/15, n/30 to 3/10, n/30 to speed collections. At present 40% of Knights paying customers take the 2% discount. Under the new terms, discount customers are expected to rise to 50%. Regardless of the credit terms, half of the customers who would not take discount are expected to pay on time, whereas the remainder will pay 10 days late. The change does not involve a relaxation of the credit standards; therefore, bad debts losses are not expected to rise above their present 2% level. However, the more generous cash discount terms are expected to increase sales from P2 million to P2.6 million per year. Knights variable cost ratio is 75%, the interest rate on funds invested in accounts receivable with production and credit sales is 9% and the firms marginal tax rate is 40%. All costs associated with production and credit sales are paid in the day of sales. What is the DSO before and after the change? Calculate the cost of…arrow_forward
- Let's say you showed your friend Cardi all these calculations, and she went, "Man, this is screwed up! Credit cards are a racket!" (Yes, Cardi, they are - if you don't pay your balance in full every month, that is.) But it's not all bad news, you tell Cardi. There is something she can do in order to reduce both her cost of borrowing and the length of time she'll be in debt. What can she do? (check all answers that apply) a. Ask her credit card company to shorten the duration of the loan. b. Make her payments earlier in the month rather than later. c. Transfer the balance to a lower interest card with another bank. d. Complain to the Consumer Financial Protection Bureau. e. Pay more than $400 every month. f. Ask her credit card company to lower the 29% interest rate. g. Occasionally make additional payments to the account.arrow_forwardDorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl’s Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl’s purchases must be paid for during the following month. Koehl pays herself a salary of $4,800 per month, and the rent is $2,000 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $400, but Koehl has agreed to maintain an average bank balance of $6,000—this is her target cash balance. (Disregard the amount in the cash register, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.) The estimated sales and purchases for December, January, and February are shown in the following table. Purchases during November amounted to $140,000. Prepare a cash budget for December, January, and February. Suppose that Koehl starts selling on a credit basis on December 1, giving customers 30 days to pay. All customers accept these terms, and all other facts in the problem are unchanged. What would the company’s loan requirements be at the end of December in this case? (Hint: The calculations required to answer this part are minimal.)arrow_forwardBeneMart, a large national retail chain, is nearing its fiscal year-end. It appears that the company is not going to hit its revenue and net income targets. The company's marketing manager, Ed Mellon, suggests running a promotion selling $50 gift cards for $45. He believes that this would be very popular and would enable the company to meet its targets for revenue and net income. What do you think of this idea?arrow_forward
- Patricia Smith recently leased space in the Southside Mall and opened a new business, Smith's Coi Shop. Business has been good. but Smith frequently runs out of Cash. This has necessitated late payment on certain orders, which in turn is beginning to cause a problem with suppliers. Smith plans to borrow from the bank to have cash as needed. but first she needs a forecast of just how much she must borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Smith's purchases must be paid for during the month following the purchase. Smith pays herself a salary of $4,800 per month and the rent is $2,000 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $400, but Smith has agreed to maintain an average bank balance of $6,000 this is her target cash balance. (Disregard till cash, which is insignificant…arrow_forwardAnne Teak, the financial manager of a furniture manufacturer, is considering operating a lock-box system. She forecasts that 700 payments a day will be made to lock boxes with an average payment size of $3,500. The bank’s charge for operating the lock boxes is $0.50 a check. The interest rate is 0.011% per day. a. If the lock box makes the cash available 2 days earlier, calculate the net daily advantage of the system. (Do not round intermediate calculations.) Anne Teak, the financial manager of a furniture manufacturer, is considering operating a lock-box system. She forecasts that 700 payments a day will be made to lock boxes with an average payment size of $3,500. The bank’s charge for operating the lock boxes is $0.50 a check. The interest rate is 0.011% per day. a. If the lock box makes the cash available 2 days earlier, calculate the net daily advantage of the system. (Do not round intermediate calculations.)arrow_forwardSonata Company is considering changing its credit terms from 2/15, net 30 to 3/10, net 30 in order to speed collections. At present, 40 percent of Sonata Company’s customers take the 2 percent discount. Under the new term, discount customers are expected to rise to 50 percent. Regardless of the credit terms, half of the customers who do not take the discount are expected to pay on time, whereas the remainder will pay 10 days late. The change does not involve a relaxation of credit standards; therefore bad debt losses are not expected to rise above their present 2 percent level. However, the more generous cash discount terms are expected to increase sales from 2 million to 2.6 million per year. Santa Company’s variable cost ratio is 75 percent, the interest rate on funds invested in accounts receivable is 9 per-cent, and the firm’s income tax rate is 40 percent. (Adapted Comprehensive Reviewer in MAS 2010 Edition, Apolinario D. Bobadilla) Determine the following: The days sales…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning