Title: “Analyzing Break-Even Point and Profitability in a Lemonade Stand Business: A Case Study”

Scholarly sources within the last 5 years. 
Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost of producing a cup of lemonade is $0.20.
Given her other assumptions, what level of sales volume will enable Julie to break even?
Given her other assumptions, discuss how a change in sales volume affects profit.
Given her other assumptions, discuss how a change in sales volume and variable cost jointly affect profit.
Use Excel’s Formula Auditing tools to show which cells in your spreadsheet affect profit directly.

Comments

Leave a Reply