Utilizing the financial information below for The Cookie Company, complete a budget performance report combining activity...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these marketing questions
-
In its income statement for the year ended December 31, 2010, Maris Company reported the following condensed data. Instructions (a) Prepare a multiple-step income statement. (b) Calculate the profit...
-
In its income statement for the year ended December 31, 2014, Michael Company reported the following condensed data. Instructions (a) Prepare a multiple-step income statement. (b) Prepare a...
-
Income statement for the year ended December 31, 2008 sales(200,000 units) $1,200,000 - cost of good sold 800,000 - groos profit 400,000 - then operating expenses - selling $280,000 - administrative...
-
Consider a lottery L1 = [0.5, A; 0.5, L2], where U(A) = 4, and L2 = [0.5, X; 0.5, Y] is a lottery, and U(X) = 4, U(Y) = 8. What is the utility of the the first lottery, U(L1)?
-
Mintz agrees to pay Bogg and Heyer $10,000 each for a one-third (33 13 %) interest in the Bogg and Heyer partnership. Immediately prior to Mintzs admission, each partner had a $30,000 capital...
-
Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA formulas.
-
The revenue recognition principle says a. record revenue only after you have earned it. b. record revenue only when you receive cash. c. match revenues and expenses in order to compute net income. d....
-
Youre a supervisor in the treasury department of Big Corp. Recently there has been increasing concern about the firms rising interest expense. Fred Eyeshade is an analyst in your group who...
-
IntFinMgt 8 1. Explain how a MNC could hedge net receivables in euros with futures contracts. 2. Explain how a MNC could hedge net payables in Japanese yen with futures contracts. 3. Explain how a...
-
Toyota Motor Corporation (TM) uses target costing. Assume that Toyota marketing personnel estimate that the competitive, average selling price for the Rav4 in the upcoming model year will need to be...
-
Write a paper about Information security governance & the risk management
-
A bottom chord of a primary indoor roof truss in a resort in Darwin (NT) is made of 90x35 mm seasoned GL12 grade radiata pine. The owner of the building wants to hang a permanent display from the...
-
Compute the entry (2,3) of this matrix-matrix multiplication. -5 9 8-2 -2 0 3 1 C = -9 0-8-2 8-3 -7-9 0 5 9-5-9 3 9-3 2-1 6-8 2 6 3 1 The (2.3) entry of C is c2,3,
-
Skim Holdings Bhd is considering purchasing a new machine with a cost of RM221,000 to increase the crude palm oil production efficiency to increase the demand in the market over the next 5 years. The...
-
After groups lobbying for environmental protection publish an article about the benefits of gasoline powered cars, the government places a price ceiling on gasoline powered cars to encourage...
-
Describe the social media presence of Tshepo Jeans to a non-academic communications professional, as though you subscribe to a positivist worldview. Do not refer directly to positivism or the...
-
For this program, I keep getting a blank /****************************************************************************** Basic Template for our C++ Programs....
-
Study the pictures/images below. Obviously these was focus on LT sociology, anthropology and poltical science. Try to do some analysis by finding clues that are synonymous with the main concepts....
-
Sigma Corporation applies overhead cost to jobs on the basis of direct labor cost. Job V, which was started and completed during the current period, shows charges of $5,000 for direct materials,...
-
Financial data for Joel de Paris, Inc., for last year follow: The company paid dividends of $15,000 last year. The "Investment in Buisson, S.A.," on the balance sheet represents an investment in the...
-
The operations vice president of Security Home Bank has been interested in investigating the efficiency of the banks operations. She has been particularly concerned about the costs of handling...
-
Skim PMIs latest version of OPM3. Summarize key information in this document and your opinion of it in a one-to-two-page paper.
-
What are the new features of Project Professional 2016?
-
Organizations can measure performance against their own past; against peers; and, even better, against __________. A. profits B. potential C. revenues D. the future
Study smarter with the SolutionInn App