Below are instructions for each:

$1)$ Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity variances and revenue and spending variances like that in Exhibit $9-8$ on page $462$ of the textbook. Please be sure to include Favorable vs$.$ Unfavorable indicators for each variance. The report must be created from scratch in Excel. Each student's report should be completely unique even if following similar formats. Formulas MUST be used for ALL calculations, and the final submission must be made in Excel to grade calculations properly.

$*$Feel free to email me your Excel spreadsheet to check your calculations before starting the written paper. I am happy to offer feedback before continuing the project, and this will also help ensure a better final grade.

$2)$ After completing the spreadsheet, write a $1-2-$page paper analyzing the variances and overall performance of the company. Be sure to highlight how different areas of business $($i$.$e$.$ marketing, $\backslash ($ H R $\backslash ),$ supply chain, etc.$)$ contribute to the overall success or failure of the business. Feel free to make up or assume additional information about the company that is not provided to support your evaluation, as long as it is consistent with the financial data. It is recommended to use $12-$pt$.$ font $($Times New Roman, Calibri, or Arial$)$ and be double$-$spaced with one$-$inch margins. The Cookie Company

Income Statement

For the Year Ended December $31,2024$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|\}$

$\backslash$hline & Budget Information & Actual Results $\backslash \backslash$

$\backslash$hline Quantity Sold & $2,200$ & $2,700\backslash \backslash$

$\backslash$hline Sales & $\backslash$$$4\mathrm{.}50$q & $\backslash$$ $11,200\mathrm{.}00\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{3\}\{|$l$|\}\{$Cost of Goods Sold$\}\backslash \backslash$

$\backslash$hline Flour & $\backslash$$$0\mathrm{.}16$q & $\backslash$$ $800\mathrm{.}00\backslash \backslash$

$\backslash$hline Sugar & $\backslash$$$0\mathrm{.}22$q & $1,200\mathrm{.}00\backslash \backslash$

$\backslash$hline Oil & $\backslash$$$0\mathrm{.}12$q & $600\mathrm{.}00\backslash \backslash$

$\backslash$hline Chocolate & $\backslash$$$0\mathrm{.}50$q & $2,000\mathrm{.}00\backslash \backslash$

$\backslash$hline Eggs & $\backslash$$$0\mathrm{.}10$q & $750\mathrm{.}00\backslash \backslash$

$\backslash$hline Packaging$/$Supplies & $\backslash$$$0\mathrm{.}19$q & $850\mathrm{.}00\backslash \backslash$

$\backslash$hline Gross Margin & & $\backslash$$ $5,000\mathrm{.}00\backslash \backslash$

$\backslash$hline Utilities & $\backslash$$ $400\mathrm{.}00$ & $450\mathrm{.}00\backslash \backslash$

$\backslash$hline Insurance & $\backslash$$ $100\mathrm{.}00$ & $100\mathrm{.}00\backslash \backslash$

$\backslash$hline Office Supplies & $\backslash$$ $100\mathrm{.}00$ & $122\mathrm{.}00\backslash \backslash$

$\backslash$hline Salaries$/$Wages & $\backslash$$$2,000+\backslash$$$0\mathrm{.}10$q & $2,600\mathrm{.}00\backslash \backslash$

$\backslash$hline Commissions & $\backslash$$$0\mathrm{.}25$q & $750\mathrm{.}00\backslash \backslash$

$\backslash$hline Janitorial Expense & $\backslash$$ $200\mathrm{.}00$ & $200\mathrm{.}00\backslash \backslash$

$\backslash$hline Rent & $\backslash$$ $1,000\mathrm{.}00$ & $1,000\mathrm{.}00\backslash \backslash$

$\backslash$hline Repairs & $\backslash$$ $200\mathrm{.}00$ & $260\mathrm{.}00\backslash \backslash$

$\backslash$hline Depreciation & $\backslash$$ $150\mathrm{.}00$ & $150\mathrm{.}00\backslash \backslash$

$\backslash$hline Marketing & $\backslash$$ $400\mathrm{.}00$ & $450\mathrm{.}00\backslash \backslash$

$\backslash$hline Software$/$IT & $\backslash$$ $75\mathrm{.}00$ & $20\mathrm{.}00\backslash \backslash$

$\backslash$hline Human Resources & $\backslash (\backslash$$ $45\mathrm{.}00\backslash )$ & $18\mathrm{.}00\backslash \backslash$

$\backslash$hline Accounting Fees & $\backslash$$ $250\mathrm{.}00$ & $200\mathrm{.}00\backslash \backslash$

$\backslash$hline Other Management Expenses & $\backslash$$ $175\mathrm{.}00$ & $150\mathrm{.}00\backslash \backslash$

$\backslash$hline Legal Fees & $\backslash$$ $100\mathrm{.}00$ & $800\mathrm{.}00\backslash \backslash$

$\backslash$hline Total Selling $\backslash$& Administrative Expenses & & $\backslash (7,270\mathrm{.}00\backslash )\backslash \backslash$

$\backslash$hline Net Operating Income$/($Loss$)$ & & $\backslash$$ $\backslash ((2,270\mathrm{.}00)\backslash )\backslash \backslash$

$\backslash$hline Interest Expense & $\backslash$$ $35\mathrm{.}00$ & $35\mathrm{.}00\backslash \backslash$

$\backslash$hline Taxes & $\backslash (\backslash$$ $75\mathrm{.}00\backslash )$ & $75\mathrm{.}00\backslash \backslash$

$\backslash$hline Net Income$/($Loss$)$ & & $\backslash$$ $\backslash ((2,380\mathrm{.}00)\backslash )\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$*$variable costs are given as per unit amounts and indicated with $($q$)$ for quantity, fixed components are listed as total dollar amounts