In Chapter 08, we learned about Flexible Budgets.

Using the FLEXIBLE BUDGET sample in Chapter 08, , Section 8.1.2, Exhibit 8-3, as your guide, create a flexible budget with two levels of activity.

At a minimum, each level of activity in your budget should have: Sales, Variable Costs, Contribution Margin, Fixed Costs, Operating Income.

This must be created and submitted in Excel with at least TWO cells containing functions/formulas doing the calculations.

This is worth 20 points overall, 10 points for each level of activity.

CHEERFUL COLORS Flexible Budget For the Year Ended December 31, 2025 Budget Amounts per Unit \begin{tabular}{lrrrr} \hline Units (Batches of 100) & & 48,000 & 50,000 & 52,000 \\ \hline Sales Revenue & $7.50 & $360,000 & $375,000 & $390,000 \end{tabular} Variable Costs: Manufacturing: DirectMaterialsDirectLaborVariableOverhead1.753.000.7584,000144,00036,00087,500150,00037,50091,000156,00039,000 Selling and Administrative: CHEERFUL COLORS Flexible Budget For the Year Ended December 31, 2025 Budget Amounts per Unit \begin{tabular}{lrrrr} \hline Units (Batches of 100) & & 48,000 & 50,000 & 52,000 \\ \hline Sales Revenue & $7.50 & $360,000 & $375,000 & $390,000 \end{tabular} Variable Costs: Manufacturing: DirectMaterialsDirectLaborVariableOverhead1.753.000.7584,000144,00036,00087,500150,00037,50091,000156,00039,000 Selling and Administrative