{"id":9246,"date":"2026-03-10T05:17:26","date_gmt":"2026-03-10T05:17:26","guid":{"rendered":"https:\/\/forquestsolutions.com\/staging\/7345\/?p=9246"},"modified":"2026-03-15T05:25:02","modified_gmt":"2026-03-15T05:25:02","slug":"case-study-cpg-financial-trade-planning","status":"publish","type":"post","link":"https:\/\/forquestsolutions.com\/staging\/7345\/case-study-cpg-financial-trade-planning\/","title":{"rendered":"How a Leading Pet Care Company Connected Financial Planning to $180M in Trade Spending"},"content":{"rendered":"\n<p><strong>How a leading pet care company connected its financial plan to $180M in trade spending \u2014 giving the CFO a real gross-to-net P&amp;L and the sales team promotion ROI they could actually act on.<\/strong><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">The Client<\/h3>\n\n\n\n<p>A leading pet care company with annual revenue exceeding $800M across 8 product categories including flea &amp; tick treatments, pet nutrition, grooming, and accessories. The company manages 3,000+ SKUs distributed through grocery, mass, pet specialty, club, and e-commerce channels \u2014 with an annual trade spend budget of $180M representing 22% of gross revenue.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Challenge: Two Planning Worlds That Never Connected<\/h3>\n\n\n\n<p>The company ran two completely separate planning processes: Finance owned the P&amp;L plan in one set of spreadsheets; Sales owned trade spend planning in another. The two never connected \u2014 which meant the CFO&#8217;s financial plan used a flat trade rate assumption while Sales committed $180M in actual promotions that didn&#8217;t match.<\/p>\n\n\n\n<p>The consequences were severe and compounding:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Financial plan disconnected from trade reality<\/strong> \u2014 the annual P&amp;L budget used a blended 20% trade rate assumption across all channels. Actual trade rates ranged from 12% in e-commerce to 32% in grocery. The financial plan was wrong before the year even started<\/li>\n\n\n\n<li><strong>10-week annual plan cycle<\/strong> \u2014 Finance, Sales, and Marketing each built their plans sequentially. Finance set revenue targets in August, Sales built promotion calendars in September, and Marketing layered in brand spending in October. The final consolidated plan wasn&#8217;t approved until mid-November \u2014 6 weeks before the fiscal year started<\/li>\n\n\n\n<li><strong>No gross-to-net visibility<\/strong> \u2014 the P&amp;L showed net revenue, but nobody could decompose it into gross revenue minus trade spend minus returns minus slotting by channel, customer, or brand. The CFO couldn&#8217;t explain why net revenue missed when gross shipments were on plan<\/li>\n\n\n\n<li><strong>Trade spend planned by region, not by ROI<\/strong> \u2014 6 regional sales directors each managed their own promotion budgets in Excel with no standardized event templates, no ROI measurement, and no post-event analysis. $180M was allocated by historical precedent, not performance<\/li>\n\n\n\n<li><strong>Forecast disconnected from actuals<\/strong> \u2014 the monthly forecast process took 3 weeks because Finance manually collected trade spend actuals from Sales, reconciled them against the financial plan, and adjusted the remaining quarters. By the time the forecast was done, it was already stale<\/li>\n\n\n\n<li><strong>Accruals consistently wrong<\/strong> \u2014 trade spend accruals were based on the original budget, not actual promotion execution. The gap between accrued and actual trade spend created $8M+ in quarterly true-ups that the audit committee flagged as a material weakness risk<\/li>\n<\/ul>\n\n\n\n<p>The CFO put it bluntly: &#8220;We budget $180 million in trade spend and we can&#8217;t tell you whether it&#8217;s working, where it&#8217;s going, or how it affects the bottom line.&#8221;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Solution: ProfitCy\u00ae Financial Planning &amp; Trade Spend on IBM Planning Analytics<\/h3>\n\n\n\n<p>ForQuest deployed ProfitCy\u00ae with two integrated modules \u2014 Financial Planning and Trade Spend Management \u2014 on IBM Planning Analytics. The critical design principle: one model where the trade spend plan flows directly into the financial plan with full gross-to-net reconciliation.<\/p>\n\n\n\n<p>The implementation took 14 weeks from kickoff to production.<\/p>\n\n\n\n<p><strong>What ForQuest built:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Integrated gross-to-net P&amp;L<\/strong> that starts with gross revenue by channel \u00d7 brand \u00d7 customer tier and flows through trade spend, returns, slotting fees, and allowances to arrive at net revenue \u2014 with every deduction category plannable and trackable separately<\/li>\n\n\n\n<li><strong>Trade spend planning by event<\/strong> with standardized promotion templates across all 6 regions. Each event captures promotion type, timing, volume lift assumption, funding source, and expected ROI. The trade plan rolls up to the financial plan automatically \u2014 eliminating the disconnect between what Sales commits and what Finance budgets<\/li>\n\n\n\n<li><strong>Channel-level trade rate planning<\/strong> replacing the flat 20% blended assumption with actual trade rate targets by channel (grocery 28-32%, mass 22-26%, club 18-22%, pet specialty 14-18%, e-commerce 10-14%). Finance and Sales now plan to the same trade rates<\/li>\n\n\n\n<li><strong>Monthly rolling forecast with trade integration<\/strong> \u2014 actuals from the trade management system feed into TM1 via TurboIntegrator. The forecast automatically adjusts remaining trade spend, net revenue, and margin based on actual promotion execution \u2014 no more 3-week manual reconciliation<\/li>\n\n\n\n<li><strong>Trade accrual engine<\/strong> that calculates monthly accruals based on actual promotion execution status rather than original budget. Each promotion carries a status (planned, committed, executed, settled) and the accrual adjusts accordingly \u2014 eliminating the quarterly true-up surprises<\/li>\n\n\n\n<li><strong>Trade ROI analytics<\/strong> calculating incremental volume, incremental revenue, trade spend, and ROI at the event \u00d7 account \u00d7 product level. Category managers can see which promotions are driving profitable volume and which are subsidizing baseline<\/li>\n\n\n\n<li><strong>PAXcel\u2122 dashboards<\/strong> giving Finance the gross-to-net bridge in Excel, Sales the trade spend tracker with ROI by event, and the CFO a consolidated P&amp;L with full trade waterfall \u2014 all from the same TM1 model<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Why ProfitCy\u00ae Made the Difference<\/h3>\n\n\n\n<p>The company had previously evaluated a standalone trade promotion management (TPM) tool. The vendor proposed a $1.4M, 12-month implementation \u2014 but the tool couldn&#8217;t integrate with the financial planning process. It would have created a third planning silo alongside the existing Finance and Sales processes.<\/p>\n\n\n\n<p>ProfitCy\u00ae solved this by building trade spend planning natively inside the financial planning model:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Trade events roll up to the P&amp;L automatically \u2014 no integration, no reconciliation, no &#8220;Sales says one number, Finance says another&#8221;<\/li>\n\n\n\n<li>Gross-to-net decomposition uses the same chart of accounts and customer\/channel hierarchies as the financial plan<\/li>\n\n\n\n<li>Monthly forecast actuals flow through one TurboIntegrator process that updates both trade and financial views simultaneously<\/li>\n\n\n\n<li>Accruals calculate from the same promotion data that drives the P&amp;L \u2014 because it&#8217;s the same model<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">The Results: Measurable Impact in Two Quarters<\/h3>\n\n\n\n<p><strong>10 Weeks \u2192 4 Weeks: Annual Plan Cycle<\/strong><br>Finance, Sales, and Marketing now plan concurrently in the same TM1 model instead of sequentially in separate spreadsheets. Revenue targets, trade spend, and brand investment are planned together with real-time visibility into the gross-to-net impact. The plan is board-approved 6 weeks earlier than before.<\/p>\n\n\n\n<p><strong>Gross-to-Net Visibility: First Time Ever<\/strong><br>The CFO can now decompose net revenue into gross shipments minus trade discounts, off-invoice allowances, performance incentives, slotting, returns, and cash discounts \u2014 by channel, brand, customer tier, and period. When net revenue misses, the team knows within hours whether the gap is volume, price, trade rate, or mix.<\/p>\n\n\n\n<p><strong>Trade ROI: $6.2M Reallocated<\/strong><br>The first full quarter of trade ROI analytics revealed that 28% of grocery promotions generated zero incremental volume \u2014 customers were buying on deal what they would have bought at full price. The Sales team reallocated $6.2M from zero-lift events to high-performing accounts and new product launch support.<\/p>\n\n\n\n<p><strong>Monthly Forecast: 3 Weeks \u2192 4 Days<\/strong><br>The monthly forecast now takes 4 business days. Trade actuals feed automatically from the trade management system. Finance reviews exceptions and adjusts the outlook rather than spending 3 weeks manually reconciling Sales and Finance data.<\/p>\n\n\n\n<p><strong>Trade Accruals: $8M Quarterly True-Ups Eliminated<\/strong><br>The event-level accrual engine reduced quarterly trade accrual true-ups from $8M+ to under $400K. The audit committee removed the material weakness flag. Monthly accruals now reflect actual promotion execution status rather than static budget assumptions.<\/p>\n\n\n\n<p><strong>Channel Trade Rates: Planned and Tracked<\/strong><br>Finance and Sales now plan to the same channel-level trade rates. Actual trade rates are tracked monthly against plan with variance analysis by channel, brand, and customer tier. The blended trade rate dropped from 24.1% to 22.3% in the first year \u2014 representing $14.4M in improved gross-to-net efficiency.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Client&#8217;s Perspective<\/h3>\n\n\n\n<p>&#8220;For the first time, my financial plan and my trade plan are the same plan. I don&#8217;t have to reconcile two different versions of reality anymore. When the board asks why net revenue moved, I can show them the exact gross-to-net bridge in real time.&#8221;<\/p>\n\n\n\n<p><em>\u2014 Chief Financial Officer<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Technology Stack<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Platform:<\/strong> IBM Planning Analytics (TM1)<\/li>\n\n\n\n<li><strong>Planning Model:<\/strong> ProfitCy\u00ae Financial Planning + Trade Spend Management<\/li>\n\n\n\n<li><strong>Excel Connectivity:<\/strong> PAXcel\u2122 Web Add-In<\/li>\n\n\n\n<li><strong>Data Integration:<\/strong> TurboIntegrator (ERP, trade management system, syndicated POS data)<\/li>\n\n\n\n<li><strong>Dashboards:<\/strong> Planning Analytics Workspace (PAW)<\/li>\n\n\n\n<li><strong>Implementation Timeline:<\/strong> 14 weeks<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Is Your Financial Plan Disconnected from Trade Spending?<\/h3>\n\n\n\n<p>If your CFO sees one number and your Sales team sees another, ForQuest can help. ProfitCy\u00ae connects financial planning to trade spend management in one IBM Planning Analytics model \u2014 with full gross-to-net visibility.<\/p>\n\n\n\n<p><strong><a href=\"\/get-a-demo\/\">Book a Demo \u2192<\/a><\/strong> | <strong><a href=\"\/financial-planning\/\">View Financial Planning Module \u2192<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A leading pet care company with $800M in revenue replaced disconnected financial planning and trade spend processes with ProfitCy\u00ae on IBM Planning Analytics \u2014 connecting gross-to-net revenue planning with trade promotion ROI for the first time and cutting the annual plan cycle from 10 weeks to 4.<\/p>\n","protected":false},"author":16,"featured_media":9241,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[89],"tags":[104,105,88,22,86,64,106],"class_list":["post-9246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-studies","tag-cpg","tag-financial-planning","tag-fpa","tag-planning-analytics","tag-profitcy","tag-tm1-2","tag-trade-spending"],"_links":{"self":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/9246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/comments?post=9246"}],"version-history":[{"count":1,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/9246\/revisions"}],"predecessor-version":[{"id":9247,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/9246\/revisions\/9247"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media\/9241"}],"wp:attachment":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media?parent=9246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/categories?post=9246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/tags?post=9246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}