For Cash balance on 1/10/2022 use the last two digits of your ID number in place of XX to arrive at the amount
My last number 57
Please solve conscientiously
6.000 Prepare Cash Budget for the period October, November and December 2022 based on the information given below for Al Maha Company Month-2021 Sales Purchases Wages Sales Expenses (OMR) (OMR) (OMR) (OMR) August 24,000 80.000 12.000 2.500 September 44,000 60,000 10.000 2.600 October 60,000 40.000 8.000 2.000 November 50,000 60.000 3,000 December 80,000 90,000 8.000 2.000 Additional Information: 1) Cash Balance as on 01-10-2022 is OMR 40,0XX 2) 50% of the sales are for cash and 50% for credit. The credit sales are realised after two months. 3) Purchases: Creditors are paid in the same month of purchase 4) Wages are paid in the next month. 5) Sales expenses are paid in the same month 6) Machinery costing OMR 22,000 purchased in October 2022, and paid in December 2022 7) Income from sale of old furniture OMR 15,000 is received in the month of October 2022. 8) Fixed expenses per month OMR 200 9) Sold old car for OMR 1,000 in November 2022 and cash is received after 2 months a. You are required to prepare the cash budget for the company for the period October to December 2022 b. What is the expected amount of cash available on November 2023? OMR_ c. Will there be a necessity for Al Maha Company to take a bank loan or overdraft? If yes, suggest the company as to how much minimum amount has to be taken as loan or overdraft and in which month it will be required. Note: For Cash balance en 1/10/2022 use the last two disits of your ID number in place of XX te arrive at the amount.) CASH BUDGET FOR THE PERIOD OCTOBER TO DECEMBER 2022