Oracle Supply Chain Planning and Business Intelligence Products - A blog dedicated to Oracle's Fusion/On Prem VCP and BI offering.
Thursday, February 18, 2010
Wednesday, June 3, 2009
Notes from Today's Webcast on "The Key to Optimizing Demantra Worksheet Performance"
Monday, March 23, 2009
2009 Readers' Choice Survey: Trade Promotion Management
| 2009 Readers' Choice Survey: Trade Promotion Management Alliston Ackerman, Kara Romanow and Alarice Padilla | |
| It is generally estimated that the average consumer goods company spends 20 percent of revenue on trade promotions, yet many companies are still unsure of their effectiveness or value. In an April 2008 article, Lora Cecere, vice president, Consumer Products, AMR Research, reported that only 54 percent of trade promotions would be evaluated in 2008. "Why? There is usually a disincentive to report and, as a result, companies do not force discipline in the process," she stated. Gartner's Research Vice President, Industry Advisory Services - Manufacturing, Dale Hagemeyer, adds that while the business case for deploying Trade Promotion Management (TPM) is strong, obstacles lie in defining new processes and change management. Findings from aCGT research report ("Trade Promotion Optimization") supported this opinion: 56 percent of those surveyed said that change management was the single largest hurdle to deploying a solution. SMB Market: Oracle "This [Oracle Demantra] gives us the beginning impetus to understand where our peaks and valleys are, where we can optimize promotions and where we can increase revenues. Several hundred people now have a single unified view into what trade promotions are doing, and this leads to better reporting, better visibility and better accountability overall." -- Mitch Margolis, CIO, NBTY Inc ............................ .................. Read complete article @http://www.consumergoods.com/ME2/dirmod.asp?sid=234FFCB1E8DF4FACBAFF60DFFD8AD37C&nm=&type=MultiPublishing&mod=PublishingTitles&mid=A533BDC6582947448BBFA37BFF6394FF&tier=4&id=7D4119A515B943B5BE2CE28DBE8F2C2F | |
Thursday, February 26, 2009
Trade Promotions Management & Demantra's PTP module
Manufactures use their marketing funds for promotions execution in collaboration with retailers. The process of planning a promotion, analyzing it’s profitability, reviewing effect on sales & spending, and settling down the promotional allowance with retailer is a complex process. Good amount of money and time is spend towards the whole process working on Legacy applications like Excel sheet. Industry experts have recognized that having a Trade Promotion management application in place can widely influence the business, by improving the profitability of promotions and synchronizing planned volume with operations.
Fig. 1.1 Example of typical promotions Oracle Demantra’s solution for Trade promotions management needs is offered in module:
- Demantra Predictive Trade Planning (PTP)
->Option: Trade Promotion Management Optimizer (TPMO)
->Option: Deduction Settlement Management (DSM) (not covered in this discussion)
Trade Promotions management is carried out in top-down fashion on Financial budgeting part & bottom-top approach on promotions planning part. It involves various activities which are readily supported by Oracle Demantra’s PTP module.What Demantra Offers specially to Promotions Planning arena:
- Manage all promotions, accounts, trade spending collaboratively
- Generate separate Incremental Forecast broken down to Lift, Cannibalization, and Pre/Post effects.
- Simulate & Optimize promotions in a sandbox environment
- Integrated with Seibel & JD Edwards application
Quotas & Fund Management:
Funds are allocated to promotions and are allocated downwards. Demantra gives you a standard set of promotion funds like, Brand Development fund, Market Development Fund and Slotting Funds. Senior management enters base rate, development rate and fixed rates for BDFs & MDFs, they also key in Quota details in the system.
Demantra provides seeded worksheet for Quotas & Fund Management, which involves providing entry sheets point for senior management and review sheets for sales reps. Sales reps can easily view funds available against their sales quota at detailed level of each brand and promotion group.
Volume Tracking:
Planned volume tracking can be done with ease, using Demantra worksheet with views to show base and incremental volume, historical shipments and current year plans. This empowers planners to monitor and track account volumes, which are finally communicated to Operations. Funds planning is an integral part of Volume tracking, as based on planned volume decisions are made on budgets and spending for allowances and deals.
Planning Promotions:
Newly created promotion has “Unplanned” status and has no impact on funds or forecast. Once this promotion’s status is changed to “Planned” for usage in forecasting, it impacts the system. Planned promotions cost is taken out from the available fund balance and Engine when run, generates baseline and lift for it. System also calculates measures like profit for manufacturer and retailers, fund balance etc. which are later used for Cost Benefit reviews.
After the review, you can approve the promotion and status changes to “Approved”. Next, once a firm agreement is reached between retailer and manufacturer, you change the status to “Committed”.
Committed promotions are recognized by a batch process and are reflected in projections.
After the execution of promotion and payment to retailer done, status is changed to “Paid” and later to “Closed.
Fig. 1.2 Promotion Life cycle: Status Changes
Promotion Planning Environment:
Promotion planning environment empowers you to analyze historical and new planned promotions. You can create new promotions, see their impact on sales, spending and profitability, while reviewing corresponding sales quota.
Demantra provides standard worksheets like “Planning Environment” & “Promotion Comparison”, which serves as the platform for various activities:
- Create new promotion
- Modify existing promotion
- Compare promotions
- Delete promotions
Activity browser in the worksheets gives you a visual of events calendar, showing events hierarchy and their planned execution period.
Promotion Optimization:
Planning environment worksheet offers optimization feature, using which you can optimize your planned promotions. You can select optimization rules from Maximizing Revenue, Maximizing Profit or Maximizing Units for getting an optimized promotion suggestion. After running optimization you can review the optimized promotions proposed in “Optimization Comparison” worksheet. Later, you can accept the optimization results, which will in turn copy the optimized promotion definition into the original promotion.
Next you change the promotion status to Planned, so that it can be used in your current plan.
Post Promotion Review:
Once the promotion is executed by the retailer and actual sales figure arrive, you can evaluate promotion’s effect. You can review the planned vs. actual for promotions using worksheet “Promotion Evaluation”. This worksheet has multiple views, Event Projection, Event Actuals, Projected sales vs. Actuals, Projected Profit vs. Actuals and Lift decomposition. Lift decomposition breaks down the Lift calculated by engine into promotional effects like cannibalization, pre and post effects.
This review helps you in evaluating the performance of the executed promotion and reveals true profitability of promotion.
Demantra also provides more detailed review worksheets for your past promotions, “Promotion Evaluation – Details” and “Scenario Evaluation”
Typical high level Promotion Flow in Demantra:
1. Load historical promotions
2. Run Engine in Promotion Effectiveness mode
3. Create new promotions in Demantra Promotion Planning environment
4. Run Simulation for newly created promotion
5. Analyze promotion details and it’s impact
6. Approve promotion
.............will be putting details of the promotions planning flow in upcoming blogs soon.
Thursday, July 24, 2008
Demantra Predictive Trade Planning & Promotion Optimization
- Lift generation on top of Baseline forecast when engine is run in Promotion Effectiveness (PE) mode
- Promotions Planning & Analysis, with easy scenario wise comparison of expected incremental lift and trade spending
- Promotion optimization, to simulate promotional scenarios for decision making assistance on the basis of ROI, Revenue or Profit targets.
Oracle has already released seeded integration between PTP module with Enterprise One (JD Edwards) and Siebel.
PTP Integration Flow with Enterprise One(E1):
- Load master data(product and customer hierarchy) with historical sales data from E1
- Load history of promotions (can come from legacy TPM system)
- Generate Baseline forecast & Lift by executing Engine in Demantra
- Create promotion plans and scenarios in Demantra
- Load future promotion plans/pricing information to E1
- Process sales orders against new promotions in E1
- Load actual trade spending from E1 to Demantra
- Generate volume forecast in Demantra and Submit back to E1
PTP Integration Flow with Siebel: This integration supports two scenarios in which Demantra can be used by a business. First, Promotion planning done inside Siebel with Demantra being executed in back end. Baseline forecast with Lift information is fetched into Siebel on regular basis for usage during planning. Second, Promotion planning being done in either of the systems and results are synchronized on near real time basis.
- Load data extracts for Product, Account, Promotion, Planning hierarchy with sales and promotion activity details into Demantra from Siebel
- Generate Forecast with lift in Demantra
- Load data extracts from Demantra for Baseline Volume Forecast, Lift and Promotions to Siebel.
The objective behind these integrations is to make Demantra's advanced Forecasting technology available to all. Using the best of breed technology for various business processes is the strategy which Oracle is following as a path towards Fusion. With PTP & TPMO module's seeded integrations, customers on JD Edwards(E1) or Siebel can benefit themselves from Demantra's offering with ease.