Acc105 Managerial Accounting: E9-19 Pletcher Dental Clinic is a medium-sized dental service

Acc105 Managerial Accounting
Pletcher Dental Clinic is a medium-sized dental service specializing in family dental care. The clinic is currently preparing the master budget for the first 2 quarters of 2017. All that remains in this process is the cash budget. The following information has been collected from other portions of the master budget and elsewhere.
Beginning cash balance 30,300
Required minimum cash balance 25,250
Payment of income taxes (2nd quarter) 4,040
Professional salaries:
1st quarter  141,400
2nd quarter 141,400
Interest from investments (2nd quarter) 7,070
Overhead costs:
1st quarter  77,770
2nd quarter 101,000
Selling and administrative costs, including $2,020 depreciation:               
1st quarter  50,500
2nd quarter 70,700
Purchase of equipment (2nd quarter) 50,500
Sale of equipment (1st quarter) 12,120
Collections from clients:               
1st quarter  237,350
2nd quarter 383,800
Interest payments (2nd quarter) 202

Prepare a cash budget for each of the first two quarters of 2017. (Do not leave any answer field blank. Enter 0 for amounts.)