Is the math in the chart correct? Rhonda runs a six-week summer camp in the North Georgia
Fantastic news! We've Found the answer you've been seeking!
Question:
Is the math in the chart correct?
Transcribed Image Text:
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. CASH BASIS: Revenue Counselor salary expense Supplies expense Utilities, horses, food Profits ACCRUAL BASIS: Revenue Counselor salary expense Supplies expense Utilities, horses, food Profits March $ 8,000 April June $ 32,000 July August $ $ 4,000 Season $40,000 12,000 $12,000 $ 4,000 HIGH ENROLLMENT CASH BASIS: March April Revenue $12,000 June $ 48,000 July Counselor salary expense $ 6,000 $6,000 Supplies expense $ 4,000 $18,000 Utilities, horses, food Profits $ 8,000 $ 32,000 $40,000 ACCRUAL BASIS: $ $ 4,000 $ 12,000 $12,000 $2,350 6,000 $6,000 $19,650 Revenue $12,000 $48,000 Counselor salary expense Supplies expense $ 4,000 Utilities, horses, food Profits August Season $60,000 $12,000 $12,000| $ 4,000 $7,000 $7,000 $37,000 $60,000 $12,000 $12,000| $ 4,000 $7,000 $7,000 $37,000 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. CASH BASIS: Revenue Counselor salary expense Supplies expense Utilities, horses, food Profits ACCRUAL BASIS: Revenue Counselor salary expense Supplies expense Utilities, horses, food Profits March $ 8,000 April June $ 32,000 July August $ $ 4,000 Season $40,000 12,000 $12,000 $ 4,000 HIGH ENROLLMENT CASH BASIS: March April Revenue $12,000 June $ 48,000 July Counselor salary expense $ 6,000 $6,000 Supplies expense $ 4,000 $18,000 Utilities, horses, food Profits $ 8,000 $ 32,000 $40,000 ACCRUAL BASIS: $ $ 4,000 $ 12,000 $12,000 $2,350 6,000 $6,000 $19,650 Revenue $12,000 $48,000 Counselor salary expense Supplies expense $ 4,000 Utilities, horses, food Profits August Season $60,000 $12,000 $12,000| $ 4,000 $7,000 $7,000 $37,000 $60,000 $12,000 $12,000| $ 4,000 $7,000 $7,000 $37,000
Expert Answer:
Answer rating: 100% (QA)
Executive Summary Based on the cash flow and accrual basis profit analysis for a typical summer camp season at low and high enrollment it appears that ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Coffee and Depression . Researchers conducted a study investigating the relationship between caffeinated coffee consumption and risk of depression in women. They collected data on 50,739 women free...
-
Rhonda runs a six - week summer camp in the North Georgia Mountains ( three weeks in June and three weeks in July ) . Between 2 0 and 3 0 campers sign up for the summer, each paying $ 2 , 0 0 0 for...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Quality Athletics Company produces a wide variety of sports equipment. Its newest division, Golf Technology, manufactures and sells a single product AccuDriver, a golf club that uses global...
-
Canadian-controlled private corporations differ from public corporations in the rate of tax, the extent of double taxation, and the degree of secondary relationships with shareholders. Briefly...
-
3.1 (2.7 x) > 1.55 Describe the solution set as an inequality, in interval notation, and on a graph.
-
Assume the following timing of events, and suppose that there are four periods-0, 1, 2, and 3. At date 0, the bank lends an amount I to the borrower, and she invests the entire proceeds from her...
-
A new machine tool is being purchased for $16,000 and is expected to have a zero salvage value at the end of its 5-year useful life. Compute the DDB depreciation schedule for this capital asset....
-
Dorsey Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $315,000 per quarter. For financial reporting...
-
Internal controls play a significant role in the overall performance of an organisation. We have discussed different aspects of internal controls in this unit. Do you think a well-designed internal...
-
What is the difference between expenses and cash flow?
-
What the differences are between federal and state court jurisdiction?
-
Why do recurring revenue and commission-based firms frequently experience losses during periods of rapid sales growth?
-
Discuss the three major factors that affect where an entrepreneur is likely to find financing.
-
When a party may be compelled to defend an action in a particular court?
-
what is the closure plan and encompassing steps for concluding the virtual project while ensuring sustainability and knowledge transfer.
-
Let (x) = x 2 - 9, g(x) = 2x, and h(x) = x - 3. Find each of the following. (((--) 2
-
What is the cost of net debt of a company that has no more shareholders equity equal to? And the cost of capital?
-
Is the cost of capital an accounting or financial concept?
-
What are we forgetting when we say that by increasing return on equity, the leverage effect of debt cannot increase value?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App