Spreadsheet: 6db20d96-ab42-4ba3-939c-36cbde66aaa0
Sheet: Storage

Storage and CDN Costs
DISCLAIMER: This is a sample worksheet making assumptions for a specific scenario, and without considering partner discounts. You can use this worksheet as a sample to get you started. |  |  |  |  |  |  |  |  |  |  |  |  | Legend:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Azure costs that could require update
Storage Costs |  | Q1 | Q2 | Q3 | Q4 |  |  |  |  |  |  |  |  | Input values that are source for calculations on the page
$/GB | 0.14 |  |  |  |  |  | Assumptions:
Daily Average (GB) |  |  |  |  |  |  | Quarterly totals are same as daily average for quarter
Monthly cost |  |  |  |  |  |  | Using producer users as cost point, consumers pay for media downloads, cost is covered by sale
Monthly cost per producer
$/10K storage transactions | 0.01
Monthly costs
Monthly cost per producer
How many bytes per record and # record estimates? |  |  |  |  |  |  |  |  |  | Assumptions:
 | bytes/rec | Q1 | Q2 | Q3 | Q4 |  |  |  |  | average 50 media records uploaded by each publisher account
media information | 2000 |  |  |  |  |  |  |  |  | average 1 profile per user
profile | 1000 |  |  |  |  |  |  |  |  | fewer publishers than consumer users
producer users | 200 | 50 |  |  |  | 0.5 | growth per quarter |  |  | consumer users will grow faster
consumer users | 200 | 100 |  |  |  | 2 | growth per quarter
total table storage records
How many bytes table storage by quarter?
 |  | Q1 | Q2 | Q3 | Q4
media information
profile
producer users
consumer users
total table storage bytes
in GB |  |  |  |  |  |  | SQL Storage values, assuming blob and queue remain in azure storage
How many bytes blob data?
 |  | Q1 | Q2 | Q3 | Q4 |  | Assumptions:
media blob | 5000000 |  |  |  |  |  | All blobs go to CDN.
CDN storage
CDN storage GB
How many bytes queue data?
 |  | Q1 | Q2 | Q3 | Q4 |  | Assumption:
upload confirmation bytes | 2000 |  |  |  |  |  | All media uploads generate a queue message
Total storage in bytes
in MB
in GB |  |  |  |  |  |  | represents total [NAME] uploaded that quarter, could average this over 3 months
Average storage per producer
Media downloads transactions
 | avg per user | Q1 | Q2 | Q3 | Q4
per day | 2
per week
per month |  |  |  |  |  |  | Assumptions
per year |  |  |  |  |  |  | cdn and blob storage downloads based on per month numbers with average consumption per user
per month 10K tx |  |  |  |  |  |  | total GB downloads per month also maps to downloads of media used
Table storage transactions per month
 | avg per user | Q1 | Q2 | Q3 | Q4
media blob | 10 |  |  |  |  |  | how many add, update, delete (reads are downloads above)
media record | 20 |  |  |  |  |  | how many add, update, read, delete
profile | 20 |  |  |  |  |  | each table has patterns
source users | 3 |  |  |  |  |  | how many times would a source upload, read, write, delete media records per month?
consumer users | 3
total tx per month |  |  |  |  |  |  | each queue message has a create, read, delete action
total 10K tx per month |  |  |  |  |  |  | queue polls per second is in addition to actual reads where a message is not present
total 10K tx incl blob downloads
total 10K tx incl queue tx
Queue transactions | avg / day | Q1 | Q2 | Q3 | Q4
queue messages
empty queue polls / month | 500
total tx per month
total 10K tx per month
Bandwidth usage per month
 |  | Q1 | Q2 | Q3 | Q4
 |  |  |  |  |  |  | bandwidth inbound not charged, but we'll track it in case future changes require estimation
media uploads in bytes |  |  |  |  |  |  | upload is producer based, create records, interact with service, upload media, does not yet account for mistakes, reupload, replacing media
record uploads in bytes |  |  |  |  |  |  | download is consumer based and application consumption
total transfer inbound in bytes |  |  |  |  |  |  | avoid download media if not streaming it, use previews, etc.
total transfer inbound in GB /mo |  |  |  |  |  |  | based on page loads and average record size
GB/hour
media downloads in bytes
record downloads
average pages / s |  | 30 | 60 | 100 | 500
average record size / pg | 3000
transfer outbound in GB /mo
% users US/EU | 0.8
% user APAC | 0.2
GB/hour
$ users US/EU | 0.15
$ users APAC | 0.2
price per download | 1 |  |  |  |  |  | This is a shot in the dark at revenues per month based on charging for media downloads. Just to indicate the potential for revenue to offset bandwidth costs.