PLEASE GIVE ME DETAIL ANSWER WITH EXPLAINATION! THX A LOT.

Additional information

1. All purchases are on credit and accounts payable are paid in the month following the purchase.

2. Salaries for the remainder of the year are expected to be $1,500,000 per month plus twenty per cent of the months billings. Salares are paid in the month of service.

3. The hospitals monthly depreciation charges amount to $125,000.

4. The hospital incurs interest expense of $150,000 per month and makes interest payments on the last day of the quarter (i.e. 31 March, 30 June, 30 September and 31 December).

5. Investment income is $175,000 per month, which is collected one month in arrears.

6. The hospital has a cash balance of $300,000 on 1 July.

7. The hospital has a policy of maintaining a minimum end-of-month cash balance equal to ten percent of the current months purchases.

8. The hospital uses a calendar year (1 January to 31 December) reporting period.

Required

Prepare a cash budget for the last half of the year (i.e. 1 July to 31 December) that includes.

- Budgeted cash receipts broken down by month, by quarter and for the half year. - Budgeted cash payments broken down by month, by quarter and for the half year.

Eighty per cent of the Tonsley Hospital's billings are made to health funds such as Medicare and private health insurance companies. The remaining twenty per cent of billings are made directly to patients. Historical patterns of billing receipts are as follows. The billing and collection patterns identified above were replicated during the first six months of this year. There is no reason to suspect those patterns will not continue during the last six months of the year. Estimated billings for the last six months of the year are listed below. The actual purchases of the past three months and the planned purchases for the last six months of this year are presented in the following schedule. Eighty per cent of the Tonsley Hospital's billings are made to health funds such as Medicare and private health insurance companies. The remaining twenty per cent of billings are made directly to patients. Historical patterns of billing receipts are as follows. The billing and collection patterns identified above were replicated during the first six months of this year. There is no reason to suspect those patterns will not continue during the last six months of the year. Estimated billings for the last six months of the year are listed below. The actual purchases of the past three months and the planned purchases for the last six months of this year are presented in the following schedule