Question
You are the manager of Pools Galore who are in the business of selling inground pools and landscaping to high end customers. At 1
You are the manager of Pools Galore who are in the business of selling inground pools and landscaping to high end customers. At 1 January 2021, the business had a bank balance of $124,000. Provided below are estimates for receipts and payments for the three months ending 31 March 2021. Pools Galore Receipts Sales Proceeds from the sale of old non-curent assets Payments Salaries and wages Supplies New equipment Purchase of plants Sales are received as follows: 50% in month of sale 30% in month following sale 20% in second month following sale January February March $ $ $ 380,000 420,000 500,000 175,000 165,000 180,000 205,000 35,000 40,000 27,500 275,000 105,000 115,000 130,000 Required (approximately 250 words): a) You are to prepare a monthly cash budget for the three months ending 31 March 2021 to calculate an expected cash at bank figure which your accountant will review. Please ensure you include an overall total column and show all your workings as marks are allocated between workings and the final answer. Note: It is recommended you compile your cash budget in excel and copy it into your word report.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started