Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Breakeven Analysis/Target Sales (Assignment #5 to be completed in Excel) Although business was off to a great start in January, Rich realized that he
Breakeven Analysis/Target Sales (Assignment #5 to be completed in Excel) Although business was off to a great start in January, Rich realized that he would need to be profitable in order to continue as a viable business. He discussed the subject of profitability with Adrian who suggested that he needs o determine his breakeven point in both sales and dollars. He explained that break even is the point where all costs are covered by sales and so, profit is equal to zero. He also suggested that the company should establish monthly target profitability in order to determine the amount of cakes it would need to sell to achieve this level. Since Rich didn't know how to perform this calculation and in order to save money, he asked you to calculate the company's breakeven point and the target sales needed to achieve a monthly profit of $500. Required: Calculate S & S Bakery's breakeven point in both units and sales dollars. Also, calculate the sales needed in order to achieve a monthly profit of $500. (Note: Use four decimal places in converting from total to per unit cost).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started