Purchase Solution

Charter school: static budget, breakeven, viable, benefits

Not what you're looking for?

Ask Custom Question

This case has two parts.

Part I.
Let's try to apply our knowledge of variable costing and review a sample budget for a charter school. This budget is prepared assuming three levels of student enrollment (66, 100 and 120). Revenue and expenses projections are shown in the budget. Operating assumptions are shown in "Schedule A".

The first requirement of this case relates to the planning function of a budget. Comment on the following relating to the charter school budget:

(1) Is this a static or flexible budget?
(2) What is total revenue (excluding grants) per student?
(3) What are total expenses per student?
(4) Do all expenses seem necessary?
(5) Is this school viable? How many students does the school need to break even (show your calculations with analysis and state your assumptions for break-even)?
(Note: For break even analysis - Ignore revenue received as "Grants" and "Startup Costs" (Schedule A).
(6) What are the general benefits of preparing this budget?
(7) Discuss how this budget is likely to be used for the control function.

Part II.
The second requirement of this case relates to the control function of a budget. Use the background material and Internet to answer the following questions.

(1) Variance analysis is a traditional tool used for planning and control. Comment on advantages and disadvantages of using this approach for performance evaluations.
(2) Do you have any suggestions for complementary or alternative performance measures?

Purchase this Solution

Solution Summary

Your tutorial is 582 words plus schedules in Excel to compute revenue per student, cost per student, total fixed costs and number of students to breakeven.

Solution Preview

Charter School Budget

PART I

(1) Is this a static or flexible budget?

This is a flexible budget because it adjusts the variable expenses expected based on the volume of students. The fixed costs are not sensitive to the volume of students and so do not change between a static and flexible budget.

(2) What is total revenue (excluding grants) per student?

See excel attached.

(3) What are total expenses per student?

See excel attached.

(4) Do all expenses seem necessary?

See excel attached.

(5) Is this school viable? How many students does the school need to break even (show your calculations with analysis and state your assumptions for break-even)?

(Note: For break even analysis - Ignore revenue received as "Grants" and "Startup Costs" (Schedule A).

See excel attached for breakeven analysis.

It takes 85 students to cover the fixed costs ignoring grants. There is a flexible ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations