Cash budget. Jim Zeeman Clinic provided the financial information in Exhibit 5.14. Calculate a cash budget for the clinic for the quarter ending March 20X1.

Revenues and Expenses Patient Revenues, Estimated Patient 20XO Revenues, 20X1 Given 1 October $4,500,000 Given 2 January $5,100,000 November $4,700,000 February $5,500,000 December $5,100,000 March $5,800,000 Other Revenues, Estimated Cash 20X1 Outflows, 20X13 Given 3 |January $82,000 Given 4 |January $3,400,000 February $140,000 February $3,600,000 March $220,000 March $4,000,000 April $4,600,000 Receipt of Payment for Patient Ending Cash Balances Revenues and Services Given 6 December $1,300,000 Given 5 Current month of service 60% 20XO 40% Ist month of prior service 30% 2nd month of prior service 10% 3rd+ months of prior service 0% "Cash outflows"for the current month. 'The ending balance for each month as a percentage of the estimated cash outflows for the next month