The budgeted transactions of Kit Kat (Pty) Ltd for the first quarter are as follows:

1. Budgeted sales for the quarter amounts to R998 546.00. (30% will be sold during January 2021, 45% during February 2021 and the rest during March 2021.

50% of the sales are expected to be made on credit. Debtors usually pay their debt as follows:

30 % in the month following the month of sales

39 % in the second month following month of the sales

20 % in the third month following the month of the sales

11 % is written off as irrecoverable in the last month of collection

2021:

Bank (favourable)

R529 532.00

Debtors

R177 866.00

Creditors

8.

October 2020

R156 023.00

Credit sales were as follows during the previous period:

R156 023.00

November 2020

R93 614.00

December 2020

R124 818.00

Purchases are expected to amount to R624 091 00 for the quarter. Assume that opening and closing inventories will remain constant and that a constant mark-up percentage is maintained throughout. 53% of all the purchases are made on credit, while creditors are paid in the month following the month in which the purchases were made.

Sales personnel receive a commission of 10% on all sales. Office personnel each receive a salary of R11 347.00 per month. There are 12 office staff members. The commission and salaries are paid in cash every month.

New equipment with a hire purchase price of R199 709.20 will be purchased on 1 February 2021. A deposit of 30 % of the hire purchase price must be paid on 1 February 2021, and the balance must be paid in 65 equal monthly instalments starting on 1 March 2021. R7 396.64 depreciation is to be written off per month.

Income tax amounting to R22 694.00 is payable during February 2021 to

SARS.

Dividends of R17 021.00, declared on 22 January 2021, must be paid during February 2021.

The following balances appeared in the books of Kit Kat on 1 January

Required:

Time left 3:40:55

Prepare Kit Kat's cash budget for the quarter ending 31 March 2021. (27 marks)