Skip to main content

P×Q (Price × Quantity)

The P×Q module forecasts product sales revenue by modelling each product as a set of sales channels, each with its own price and quantity per month. It's designed for businesses where revenue is volume-driven and can be expressed as units sold at a given price.

When to use P×Q​

Use this module when:

  • You sell products or services at a per-unit price
  • Your revenue model can be decomposed into: how many units × at what price
  • You have multiple sales channels (e.g. direct, reseller, online) with different pricing
  • You want to feed sales volume into the COGS module for margin modelling

Creating the module​

  1. In your Scenario, click Add a budget
  2. Choose PxQ
  3. Follow the setup wizard (4 steps)

Step 1 — Introduction​

Set the forecast period. Optionally connect a product integration — if your ERP or sales platform exports product data, Monitr can import your product catalog directly.

Step 2 — Model​

Define your products and revenue channels:

Products​

Add each product you want to forecast. A product represents a distinct revenue line (e.g. "Software License", "Support Package", "Hardware Unit").

Revenue channels​

Each product can have one or more revenue channels — the different routes through which it's sold. For example:

  • Product: "Software License"
    • Channel: "Direct Sales" (€800/unit)
    • Channel: "Reseller" (€600/unit — different pricing for partner deals)
    • Channel: "Online" (€500/unit — self-serve pricing)

For each product × channel combination, enter per month:

  • Price — unit selling price (can vary month-to-month for pricing changes or seasonal promotions)
  • Quantity — number of units sold

Monitr multiplies price × quantity per channel and sums to the product total.

Monthly overrides​

The default price and quantity are set as monthly values. Override specific months when you know of a price change, seasonal peak, or promotional period.

Step 3 — Mapping​

Assign budget accounts per revenue channel:

  • All channels can map to a single "Revenue" budget account
  • Or map each channel (or each product) to a dedicated budget account for granular P&L reporting

Analytical axis assignments can further break down revenue by region, team, or entity if your accounting uses dimensions.

Step 4 — Result​

Review the monthly revenue forecast per product and channel:

  • Revenue per channel per month
  • Product totals
  • Grand total revenue
  • Comparison with actuals (if the forecast period overlaps with imported GL data)

Integration with COGS​

If you also use the COGS module, it can reference P×Q quantities to calculate variable costs automatically. When P×Q quantities change, COGS recalculates — keeping your gross margin forecast consistent without double entry.

Optional product integration​

If a product/ERP integration is connected, the introduction step lets you import your product catalog and historical sales data. This populates products and channels automatically and pre-fills past months with actual quantities.

Output in reports​

P×Q feeds your P&L revenue lines. In the Forecast report, revenue appears on the lines you've mapped to. The Revenue dashboard breaks down revenue by product and channel, with budget vs. actuals comparison.