a) The following information relates to Ada Ltd for Sept to Dec 2023. Sales Purchases (GHS) (GHS)

Sep 60,000 Oct 70,000 Nov 65,000 Dec 90,000 Other Relevant Information: 32,000 60,000 70,000 45,000 i. Forecast sales and purchases for the month of Aug 2023 are GHS60,000 and 28,000 respectively. ii. Wages to be paid to workers GHS 6,000 each month iii. Dividend from Investments amounting to GHS10,000 are expected to be received on 31st Dec. iv. Income tax to be paid in Dec GHS4,000 v. Preference Share Dividend of GHS 5,000 is to be paid on 30th November. vi. Balance at Bank on 1st Sept is expected to be GHS6,000. vii. Equipment of GHS2,000 to be purchased in December. viii. Administrative overheads of GHS4,000; GHS7,000; GHS3,000 and GHS5,000 are expected to be incurred in Sept, Oct, Nov and Dec respectively. This expense includes a monthly depreciation charges of GHS1,400. ix. All transactions are for cash except Purchases and sales. x. Suppliers are expected to grant one-month credit of 50% of the goods supplied whiles 80% of sales are for cash and the remaining receivable in the subsequent month. Required: Prepare a monthly Cash Budget for Sept to Dec 2023.