Q11 Fill the tables

Please solve all its one question

Candlyicious, a candy show in Dubai expects the following sales and material payments for the period January till May of the coming year (all numbers are in thousands): Sales Material Payments January BD 14,000 BD 18,000 February 30,000 21,000 March 46,000 19,100 April 22,000 22,400 May 18,000 14,000 The company notes that historically 30% of sales are for cash, 40% are collected one month after the sale, 30% are collected in the second month after the sale. Material payments are paid in the same month of incurrence. Labor expenses are 5% of the month's sales. Rent payments are BD 1,200 per month. Capital investment of BD 25000 is expected in May. The firm's ending cash balance in February was BD 2000, and its minimum required cash balance is BD 2.500. Compute Candylicious' Cash Receipts (2 marks) -Cash Payments (2 marks) and Net Cash Flow (1.5 mark) for March, April and May. Cash Receipts May March April Total cash receipts (2 marks) The company Totes that storically 30% orsales are for cash 4070 are collected one month after the sale 076 are collected in the second mononanter the sale. Material payments are paid in the same month of incurrence. Labor expenses are 5% of the month's sales. Rent payments are BD 1,200 per month. Capital investment of BD 25000 is expected in May. The firm's ending cash balance in February was BD 2000, and its minimum required cash balance is BD 2,500. Compute Candylicious' Cash Receipts (2 marks) -Cash Payments (2 marks) and Net Cash Flow (1.5 mark) for March, April and May. Cash Receipts March April May Total cash receipts (2 marks) Cash Payments March Total payments (2 marks) Candlyicious Net Cash Flow (Cash Budget) March Net Cash flow (1.5 marks) April April May May