Graded Ch 8 work submitted via Blackboard 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: o Sales, o Variable Costs on a per unit basis o Variable Costs on a percentage of sales basis o Contribution Margin o Fixed Costs o 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. When your file is ready to su mit, click on "Graded: Ch 08 Flexible Budget submitted via Blackboard" above. In the next screen, attach your file. Begin a few days prior to the deadline so you can contact your instructor with questions.

Graded Ch 8 work submitted via Blackboard In Chapter 08, we learned about Flexible Budgets. Using the FLEXIBLE BUDGET sample in Chapter 0B, , Section 8.1.2, Exhibit 8-3, as your guide, create a flexble budget with two levels of activity. At a minimum, each level of activity in your budget should have: - Sales. - Variable Costs on a per unit basis - Variable Costs on a percentage of sales basis - Contribution Margin - Fixed Costs - Operating income This must be created and submitted in Excel with at least TWO cells containing functionsilormulas doing the calculations. This is worth 20 points overall, 10 points for each lovel of activity. When your file is ready to submit, click on "Graded: Ch oe Flexble Budget submitted via Blackboard" above. in the next screen, attach your file. Begin a few days prior to the deadine so you can contact your instructor with questions: xhibit M:8-3 lexible Budget CHEERFUL COLORS . Flexible Budget For the Year Ended December 31, 2025 \begin{tabular}{|c|c|c|c|c|} \hline & \begin{tabular}{l} Budget \\ Amounts \\ per Unit \end{tabular} & & & \\ \hline Units (Batches of 100 ) & & 48,000 & 50,000 & 52,000 \\ \hline Sales Revenue & $7.50 & $360,000 & $375,000 & $390,000 \\ \hline \multicolumn{5}{|l|}{ Variable Costs: } \\ \hline \multicolumn{5}{|l|}{ Manufacturing: } \\ \hline Direct Materials & 1.75 & 84,000 & 87,500 & 91,000 \\ \hline Direct Labor & 3.00 & 144,000 & 150,000 & 156,000 \\ \hline Variable Overhead & 0.75 & 36,000 & 37,500 & 39,000 \\ \hline \multicolumn{5}{|l|}{ Selling and Administrative: } \\ \hline Supplies & 5% of sales & 18,000 & 18,750 & 19,500 \\ \hline Total Variable Costs & & 282,000 & 293,750 & 305,500 \\ \hline Contribution Margin & & 78,000 & 81,250 & 84,500 \\ \hline \multicolumn{5}{|l|}{ Fixed Costs: } \\ \hline Manufacturing & & 25,000 & 25,000 & 25,000 \\ \hline Selling and Administrative & & 22,500 & 22,500 & 22,500 \\ \hline Total Fixed Costs & & 47,500 & 47,500 & 47,500 \\ \hline Operating Income & & $30,500 & $33,750 & $37,000 \\ \hline \end{tabular} Sheet1 Graded Ch 8 work submitted via Blackboard In Chapter 08, we learned about Flexible Budgets. Using the FLEXIBLE BUDGET sample in Chapter 0B, , Section 8.1.2, Exhibit 8-3, as your guide, create a flexble budget with two levels of activity. At a minimum, each level of activity in your budget should have: - Sales. - Variable Costs on a per unit basis - Variable Costs on a percentage of sales basis - Contribution Margin - Fixed Costs - Operating income This must be created and submitted in Excel with at least TWO cells containing functionsilormulas doing the calculations. This is worth 20 points overall, 10 points for each lovel of activity. When your file is ready to submit, click on "Graded: Ch oe Flexble Budget submitted via Blackboard" above. in the next screen, attach your file. Begin a few days prior to the deadine so you can contact your instructor with questions: xhibit M:8-3 lexible Budget CHEERFUL COLORS . Flexible Budget For the Year Ended December 31, 2025 \begin{tabular}{|c|c|c|c|c|} \hline & \begin{tabular}{l} Budget \\ Amounts \\ per Unit \end{tabular} & & & \\ \hline Units (Batches of 100 ) & & 48,000 & 50,000 & 52,000 \\ \hline Sales Revenue & $7.50 & $360,000 & $375,000 & $390,000 \\ \hline \multicolumn{5}{|l|}{ Variable Costs: } \\ \hline \multicolumn{5}{|l|}{ Manufacturing: } \\ \hline Direct Materials & 1.75 & 84,000 & 87,500 & 91,000 \\ \hline Direct Labor & 3.00 & 144,000 & 150,000 & 156,000 \\ \hline Variable Overhead & 0.75 & 36,000 & 37,500 & 39,000 \\ \hline \multicolumn{5}{|l|}{ Selling and Administrative: } \\ \hline Supplies & 5% of sales & 18,000 & 18,750 & 19,500 \\ \hline Total Variable Costs & & 282,000 & 293,750 & 305,500 \\ \hline Contribution Margin & & 78,000 & 81,250 & 84,500 \\ \hline \multicolumn{5}{|l|}{ Fixed Costs: } \\ \hline Manufacturing & & 25,000 & 25,000 & 25,000 \\ \hline Selling and Administrative & & 22,500 & 22,500 & 22,500 \\ \hline Total Fixed Costs & & 47,500 & 47,500 & 47,500 \\ \hline Operating Income & & $30,500 & $33,750 & $37,000 \\ \hline \end{tabular} Sheet1