Build a demand range from confirmed orders and explicit assumptions when usable sales history is missing. Keep a dated estimate, then compare it with initial orders and actual sales.
Oct 25, 20265 min readThe double moving average forecasting method uses two successive rolling averages to estimate a changing level and trend. Build it from an order export, reproduce the spreadsheet formulas, and compare forecasts with actuals and simpler benchmarks.
Oct 25, 20265 min readBuild a restaurant sales forecast from covers, orders and average checks by location and service period. Use the workbook layout, actual-versus-plan formulas and checks to explain trading results.
Oct 25, 20266 min readReview a supplied cash forecast against actual bank movements using explicit timing assumptions. Reconcile opening cash, receipts, payments and closing cash before asking AI to explain the variances.
Oct 24, 20265 min readCash positioning establishes the cash a company holds and can use at a specific cutoff. Cash forecasting projects future balances from that opening position, with a worked reconciliation of bank balances, restrictions, temporary holds and scheduled flows.
Oct 24, 20266 min readCompare food forecasts with sales, receipts and waste by product and week. Reconcile inventory movements, calculate the cost of waste and identify stock exposed before its customer selling cutoff.
Oct 23, 20265 min readExponential smoothing and moving average forecasts differ in how they weight past sales. Compare both methods on the same monthly rows, then check their errors against actual sales that were unavailable when each forecast was made.
Oct 22, 20266 min readA rolling order forecast refreshes expected order intake and the backlog it creates. Reconcile opening orders, new bookings, cancellations and shipments, then compare actual intake with a frozen forecast before extending the horizon.
Oct 22, 20265 min readA useful sales forecast meeting explains what changed, which deals support the number and who will act next. Build the review from frozen pipeline snapshots, check the movement by deal and rep, and leave with an evidence-based action list.
Oct 22, 20265 min readCompare CPG forecasts with consumer sales and shipments by SKU and channel. Separate promotional uplift from base demand, then reconcile the difference to channel inventory.
Oct 21, 20265 min readWAPE measures absolute forecast misses relative to total actual demand. This page works the formula from product and site rows, reconciles the total, and explains zero-demand periods and the limits of an accuracy score.
Oct 20, 20265 min readForecast established products from comparable sales history, then separate promotions, stockouts and changing demand. Follow a worked spreadsheet example and reconcile forecast errors before changing the next plan.
Oct 19, 20265 min readDemand forecasting for perishable goods must match demand to the period when inventory can still be sold. Work through a lot-level example, spreadsheet formulas, and a reconciliation that separates forecast error from excess supply.
Oct 19, 20266 min readReal-time demand forecasting updates estimates as new information arrives. Compare timestamped forecast versions with actual demand and decision deadlines to see whether a faster cadence improves planning.
Oct 19, 20265 min readSKU level demand forecasting keeps item decisions visible when category totals look right. Reconcile supplied forecasts to category totals, compare item demand with actuals and calculate an absolute error measure that cannot disappear through offsetting errors.
Oct 19, 20265 min readEstimate demand that could not be served during a stockout using comparable in-stock selling periods. Work through an hours-based example, spreadsheet formulas, a sensitivity range and the checks that keep estimated demand separate from recorded sales.
Oct 18, 20266 min readCompare customer demand forecasts with confirmed orders, output plans and manufacturing capacity. Follow a product-level example with Excel formulas that expose forecast error and production-plan mismatches.
Oct 18, 20266 min readCompare seasonal fashion forecasts with sales by style, color and size. Separate availability constraints from forecast errors and keep full-price demand distinct from later markdown sales.
Oct 17, 20265 min readAdaptive smoothing changes the weight on recent observations in response to forecast errors. Work through an error-responsive example, compare it with fixed smoothing, and see the checks needed before adopting it.
Oct 16, 20265 min readCRM forecasting compares a frozen opportunity forecast with the sales that actually closed. Build the review from dated exports, preserve the original team and category, and reconcile every movement to an opportunity.
Oct 13, 20264 min readTime series analysis compares business measurements in date order to separate direction, recurring patterns and unusual movements. Work through a revenue example, the source checks and the decisions each pattern can support.
Oct 13, 20266 min readBuild an ARR forecast from opening subscriptions, renewal assumptions and recurring pipeline. Work the customer-group bridge, reproduce it in Excel and check that every movement reaches the closing total.
Oct 12, 20266 min readBuild a forward cash forecast from a projected income statement and linked balance schedules. Work through noncash adjustments, working capital, capital spending and debt, then prove the closing cash balance.
Oct 12, 20266 min readCompare a frozen shipment forecast with actual loads and transport costs by lane. Build a volume and rate bridge, reconcile it to freight spending, and identify the assumptions to change.
Oct 12, 20265 min readSales commission forecasting separates the cost of sales compensation from its payment timing. Build an approved forecast by team, reconcile the payable balance, and compare exported forecasts with actual expense and payments.
Oct 12, 20264 min readA sales force composite combines sales representatives' estimates into one forecast. Use a consistent submission basis, preserve review adjustments and compare the frozen estimates with actual results.
Oct 9, 20265 min readCausal demand forecasting connects demand forecasts with measured business drivers such as price and promotions. Compare supplied scenarios, reconcile revenue effects and test forecasts against demand without treating correlation as proof of causation.
Oct 8, 20266 min readReview carrier declines by line, reason and source quality. Keep unanswered, withdrawn and declined submissions distinct.
Oct 6, 20262 min readA baseline demand forecast estimates normal demand before temporary events and availability losses. Work through a product-month example that separates baseline, promotion lift, one-time demand and stockouts, then reconciles the result to actual sales.
Oct 6, 20266 min readHolt method forecasting updates the level and trend of nonseasonal demand separately. Follow a complete numerical example, check the forecast equations, and compare saved forecasts with actual demand.
Oct 6, 20266 min readTrack opportunities from submission to quote and bind. Deduplicate alternative quotes and compare equally mature cohorts.
Oct 5, 20263 min readBuild a monthly services revenue forecast from available hours, billable utilization, expected work and billing rates. A worked practice-level example reconciles forecast revenue to actual billed hours and realized rates.
Oct 4, 20265 min readProjected financial statements connect expected profit, financial position and cash movements. Follow a checked forecast, compare it with actual results, and separate profit misses from collection timing.
Oct 4, 20265 min readService demand forecasting turns expected work volumes and handling times into required hours. Work from a service export to a capacity comparison, then separate volume errors from handling-time errors.
Oct 4, 20265 min readActive forecasts include planned business changes, while passive forecasts extend historical demand. Compare both approaches on the same sales rows, retain an assumption bridge and measure errors without hiding offsetting misses.
Oct 3, 20265 min readA forecasting dashboard compares saved forecast versions with actual results by business unit and horizon. Follow a worked US distributor example, a changed-input variation, and the checks that make the review reliable.
Oct 3, 20265 min readTranslate qualified opportunity premium into an agency-income scenario. Show commission, fees and probability assumptions separately.
Oct 3, 20262 min readBuild a pending-renewal income range from explicit assumptions. Separate confirmed income, uncertain outcomes and new business.
Oct 3, 20263 min readPredictive analytics in retail estimates future demand, but a forecast earns trust through checks against actual sales. Compare supplied forecasts with a baseline, measure error by store and product, and keep the original forecast date beside every result.
Oct 3, 20265 min readUpdate healthcare operating forecasts with department volumes, net revenue assumptions and staffing costs. A worked comparison of forecast versions separates volume, reimbursement yield, labor intensity and hourly cost changes.
Oct 3, 20266 min readSales promotion forecasting separates ordinary demand from the additional units expected during an event. Build the forecast from comparable product and channel rows, check the timing after the event and compare unit lift with the effect of the discount on gross profit.
Oct 3, 20265 min readCompare methods for forecasting US public-budget tax and fee collections. A worked monthly example shows how to reconcile forecast receipts, explain shortfalls and separate recurring changes from collection timing.
Oct 2, 20266 min readSeparate confirmed contingent commission from conditional scenarios. Show assumptions and sensitivity without presenting estimates as earned income.
Oct 1, 20262 min readPredictive analytics in construction is useful when earlier forecasts can be checked against completed work. Compare frozen project-cost estimates and milestone dates with actual outcomes, measure error and decide what needs review.
Oct 1, 20265 min readForecast operating cash flow and capital expenditures from explicit business assumptions. Use a monthly example, a collection downside and a forecast-to-actual bridge to check cash generation.
Sep 30, 20266 min readHolt-Winters forecasting combines level, trend and a repeating seasonal pattern. Compare additive and multiplicative seasonality, work a seasonal forecast from its components and check forecast outputs against actual product demand.
Sep 29, 20266 min readEvaluate supplied churn scores against subsequent customer losses. This worked example separates expected losses, observed churn, outreach capacity, and evidence that a retention action helps.
Sep 28, 20265 min readEvaluate supplied linear regression demand forecasts against actual demand and a baseline. Align the exports, calculate errors, and investigate patterns before relying on the predictions.
Sep 28, 20265 min readRegression analysis tests relationships between inventory-related business measures. Work through a demand example, reserve later periods for validation, and compare prediction errors before using the result in a planning review.
Sep 28, 20265 min readHow to build a sales projection for next year from three parts: existing customers at their net revenue retention, new business from qualified pipeline and win rates, and a top-down check against the growth trend. Worked on three segments, with the Excel formulas and the gap that has to be explained.
Sep 26, 20265 min readPredictive analytics uses statistical models fitted on historical data to estimate a future or unknown value. This page sets it beside descriptive, diagnostic and prescriptive analytics, gives examples from finance and sales, describes the main methods in plain words, and tests a trend forecast on quarters it has not seen, against a naive baseline.
Sep 25, 20266 min readDemand forecasting in project management compares portfolio resource requirements with the hours available to deliver them. Build a monthly role-level view, calculate the cost plan and reconcile shortages that a portfolio total can hide.
Sep 24, 20265 min readCompare forecast misses separately for launch, growth, maturity and decline. This workflow shows the export columns, spreadsheet formulas and checks that keep changing product stages from hiding inside one accuracy score.
Sep 24, 20265 min readTime series regression relates dated business outcomes to trends and drivers. Work through supplied revenue predictions, distinguish residuals from forecast errors, and review seasonality, lagged drivers and chronological validation.
Sep 24, 20266 min readPredictive marketing analytics estimates future customer responses from prior information. Learn how to compare supplied predictions with actual outcomes in unseen periods, check segment errors and challenge the results against a simple baseline.
Sep 20, 20267 min readA monthly cash flow forecast built the direct way: receipts from how customers actually pay, payments by date, and closing cash rolled forward against a minimum buffer. This page gives the template layout, a worked three-month example with the Excel formulas, the checks that prove it, and how to update it against actuals.
Sep 18, 20268 min readIntermittent demand needs a calendar that preserves genuine zeros and a review that separates order timing from order size. Compare supplied forecasts with a worked example, spreadsheet formulas, and checks for slow-moving items.
Sep 18, 20265 min readPharmaceutical demand forecasting needs separate views of commercial forecasts, channel orders, shipments, and inventory approaching its selling cutoff. Use a worked supply reconciliation and lot-level expiry exposure check with spreadsheet formulas.
Sep 18, 20265 min readBuild a multiyear cash forecast from operating drivers, working capital, investment and debt schedules. A linked annual example shows why rising sales can still leave a funding gap.
Sep 17, 20266 min readMarket analysis and sales forecasting connects supplied demand estimates with attainable company sales. Build a regional assumption table, compare it with actual sales, and identify which inputs explain the gap.
Sep 17, 20265 min readTurn an open-payables export and planned purchases into a dated supplier-payment forecast. Use invoice-level checks and a worked weekly schedule to reconcile projected outflows before adding them to company cash.
Sep 16, 20266 min readConvert forecast production volumes into required work-center hours and compare them with site capacity. Use a worked manufacturing example and Excel formulas to expose bottlenecks hidden by company totals.
Sep 15, 20265 min readBuild a monthly sales forecast in Google Sheets from baseline revenue, growth assumptions and incremental pipeline. Compare the completed forecast with actual revenue by month and region, then reconcile the differences.
Sep 15, 20265 min readBuild a customer-month SaaS revenue forecast from retention, contraction, expansion and new sales. Separate recurring run rate from recognized revenue and reconcile the plan with actuals.
Sep 14, 20265 min readDemand forecasting turns expected customer demand into a planning input for supply chain teams. Compare methods, work a SKU-and-site example and check forecast errors before using the result for supply decisions.
Sep 12, 20266 min readCompare aggregate service-volume forecasts with department actuals, staffed capacity and supply budgets. Work through a department example with Excel formulas and checks that keep the totals honest.
Sep 11, 20265 min readBuild a conservative sales forecast from explicit volume, price and timing risks. Compare the downside with the base forecast by customer and region, reconcile the change, and test the assumptions against actual results.
Sep 9, 20265 min readConvert a supplied demand plan into production requirements after inventory and scheduled supply. Use Excel formulas to reconcile finished units, check capacity and expose timing constraints.
Sep 6, 20265 min readBacktesting compares archived forecasts with the actual results that followed. Learn how to preserve forecast dates, compare equal horizons, calculate error and bias, and reconcile revenue and cost results.
Sep 5, 20265 min readDemand planning KPIs connect forecast quality with availability and inventory. Build a planner scorecard from frozen forecasts, customer demand, fulfillment records and stock snapshots, then reconcile the measures before acting.
Sep 4, 20266 min readTurn a demand forecast into a stock requirement using lead times, available inventory and a stated buffer. Follow a spreadsheet example, reconcile the projected balance and test what happens when a receipt arrives late.
Sep 1, 20265 min readA monthly demand forecast needs a preserved starting point, explained revisions and actual demand on the same basis. Follow one planning cycle from exported assumptions to item-level errors and a reconciliation of the total.
Aug 31, 20264 min readBuild Holt's level-and-trend forecast in Excel from monthly sales. Follow the formulas, initialization and held-out accuracy comparison against two simpler baselines.
Aug 30, 20265 min readBuild cash forecasts in each transaction currency before translating them into USD. Use a worked schedule to separate operating movements, currency headroom and exchange-rate effects.
Aug 30, 20265 min readThe Poisson distribution describes demand counts under specific rate and independence assumptions. Compare supplied count-based forecasts with observed low-volume demand, check zero frequency and variation, and recognize when the assumptions are unsuitable.
Aug 28, 20266 min readWin rate, close rate and conversion rate are used interchangeably in sales reporting and have different denominators. Win rate is won over decided. Close rate is usually won over all opportunities created, decided or not. Conversion rate is the share moving from any one stage to the next. This page sets out the three definitions, computes all three on the same hundred opportunities, shows when each is the right one, and lists the questions to ask before comparing a figure to anyone else's.
Aug 28, 20263 min readA template for win-loss analysis that runs on every closed deal instead of an occasional interview program: the seven fields to record at close, a short controlled list of loss reasons, how to stop price becoming the answer to everything, and the four tables the data produces: win rate by segment and size, by competitor, by source and by stage lost. This page gives the fields, the reason list, the tables, the interview questions for the few deals worth a conversation, and a copyable form.
Aug 28, 20265 min readSupply forecasting estimates what will be available by item, site and date. Build a dated supply schedule from inventory and receipts, test capacity assumptions, and reconcile the plan with actual arrivals.
Aug 27, 20265 min readThe honest answer to what B2B sales win rate a team should have: the 20 to 30 percent figures usually quoted depend entirely on the stage the rate is measured from, whether it is counted by deals or by value, and what happens to deals that never close. This page gives the ranges by stage and desk, the three measurable things that set the right figure for one team, and the table to compute before anyone quotes a percentage.
Aug 27, 20263 min readThe honest answer to how accurate a sales forecast should be: the plus or minus 10 percent that is often quoted depends on when in the period the forecast was made, whether the miss is random or always in one direction, and whether accuracy is measured on the total or per rep. This page gives the ranges by horizon, the three measurable things that set the right figure for one team, the horizon, the bias, and the per-rep spread, and the table to compute before anyone quotes a percentage.
Aug 26, 20263 min readThe honest answer to what pipeline coverage a team needs: the widely quoted 3x is a rule of thumb that only holds at one win rate and one sales cycle. This page gives the arithmetic behind 3x, the three measurable things that set the right ratio for one team, the historical win rate on qualified pipeline, the deals that will close in the period, and the pipeline by stage, and the table to compute before anyone quotes a multiple.
Aug 26, 20263 min readThe honest answer to what share of quotes should turn into orders: the 25 to 50 percent figures quoted for distributors and manufacturers depend on how quotes are joined to orders, on whether conversion is by count or by value, and on the customer mix, because some customers quote everything three ways and some only quote what they intend to buy. This page gives the ranges by desk, the three measurable things that set the right figure for one business, and the table to compute before anyone quotes a percentage.
Aug 26, 20263 min readThe complete sell-in against sell-out calculation on one SKU at one retailer over thirteen weeks, small enough to check by hand: weekly shipments and weekly sell-out, cumulative each, implied channel inventory from a stated starting figure, the trailing eight-week sell-out rate, weeks of cover per week, the promotion weeks that explain one build and the loading that explains another, the identity that implied inventory never goes negative, and the next-quarter shipment effect, so a reader can reproduce every figure and then run it on their own files.
Aug 25, 20263 min readBuild a new business sales forecast from explicit leads, conversion, price and capacity assumptions. Use a monthly worked example, test a range, and replace assumptions with observed customer results.
Aug 24, 20265 min readThe complete sales velocity calculation and decomposition across two quarters, small enough to check by hand: qualified opportunities, win rate from outcomes, average won value and cycle length from won deals, velocity as revenue per day, the four one-factor recomputations that attribute the change, the interaction residual, and why cycle length explains more than the whole decline, so a reader can reproduce every figure and then run it on their own snapshots and outcomes.
Aug 24, 20262 min readThe complete renewal calendar calculation on five contracts, small enough to check by hand: end date, notice period and monthly value from the register, the notice window start per contract, the activity log's renewal-type entries in the last ninety days, the untouched-in-notice list, value ending per month, the co-terminus customer whose services end months apart, the rolling contract with no end date, and the identity that the calendar's total equals the contracted base, so a reader can reproduce every figure and then run it on their own register.
Aug 24, 20263 min readThe complete tier gap and utilization calculation on three health system agreements, small enough to check by hand: each agreement's tier thresholds and the tier the customer is priced on, the trailing year's volume from the invoice lines, the tier that volume earns, the price difference per unit between the two tiers times the volume, contracted categories against categories actually bought, the agreement inside its renegotiation window with no activity, and the identity that revenue under agreements plus off-agreement equals the ledger, so a reader can reproduce every figure and then run it on their own agreement register.
Aug 24, 20263 min readBuild a new-business cash forecast from startup costs, sales assumptions and collection dates. Work through a launch example, test slower receipts and compare the plan with the first actual results.
Aug 22, 20265 min readCommit, best case and pipeline are the usual sales forecast categories, and on most teams they mean whatever each rep wants them to mean. This page gives a definition for each category that rests on evidence in the deal rather than on confidence, the close rate each category should achieve if the definitions are being followed, how to test that on the team's own history, how to roll the categories up into a forecast range, and a copyable forecast sheet.
Aug 21, 20265 min readA sales mix forecast projects which products will make up sales and what that composition means for revenue and gross profit. Build unit and revenue shares from a product-level export, then compare actual results with the same price and cost assumptions.
Aug 21, 20265 min readThe complete run rate and seasonal index calculation on one company's twelve months of revenue, small enough to check by hand: the trailing three-month run rate at four points in the year and how far each is from the actual year, the seasonal index per month from three years' shares, the deseasonalized run rate, the same-period-last-year comparison, and the one-off order that doubles a quarter, so a reader can reproduce every figure and then run it on their own ledger.
Aug 20, 20263 min readForecast COGS from expected sales units, product mix and the cost assigned to each unit. Follow a product-level spreadsheet example, reconcile the changes and compare the forecast with actual ledger costs.
Aug 19, 20264 min readA template for a one-to-one pipeline review between a sales manager and a rep: the pre-read table that flags which deals need discussing, the six questions to ask about each flagged deal, how to handle stalled deals and slipped close dates, how the review feeds the forecast, and what to record. This page gives the flags, the questions, a thirty-minute structure, and a copyable template, so the review is about the ten deals that need a decision and not a recital of all forty.
Aug 19, 20265 min readThe complete quote-to-order conversion calculation on ten quotes from three customers and two estimators, small enough to check by hand: the quote log's requested and issued dates and value, the order book's quote references, conversion by count and by value per customer, per product family, per estimator and per turnaround band, the price-check customer, the family losing on value, the slow quotes that lose, the order that references no quote, and the identity that converted quote value equals booked orders from quotes, so a reader can reproduce every figure and then run it on their own quote log.
Aug 19, 20263 min readThe complete pace calculation on one hotel for one future month, small enough to check by hand: rooms and revenue on the books by segment from today's reservation snapshot, the same month at the same point last year from the kept snapshot, pace by segment in rooms and as a share, budget by segment, pickup needed, historical pickup from this point from three years of snapshots, the segment that is behind while the comparable set is ahead, and the identity that segments sum to the snapshot, so a reader can reproduce every figure and then run it on their own snapshots.
Aug 18, 20262 min readPipeline coverage and weighted pipeline are two ways of asking whether there is enough pipeline to make the number. Coverage divides unweighted in-period pipeline by the target and compares the multiple to one over the win rate. Weighted pipeline multiplies each deal by a stage probability and compares the sum to the target directly. This page sets out both, computes them on the same ten deals, shows that they agree when the stage probabilities are the team's own measured rates and disagree when they are defaults, and says which to use for what.
Aug 18, 20264 min readCompare forecast shipment volumes, actual demand and usable capacity by site and lane. Use a weekly spreadsheet review to identify local shortages that a company total can hide.
Aug 17, 20265 min readThe complete meeting-to-opportunity conversion calculation on ten first meetings from two reps, small enough to check by hand: the first-meeting rule, the source per account, the pipeline's opportunity created dates, the thirty-day window, converted or not per meeting, the follow-up check, conversion per rep and per source, the no-follow-up list, the meeting whose opportunity came outside the window, and the assertion that first meetings equal converted plus followed-up plus no-follow-up, so a reader can reproduce every figure and then run it on their own activity log and pipeline.
Aug 17, 20263 min readBuild a subscription cash forecast from billing, customer collection dates and operating payments. A worked example separates annual prepayments from revenue and shows how a delayed renewal changes cash headroom.
Aug 15, 20265 min readA going concern cash flow forecast organizes the evidence behind management's liquidity assessment. Build the cash schedule, test a downside case, separate proposed funding, and reconcile the result before drawing a conclusion.
Aug 14, 20266 min readDurable-goods demand combines replacement purchases, new buyers and changes in channel inventory. Build a transparent comparison from your installed-base assumptions, supplied forecasts and actual orders.
Aug 13, 20265 min readThe complete forecast bias and error calculation on five reps over four quarters, small enough to check by hand: each rep's week-six forecast and closed result per quarter, the signed miss, error as the mean absolute miss, bias as the mean signed miss, the four kinds of rep, the adjustment for the predictably-high rep with its range, the reps with too few quarters to adjust, and the identity that the adjusted total equals the raw total plus the adjustments, so a reader can reproduce every figure and then run it on their own snapshots.
Aug 13, 20263 min readThe complete sponsorship delivery ratio calculation on three partners at two thirds of a season, small enough to check by hand: each partner's contracted assets and fixtures, rate card per asset per fixture, units delivered from the delivery log, delivered value at rate card, contract value, the delivery ratio, the expected ratio from the package discount, the gap in points, the unconfirmed fixtures that count as neither, the make-goods owed with a third of the season left, and the assertion that delivered units never exceed capacity, so a reader can reproduce every figure and then run it on their own contract file and delivery log.
Aug 12, 20263 min readThe complete deposit flight calculation on five commercial banking relationships, small enough to check by hand: the trailing twelve month-end balances and the median as baseline, the last three months against the baseline and against the same months last year, the decline rule, the transaction split that says whether the money moved to another bank, the business shrank or the season turned, the balances gone, and the assertion that balances reconcile to receipts and payments, so a reader can reproduce every figure and then run it on their own balance file.
Aug 12, 20263 min readA demand forecasting process connects source exports, documented adjustments, an approved snapshot, and a review against actual demand. Follow the handoffs with a worked reconciliation and exact spreadsheet formulas.
Aug 11, 20265 min readBuild SaaS financial projections from customer movements, pricing, delivery costs and hiring assumptions. Follow a monthly spreadsheet example, reconcile cash and receivables, and compare the projection with actual performance.
Aug 11, 20265 min readHotel forecasting connects room-night demand and average daily rates to room revenue. Build the forecast from operating exports, compare it with actual results, and reconcile the difference to volume and rate.
Aug 10, 20265 min readHow to compute win rate from closed outcomes rather than open pipeline, why the team's single figure hides a 45 percent rate in one segment and a 12 percent rate in another, the three splits that matter, segment, source and deal size band, the minimum count that makes a split trustworthy, and how the split changes where the pipeline effort goes.
Aug 8, 20262 min readAn unconstrained demand forecast estimates what customers would request without availability limits. Separate recorded sales from assumed lost demand, work a stockout adjustment, and test the estimate before using it for inventory decisions.
Aug 7, 20265 min readHow a SaaS customer success team finds the onboarding milestone that most separates renewed from churned accounts, from the usage export, the onboarding log and the renewal outcomes: days to each milestone per account, first-renewal retention by whether and when the milestone was reached, the milestone with the largest separation, the accounts in onboarding now that are past its typical day without reaching it, and the honest statement that it is an association.
Aug 5, 20263 min readUnderstand what Monte Carlo scenario results say about business cash shortfalls, revenue assumptions and cost exposure. Use a worked scenario export to calculate downside frequency, percentiles and funding gaps without confusing simulation output with certainty.
Aug 2, 20266 min readHow a freight broker reads its tender log as a capacity signal: rejections over tenders per lane per week, the lanes where the rate rose against their own baseline before spot rates did, the carriers rejecting most on each lane, the cost of a rejection in the spread between the contracted rate and the cover rate, and the shipper conversation that a rising rejection rate should trigger before the lane goes to spot.
Aug 2, 20262 min readThe ten questions the chief executive of an education provider puts to the sales and success teams, which institutions renew in six months with low utilization, which cohort stalled, which trusts and districts are counted as ten schools, what did the price uplift realize, which programs fit which institutions, which entities have gone silent before the academic year, which account managers hold a price, what is the pipeline against the year's target, which institutions are over their seats, and what changed, each with the table from the license register, the usage export and the orders, and the answer to send back.
Aug 1, 20262 min readThe ten questions the chief executive of a commercial insurance broker puts to the placement and account teams, which renewals are in notice with no remarketing, which lines do our clients place elsewhere, where is one carrier the line, which clients' claims changed their renewal risk, what did we lose and to whom, which executives' books stopped growing, which new business leaves at the first renewal, which clients' programs sit with one carrier, what is the commission and fee mix, and what changed, each with the table from the placement ledger, the outcomes and the claims file, and the answer to send back.
Aug 1, 20263 min readThe ten questions a hotel group's commercial director puts to the property and sales teams, which properties are behind pace and in which segment, which corporate accounts under-produce their agreements, which properties have the wrong segment mix for their set, where does function space sit empty, which accounts leak to public rates, which sales managers cover their accounts, which properties turn business away midweek, which agreements expire with no production review, what is the group's concentration by account, and what changed, each with the table from the reservation snapshots and the agreement file, and the answer to send back.
Jul 31, 20262 min readThe ten questions a SaaS chief revenue officer puts to the sales and success teams about existing customers, what is net revenue retention by cohort and which cohort broke, which accounts renew inside 120 days under their seats, is the expansion pipeline on the accounts with whitespace, which onboardings are behind the milestone that predicts renewal, what is whitespace reconciled to ARR, which accounts are over their cap, which accounts have gone untouched, what do bookings, billings and revenue each say, which deals slipped three times, and what changed, each with the table from the subscription ledger, the usage export and the CRM, and the answer to send back.
Jul 31, 20262 min readBuild a purchase forecast from supplied demand, inventory and lead-time assumptions. Compare it with purchase orders and receipts by item and supplier, with checks that distinguish quantity, timing and mix.
Jul 30, 20265 min readCompare a comparable product's launch with an explicit buyer-adoption estimate. Build both forecasts, preserve the assumptions, and test them against early actual sales.
Jul 29, 20265 min readPredictive analytics for customer retention tests whether earlier account risk flags identify later churn. Work from dated exports, compare account cohorts, and check precision, recall, and the revenue behind missed renewals.
Jul 29, 20266 min readThe ten questions a head of customer success asks about the base, which accounts are at risk, which are under-using what they bought, which renewals are inside the window untouched, which accounts are surging or silent on support, which have to call twice, which onboardings are behind the milestone that matters, which are over their seat cap, which cost more to serve than they pay, which churned last quarter and why, and what the health score got wrong, each with the computed signal that answers it and the list it produces.
Jul 29, 20263 min readSeparate persistent forecast bias, irregular variation, timing shifts, structural changes, and data mistakes. Use a forecast snapshot and actuals export to find the pattern before choosing a correction.
Jul 28, 20265 min readHow a sales leader measures slip count from weekly pipeline snapshots: the number of times each open deal's close date has been pushed, the close rate by slip count from the team's own history, the weighted forecast that discounts multi-slip deals by that rate, the reps whose pipeline carries the most slips, and why a deal that slipped three times is a different object from a deal that slipped once.
Jul 27, 20263 min readDemand estimation describes demand for a defined period from incomplete observations. Forecasting projects demand into a future period; compare both using the same SKU rows, clear cutoffs and separate actuals.
Jul 26, 20266 min readDemand forecasting estimates what customers will request in a future period. Build a simple baseline, separate demand from recorded sales, and check forecast errors against the rows behind them.
Jul 26, 20265 min readExecutive opinions forecasting uses management judgment to estimate future sales. Document the assumptions, preserve the original baseline and test whether executive adjustments improve the result.
Jul 26, 20265 min readHow a business telecom provider reads its usage data per site against each site's contracted capacity: peak utilization against the circuit's bandwidth, the sites above a stated share of capacity for a stated number of days, the customers with several such sites, the upgrade value at the next tier, the sites whose usage fell to nothing and may be closing, and why the upgrade list beats the fault ticket as the moment to sell more.
Jul 26, 20262 min readHow a CPG brand compares what it shipped to each retailer with what the retailer sold through, from the shipment ledger and the sell-out data: the channel inventory implied by the difference, weeks of cover per retailer and per SKU, the retailers where sell-in has run ahead of sell-out for a quarter, the promotions that loaded the channel, and why a strong shipment quarter with rising channel inventory is next quarter's problem.
Jul 25, 20262 min readHow an industrial manufacturer builds a service contract calendar from the installed base register: units by warranty end date and contract end date per customer, the attach rate for units in their first year off warranty from the manufacturer's own history, the customers with units coming off warranty in the next two quarters and no contract offer logged, the value of a contract at the norm per unit, and why the call belongs to the service sales team before the parts desk hears from the customer.
Jul 25, 20262 min readProbabilistic demand forecasting describes possible demand outcomes and their likelihood. Compare supplied forecast intervals with actual demand, measure coverage and width, and check whether uncertainty assumptions support business decisions.
Jul 24, 20266 min readHow seasonality distorts every trend-based measure, run rate, dormancy, surge, forecast bias, and the two comparisons that handle it: same period last year, and a seasonal index from the company's own history. When each applies, how the index is built per segment and per account, the accounts whose seasonality is their own, the rule that the comparison is stated on the line, and the four measures where the trailing average is simply wrong.
Jul 24, 20262 min readHow a SaaS revenue team turns product usage and the contract register into a renewal risk and expansion list: active seats against contracted seats per account, the utilization trend over the last two quarters, the accounts under a threshold with a renewal inside 120 days, the accounts at or above their seat cap, and the identity that ties the seat table to ARR.
Jul 24, 20262 min readIndustrial demand combines repeat purchases, replacement needs and customer projects. Compare those drivers with supplied forecasts and actual net orders using a reconciled product-level workbook.
Jul 23, 20265 min readThe sales velocity formula, opportunities times win rate times average deal value divided by cycle length, how to compute each factor from CRM snapshots and closed outcomes rather than from the CRM's own summary, per rep and per segment, why the factors are not independent, and how to find which one changed when velocity did, with a worked decomposition.
Jul 23, 20263 min readWhy run rate is the floor a forecast should be compared to rather than a forecast itself, what the gap between the two is made of, new business, expansion, churn, seasonality and known changes, the bridge from run rate to forecast with a line for each, the forecast that sits below run rate and needs a reason, the one far above it and needs pipeline, and the rule that the forecast is defended by the lines between it and the floor.
Jul 22, 20263 min readThe run rate formula, the choice of window and why it matters, a worked example against a seasonal and a lumpy business, the four ways run rate misleads, seasonality, one-off orders, a short window and a trend, and the rule for when to annualize and when not to. With the account-level use that makes run rate a ranking rather than a forecast.
Jul 22, 20263 min readEvaluate demand estimates against actual sales at the product and location level. Use a frozen forecast, a simple benchmark and reconciled error measures before accepting an explanation.
Jul 21, 20265 min readRevenue forecasting automation makes recurring preparation and comparisons repeatable while people own assumptions and approvals. Follow a spreadsheet workflow that reconciles saved versions, actual revenue and unexplained segment changes.
Jul 21, 20266 min readSales forecasting for multiple products builds a company outlook from consistent product rows. Reconcile units, prices, and revenue, preserve unexplained target gaps, and compare the frozen forecast with actual sales.
Jul 21, 20265 min readHow a sports organization reads partner renewal timing from its contract history: days before expiry at which each partner renewed in past cycles, the organization's own norm by partner tier, the partners now past their usual signing point with no renewal, what the late renewers of past seasons had in common, falling delivery ratio, low hospitality yield, a change of marketing director, and the list that says who to call this week.
Jul 20, 20263 min readHow a sports organization's partnerships team measures what each partner received against what they paid, from the delivery log and the contract file: delivered inventory valued at rate card against contract value, the partners under-delivered who will ask for make-goods, the partners over-delivered whose renewal should price the extra in, and the timing that puts the list in front of the team before the renewal window opens.
Jul 20, 20262 min readMAD measures the average absolute forecast miss in the original business units. This page calculates it from saved forecasts and actuals, proves the result, and explains the row count, scale and missing-data choices that affect it.
Jul 19, 20266 min readPredictive revenue estimates future sales from historical revenue and information available at the forecast date. Learn how to choose inputs, test predictions on later periods, measure bias and assess uncertainty before using the figures in a business plan.
Jul 19, 20265 min readHow an asset manager's distribution team finds the intermediaries whose net flows have turned negative against their own history while their assets still look intact, from the transfer agent file: the flow baseline per intermediary per strategy, the turn signal, the months of runway before the assets follow, and the list that reaches the wholesaler while there is still a conversation to have.
Jul 19, 20262 min readRestaurant sales forecasting starts with comparable trading days, expected covers and average check. Work from POS exports to a location and service-period forecast, then reconcile actual sales to the assumptions.
Jul 19, 20265 min readHow an industrial manufacturer measures the share of quotes that become orders per customer, per product family and per estimator, from the quote log and the order book: conversion by count and by value, the customers who request many quotes and place few orders, the product families where the price is losing, the lead time on quotes that convert against those that do not, and the identity that ties converted quotes to booked orders.
Jul 18, 20263 min readHow to build a sales forecast bridge from pipeline history: the components that explain the difference between run rate and forecast, the slip count per deal that predicts the next slip, and the follow-up questions that turn the forecast call into a conversation about evidence.
Jul 18, 20263 min readWhy a month-to-date figure read on the 12th misleads in three predictable ways, the day-of-month profile that says how much of a normal month has usually landed by each day, the projection that follows and its range, which measures can be read mid-period and which cannot, and the rule that a partial-period figure is always shown with its expected share and never beside a full period as if comparable.
Jul 18, 20262 min readBuild a retail demand comparison from product-store forecasts, sales and availability records. Separate promotion assumptions and stockout weeks, calculate forecast error with spreadsheet formulas, and identify the stores that need review.
Jul 18, 20266 min readHow a consulting or advisory firm measures proposal win rate from its proposal log and engagement letters, by practice, by source, existing client, referral, competitive tender or cold, and by fee band, the cost of a proposal in hours from the time entries, the cost per win by cell, and the cells where the firm spends the most partner time for the least work.
Jul 17, 20263 min readHow a pharmaceutical commercial team measures whether a formulary or payer win turned into prescriptions, from the access file, the prescription data and the call log: the accounts whose access opened on a date, their prescriptions before and after against accounts whose access did not change, the calls made to them in the weeks after the win, the territories where access opened and nobody called, and the honest statement of what the difference is and is not.
Jul 17, 20262 min readIndustry-level demand forecasting estimates purchases across a defined market rather than one company's sales. This guide shows how market assumptions, segment growth and company share connect, with a worked example and checks that keep the forecast scope consistent.
Jul 16, 20266 min readPipeline coverage is open pipeline over remaining target, and on many desks there is no CRM pipeline at all: the pipeline is renewals due, tenders in flight, RFQs open, applications pending, or the season's filings. This hub gives, for twelve industries, what stands in for the pipeline, where it lives, how it is weighted, and the multiple the desk actually needs, with the guide for each.
Jul 15, 20263 min readThe complete pipeline coverage calculation on ten open deals small enough to check by hand: the deals by stage and value, the team's historical conversion by stage at this point in the quarter, the face value, the weighted value, the slip counts and the slip adjustment, the remaining target, coverage three ways, the needed multiple, and the deal list that explains the gap, so a reader can reproduce every figure and then run it on their own snapshot.
Jul 15, 20263 min readThe pipeline coverage formula, why the common three-times rule is a guess, how to derive the multiple your team actually needs from its own stage conversion history, the coverage by rep and by stage that comes out, and the gap to target in dollars that a sales leader can act on with weeks left.
Jul 15, 20262 min readWhy a stage-weighted forecast is only as good as the stage definitions, what an exit criterion is, five stages with criteria a rep can verify and a manager can audit, how to check from the CRM that deals in a stage actually meet its criteria, the stage probabilities derived from the team's own history rather than set in a workshop, and the versioning that keeps last year's pipeline comparable.
Jul 15, 20262 min readHow an investment bank's coverage and product groups measure pitch-to-mandate conversion from the pitch log and the mandate register: pitches made per sector team and product, mandates won, conversion by count and by estimated fee, the senior hours per pitch from time or calendar records, fees won per senior hour by cell, and the sectors and products where the bank pitches most and wins least.
Jul 15, 20263 min readHow a hotel group builds a pace report from the reservation export that a revenue manager can act on: rooms and revenue on the books for each future month against the same point last year, by segment, per property, the properties behind pace in a segment where their comparable set is ahead, the pickup still needed to reach budget, and the identity that ties the pace table to the reservation system.
Jul 14, 20262 min readTime series forecasting uses ordered business history to estimate future revenue or demand. Follow a monthly example, check the forecast against actuals and identify the decisions the results support.
Jul 14, 20265 min readA top-down sales forecast turns addressable demand and an explicit market-share assumption into revenue. Build the estimate by segment, compare it with historical sales, and test the customer and capacity requirements behind the result.
Jul 14, 20265 min readBuild a bank cash flow schedule from loan receipts, deposit maturities and funding payments. Work through maturity buckets, cumulative balances and a deposit-withdrawal scenario, with spreadsheet formulas and reconciliation checks.
Jul 12, 20266 min readLong term demand forecasting connects multiyear customer and usage assumptions to a capacity decision. Build a spreadsheet scenario, reconcile demand to available finished-unit capacity and see which assumptions change the timing of an expansion.
Jul 12, 20265 min readTranslate a supplied production plan into component requirements, then reconcile materials with usable stock and timely receipts. Follow a worked example with Excel formulas and a stock balance check.
Jul 12, 20265 min readHow a sales leader measures the share of first meetings that become a qualified opportunity within a stated window, per rep and per source, from the activity log and the pipeline: the conversion rate, the meetings with no opportunity and no follow-up, the reps with many meetings and little pipeline, the sources whose meetings convert, and why the measure sits between activity and pipeline where most teams measure neither.
Jul 11, 20262 min readEvaluate retail demand estimates against actual unit sales and a simple baseline. Work from store and SKU exports, calculate forecast errors, and separate stockouts and returns before judging the result.
Jul 8, 20265 min readA reading guide for a forecast bridge from last period's number to this one: the check that the lines sum before anything is read, the order to read them in, closed, slipped, lost, new, resized, the deal list behind each line as the thing to open, the line with no deals behind it as the one to distrust, the repeat slippers across bridges, and the two lines that set next period's calibration.
Jul 6, 20263 min readA reading guide for a pipeline table by rep and stage: why face value is the column to distrust, why weighted by historical conversion is the one to believe, what the slip count column does to both, how to read stage distribution as a shape rather than a total, the needed multiple against coverage, and the two rows to open, the rep whose weighted coverage is lowest and the rep whose face-to-weighted ratio is highest.
Jul 6, 20262 min readCash forecasting in treasury management brings entity submissions into a reconciled view of future cash. Follow the account mapping, intercompany checks, availability bridge and version comparison, with spreadsheet formulas and a worked US company example.
Jul 4, 20266 min readHow a sales leader measures forecast accuracy per rep from the weekly forecast snapshots and the closed results: error, bias and the split between them, why a rep who is always 20 percent high is more useful than one who is randomly 10 percent out, the per-rep adjustment it produces, and the identity that ties the adjusted forecast to the raw one.
Jul 2, 20263 min readThe four common ways to forecast a quarter, rep roll-up, stage-weighted pipeline, run rate and historical conversion, what each needs, what each is good and bad at, a worked quarter where they give four different numbers, and why the right output is not one of them but the bridge between them, with the deals that explain the gaps.
Jul 2, 20263 min readTest customer collections, sales receipts and payment dates together to find a liquidity shortfall. A worked weekly example shows the formulas, the minimum balance and the checks behind each scenario.
Jul 1, 20265 min readService parts demand is often intermittent, so weekly forecast errors need to be read alongside stock and service criticality. Work through a parts-usage example, spreadsheet formulas and inventory checks by part and site.
Jul 1, 20265 min readHow a SaaS revenue team checks whether its expansion pipeline covers the whitespace the account data shows: expansion opportunities per account against the account's valued whitespace, the accounts with large gaps and no open opportunity, the opportunities on accounts with no gap, the share of whitespace value under active pursuit per rep, and the identity that ties expansion pipeline to the whitespace grid.
Jun 30, 20263 min readHow a supply chain team measures demand forecast accuracy and bias per SKU per site from the forecast snapshots and the actual demand: error and signed bias, the SKU-site pairs that are consistently over-forecast and carry the excess stock, the ones consistently under-forecast and carry the stock-outs, why bias at one site is usually a planner's override, and the adjustment the team's own history supports.
Jun 29, 20263 min readHow a commercial bank finds the relationships whose operating balances have fallen against their own baseline while the accounts remain open, from the daily or month-end balance file: the balance baseline per customer, the decline signal, the split between seasonal, business-driven and moved-elsewhere, and the list per relationship manager ranked by the balances that have gone.
Jun 29, 20262 min readA projected balance sheet translates operating and financing assumptions into future assets, liabilities and equity. Build a linked forecast, reconcile cash and compare the supplied projection with actual balances.
Jun 28, 20265 min readCompare forecast methods against actual business results using fixed horizons and holdout periods. Work through error measures, baseline comparisons and the checks needed before choosing a method.
Jun 26, 20265 min readHow a customer service leader turns the ticket export into a weekly list of accounts whose contact volume has jumped against their own history, why the account's own baseline beats a global threshold, the surge score, and the two readings every surge has: a product problem or an account about to leave.
Jun 25, 20262 min readHow a business telecom provider builds the renewal calendar from the contract register: contract value ending per month per account manager, the accounts within the notice window with no logged renewal activity, the co-terminus opportunities where a customer's services end months apart, and the identity that ties the calendar's total to the contracted base.
Jun 25, 20262 min readHow a commercial insurance broker joins the claims file to the placement ledger and the renewal outcomes to see how claims experience affects retention: loss ratio per client per line, the clients whose ratio moved past the carrier's appetite, the clients with a large open claim inside the renewal window, the historical non-renewal rate by claims band from the broker's own book, and the remarketing list ranked by both the risk and the premium.
Jun 24, 20263 min readS&OP forecasting brings demand, supply and financial assumptions onto the same basis. Compare monthly product-family exports, calculate the gaps, and reconcile the resulting revenue plan.
Jun 23, 20265 min readHow a company that sells on orders rather than subscriptions measures churn from its ledger: the definition of a lost customer from its own order cadence, churned revenue as the run rate before the silence, the churn rate by segment and by rep, the identity that ties churned plus retained plus new to the two periods' revenue, and why a fixed 12-month rule counts the wrong customers as lost.
Jun 22, 20262 min readHow a medical supplies company builds a contract expiry calendar from its agreement register: GPO and system agreements by end date, the revenue and facilities under each, the agreement's utilization, contracted categories actually bought, the tier the customer earned against the tier it is on, the agreements inside the renegotiation window with no activity logged, and the identity that revenue under agreements plus off-agreement revenue equals the ledger.
Jun 21, 20262 min readConnect sales volume and net price to COGS, operating expenses and profit in one planning workbook. Follow a business-unit example, test lower demand and reconcile each scenario to the same assumptions.
Jun 21, 20265 min readSeparate internal execution changes from external demand assumptions when sales miss the forecast. Build a checked price and volume bridge, then investigate the evidence behind each movement.
Jun 18, 20265 min readARIMA time series analysis uses relationships with earlier values and errors to forecast a dated measure. Compare supplied forecasts with actual revenue and a naive baseline, then review suitability, bias and source checks.
Jun 16, 20266 min readCompare the hours required to deliver planned work with the hours available from your workforce. This guide builds a department-level staffing gap from workload, productive time and expected employee movements, then checks whether a proposed transfer closes the gap.
Jun 13, 20266 min readBuild a monthly project revenue forecast from approved scope, delivery plans and recognition assumptions. Reconcile the project schedule to backlog and compare it with recognized revenue.
Jun 13, 20265 min read