Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Projection Assumptions Starting first month volumes: Coffee Pastry 500 Units 200 Units Monthly sales growth: Coffee Pastry 10% Each moth 5% Each moth Sales prices:
Projection Assumptions Starting first month volumes: Coffee Pastry 500 Units 200 Units Monthly sales growth: Coffee Pastry 10% Each moth 5% Each moth Sales prices: Coffee Pastry $ $ 3.00 Per unit 2.00 Per unit Cost of sales: Coffee Pastry 0.25 1.00 Per unit Per unit $ Other non-fixed expenses: Starting hours Month 1 Growth in monthly hours Hourly pay Paper/supplies 200 Hours 2% Each moth 8.50 Per hour 5% % of total sales value $ $ Fixed expenses: Rent/utilities Insurance Advertising Accounting/tax 1,000 per month 200 per month 200 Per month 100 per month $ $ Using Goal Seek determine the selling price of coffee needed to break even for the year Type answer here
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