i thing they wont to do like this

QUESTION 7 Bahrain Duty Free Shop Complex B.S.C. (Bahrain Bourse, #DUTYF) expects the following sales and material payments for the per January till May of the coming year (all numbers are in thousandsy Sales Material Payments January BD 14.000 80 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, 40e are collected one month after the sale. 30e 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 months 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 2000, and its minimum required cash balance is BD 2.500. Compute DUTFY's Cash Receipts (2 marks) Cash Payments (2 marks) and t Cash Flow (1 mark) for March. April and May. de EN 934 cha ision (3) Actual Cash Budgets 13 () FXample... use the Same information of Cash Receipt and Cash Payment in the previous example plus this information, if the Company wish to have minimum lash Balance of $5000 at all times. Required. Prepare the schdul of Cash Budgets from Jan to June. Cash Budgets items Jan feb March April May June Cash Receipt 12600 14000 11000 17.000 23000 16.000 Cash payment (11220) (20452) (14955) (12452) (12452) (27955) wel Cash flow 1380 (6452) (3955) 45487 10548 (11955) Cash -395545 -(4524638 373 + Go + begining last bubuk 5000 16380 5000 5000 hore 11069 Cartulative Cash Bulan 6380, (72) 200+ (72) 1045 95482 (72) 1045 9548 15548 (886) 5000+996 - 9548 $ Monthly Loon 5072 3955 (4548) (4479) 5885 - %27+15) 5106 Cumulative loon 50.725 9027 4479 20 5886 Ending Cash Balance 6380 1000! 5000 5000 5000 11069 5000 EWA 210464 +355 $5.00 924846150) 15543+ (-37) (86) St 5072+ (-12) 5000 -11669 - San o