Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity and revenue and spending variances like that in
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 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. Quantity Sold Sales Cost of Goods Sold Flour Sugar Oil Chocolate Eggs Packaging/Supplies Gross Margin Utilities Insurance Office Supplies Salaries/Wages Commissions Janitorial Expense Rent Repairs Depreciation Marketing Software/IT The Cookie Company Income Statement For the Year Ended December 31, 2022 Human Resources Accounting Fees Other Management Expenses Legal Fees Total Selling & Administrative Expenses Net Operating Income/(Loss) Interest Expense Taxes Net Income/(Loss) $4.50q $0.18q $0.22q $0.12q $0.50q $0.10q $0.19q $ $ $ $ | | | | | | $2,000+ $0.10q $0.25q $ $ $ $ $ $ Budget Information $ $ $ $ $ 2,200 400.00 100.00 100.00 200.00 1,000.00 200.00 150.00 400.00 75.00 45.00 250.00 175.00 100.00 35.00 75.00 Actual Results $ 2,530 $ 10,400.00 800.00 1,200.00 600.00 2,000.00 750.00 850.00 $ 4,200.00 450.00 100.00 122.00 2,600.00 750.00 200.00 1,000.00 260.00 150.00 450.00 20.00 18.00 200.00 150.00 600.00 7,070.00 $ (2,870.00) 35.00 75.00 $ (2,980.00) *variable costs are given as per unit amounts and indicated with (q) for quantity, fixed components are listed as total dollar amounts
Step by Step Solution
★★★★★
3.39 Rating (165 Votes )
There are 3 Steps involved in it
Step: 1
St...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started