Question 1: Malik foods has a following sales forecasts for parts of 2019 and 2020: May 2019 June July August September October November December January 2020 Rs.200,000 300,000 300,000 450,000 520,000 600,000 400,000 400,000 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