This is all the information I have. with the information provided can the cash budget still be created ? Or is the information not enough for that either ?

Speedy Quick Urgent Care Center (SQUC²) is in the process of creating their cash budget for the 2^nd quarter of 2020. 50% of SQUC² sales are from self-pay patients who pay at the time of their service. 25% are from patients covered by Blue Cross who pays the month following the service. The remainder are covered by Medicare who pays 2 months following the service.

Speedy Quick pays their rent of $7,500, which includes utilities, on the first day of every month. Payroll payments, which include fringe benefits, are $20,000 and are paid the 15^th and 30^th of every month. Their supplies, which include office and medical supplies) are purchased monthly from a clinic supply purchasing consortium. Supplies are $5,000 per month. They have anticipated income tax payments of $6,000 due on April 15, October 15^th.

Speedy Quicks sales for the past quarter and anticipated sales for Q2 are as follows:

Jan $70,000

Feb $60,000

March $60,000

Apr $75,000

May $70,000

June $55,000

Speedy Quicks cash balance at the close of business on March 31, 2020 is $60,000. (assume that is after any end of month bills have already been paid.)

Their desired minimum cash balance in their account is $25,000.

1. Create Speedy Quick Urgent Care Centers cash budget for April June, 2020