Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity...

 

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

St... View the full answer