You are required to prepare the cash budget for the second quarter of the year for DMA for the months of April, May, and June; including the cash collections schedule and cash disbursements schedule. Grades will be awarded as follows: i. Cash Collections Schedule for the second quarter. ii. Cash Disbursements Schedule for the second quarter. iii. Cash Budget for the second quarter.

Sales Forecasts for 2020 in S July 3000 000 August3 000 000 March1 800 000 September3 200 000 April2 200 000October3 200 000 May 2 500 000 Novber 3000 000 June 2 800 000December3 400 000 January1 800 000 Febuary2 000 000 The chief financial manager (CFO) of the company has formed a group of five managerial accountants and the group has been assigned the responsibility for preparing the cash budget of the company in view of the above sales forecasts taking into account the following points 1. DMA has excellent experience in collecting receivables due from debtors. The companys credit policy is to collect 60% of the receivables in the month following the sale, and 38% to be collected in the second month of sale, two months after the sale. The remaining 2% is unlikely to be collected. 2. Purchases of raw material are the largest expenditure of the company, where the cost of these materials is 50% of the total value ofsales in each month. 3. Previous experience with the company's suppliers shows that 80% of the balances of the creditors are paid after one month from the time of purchase. The rest ofthe outstanding balance of 20% will be paid after two months from the date of purchase 4. Direct labour is determined based on the volume of sales and is equal to 20% of the sales of each month, That cost shall be paid in the same month as it is due General and administrative expenses are estimated at $ 2 640 000 per year. This amount includes the items shown in the following table. All expenses are allocated equally during the year with the exception of property taxes, which are paid in 4 equal instalments on the last month of each quarter 5. Annual Expected General and Administration Expenses in S Salaries 480 000 Rent 660 000 Property Taxes 240 000 Insurance 360 000 Utilities 300 000 Depreciation 600 000 6. There is a need to purchase equipment to assist the company in its operations Equipment purchases in April are estimated at 300,000 and $ 346,300 in May. 7. The Company has a policy of maintaining a cash balance at the end of each month of $ 100 000 so that cash is borrowed or invested to reach this amount It is estimated that any excess cash, which the company shall invest will yield a 1% monthly return. This monthly return shall be collected in the month following the investment. On the other hand, any deficit cash shall be borrowed from one ofthe commercial banks at an annual interest rate 12%. The monthly andlor any amounts borrowed, the contract is for 6 months