Report Writing on Forecasts of Income and Expenditure - Ryde Day Surgery - Finance Assignment Help

Assignment Task-

Question 1-

Below are the forecasts of income and expenditure for the Ryde Day Surgery-

Additional information is as follows:
1. Patients pay two months after they are treated.
2. A loan repayment of $10,000 in due in April.
3. The waiting room will be renovated in January 2018 for a cost of $5,000 which will
be paid in January 2018.
4. Payment for consumables is made two months after they are received.
5. Monthly lease payments of $2,000 for a new car will begin in March 2018
6. Wages are paid on the 1st of the next month.
7. Other expenses are paid one month after they are incurred.
8. The balance of cash in hand on 1st January 2018 is $15,000.

• Prepare a cash budget for the months of January 2018 to April 2018.
• What is the estimated cash balance at the end of April 2018?
• From January 2018, the Day Surgery will collect money from patients in the same month as they are treated. Also from January 2018, the suppliers of consumables want to be paid in the same month as they deliver the consumables. What impact will both changes have on the Surgery’s cashflow? What will be the estimated cash balance at the end of April 2018?
• Write a report to the manager outlining the Day Surgery’s forecast cash position and explain the financial impact of changing the collection and payment conditions as outlined in part c above. You need to compare the new situation with what would have occurred if neither of these changes had occurred. Would the Day Surgery need to borrow money if these changes occurred? Explain your answer.

Question 2-

It is now June and you have been asked to do a budget for The Flu Shot clinic as the flu season will soon begin. The clinic will operate for the months of July and August. As the hospital has no spare space it will rent a room in a nearby shopping center for the clinic. The clinic will also employ a nurse to give the injections and a receptionist to assist with arranging vaccinations. Vaccines are expected to cost $15 per patient. In addition, the clinic will give each patient either regular or glow-in-the-dark band-aids. A regular band-aid is budgeted at $2, while a glow-in-the-dark band aid is budgeted at $3. Children always request glow-in-the-dark band aids. It is anticipated that the clinic will be paid $45 for each child and $30 for each adult that receives vaccinations. During last year’s flu season, the clinic saw 400 adults and 700 children each month and operated for 2 months. The nurse is paid $10 per child and $5 per adult and the receptionist is paid $700 per month. Rent and utilities are $500 per month.

1. Using this information do a budget for the clinic for July and August. You are told to assume that there will be a 10% increase in the number of both children and adults wanting vaccinations this year.
2. The actual results for this clinic are shown below. Management wants to know why the budgeted result and actual results for each month are different. Do a budget variance analysis for each month to identify what caused the actual and budgeted amounts to be different. You are told that in July the clinic saw 500 adults and 900 children, and in August the clinic saw 300 adults and 600 children.
3. Write a brief report to your manager summarising your findings and give recommendations on how to prepare the budget for next year.

T