Trident ACC403 module 5 case

Case AssignmentThis case has two parts.Part I.Let’s try to apply our knowledge of variable costing and review a .trident.edu/content/enforced/41894-ACC403-NOV2014-1/Modules/Module5/Charter%20School%20Budget%20-%20ACC403%20.xls?_&d2lSessionVal=1B48ncNXHxLazHWzfaFJY7gbH&ou=41894″>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:Is this a static or flexible budget?What is total revenue (excluding grants) per student?What are total expenses per student?Do all expenses seem necessary?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).What are the general benefits of preparing this budget?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.Variance analysis is a traditional tool used for
planning and control. Comment on advantages and disadvantages of using
this approach for performance evaluations.Do you have any suggestions for complementary or alternative performance measures?Assignment ExpectationsIt
is important to answer the questions as posed. The discussion should be
three to five pages and written in a clear and concise manner. Support
your discussion with references in APA format. You are encouraged to use
Excel or other compatible spreadsheet when computations are involved.