You are provided with a Cash Budget of Mbatha Ltd for January to June 2021. The financial year- end is 28 February 2021. Show all calculations. You are required to complete the questions in the answer booklet provided: Additional Information: 1. Total sales for the Budget period is expected to be as follows: January February March April May June 324 000 346 000 360 000 480 000 330 000 ? 2. Cash sales are expected to be 40% of total sales for the entire budget period. 3. Debtors are expected to pay as follows: 50% pay in the same month as the sales transaction (less 5% discount) 30% pay in the month after the sales transaction month 15% pay in the second month after the sales transaction month 5% are expected to be bad and are written off in the third month after the transaction. 4. The current mark-up is 60% on cost. 5. A fixed base stock of raw materials is kept at all times. All raw materials are bought on credit. Creditors are paid in the month following the purchase of stock (i.e. within 30 days) to earn a 10% discount. 6. At the end of the financial year ended 28 February 2021, the return on total capital employed was 5%. Mbatha LTD Cash Budget for the six period January to June 2021 May June April March Jan Receipts Feb 148 800 132 000 192 000 Cash sales 129 600 144 000 138 400 ? ? ? 2 Collection from debtors 188 700 194 370 0 0 Issue of shares 1 300 000 0 0 o o 0 80 000 0 0 0 Sale of Factory Equip Total Receipts ? ? 1 618 300 332 770 ? ? PAYMENTS Payments to creditors 201 563 182 250 185 625 B Salary of Factory Manager 20 000 20 000 20 000 20 000 20 800 20 800 Wages for 20 Direct Labourers 150 000 150 000 150 000 150 000 161 250 161 250 Directors Fees 66 000 66 000 66 000 66 000 66 000 66 000 Interest on loan (8% p.a.) 5 600 5 600 4 200 4 200 4 200 2 700 Repayment of loan 0 0 D 0 0 E Repurchase of Shares 0 0 o ? 0 0 Interim dividends paid 0 0 0 0 F Maintenance of Factory Equip 12 000 12 000 12 000 12 000 2 000 2 000 Electricity (80% for factory) 8 000 8 000 8 000 8 000 6 500 6 500 0 0 0 0 150 000 0 Deposit on new Factory Equip Instalments on new factory Equip (incl finance charges) 0 0 0 0 0 16 000 Independent auditors fees 0 0 0 60 000 0 0 Total Payments ? ? ? ? ? 2. Cash Surplus / Deficit ? ? ? ? ? ? Cash Balance at the beginning of the period ? ? ? ? ? 2 Cash Balance at the end of the period 7 ? ? ? ? ? 3 Calculate the total amount of bad debts that Mbatha Ltd is expecting to write off during the - budget period