Please fill out the excel sheet below completely: Cakes Sold per day Average Retail per Cake Cakes
Fantastic news! We've Found the answer you've been seeking!
Question:
Please fill out the excel sheet below completely:
Transcribed Image Text:
Cakes Sold per day Average Retail per Cake Cakes Sold per year Gross Sales (year) ¡Rent ¡Utilities ¡Labor COGS (50% of Gross Sales) Total Cost Net Income Margin Cakes Sold per day Average Retail per Cake Cakes Sold per year YEAR ONE Gross Sales Rent (3% escalation) Utilities (3% escalation) Labor (5% escalation) COGS (50% of Gross Sales) Total Cost Net Income Margin Start-up Cost Left $ $ LA LA LA $ $ 7.SSA LA ? $ $ $ Break-even ? ? 310,600.00 38,644.00 594,750.00 ? ? ? ? Year One ? 100 Lets start with this assumption 80.00 ? ? 310,600.00 38,644.00 594,750.00 ? ? ? 100.0 80.00 Year Two Growth Rate Year Three 10.0% We will start with this assun Year Four Year Five Cakes Sold per day Average Retail per Cake Cakes Sold per year Gross Sales (year) ¡Rent ¡Utilities ¡Labor COGS (50% of Gross Sales) Total Cost Net Income Margin Cakes Sold per day Average Retail per Cake Cakes Sold per year YEAR ONE Gross Sales Rent (3% escalation) Utilities (3% escalation) Labor (5% escalation) COGS (50% of Gross Sales) Total Cost Net Income Margin Start-up Cost Left $ $ LA LA LA $ $ 7.SSA LA ? $ $ $ Break-even ? ? 310,600.00 38,644.00 594,750.00 ? ? ? ? Year One ? 100 Lets start with this assumption 80.00 ? ? 310,600.00 38,644.00 594,750.00 ? ? ? 100.0 80.00 Year Two Growth Rate Year Three 10.0% We will start with this assun Year Four Year Five
Expert Answer:
Answer rating: 100% (QA)
Here is the completed Excel sheet YEAR ONE Cakes Sold per day 100 Average Retail per Cake 5 Cakes So... View the full answer
Related Book For
Human Resource Management
ISBN: 978-0538453158
13th Edition
Authors: Robert L. Mathis, John H. Jackson
Posted Date:
Students also viewed these finance questions
-
Explain the challenges faced by managerial accountants in effectively communicating managerial accounting information to various interested users.
-
Exercises 36 and 38 discussed the challenges faced by the Red Cross in finding enough blood of various types. But blood typing also depends on the Rh factor, which can be negative or positive. Here...
-
Explain the challenges faced by managerial accountants in effectively communicating managerial accounting information to various interested users.
-
In 1789, Henry Cavendish estimated the density of the earth by using a torsion balance. His 29 measurements follow, expressed as a multiple of the density of water. (a) Calculate the sample mean,...
-
In order of importance in your opinion, list six techniques or activities widely used to alter an organizations culture.
-
While shopping for an air conditioner, Adam Bryer consulted the following table, which gives a machines BTUs and the square footage (ft 2 ) that it would cool. a. Find the equation for the least...
-
Give some patterns or red flags of financial statement fraud.
-
Enterprise Fund Journal Entries and Financial Statements. Following is the June 30, 2010, statement of net assets for the City of Bay Lake Water Utility Fund. Required a. For fiscal year 2011,...
-
A 35-year-old woman decides to put funds into a retirement plan. She can save $1,000 a year and earn 5 percent on this savings. How much will she have accumulated if she retires at age 65?Round your...
-
Lansing Company's current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December...
-
Debt: $3,000,000 par value of 9%, 9-year bonds outstanding withan annual before-tax yield to maturity of 7.67% on a new issue.Common stock: 70,000 shares outstanding currently selling for$50 per sh 2...
-
Benoit Company produces three products-A, B, and C. Data concerning the three products follow (per unit): Product B Selling price Variable expenses: Direct materials Other variable expenses Total...
-
Jackson Autos has one employee. As of March 30, their employee had already earned $6,120. For the pay period ending April 15, their employee earned an additional $2,040 of gross wages. Only the first...
-
Laura currently manages the polished chrome division of Blue Broadway, a business that specializes in ceiling light fixtures. Its performance has been stable for the past few years. However, the...
-
Use the following consolidated balance sheet for Campbell Soup Company annual report. CAMPBELL SOUP COMPANY Consolidated Balance Sheets (Millions, except per share amounts) Current assets July 30,...
-
A 6-L ideal gas with y = 1.5 is at 300 K and 100 kPa. The gas is compressed adiabatically until its volume becomes 3.2 L, then cooled at constant pressure back to 300 K, and finally allowed to expand...
-
Clear solution and clear format please . 32. LO.5 (Product profitability) Rice Inc. manufactures lawn mowers and garden trac- tors. Lawn mowers are relatively simple to produce and are made in ...
-
Explain the term "Equivalent Units". Why are they calculated in process costing? [4 Marks] [minimum 350 words]
-
Discuss how NOVs efforts combine different phases of talent management to reach a successful result.
-
Your company now has more than 60 employees. The controller has been handling all of the HR functions including administration of the companys benefits. The benefits package includes health, dental,...
-
The power of HR metrics and analytics is an untapped resource for many organizations. Human resource information systems (HRIS) are commonly used to capture and store gigabytes of data about...
-
a. Briefly explain why from the shareholders perspective it is desirable for corporations to maximize NPV. b. What assumptions are necessary for this argument to be correct?
-
Harry Hernandez has \($60,000\) this year. He faces the investment opportunities represented by point B in the following figure. He wants to consume \($20,000\) this year and \($67,500\) next year....
-
Suppose that the person in the land-investment example in the text wants to consume \($60,000\) this year. a. Detail a plan of investment and borrowing or lending that would permit her to consume...
Study smarter with the SolutionInn App