MaxiTel ltd 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: 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 Sentember 30 is ksh 15.75 million. i) Prepare the schedule of expected cash collections from debtors for the budget period Required: (5 Marks) (4th-quarter ) ii) Prepare the schedule of cash payment to suppliers of inventories for the quarter (5 Marks) (Total: 10 Marhs) MaxiTel ltd 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: 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 ksh27 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 Sentember 30 is ksh 15.75 million. quired: Prepare the schedule of expected cash collections from debtors for the budget period (4th-quarter) (5 Marks) Prepare the schedule of cash payment to suppliers of inventories for the quarter (5 Marks) (Total: 10 Marks)