to that question is, it depends on whether fixed costs have been recovered by revenue. The contribution margin per FTE is the revenue per FTE minus the variable costs per FTE. The contribution margin covers fixed costs and (hopefully) profit.
What is the budgeted average revenue and expense per average student FTE per year? What is the budgeted contribution margin per FTE per year? How many FTE contribution margins are needed to pay for the full fixed costs in the budget? That answer is the breakeven point in number of average FTEs for the year per the budget.
What is the budgeted breakeven number of FTEs? What is the actual breakeven number of FTEs? Why is the actual breakeven lower than the budgeted breakeven? Why is the actual net income (loss) per FTE different than the budgeted net income per FTE?
Developing the Cost/Volume/Profit Chart
Many times a picture communicates more than words or calculations. A cost/volume/profit chart shows you all the possible profit and loss positions for your business at a particular moment in time. It visually shows you how much profit or loss you would earn for a given number of FTEs. Prepare a cost/volume/profit chart for the Daycare Center using the budgeted data. The possible range of FTEs should be on your x axis; also include dollars showing fixed variable cost, as well as sales by FTEs.
Show the breakeven point in terms of FTEs. What do you estimate the relevant range to be? Prepare a cost/volume/profit chart for the Daycare Center using the forecasted year’s actual six-month data plus your forecasted Q3 and Q4 data to form the year. Show the breakeven point in terms of FTEs. Explain the reasons for the differences between forecast and budget.
Prepare a report for the director that discusses the opportunities for improvement and provide general suggestions of how the financial situation could be improved.
The paper should provide an introduction that explains what you will talk about followed by the details of the current financial situation. Discuss the opportunities for improvement and provide general suggestions of how the financial situation could be improved. Conclude with your recommendations. Be sure to include the following:
A Fixed versus Variable Analysis
Cost Function Analysis:
Calculate the cost function utilizing the following three methods. Provide a discussion of which of the three methods gives the most accurate cost function and why.
Account Analysis Method
Regression Analysis Method
Forecast: Using the Account Analysis Method prepare a forecast for the third and fourth quarters based on current management strategy – include a row for expected FTEs by quarter.
Prepare a Proforma Forecast versus Budget for the current year
Determine Profitability by FTE
Prepare a Cost/Volume/Profit Chart using the budgeted data and one using the forecasted data. Explain any differences. Student
posted a question · Oct 22, 2015 at 7:32am