MaxiTel Itd is a professional Catering and event organizing company that operates in Nairobi City and its environs. The company is planning its cash needs for the 4th quarter of the year 2022. The following information has been assembled to assist in cash budget preparation for the 4th quarter: Year 2022 Year- 2023 October November December January Ksh. Ksh. '000' Ksh. '000' Ksh. '000' '000' Sales Cost of sales 45,000 55,000 75,000 50,000 21,000 28,000 42,000 22,000 Gross margin 24,000 27,000 33,000 28,000 Selling and administration expenses Selling expenses 7,000 8,400 11,200 7,300 Admin expenses 5,500 5,900 6,900 5,200 Total selling and administration 12,500 14,300 18,100 12,500 expenses Net operating income 11,500 12,700 14,900 15,500 Additional information: 1. Administration expenses include depreciation of ksh 1,800,000 each month 2. Sales are 10% for cash and 90% on credit. Credit sales are collected over a 3- month period with 30% collected in the month of sale, 50% in the month following sale, and 20% in the second month following sale. August sales totaled ksh 27 million and September sales totaled ksh 33 million. 3. Inventory purchases are paid for within 21 days. Therefore 30% of a month's inventory purchase are paid for in the month of purchase and the remaining 70% paid for in the following month. Accounts payable for inventory purchases as at September 30 totaled ksh 11.1 million. Purchases accrue evenly throughout the month. 4. The company maintains its ending inventory levels at 75% of the cost of the merchandise to be sold in the following month. The merchandise inventory as at September 30 is ksh 15.75 million. Required: i) Prepare the schedule of expected cash collections from debtors for the budget period (4th-quarter) (5 Marks) ii) Prepare the schedule of cash payment to suppliers of inventories for the quarter (5 Marks) (Total: 10 Marks)