Please Solve it correctly and step by step :

PLEASE !!!!

4. Mr. X, Manager Green Tea Ltd., requires a Cash Budget for the period April, 2021 to July 2021 (4 months) from the estimated details furnished below: Estimated Sales (Rs.) during 2021: May February March April 12,00,000 10,80,000 9,00,000 9,60,000 June July August 10,80,000 12,00,000 15,00,000 (i) On an average 20% of the sales are on cash basis. The credit sales are realized as follows: 60% of credit sales are realized in the next month and remaining 40% are realized in the following month. (ii) Purchases amount to 70% of the sales of same month. Period of credit allowed by suppliers is 1 month. (iii) Variable expenses constitute 20% of the sales and are paid in the month following the month of sales. (iv) Fixed expense amounts to Rs 70,000 per month. (v) A Machine is expected to be purchased in the month of June for Rs. 3,00,000 for cash. (vi) GST is payable in the month of May amounted to Rs. 1,50,000 (vii) Opening Cash Balance as on 1st April, 2021 is estimated at Rs 1,30,000