Sales Forecasting & Manufacturing
Sales forecasting for manufacturers has always been essential, but can sometimes be tricky. If you’re a manufacturer, sales forecast data integrity is even more crucial since it used to generate plans in all aspects of the business including manufacturing scheduling, inventory management, product positioning and placement, production planning, manufacturing scheduling…even budgeting, cash flow, expansion, investments for capital equipment and raw materials purchases. For your Operations Organization, these forecasts are used as an input into demand planning to:
- Maintain inventories of finished products
- Plan for replenishment of raw materials and other items
- Plan for production and capacity
This is the reality…the supply chain must procure the correct level of raw materials to manufacture an assumed amount of finished goods, given there is market demand for those goods. In turn, a sales forecast can predict how many units will be sold in a given time period. Now, the company can purchase enough raw materials to manufacture those units.
This is the conundrum…If your sales forecast is too generous, you’re burdened with units you must carry/inventory instead of selling…unfortunately, you are still stuck with the raw materials that you already paid for that were required to produce this overstock. Conversely, if your forecast is too conservative, you won’t produce enough units, resulting in a backorder situation and possibly having sales orders canceled. Even worse, your customer could drop you as a vendor. Obviously, this scenario creates an “organic rub” between sales and supply chain planning, especially when confidence in the forecast accuracy is low. The solution is having a more accurate & timely forecast whereby sales will be able to hit their revenue targets. This allows the factory to:
- Build the correct product mix
- Lower on-hand inventory levels
- Reduce unfulfilled backlog
- Reduce Inventory obsolescence
- Improve lead times of finished goods and its components
CRM & Forecasting
By now, you should be getting the message that forecast accuracy is key…and CRM systems can help with this. Having a forecast module in a CRM system is a must for manufacturers. Since it is used every day, CRMs allow sales reps to review the buying behavior and accurate analytics on each account. This provides a real-time dimension to the historical data resulting in more concrete and reliable sales forecasts. Incorporating info generated by the CRM can give the forecast a more accurate perspective of true demand as you’re getting as close to the customer as possible. Forecasts based on analytics such as “average closing ratios” and “average time for a sale at a particular stage of the sales process” (allowing a much more precise calculation of risk-versus-reward for each sale) tend to be more accurate than methods based solely on an educated guess.
Marketing and sales organizations prefer to plan forecasts in revenue and conversely, production needs to plan in units. For products to be available when the customer needs them, you need to develop a forecast by product in units. However, your forecasting system should be flexible enough so that it can aggregate demand to different levels of details in units and in dollars to satisfy company-wide needs.
Forecasting in CRMs enable:
- Automation of a role-based data entry process by linking the opportunity pipeline to the forecast increasing accuracy.
- Sales reps to better evaluate what customers may purchase as they cultivate real-time opportunities. These sales forecasts are available by customer account and can be viewed via a Sales Dashboard.
- With organization-wide usage, it will allow Sales and Demand Teams to collaborate in real-time on forecasts. It also enables the option for end-user customers and sales partners to view/input forecasts via a self-service portal.
- Reporting that can provide a clear picture to senior management as to how actual results compare to the sales forecast.
- Since CRM usage is daily, it allows the forecast to be measured and reviewed frequently, which in turn, fosters better accuracy – WHICH IS A MUST!