Question: Based on this spreadsheet below. Is it possible to project customer growth? Revenue growth? If so, how can we do this with no historical data.
Based on this spreadsheet below. Is it possible to project customer growth? Revenue growth? If so, how can we do this with no historical data.

A B D E F G H Break-Even Point 1 2 3 #1 #1 # 500.00 4 417.00 300.00 5 6 417.00 7 3,091.96 170.00 500.00 500.00 Typical Sale Sales Price (per Unit) Variable Cost (per unit) Gross Profit (per Unit) % Fixed Costs dedicated to typical sale Fixed Costs (based on percentage) Break-Even (Units per month) RATE OF SALES Work Days per Month Break-Even (Units per day) 8 $1,300.00 $ 1,150.66 $ 149.34 0.01 $ 60.34 0.40 28 0.01 Variable Costs (per month) Materials (printing) Packaging Transportation Labor Google Cloud Mailgun Twilio Payment System (fee +2.9%) Taxes Admin (10%) Other Total Variable Costs (per Unit) 217.00 8.33 9 10 8.33 11 Fixed Costs (per month) Travel Rent Utilities Salaries Liability Insurance Marketing Legal and Accounting Fees Loan Payments Supplies (office, copier, etc) Web Hosting Google Suite Social Media Fee (buffer) Figma Circle Computer Webflow Food Contingency Total Fixed Costs 12 13 14 15 $ 1,150.6 16 500.00 3.00 12.00 100.00 84.00 199.00 125.00 32.00 17 $ $ 18 19 $ 20 21 22 $ 6,033.96 23 24 25 26 A B D E F G H Break-Even Point 1 2 3 #1 #1 # 500.00 4 417.00 300.00 5 6 417.00 7 3,091.96 170.00 500.00 500.00 Typical Sale Sales Price (per Unit) Variable Cost (per unit) Gross Profit (per Unit) % Fixed Costs dedicated to typical sale Fixed Costs (based on percentage) Break-Even (Units per month) RATE OF SALES Work Days per Month Break-Even (Units per day) 8 $1,300.00 $ 1,150.66 $ 149.34 0.01 $ 60.34 0.40 28 0.01 Variable Costs (per month) Materials (printing) Packaging Transportation Labor Google Cloud Mailgun Twilio Payment System (fee +2.9%) Taxes Admin (10%) Other Total Variable Costs (per Unit) 217.00 8.33 9 10 8.33 11 Fixed Costs (per month) Travel Rent Utilities Salaries Liability Insurance Marketing Legal and Accounting Fees Loan Payments Supplies (office, copier, etc) Web Hosting Google Suite Social Media Fee (buffer) Figma Circle Computer Webflow Food Contingency Total Fixed Costs 12 13 14 15 $ 1,150.6 16 500.00 3.00 12.00 100.00 84.00 199.00 125.00 32.00 17 $ $ 18 19 $ 20 21 22 $ 6,033.96 23 24 25 26
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
