Question: Below are instructions for each: Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity variances and revenue and

Below are instructions for each:
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.
The Cookie Company
Income Statement
For the Year Ended December 31,2024
\table[[,Budget Information,Actual Results],[Quantity Sold,2,200,2,700],[Sales,$4.50q,$ 11,200.00],[Cost of Goods Sold],[Flour,$0.16q,$ 800.00],[Sugar,$0.22q,1,200.00],[Oil,$0.12q,600.00],[Chocolate,$0.50q,2,000.00],[Eggs,$0.10q,750.00],[Packaging/Supplies,$0.19q,850.00],[Gross Margin,,$ 5,000.00],[Utilities,$ 400.00,450.00],[Insurance,$ 100.00,100.00],[Office Supplies,$ 100.00,122.00],[Salaries/Wages,$2,000+ $0.10q,2,600.00],[Commissions,$0.25q,750.00],[Janitorial Expense,$ 200.00,200.00],[Rent,$ 1,000.00,1,000.00],[Repairs,$ 200.00,260.00],[Depreciation,$ 150.00,150.00],[Marketing,$ 400.00,450.00],[Software/IT,$ 75.00,20.00],[Human Resources,$ 45.00,18.00],[Accounting Fees,$ 250.00,200.00],[Other Management Expenses,$ 175.00,150.00],[Legal Fees,$ 100.00,800.00],[Total Selling & Administrative Expenses,,7,270.00],[Net Operating Income/(Loss),,$ (2,270.00)
PLEASE SHOW IN EXCEL, WITH FORMULAS AND CELL REFERNCES
Below are instructions for each: Utilizing the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!