Question

In: Accounting

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, $200,000; May, $240,000; and June, $290,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?

Solutions

Expert Solution

Please comment for any explanation,

Thanks,


Related Solutions

Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 106,000...
Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 106,000 $ 112,000 $ 132,000   Cash payments      For inventory purchases 93,000 75,000 88,000      For S&A expenses 34,000 35,000 30,000      Newman Medical had a cash balance of $11,000 on January 1. The company desires to maintain a cash cushion of $5,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent...
Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000...
Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000 $ 122,000 $ 142,000 Cash payments For inventory purchases 98,000 80,000 93,000 For S&A expenses 39,000 40,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...
Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 101,000...
Newman Medical Clinic has budgeted the following cash flows. January February March   Cash receipts $ 101,000 $ 107,000 $ 127,000   Cash payments      For inventory purchases 90,500 72,500 85,500      For S&A expenses 31,500 32,500 27,500      Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...
Munoz Medical Clinic has budgeted the following cash flows: ***** Can you please explain in detail...
Munoz Medical Clinic has budgeted the following cash flows: ***** Can you please explain in detail – where does the $18,000 come from- This is for the Borrowing (repayment) section**** This is based on the correct answers below according to Connect***? Please explain, I am super confused as to where did $18,000 came from??? January February March Cash receipts $ 110,000 $ 116,000 $ 136,000 Cash payments For inventory purchases 95,000 77,000 90,000 For S&A expenses 36,000 37,000 32,000 Munoz...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience...
Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale 35 percent of credit sales in the first subsequent month 20 percent of credit sales in the second subsequent month 5 percent of credit sales in the third subsequent month...
Based on the data below, with a collection period of 60 days what are cash collections...
Based on the data below, with a collection period of 60 days what are cash collections in Q2? (format $xxx as needed, no cents) Beginning A/R $335 a. Collection Period 45 b. Collection Period 60 c. Collection Period 30 Sales: Q1 $545 Q2 $598 Q3 $575 Q4 $795
X Company has the following budgeted cash flows for January Cash collections    $55,000 Cash Payments...
X Company has the following budgeted cash flows for January Cash collections    $55,000 Cash Payments Inventory 17,000 Operating Expenses 13,000 Capital Expenditures 18,000 If the cash balance is $5,000 on January 1 and the company wants to maintain a minimum cash balance of $5,000, what amount can either be invested or used to pay down existing debt for January?
The Mayo Clinic and IBM have partnered in a venture to improve medical imaging technology. The...
The Mayo Clinic and IBM have partnered in a venture to improve medical imaging technology. The clinic’s current technologies are not keeping up with the intense processing demands required to analyse digital medical images such as x-rays, CT scans, and MRIs. Bradley Erickson, chairman of radiology at the Rochester-based Mayo Clinic, was quoted in Computerworld as saying, "We are facing significant problems in medical imaging because the number of images produced in CT scanners basically tracks Moore’s Law. My eyes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT