I used some Chat GPT to calculate potential revenue...very easy as long as you give it a right command ! I can not do it that fast in Excell
Let's calculate the total revenue for 12 months.
Cumulative Customers
- Month 1-5: 13000
- Month 6: 13000 + 4500 = 17500
- Month 7: 17500 + 4500 = 22000
- Month 8: 22000 + 4500 = 26500
- Month 9: 26500 + 4500 = 31000
- Month 10: 31000 + 4500 = 35500
- Month 11: 35500 + 4500 = 40000
- Month 12: 40000 + 4500 = 44500
Revenue from New Customers
- Month 1-5: 13000 * $400 = $5,200,000 (one-time revenue for the first 5 months)
- Month 6-12: 7 * 4500 * $400 = $12,600,000
Total revenue from new customers: $5,200,000 + $12,600,000 = $17,800,000
Revenue from Refills
- Month 1-5: $0 (no refills for the first month), then 1000 less each month isn't given so lets assume customers come every month after first month
- Month 2-5: (13000 - 13000/5) * $400 * 4 = 10400 * 400 * 4 = $16,640,000
- Month 6: 13000 * $400 = $5,200,000
- Month 7: 17500 * $400 = $7,000,000
- Month 8: 22000 * $400 = $8,800,000
- Month 9: 26500 * $400 = $10,600,000
- Month 10: 31000 * $400 = $12,400,000
- Month 11: 35500 * $400 = $14,200,000
- Month 12: 40000 * $400 = $16,000,000
Total revenue from refills: $16,640,000 + $5,200,000 + $7,000,000 + $8,800,000 + $10,600,000 + $12,400,000 + $14,200,000 + $16,000,000 = $90,840,000
Total 12-Month Revenue
$17,800,000 (new customers) + $90,840,000 (refills) = $108,640,000
In AUD (using the exchange rate 1 USD = 1.5 AUD): $108,640,000 * 1.5 = AUD 162,960,000.
(20min delay)