Ali foods has a following sales for parts of 2019 and 2020:

May 2019 Rs.200,000 June 300,000 July 300,000 August 450,000 September 520,000 October 600,000 November 400,000 December 400,000 January 2020 300,000

Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 30%; collected the month following the sale, 50%; collected the second month following the sale, 20%. Labor and raw material is estimated as 75% of the next month sales. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials:

Other payments are expected to be as follow: a) General and administrative salaries are approximately Rs.40,000 a month. b) Depreciation charges are Rs.20,000 a month. c) Lease payments under long-term leases are Rs.10,000 a month. d) Miscellaneous expenses are Rs.5000 a month. e) Income tax payments of Rs.50,000 are due in September and December. f) A progress payment of Rs.200,000 on a new design studio must be paid in October. Cash on hand on July 1 will be Rs.150,000, and a minimum cash balance of Rs.100,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b.Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money the firm will need to borrow or will have available to invest.