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)
- Anne 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_forwardYou find yourself in a situation commonly faced by Financial Managers. Your Managing Director thinks business will improve if you change your current policy of cash sales only to allow for credit sales. Currently your annual sales are GH¢6,000. If you offer 30 days credit, you will need to set up a credit department. You expect that it will cost you GH¢2 to run this department monthly. Naturally, you expect all customers to buy on credit for 30 days. You anticipate that 1.5% of credit sales will not be collected. You must also make additional investments in debtors but not in fixed machinery or other overheads by drawing on your credit line with a bank on which you expect to pay 12% per annum interest on amounts drawn. Your cost of sales has been 60% of sales. Additionally, marketing expenses are 25% of sales. If your tax rate is 25% by how much must your sales increase to make this change worthwhile?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
- 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_forwardLet'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_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_forward
- Dorothy 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_forwardPatricia 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_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
- Sonata 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_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_forwardFitzgerald, Incorporated, currently has an all-cash credit policy. It is considering making a change in the credit policy by going to terms of net 30 days. The required return is .67 percent per month. Price per unit Cost per unit Unit sales per month Current New Policy Policy $170 $173 $ 134 $ 137 1,290 1,320 Calculate the NPV of the decision to change credit policies. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV Answer is complete but not entirely correct. $ 646.71arrow_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