Question: Need help calculating break even analysis with the following information. To calculate the break-even point in units use the formula: Break-Even point (units) = Fixed
Need help calculating break even analysis with the following information. To calculate the break-even point in units use the formula: Break-Even point (units) = Fixed Costs (Sales price per unit Variable costs per unit) or in sales dollars using the formula: Break-Even point (sales dollars) = Fixed Costs Contribution Margin."
| Year | #Contractor sign ups | Booking Fee ($16 per shift) | Shifts worked by contractor | # Business Sign ups | Pro Membership $50 per month | Premium Membership $100 per month | Premium Plus Membership $150 per month |
| 1 | 10000 | $480,000 | 30000 | 1000 | 500 | 250 | 250 |
| 2 | 30000 | $1,440,000 | 90000 | 5000 | 3000 | 1250 | 750 |
| 3 | 60000 | $2,880,000 | 180000 | 10000 | 4000 | 2000 | 4000 |
| Revenues | year 1 | year 2 | year 3 |
| Booking Fees | $ 480,000 | $ 1,440,000 | $ 2,880,000 |
| Pro Membership | $ 300,000 | $ 150,000 | $ 200,000 |
| Premium Membership | $ 300,000 | $ 125,000 | $ 200,000 |
| Premium Plus Membership | $ 450,000 | $ 112,500 | $ 600,000 |
| Total Sales | $ 1,530,000 | $ 1,827,500 | $ 3,880,000 |
| Loans | $ 200,000 | $ - | $ - |
| Total Revenue | $ 1,730,000 | $ 1,827,500 | $ 3,880,000 |
| Expenses & Costs |
|
|
|
| Lease | $ 30,000 | $ 35,000 | $ 40,000 |
| Marketing | $ 100,000 | $ 100,000 | $ 150,000 |
| Salaries | $ 598,339 | $ 760,008 | $ 760,008 |
| Office Supplies | $ 30,000 | $ 30,000 | $ 30,000 |
| Other Expenses | $ 20,000 | $ 20,000 | $ 20,000 |
| Total Expenses and Costs | $ 778,339 | $ 945,008 | $ 1,000,008 |
| Month | Salaries | Office Supplies | Headquarters | Marketing | Office supplies | Sales Revenue | Monthly Debt
| Accumulated Debt
|
| Jan | $25000 | $1000 | $0 | $0 | $0 | $0 | $26,000 | $26,000 |
| Feb | $25000 | $2000 | $0 | $0 | $0 | $0 | $27,000 | $53,000 |
| March | $41,667 | $3000 | $0 | $10,000 | $0 | $0 | $54,667 | $107,667 |
| April | $63,334 | $8,000 | $2500 | $10,000 | $10,000 | $10,000 | $93,834 | $201,501 |
| May | $63,334 | $8,000 | $2500 | $10,000 | $10,000 | $50,000 | $93,834 | $295,335 |
| June | $63,334 | $9,000 | $2500 | $10,000 | $10,000 | $250,000 | $94,834 | $390,169 |
| July | $63,334 | $0 | $2500 | $10,000 | $0 | $470,000 | $75,834 | $466,003 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
