how you got these number ?

1) Calculation of Cash Receipts Particulars Mar 21 Apr-21 sales Jul 460.000 65 550 Aug 20 4.80.000 68.400 1.15.000 Sep-20 5,00.000 71.250 120.000 1.84.000 Feb 21 5.00.000 71.250 -15% in Same Month -25% in Next Month 40% after 2 Months - 15% after 3 Months Total Receipts 59 350 Oct20 9.20.000 74,100 125,000 1.92.000 69.000 4,60,100 Nov-20 4,40,000 62,700 1.30,000 2,00.000 72,000 4,64,700 Dec 20 4,00.000 65.550 2.10.000 2.08.000 75.000 4,50.550 Jan 21 450,000 54,125 115.000 1.76,000 7.000 433,125 4 30.000 58 400 15.000 1. 30.000 69.000 4,42,400 May-21 4,00.000 57.000 1.05.000 1.92.000 75.000 4.2.000 Jun-21 3.60.000 51 300 1.100.000 1.68.000 72.000 3,91,300 Jul-21 4,00.000 57.000 90,000 1,60,000 61,000 3,70,000 1.34.000 66.000 433,750 200 000 67.500 427,350 65. 1,83,400 3,75,250 Dec-20 4,50.000 Jul-21 4,00,000 Oct-20 Nov 20 5.20,000 4,40,000 3.52.000 3,68,000 4,16.000 1,52,000 Feb-21 450,000 500.000 400,000 384.000 150.000 40,000 Mar-21 Apr-21 May 21 40.000 420.000 4,00.000 25.000 3.20,000 2.88.000 14.000 LO 20.000 Jun-21 3.60.000 320.000 2,000 3,68.000 120,000 Apr-21 2) Calculation of Payment of Raw Material Particulars Aug 20 Sep-20 4.50.000 4.80.000 5.00.000 Cost of Materials Of Next Month Sales 3.54.000 4,00.000 4.16.000 Cash Paid for Purchases 3,84.800 4,00.000 Calculation of Payment of Production Overheads & Selling Overheads Particulars Jul 20 Aug-20 Sep-20 Sales 4.50 000 4,00.000 5.00.000 Production CH 105 of Sales 5.000 48.000 50.000 70% in Current Month 31.600 35.000 -30% in Next Month 13,300 Cash Pald for Production OH 4.40 Selling OH @5% of Sales 23.000 24.000 25,000 60% in Current Month 14950 15.500 16,250 35% in Next Month 3,050 8.000 Cash Pald for Selling OH 14 21,650 24,650 Dec-20 4.60.000 Mar-21 4.30.000 45,000 42.000 100 May 21 4,00.000 40.000 28.000 12.000 32,200 15.000 10.000 Oct20 Nov-20 5.20,000 4,40,000 52.000 44,000 36,400 30,000 15,000 15,600 51.00 46,00 22.000 16,500 8,750 9,100 25,650 23,600 In Feb-21 450.000 5.00.000 45,000 31,500 35. 13.800 13.500 5,300 e, so 22.500 16.250 8,050 22,675 2015 Jun-21 Jul-21 3.60.000 4,00,000 36.000 40,000 25.200 28,000 12.000 37,20 18,300 18.000 20.000 11 700 13,000 7,000 6,300 18.10 19, 100 45,000 23.000 14,930 7,700 22.10 21.000 14,100 15.000 20.000 13.000 7350 2010 24,350 22.01 Nov 20 3,52,000 Dec 20 3,68.000 Feb 21 400.000 10,000 Apr 21 000 Aug 20 3.84.000 72.000 47.400 21.650 Sep 10 4,00.000 75.000 49.400 TR Mar 21 1.000 72.000 0.000 Oct 20 4,16,000 71.000 51,400 25.650 2.38.000 14.000 1.00 4) Calculation of Cash Disbursement Particulars Payment to Suppliers (WN-2) Wages (15 of Sales Production OH(WN Selling & Distribution Expenses Fred Overheads other than Depreciation) Installment of Tax Total Cash Payments May 21 3.20.000 60.000 40,600 20150 12.200 4.500 46,400 21,400 6.000 45.400 22.000 6,000 45,300 22.67 14.90 Jul 21 3,20,000 60.000 38,300 19.100 6.000 2010 22.00 11700 6.000 6.000 6.000 6.000 1.22110 5,00 5,55.05 5.77.050 4,93,800 5.11.050 5.01,475 S.51.625 SH 4 4,46,950 4,03,200 444,100 300.000 May 21 -7,50 4,29.000 8.16.825 3.91.300 Particulars Opening Cash Add: Cash Received from Customers Add: Share Premium Received Total Cash Available (A) Less: Cash Desbursements Ending Cash Balance (AB) CASH BUDGET FOR THE MONTH OF JULY 20 TO JUNE 21 Aug 20 Sep-20 Oct 20 Nov 20 Dec 20 Feb-21 Mar 21 Apr1 1,91.400 1.56,250 3.16.000 4,53.000-442.100 44,600 3.62.950 6.2.125-7,7237 1,83,400 3,75,250 4,60,100 4,64,700 4,58,550 433,730 4. 42.400 4.47 350 40,000 3,76.800 2.19.000 1,24,050 51,700 16.450 -61,475 -1.29,200 2.40.425 -3.28.025 5.33.650 5.55.050 5,77,050 4,93,800 5.11.050 5.01.475 5.53.625 5.34950 4.70.550 -1.56,250 -3,36.00 4,53,000 4,42,100 4.94.600 -5.62,950 -7,75,375 -2.98.875 2.72.150 -3,69.875 4.46.950 3.16.25 4. 25.525 4.03.900 8,29,425 HCT protected.pdf.pdf Question No 3: (10 Marks) Salalah Mills SAOG wishes to arrange overdraft facilities with its banker - Bank Dhofar during the period July 2020 - June 2021 when it will be manufacturing mostly for stocks. As cash budget is one of the crucial budgets for an organization, as it forecast cash position from time to time for a short period or a long period, as it helps coordinating activities of different segments because entire requirement of liquid funds needs to be taken into account while preparing this budget; as because this characteristic of the cash budget, the Manager of Bank Dhofar asked the CEO of Salalah Mills SAOG to provide a Cash Budget for one year (July 2020-June 2021) to understand the company's cash position at the end of each month for next one year; to decide on overdraft facility to the company. For this purpose, the finance manager of the company asked you to forecasts a monthly cash position for one year based on the following information obtained from the books of accounts. (1) Sales forecast for different months are: Sales Amount in Months Sales Amount in Months OMR OMR 500,000 July 2020 August 2020 September 2020 460,000 480,000 500,000 520,000 440,000 460,000 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 480,000 420,000 400,000 October 2020 November 2020 360,000 400,000 December 2020 January 2021 450,000 (2) Realization from S Page 9 1 14 diely, 25% one month later, MacBook Air CT_protected.pdf.pdf 21 (2) (3) Realization from Sales as follows: 15% immediately, 25% one month later, 40% two months later, 15% three months later and balance represents anticipated bad debts. A 5% discount will be given to customers those paid cash immediately on sales. The company adopts a uniform pricing policy for the materials purchased. The company estimates that cost of materials purchased would be 80% of following month's sales. The payment for purchases will be made in the month following month of receipt of materials. Estimated Direct Wages amount equals to 15% of sales amount. Wages will be paid in the month in which the production occurs. (5) 9 Page (6) (7) Estimated that variable production overheads equals to 10% of sales amount. And, Selling and Distribution overhead at 5% of Sales amount. 70% of Variable Production and 65% Selling and Distribution overheads will be paid in the month in which occurs and reminder will be paid in the subsequent month. Fixed overheads are estimated at OMR 96,000 per annum; are expected to be incurred in equal amounts each month. 60% of the fixed overheads costs will be paid in the month in which they are incurred and 15% in the following month. The balance represents depreciation (8) of noncurrent assets. (9) + due for the previous year The company has Page 114 amounted to OMR 5040 HCT protected.pdf.pdf mturned equal tots each month. 60% of the fixed overheads costs will be paid in the month in which they are incurred and 15% in the following month. The balance represents depreciation of noncurrent assets. (9) The company has to pay the last installment of tax due for the previous year amounted to OMR 50,000 on 1st July 2020. (10) Share premium at 10% on OMR 400,000 Equity shares to be received on 1st November 2020. (11) Estimated cash balance on 1st July 2020 is OMR 300,000 **Use Formatting Instructions for the construction of Table: Text Font: Calibri Font Size: 12 Column width: Column 4 - 30; Column B-10; Columns C to 0-12 Row Height: 25 Amounts category -Number; Decimal Place -2, Use 1,000 separator Use formula wherever required