Rhonda runs a six$-$week summer camp in the North Georgia Mountains $($three weeks in June and three weeks in July$).$ Between $20$ and $30$ campers sign up for the summer, each paying $$2,000$ for the six$-$week session. She receives $20\%$ as a down payment in March when the campers book their summer camp and the remainder on arrival at the camp for the summer in June. Rhonda pays her four counselors $$3,000$ each in August. Rhonda buys the supplies for camp for cash in April, costing $$4,000.$ At the end of June, Rhonda normally has about $$2000$ of supplies left over and at the end of July, Rhonda had $$350$ of supplies leftover if there are fewer campers and none left over with more campers enrolled. Utilities, horse feed, food are charged to the camp$$s mastercard and paid at the end of August, totaling $$6,000-$$$7,000,$ depending on attendance, used evenly in each week of the sessions.

Rhonda wants to buy a used bus for fieldtrips, costing $$37,000,$ but the bank requires an accrual basis and cash basis analysis for the summer camp to show she can pay back the loan in two years, even at lower enrollment levels. Please prepare a cash flow and accrual basis profit analysis for a typical summer camp season at low and high enrollment. Using these schdules, explain to Rhonda if she will likely be able to pay back the loan. Rhonda is busy so be brief and get to the point, including a clear schedule to support your points. A starter executive summary memo is provided to give you an idea of what Rhonda needs. The missing parts you complete. Edit and adjust to fit your results and ideas.