The budget performance report will consist of two parts:

1) Excel spreadsheet on Microsoft Excel file

2) Written paper

Below are instructions for each:

1) Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity 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 students 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 12-page paper analyzing the variances and overall performance of the company. Be sure to highlight how different areas of business 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, 2022 *variable costs are given as per unit amounts and indicated with (q) for quantity, fixed components are listed as total dollar amounts