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)?
-
From your answers on the diversity questionnaire in Table 17.2, what competencies might you need to develop to increase your diversity competency? What action steps do you plan to take? How will...
-
A study by the National Marine Manufacturers Association found that 12.2% of those who participated in sailing were females age 2534. Of those who participated in horseback riding during the same...
-
\(1+2-3=0\) Determine whether each of the following sentence represent a logical statement. If it is a logical statement, determine whether it is true or false.
-
The accounting records of Walls China Shop reflected the following balances as of January 1, 2016: Cash ............ $80,100 Beginning inventory .... 33,000 (220 units @ $150) Common stock...
-
AUDITING CAPITAL ACQUISITIONS AND REPAYMENTS The Government has decided to offer a grant to all small hotels that have a 100 room capacity or less. The Hotel Mingle's audit programme is currently b...
-
Use Nodal Analysis to find Vx, in the circuit. 202 4A -2 A Va VB 50 N 40 2 100 2 25 2 10 A
-
Mr. Basil paid the following amounts to earn his 2021 employment salesman commission income: $2,450 airline tickets; $5,000 country club membership fees; $1600 client meals and entertainment; $700...
-
Discussions about "what I did yesterday, what I will do today and what impediments stand in my way" form the basis of what SCRUM ceremony? List the benefits of Impact Analysis What is Gap Analysis?
-
Fill out the table according to the masonry concrete corporation risk register chart details are in the references. The details are everything in reference what i am having there is no more details...
-
Rotate the given square 30-degree CCW about point (4,5). What is the new coordinate of point A?* (35 Points) D (0,2) A (0,0) A(4.768, -0.330) A(3.036, -1.330) A(3.768, 1.402) A(2.036, 0.402) (2,2) B...
-
Danielle Nguyen (age 65) and Andrew Jones (age 65) were recently married in June of last year. They are residents of Portland, Oregon. This is a second marriage for both. Danielle and Andrew own a...
-
Fix the error compile and run // Program Lablc.java Program Lab1c.java // Demonstrate the use of the Scanner class to read numeric data. import java.util.Scanner; public class LablC { // Calculates...
-
What is the study? What was the purpose of the study/or research question(s)? which test statistic was used. Did they use more than one test statistic? What are the statistical results for all tests?...
-
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...
-
Currently, Jim Morris makes \($100,000.\) Next year his income will be \($120,000.\) Jim is a big spender and he wants to consume \($150,000\) this year. The equilibrium interest rate is 10 percent....
-
Rich Pettit is a miser. His current income is \($50,000;\) next year he will earn \($40,000.\) He plans to consume only \($20,000\) this year. The current interest rate is 12 percent. What will Richs...
-
The following figure depicts the financial situation of Ms. J. Fawn. In period 0 her labor income and current consumption is \($40;\) later, in period 1, her labor income and consumption will be...
Study smarter with the SolutionInn App