90.2K

Verified Solution

Link Copied!

someone help me pls..prepare for me the cash budget fir those transactions pls...within a less than a hour.

1. Budgeted sales for the quarter amounts to R998 546.00. (30\% will be sold during January 2021,45% during and the rest during March 2021. 50% of the sales are expected to be made on credit. Debtors usually pay their de 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 2. Purchases are expected to amount to R624091.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. 3. 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. 4. 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. 5. Income tax amounting to R22.694.00 is payable during February 2021 to SARS. 6. Dividends of R17 021.00, declared on 22 January 2021, must be paid during February 2021. 7. The following balances appeared in the books of Kit Kat on 1 January 2021 : Bank (favourable) R529 532.00 Debtors R177 866.00 Creditors R15602300 8. Credit sales were as follows during the previous period: October 2020 R156 023.00 November 2020R93614.00 December 2020 R124 818.00 Required: Prepare Kit Kat's cash budget for the quarter ending 31 March 2021.27 marks) 1. Budgeted sales for the quarter amounts to R998 546.00. (30\% will be sold during January 2021,45% during and the rest during March 2021. 50% of the sales are expected to be made on credit. Debtors usually pay their de 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 2. Purchases are expected to amount to R624091.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. 3. 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. 4. 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. 5. Income tax amounting to R22.694.00 is payable during February 2021 to SARS. 6. Dividends of R17 021.00, declared on 22 January 2021, must be paid during February 2021. 7. The following balances appeared in the books of Kit Kat on 1 January 2021 : Bank (favourable) R529 532.00 Debtors R177 866.00 Creditors R15602300 8. Credit sales were as follows during the previous period: October 2020 R156 023.00 November 2020R93614.00 December 2020 R124 818.00 Required: Prepare Kit Kat's cash budget for the quarter ending 31 March 2021.27 marks)

Answer & Explanation Solved by verified expert

See Answer