Download - ENT 450_Hyperion_Revenue Model-2
HyperionHealthy Vending Revenue Model 2014/Year 1 Year 2 Year 3
Created by Brandon Dobson Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenues
New # of Customer Sales - - - 1,691 1,750 1,752 1,752 1,752 1,752 1,752 1,752 1,752 15,706 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 21,026 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 1,752 21,026
Repeat # of Customer Sales 6,548 6,548 6,548 6,548 8,060 9,626 11,192 12,758 14,324 15,890 17,456 19,022 134,520 20,588 22,154 23,720 25,286 26,852 28,418 29,984 31,550 33,116 34,682 36,234 37,787 350,371 39,339 40,892 42,444 43,997 45,549 47,102 48,654 50,207 51,759 53,312 54,864 56,417 574,536
Average Price $0.65 $0.88 $0.88 $0.88 $0.88 $0.88 $0.88 $0.88 $0.88 $0.88 $0.88 $0.88 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.11 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34 $1.34
Total Revenues 4,260$ 5,765$ 5,765$ 7,254$ 8,637$ 10,018$ 11,397$ 12,776$ 14,155$ 15,533$ 16,912$ 18,291$ 130,765$ 24,805$ 26,543$ 28,282$ 30,021$ 31,760$ 33,498$ 35,237$ 36,976$ 38,715$ 40,453$ 42,177$ 43,901$ 412,367$ 55,069$ 57,150$ 59,230$ 61,311$ 63,391$ 65,472$ 67,552$ 69,633$ 71,713$ 73,795$ 75,875$ 77,956$ 798,147$
# of Vending Locations 13 13 13 19 22 25 28 31 34 37 41 44 47 50 53 56 59 62 65 69 72 75 78 81 84 87 90 93 96 99 102 106 109 112 115 118
Direct Sales Force (to add new vending locations thus sales) - - - 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230 1230
Number of sales reps - - 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Number of calls per month per rep - - 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
Total calls per month - - 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
Percent that take a visit 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25%
Percent of those that accept vending machines to location 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4% 4%
Average unit sales per vending location 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 Conversion Rate 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0%
Direct Mail (to add new vending locations thus sales) - - - 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25 461.25
Number of pieces sent 0 0 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
Percent of mailing list that is target market 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0% 90.0%
Number of Target market reached - - 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180 180
Unreached target market percent 100.0% 100.0% 65.8% 75.8% 79.2% 81.8% 83.8% 85.4% 86.7% 87.8% 88.8% 89.6% 90.3% 90.9% 91.4% 91.9% 92.3% 92.7% 93.1% 93.4% 93.7% 93.9% 94.2% 94.4% 94.6% 94.8% 95.0% 95.1% 95.3% 95.4% 95.6% 95.7% 95.8% 95.9% 96.0% 96.1%
Percent that see the flyer 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50%
Percent that call 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15%
Percent that say yes to our vending machines 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%
Average unit sales per vending location 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 615 Conversion Rate 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38% 0.38%
Word of Mouth Ambassadors (to increase customers thus
sales per location) - - - - 59 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61
New, satisfied customers last month 0 0 0 0 112 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116
Percent of new customers who talk about Vending Machines 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25%
Number of people in available tarket market they tell 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Percent that will check out Vending Machines 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35% 35%
Percent that will become Customers 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% 20%
Conversion Rate 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7% 7%
Repeat Sales 6548 6548 6548 6548 8060 9626 11192 12758 14324 15890 17456 19022 20588 22154 23720 25286 26852 28418 29984 31550 33116 34682 36234 37787 39339 40892 42444 43997 45549 47102 48654 50207 51759 53312 54864 56417
Prior month customer base 485 485 485 485 597 713 829 945 1,061 1,177 1,293 1,409 1,525 1,641 1,757 1,873 1,989 2,105 2,221 2,337 2,453 2,569 2,684 2,799 2,914 3,029 3,144 3,259 3,374 3,489 3,604 3,719 3,834 3,949 4,064 4,179
% that repeat purchase 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90%
Number of purchases per month 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15
Customer Base
Beginning customer base 485 485 485 485 597 713 829 945 1,061 1,177 1,293 1,409 1,525 1,641 1,757 1,873 1,989 2,105 2,221 2,337 2,453 2,569 2,684 2,799 2,914 3,029 3,144 3,259 3,374 3,489 3,604 3,719 3,834 3,949 4,064 4,179
New customers 0 0 0 113 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117
Percent satisfied 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99% 99%
Number added - - - 112 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116 116
Available customer base 485 485 485 597 713 829 945 1,061 1,177 1,293 1,409 1,525 1,641 1,757 1,873 1,989 2,105 2,221 2,337 2,453 2,569 2,685 2,800 2,915 3,030 3,145 3,260 3,375 3,490 3,605 3,720 3,835 3,950 4,065 4,180 4,295
Percent attrition 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02% 0.02%
Number attrited - - - - - - - - - - - - - - - - - - - - - 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
Ending customer base 485 485 485 597 713 829 945 1,061 1,177 1,293 1,409 1,525 1,641 1,757 1,873 1,989 2,105 2,221 2,337 2,453 2,569 2,684 2,799 2,914 3,029 3,144 3,259 3,374 3,489 3,604 3,719 3,834 3,949 4,064 4,179 4,294
Target Market (All possible Customers - Actual Customers) Increases as more locations are added
Target Market Size 1000 516 516 516 847 971 1,094 1,218 1,341 1,464 1,588 1,711 1,835 1,958 2,082 2,205 2,329 2,452 2,576 2,699 2,823 2,946 3,068 3,191 3,313 3,436 3,558 3,680 3,803 3,925 4,048 4,170 4,292 4,415 4,537 4,660 4,782
New Customers - - - 113 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117 117
Total 516 516 516 734 854 977 1,101 1,224 1,348 1,471 1,595 1,718 1,842 1,965 2,088 2,212 2,335 2,459 2,582 2,706 2,829 2,952 3,074 3,196 3,319 3,441 3,564 3,686 3,808 3,931 4,053 4,176 4,298 4,420 4,543 4,665
Demographic shift 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
Target Market Potential 526 526 526 744 864 987 1,111 1,234 1,358 1,481 1,605 1,728 1,852 1,975 2,098 2,222 2,345 2,469 2,592 2,716 2,839 2,962 3,084 3,206 3,329 3,451 3,574 3,696 3,818 3,941 4,063 4,186 4,308 4,430 4,553 4,675