When creating your financial projections for your cafe, save time and hassle by starting with an existing Excel financial model that just needs adjustment to reflect your specific business. Given that, here are a couple key areas to consider on which most of the other numbers will hinge.
Until your cafe becomes a destination through the work of your promotion strategy, it is safe to say that your primary business will be some a percentage of the foot traffic that passes by on the street, assuming you are on a city street with sidewalks. To look at revenue this way, you need to know the foot traffic per week during a normal work week, and how this number changes with the seasons or with holiday weeks over the course of a year. Next, you need to make an assumption of a percentage of this foot traffic that will enter your cafe during business hours. To base this in some reality, look at the percentages that enter a similar business. To be more exact, subtract from that number the customers who sought out the example business specifically. Finally, you need to decide on the average order size per customer who enters, taking into account those who enter and do not buy at all. Slight variations in the foot traffic assumption, the percentage who enter, and the average order size will mean huge variations in your revenue projections, so be sure to explain how all three numbers are grounded in reality.
Your space needs, salary costs, and ability to generate revenue with your cafe will depend in large part on the number of servers you plan to have operating at a given time. Take into account that a server cannot serve customers nonstop from opening to closing as there will be a need for resupplying, phone calls, breaks, and clean-up. You should nevertheless have an idea of how many average orders a server can fill in an average hour to create a reasonable maximum service capacity for your cafe. Make sure to relate the service capacity you will have to the orders per hour you expect from your foot traffic in the first year. You may want to adjust the service capacity by adding additional servers or time-saving equipment like a POS system if you expect more than you can currently handle, or to give servers additional responsibilities if you believe they will be idle at first.