Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need to calculate the forecast : Actual Quarter 1 Actual Quarter 2 Forecast Quarter 3 Forecast Quarter 4 Forecast Total Year FTEs 25 28 36
Need to calculate the forecast :
| Actual Quarter 1 | Actual Quarter 2 | Forecast Quarter 3 | Forecast Quarter 4 | Forecast Total Year | |
| FTEs | 25 | 28 | 36 | 34 | 31 |
| Revenue | $64,042.00 | $71,358.00 | $317,663.00 | ||
| Variable Cost | $27,826.00 | $26,911.00 | |||
| Fixed Cost | $39,906.00 | $40,182.00 | |||
| Total Cost | $67,732.00 | $67,093.00 | |||
| Net Income | $(3,690.00) | $4,625.00 | |||
| Budget Income | $(676.00) | $6,347.00 | $24,097.00 | $22,309.00 | $52,077.00 |
| Difference | $(3,014.00) | $(2,082.00) |
FTE means full-time-equivalent student (cost driver).
use a quarterly cost function developed from the account analysis method.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started