please solve the question without excel. please use the other method.
excel is not allowed
thank you :)
Case Nest (1 marks) Al Zuleika LLC had faced liquidity problems for the past two years. During 2019, the company implemented strict and efficient cash management so that liquidity problem does not arise in the year 2019. The company plans to prepare cash budget for the three months ending December 2019. The following information is furnished to you: Production Overheads in RO) Administration & Selling Costs in RO) Meath in RO) September October November December Credit terms an i. The selling price unit is RO 10 Sales -A credit period of 3 months is allowed to dcbitors 10% of sales are on cash basinan average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following iii. The company's policy is to purchase materials equivalent to 50% of the next month sales. The purchase price of raw material is ROI per Delay in payment to Creditors is 2 months iv. Lag in payment of expenses is only for wage & productie overhead: Wapes month: Production overheads month v Cash and unkce on October RO 12.00 vi. Other information: Plant & Machinery to be installed in August at a cost of RO 24,000. It will be paid for by monthly installment of RO 500 from October 1 Preference share dividenda RO 50,000 to be paid on December Call money on 250 equity shares @RO 2 per share to be received in November Dividends from investments among R 250 we expected to be received on 31 December Income tax advance to be paid in December RO 500 a) You are required to prepare a cash budget B) With reference to the cash budget prepared for Al Zulia LLC, as a management accountant of the company comment on its Cash position at the end of the period and suggest three suitable measures to the management that could be possibly taken in such a situation marks) Che No4(10 marks) Al Zuleika LLC had freed liquidity problems for the past two years. During 2019, the company implemented strict and efficient cash management so that liquidity problem does not wrise in the you 2018. The company plans to prepare a budget for the three months ending December 2019. The following information is furnished to you Sales in unit) Wages Productive RO) Overhead in RO) 650225 750 2 25 Administration & Selling Costs (RO) 150 200 800 0 0 200 December 1000 Credits are The selling price per unit is RO 10 Sales - Acredit period of 3 months is allowed to debtors. 10 % of sales are on cash baris Ona average 50% of credit sales are paid on the due dates while the other 50% we paid in the month following The company's policy is to purchase materials equivalent to 50% of the next month sales. The purchase price of uw material is RO) per unit. Delay in payment to Creditors is 2 months i aginpayment of expenses is only for wages & production overheads: Wayes month Production overheads month Cash and bank balance on October RO 12,500 Other information: Plant & Machinery to be installed in August at a cost of RO 24,000. It will be paid for by monthly installment of RO 500 from October I. > Preference share dividend in RO 50,000 to be paid on December > Call money on 250 equity shares @RO 2 per share to be received in November Dividends from investments mounting to RO 250 are expected to be received on 31 December Income tan c e to be paid in December RO 500 *) You are required to prepare a cash budget ) With Reference to the cash budget prepared for Al Zulia LLC, as a management content of the company commen ts Cashposition at the end of the period and the suitable measures to the management that could be possibly taken in such a situation marks)
