Answered step by step
Verified Expert Solution
Link Copied!

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

 

The Cookie Company Income Statement varıabie costs are given as per unıt amounts ana inaıcated witn (q) tor quantity, tixed 

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

1259307417, 978-1260153132, 1260153134, 978-1259307416

More Books

Students also viewed these Marketing questions

Question

Formulate the maximum flow problem as a linear programming problem.

Answered: 1 week ago