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
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 | |
_____________________________________________
If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.
*****************THANK YOU**************
In an effort to improve cash collection, Suburban Medical Clinic offers terms of 2/10, n/30, with a 5% discount on patie...
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%...
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, $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%...
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...
Budgeting Cash Collections Spencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $112,000 and $128,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% 20% 70% In month of following sale 15% 10% 25% Uncollectible accounts, returns, and allowances 5% 100% Determine the estimated cash...
Budgeting Cash Collection Alexander Rivenburgh Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for March and April of $100,000 and $200,000, respectively. Analysis of the Company's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales). Receiving Discount 50% Beyond Discount Period 25% Totals 75% In month of sale In month following sale 10% 10% 20% Uncollectible accounts, returns 5% Determine the estimated cash collected on...
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...
Budgeting Cash Calle Budgeting Cash Collections Lowell Consulting, which sells on terms 2/10,n/30, had credit sales for March and April of $200,000 and $180,000, respectively. follows (percentages are of total monthly credit sales): In month of sale In month of following sale Uncollectible accounts, returns, and allowances Receiving Discount Beyond Discount Period Totals 400 25% 65% 20% 10% 30% 5% 100% Determine the estimated cash collected on customers' accounts in April. $ 0
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....