Budgeted Cash Collections In an effort to improve cash collection, Suburban Medical Clinic offers terms of 2/10, n/30, with a 5% discount on patient payments made with cash. Suburban estimates its total billings for the second calendar quarter of the year as follows: April, $400,000; May, $480,000; and June, $580,000. Historically, Suburban has had the following patient collection patterns: Portions of Total Sales In month of sale: Cash at time of sale 25% On account during the discount period 20% On account after the discount period 10% In month following sale: On account after the discount period 25% In second month following sale: On account after discount period 15% Average portion uncollectible 5% 100% What would be Suburban’s budgeted total cash collections for June? $ Answer
ANSWER
Budgeted Total Cash Collections for June | ||
Cash sales of June:- | ||
Cash sales ($580,000*25%) | $145,000 | |
Less: Discount on cash payment (145,000*5%) | (7,250) | 137,750 |
Credit sale of June: | ||
During the discount period ($580,000*20%) | 116,000 | |
Less: Discount on credit sale (116,000*2%) | (2,320) | |
113,680 | ||
After the discount period ($580,000*10%) | 58,000 | 171,680 |
Cash collected from the sale of May ($480,000*25%) | 120,000 | |
Cash collected from the sale of April ($400,000*15%) | 60,000 | |
Budgeted total cash collections for June | $489,430 |
Budgeted Cash Collections In an effort to improve cash collection, Suburban Medical Clinic offers terms of...
Budgeted Cash Collections In an effort to improve cash collection, Suburban Medical Clinic offers terms of 2/10, n/30, with a 5% discount on patient payments made with cash. Suburban estimates its total billings for the second calendar quarter of the year as follows: April, $400,000; May, $480,000; and June, $580,000. Historically, Suburban has had the following patient collection patterns: Portions of Total Sales In month of sale: Cash at time of sale 25% On account during the discount period 20%...
In an effort to improve cash collection, Suburban Medical Clinic offers terms of 2/10, n/30, with a 5% discount on patient payments made with cash. Suburban estimates its total billings for the second calendar quarter of the year as follows: April, $400,000; May, $480,000; and June, $580,000. Historically, Suburban has had the following patient collection patterns: Portions of Total Sales In month of sale: Cash at time of sale 25% On account during the discount period 20% On account after...
In an effort to improve cash collection, Suburban Medical Clinic offers terms of 2/10, n/30, with a 5% discount on patient payments made with cash. Suburban estimates its total billings for the second calendar quarter of the year as follows: April, $200,000; May, $240,000; and June, $290,000. Historically, Suburban has had the following patient collection patterns: In month of sale: Cash at time of sale 25% On account during the discount period 20% On account after the discount period 10%...
Prepare a schedule of budgeted cash collections from sales for
May, June, and July. Include a three-month summary of estimated
cash collections.
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: • 60 percent in the month of...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 1...
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales • 60 percent in the month of sale. • 20 percent in the month following sale. • 15 percent in the second month following sale. • 5 percent uncollectible....
Tardis offers a 3% discount to customers who pay cash at the time of sale and a 2% discount to customers who pay within the first 10 days of the month after sale. Past experience shows that cash collections from customers tend to occur in the following pattern: Cash collected at time of sale 55% Collected within cash discount period in first 10 days of month after sale 15% Collected after cash discount period in first month after month of...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 80 percent collected in the month of sale. 10 percent collected in the first month after sale. 5 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible. The sales on account have been budgeted for the last seven months as follows: June July August September October November December $ 126,000 153,500 178,500...
Coyote Loco, Inc., a distributor of salsa, has the following historical collection pattern for its credit sales. 80 percent collected in the month of sale. 10 percent collected in the first month after sale. 5 percent collected in the second month after sale. 4 percent collected in the third month after sale. 1 percent uncollectible The sales on account have been budgeted for the last seven months as follows: $128,000 155,500 180,500 211,000 236,000 261,000 June July August September October...
Budgeting Cash Collections Spencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $150,000 and $170,000, respectively. Analysis of Spencer’s operations indicates that the pattern of customers’ payments on account is as follows (percentages are of total monthly credit sales): Receiving Discount Beyond Discount Period Totals In month of sale 50% 25% 75% In month of following sale 10% 10% 20% Uncollectible accounts, returns, and allowances 5% 100% Determine the estimated cash...