A Founder’s Guide to Forecasting Sales, Profit, and Inventory
- Jan 23
- 8 min read
Practical planning for founders who want clarity
Annual planning and sales forecasting can feel like busywork, something founders know they should do but rarely enjoy. I’d challenge that. When done thoughtfully, forecasting becomes one of the most meaningful investments you can make in your business.
Building something sustainable takes more than good ideas. It requires discipline and intention. As part of your strategy, it’s important to understand not just what you hope to make this year, but how revenue is actually generated across the months (or cycles). Mapping this out helps you see whether the rest of the business, production, inventory, cash, and capacity, can realistically support your growth.
Before diving into numbers, it’s worth grounding the work in a few fundamentals:
What is your brand actually trying to do?
Who are you really building this for?
How are your products positioned today?
These aren’t fluffy journaling questions. When your plan aligns with your mission and your customer, your numbers tend to hold up better, even when you need to pivot during the year.
Forecasting touches more than just your financials. When I plan, I look at several areas together:
Profit planning
Sales projections
Demand alignment
Production capacity
Inventory management
None of these operates in isolation. They influence each other constantly. The sections below walk through each area in sequence, so you can build a plan that’s actually usable, not one that lives untouched in a spreadsheet.
Step 1: Profit Planning
Before you can plan annual revenue, you need a clear understanding of what you’re actually selling.
I hear this from founders all the time: “I’m not great with numbers.” You’re not alone, and you don’t have to do this by yourself. Understanding your costs and financials isn’t about becoming an accountant; it’s about building the foundation for a sustainable business.
(Personal note: this didn’t come naturally to me either. I worked with a consultant who helped me see my numbers clearly for the first time. If this feels overwhelming, getting the right support can be a game-changer.)
If you don’t understand your profit margins, you’re essentially planning revenue in the dark.
Where to Start
If this is your first time reviewing margins:
Calculate profit margin by SKU or by product family.
If you’ve done this before:
Update your costs (ingredients, packaging, labor, supplies).
Recalculate your margins.
Once that’s done, group your offerings into three buckets:
High-margin products
Low-margin products
Products that may be losing money
From there, define your target average profit margin, the margin your business needs to sustain operations, support your sales channels, support your income goals, and fund future growth.
This exercise should help answer two practical questions: First, which products can realistically support your plan? Second, do you need to consider pricing changes? One important mindset shift to consider: not every product needs to hit your target margin. What matters is your overall product mix. Your portfolio, as a whole, should meet the target, even if some items are intentionally lower margin.
To close the loop, review your updated pricing and ask whether it still aligns with your brand strategy.
This isn’t busywork. It’s about reducing risk and building confidence in your plan. When you understand which products drive profit and which ones drag it down, your decisions become clearer and more grounded.
Optional resource: A sample margin table is included below to visualize your product mix.
Average portfolio margin: Calculate the average margin across all products to see whether your mix meets your target.
High-Margin Products | Margin % | Low-Margin Products | Margin % | Potential Loss Products | Margin % |
Chocolate bars | 78% | 12-piece bonbon set | 50% | DIY s’mores kit | 10% |
Step 2: Sales Projection
Once you understand your margins, the next step is to ground your planning in actual performance data.
Gathering Your Data
If you were operating your business last year, export your data in a simple month-by-month format. You can usually pull this from your point-of-sale system (Square, PayPal, etc.), your website platform (Shopify, etc.), and your accounting software. Before exporting, try to organize your data into useful groupings: sales by channel, customer type, and product SKU or family. You don’t need perfection here. The goal isn’t a pristine dataset; it’s clarity. Even a rough first pass can reveal insights you may not have seen before.
Sales Channels
When reviewing sales channels, you’re simply trying to understand where your revenue is generated. Common examples include online stores, wholesale, pop-up events, and experiences such as workshops or tastings. This view helps you see which channels are growing, which are stable, and which may need attention.
Customers
I’ve also found it helpful to group sales by customer type. This gives you a clearer picture of how different customers behave over time and where your most meaningful revenue is coming from. This can help you retarget key customers earlier in the year, track how purchasing patterns change, and spot opportunities to upsell when volume starts to dip.
This exercise isn’t about tracking every individual customer. It’s about capturing your larger, more strategic customers, the ones that materially impact your revenue. You might categorize customers in ways such as wholesale customers (e.g., grocery stores, coffee shops), large customers for product or experience (e.g., corporate clients), and major pop-up events (e.g., holiday pop-ups, seasonal markets).
Products
When reviewing last year’s revenue, see if you can summarize sales by SKU or by product family. This level of visibility gives you a much clearer picture of what’s actually driving your business. It can help you identify where to grow your product mix, where you might simplify or eliminate products, and whether lower-volume products play an important seasonal role. If you’re not yet able to analyze sales by SKU or product family, that’s usually a system gap worth fixing. Putting this structure in place makes every other planning step easier.
Sales Patterns and Seasonality
Plotting your sales month by month often reveals patterns you wouldn’t otherwise notice. You start to see which months tend to be stronger or slower, where seasonality shows up, and whether your revenue is driven by repeatable customers or one-off opportunities. It’s also a good moment to step back and ask whether certain channels are getting stronger over time, whether others are starting to slow down, and whether specific customer types are becoming more or less reliable. These insights become the foundation for more realistic planning.
Building your Sales Projection
Once you’ve done this groundwork, you can begin building your sales projection. Start by defining three growth scenarios: worst case, expected case, and best case.
Then, take your annual revenue target and distribute it across months, using your seasonality patterns as your guide. When I build projections, I prefer to keep monthly revenue at the total level first. We’ll use SKU-level or product-family detail later, when we move into demand planning, production capacity, and inventory management.
Step 3: Translating Revenue into Units
Now that you’ve built a sales projection, you can start working backward. Before ordering ingredients and packaging, pause and look at what the data is telling you. If possible, organize your revenue by product SKU and volume sold. You can look at this by month or at an annual level. Ideally, you’d have clean monthly unit data by SKU, but that’s not always available.
When it isn’t, here’s a simple way to estimate demand using your annual revenue:
1. Divide annual revenue (by product family) by your average product price to estimate total units sold.
2. Review monthly or quarterly sales to identify patterns (for example, heavier volume in Q4).
3. Apply that same distribution to your estimated unit volume.
This gives you a rough view of monthly or quarterly unit demand. It doesn’t need to be perfect. The goal is directionally useful numbers, not precision. If you don’t have strong historical data yet, you can still estimate. Every forecast, no matter how sophisticated, will be wrong to some degree. What matters is that you now have a baseline to work from instead of operating without one.
Once you have estimated demand by SKU, review it through two lenses:
Does this product mix still align with your brand strategy?
Does it support your target average profit margin?
At this point, your forecast becomes more than a financial exercise. Your volume targets now inform how you prioritize products and shape your marketing strategy.
Step 4: Production Capacity
With demand clearer, the next constraint to test is capacity. Now it’s time to review your projected product demand and evaluate whether your current production resources can realistically support this level of growth.
Start by reviewing the plan to understand a few key questions:
Can the team produce this volume in the time we need it?
Where are the current bottlenecks?
Often, the solution isn’t simply adding more hands on the line or investing in larger equipment. Sometimes the most effective lever is simplification. One approach I regularly use is to revisit my product menu and ask whether a SKU actually contributes meaningful revenue toward growth goals. If not, would you be better off removing it and refocusing time, capacity, and marketing on higher-impact products?
If you decide the original growth plan still makes sense, the next step is to take a closer look at your production flow. Labor is often one of the biggest drivers of cost and margin. Improving flow and efficiency can increase profit margin while also expanding production capacity using your existing resources.
If this isn’t an area you feel confident navigating alone, consider bringing in support that’s familiar with your industry. The right advisor can often suggest improvements that work within your existing budget and constraints.
Step 5: Inventory Management
Once you have a production plan by SKU, you unlock another source of leverage: procurement.
When you can estimate your inventory needs by quarter or for the year, you’re in a much stronger position to negotiate with suppliers. This is often where meaningful cost savings are found.
Even if you’re working within constraints, like limited storage space, there are still ways to structure smarter agreements. One approach I’ve used is negotiating pricing based on projected volume while requesting staggered deliveries throughout the year instead of taking everything at once. It’s also important to review the full pricing structure, especially if a supplier charges storage fees. Do a quick calculation to confirm that the discounted pricing still benefits the business once those added costs are included.
In my experience, strong supplier relationships matter here. When vendors understand your business and trust your forecasts, they’re often willing to collaborate and find solutions that work for both sides.
Bringing It All Together
Sales forecasting isn’t busywork. A thoughtful forecast helps you build a strategy that supports real growth, one that aligns with your brand, works within your business constraints, and still holds up when inevitable pivots happen throughout the year. You’re not aiming for data perfection. Even rough estimates are powerful. They give you direction, clarity, and something concrete to work toward.
When done well, forecasting connects the dots across your business. It clarifies what kind of growth actually makes sense. It reveals which products, channels, and customers are driving performance. It surfaces constraints before they become emergencies. And it gives you a stronger footing when making decisions about pricing, marketing, hiring, production, and supplier relationships.
The goal isn’t to plan perfectly. The goal is to replace guesswork with intention.
Helpful Resources
At 37 Oaks, we help small business owners make decisions with clarity. Check out these helpful resources to guide your next move.
Book with Charlotte
Sign in/ sign up to your free 37 Oaks Community account.
Book a 1:1 session with Charlotte
Access flexible and affordable coaching, courses, community, and resources to plot your path forward. https://www.37oaks.com/growthlab
You may find our 37 Oaks University Value Stream Mapping on-demand course valuable when outlining your Manufacturing Flow Diagram.
Who is 37 Oaks?
37 Oaks is an education company that strengthens communities by transforming small businesses into valuable, commerce-driven assets. Our goal is to empower them through Commerce, Innovation, and Strategy.
Sign Up For The 37 Oaks' Newsletter.
Comments