Good day, please help me with a Management Accounting question. Cash Budget. I am doing exam prep and get a negative answer on all three years.

QUESTION 1 [3D MARKS] The city of Wakanda had the folbwing sales of water for the selected months of 2004: Month Sales in R January 50 000 Februaryr 45 UDEI March 60 DDU April 42 500 May ro 000 June 120 Dl] All sales are on credit. Historically, 50 percent is collected in the month of sale, 35 percent during the rst month following the sale, and 15 percent in the second month following the sale. Cost of water averages 75 percent of sales. 1Water is purchased in the month of sale. All purchases are paid during the month folbwing the purchase. Operating costs of R40 000 are paid each month. The March 1 cash balance is expected to be the minimum balance of R5 000. Money can be borrowed from a local bank in increments of R1 000. (Do not include interest charges in your budget.) Reguired: Prepare a cash budget for March, April, and May