To build a robust financial model for an aerosol manufacturer, we start with the most granular level of detail: the Stock Keeping Unit, or SKU. Revenue is a simple function of volume multiplied by price, but the drivers for each can be complex. We'll model revenue from the ground up, starting with individual products.

Our hypothetical company produces two main categories of aerosol products: insecticides and air care. Each category has multiple SKUs, which might differ by size, scent, or specific function. Forecasting at this level allows for greater accuracy, as each product line has unique market dynamics.

Sales volume is driven by seasonality and market penetration. Insecticide sales, for example, spike in warmer months. We can model this using time-series analysis, applying seasonal indices derived from historical sales data to a baseline forecast. Air care products generally have a more stable demand profile, though specific scents might have their own seasonal peaks.

Beyond seasonality, we must forecast growth from market share gains. A common approach is to model a market penetration S-curve. This assumes that adoption starts slowly, accelerates as the product gains traction, and then plateaus as the market becomes saturated. For an established business, we are likely on the flatter part of this curve, forecasting modest year-over-year growth based on strategic initiatives like new distribution channels or marketing campaigns.

The price a customer sees on the shelf is not the price our aerosol company receives. In the Fast-Moving Consumer Goods (FMCG) industry, the journey from gross price to net revenue involves several deductions known as trade spend. These are costs paid to retailers to stock, promote, and sell our products.

Major components of trade spend include retailer rebates and promotional allowances. A retailer might receive a 2% rebate on all cases ordered if they hit a certain volume target. Promotional allowances fund temporary price reductions, in-store displays, or inclusion in weekly flyers. These activities are designed to spike volume, but they directly reduce the net price per unit.

The relationship between promotional spending and sales lift is not always linear. This is where demand elasticity analysis becomes critical. By analyzing historical data, we can build econometric models that predict how much a 10% price drop in the Northeast region for our 16oz Bug-Away Fogger will increase sales volume. This allows us to optimize our promotional calendar, ensuring the investment in trade spend generates a worthwhile return in volume and market share.

Once we have our volume and net pricing forecasts, we can analyze the drivers of revenue change from one period to the next. Price-volume variance analysis is a technique used to isolate these effects. It breaks down the total revenue variance into a few key components:

This analysis provides crucial insights. For example, we might find that total revenue increased, but a negative price variance indicates that the growth was driven by heavy discounting, potentially eroding profit margins. By modeling revenue at the SKU level and accounting for the complexities of the FMCG market, we can build a powerful tool for strategic decision-making.

This granular approach forms the foundation of our entire financial model.