can you please answer and explain?

Task 4 A Nuria owns The Academies Travel Agency, in George Street Sydney and is thinking of buying new office fumiture in three months' time (December, 20XX) you have been quoted a total cost of $65,000. The old fumiture will be sold at that time for $3,000. Assume an opening bank balance of $50,000 at the beginning of October. Other details include: 1. lain estimates $70,000 sales for each month. Half these sales are received in cash and half are received in the next month as they are credit sales. October's credit sales from September, amount to $35,000. 2. Purchases amount to 25% of sales (excluding old fumiture) and are paid for in cash. 4. Labour costs are $20,000 each month. Superannuateon ($3,000), rent (3,000), energy bills ($2,000), miscellaneous ($2,500) are all paid monthly. 5. Courier costs to Embassies and customer Documentation amount to $1,000 per month. 6. Rates are paid once in October of $5,000. Requirements: a. Prepare a cash budget for each month for The Academies Travel Agency, with the view to advising Nuria whether she is in a position to pay $65,000 cash for the furniture at the end of the third month (December). Indude also an accurate heading for this cash budget. D. Suppose your balance at end was negative, what (new approaches) actions to rectify the problem would you consider? c. Who would you consult and inform in relation to resource decisions? The Academies Travel Agency Cash budget for the three months ending 31/12/XX October November December Quarter Cash receipts Cash sales Debtors Old Furniture Total cash receipts Cash payments Purchases Labour cost Superannuaten Rent Energy bills Miscellaneous Couriers Rates New Furniture Total cash payments Surplus / Deficit Cash balance at start Cash balance at end TTM_Finance, Assessment Task |_v3 Page 9