helpp

To get a more complete picture of the financial shape of the daycare center, you should prepare a forecast for the remainder of 2020-21, assuming nothing in the cost function is changed by management, by adding estimates for the third and fourth quarters to the actual results for the first two quarters. It looks like SDC enrollment is increasing by approximately six FTEs per quarter. Use 36 FTEs for the third quarter and 34 FTEs for the fourth quarter. The fourth quarter estimate decreases because the budget shows that enrollment is expected to decrease during July and August. You can prepare a pro forma forecast for the year by completing the following table (in Excel; using formulas where appropriate, including to calculate revenue and variable cost). For the third and fourth quarter forecasts, use your quarterly actual cost function developed in step 2 and the forecasted FTE enrollments for quarters 3 and 4 indicated above. Add the original budgeted net income for the year to the bottom of the spreadsheet so that you can compare your forecast for the year to the budget for the year. By how much are you forecasting that SDC will miss its budgeted net income target for the year 2020-21? 6. Evaluating Possible Improvements The Center board has proposed 4 possible improvement initiatives, each of which can be pursued independently of the others. The proposed initiatives are summarized in Exhibit 3. Prepare an analysis (in Excel) showing the impact of each individual proposed improvement on SDC's forecasted net income for 2020-21. It will be helpful to use the contribution margin income statement approach in performing the analysis. You may wish to use the following format to summarize your results