Industries >Food & Beverage
Demand and Sales Planning
IBM Cognos TM1, IBM Cognos BI, Revelwood Performance Toolkit
The repeal of Prohibition resulted in not just legalizing alcohol again in the U.S., but it also resulted in the creation of a complex three-tier system for alcohol distribution. The three tiers are producers, distributors, and retailers—producers sell their products only to wholesale distributors, who then sell to retailers, such as liquor stores, grocery stores, restaurants and bars. This extra tier between a beverage manufacturer and the actual seller of the product adds a layer of complexity to demand and sales planning.
One well-known manufacturer of craft beers, hard ciders and malt beverages creates and sells more than 100 different products to a network of 350 wholesalers. The brewer wants to grow sales volume and market share by identifying which wholesalers are selling the most, by product. Additionally, since this brewer creates products with “sell-by” dates, it needs to identify and address the wholesalers who have the most returns of past sell-by date product, and do so by product.
Revelwood designed and developed a demand and sales planning solution using IBM Cognos TM1 integrated with IBM Cognos BI. The Revelwood team developed cubes that enable the brewer to track and analyze distribution, sales, depletions and returns by wholesaler. The system first tracks shipments to each wholesaler. Then it records depletions—which products at what wholesaler have gone out to retail outlets. Lastly the system tracks returns from the retailer to the wholesaler and back to the brewer.
Having the right analytics infrastructure allows the brewer to ask any number of questions, including:
- Who are my best and worst performing wholesalers?
- What are the best and worst selling products by wholesaler?
- What is the distribution to depletion ratio by wholesaler?
- What is the return rate for each product by wholesaler?
With the TM1-based demand and sales planning system, this brewer can now make strategic decisions on where to invest marketing and sales support by wholesaler. The brewer can identify the top performers and develop strategies to keep them there. Conversely, the brewer can identify those wholesalers who are not performing well or who have a higher volume of returns. This allows the brewer to develop strategies to improve their performance or make the decision to discontinue business with low-performing wholesalers.
With the IBM predictive analytics-based sales and marketing application, this insurance company is able to prioritize lead lists, resulting in an average 45% success rate for sales. Read More
Using IBM PCI, this B2B retailer can increase incremental sales by optimizing the advertisements it serves up to specific customers in its predictive digital marketing platform Read More
Travel & Transportation (Airline)
With an operational analytics solution in TM1, the airline is better able to identify problem areas in its operations and can understand, react to and plan for trends based on a number of variables. Read More
Media & Entertainment
Using an "ultimates" module in TM1, this entertainment company can capture the expected revenue and costs of film and TV titles and project the overall lifetime value. Read More
Real Estate Investment Trust
A TM1-based capacity planning and lease analysis solution enables this real estate company to analyze granular information by tenant, by lease and by building. Read More
Oil & Gas
Using an operational forecasting and capacity planning solution in TM1, this oil and gas company has much better visibility into its operations by pipeline, by movement and by customer. Read More
As a result of a TM1-based volume planning, demand planning and capacity planning solution, this roofer knows which plants are under-performing or over-performing and how to optimize production. Read More
Food & Beverage
With a TM1-based demand and sales planning system, this brewer can now make strategic decisions on where to invest marketing and sales support by wholesaler. Read More
With a TM1-based volume planning solution, this beverage manufacturer can now anticipate demand based on previous sales volume in many different ways. Read More
With IBM Cognos TM1, this financial services firm can more easily keep track of its clients and its assets under management to better understand how different aspects of its services are performing. Read More
Using IBM Cognos TM1, this global publisher relies on a technical planning model to perform granular, top-down planning, such as by individual subject categories and product types. Read More
With a TM1-based demand planning application, this professional services firm can analyze demand by role, project, geography and status. Read More
Since deploying an incentive compensation solution in TM1, the hotel has seen significant process efficiencies, a reduction in calculation and payout errors and improved visibility for advanced analytics. Read More
With Revelwood Lightspeed and IBM Cognos TM1 on Cloud, this investment bank extended its key financial planning and reporting information to more decision makers throughout its organization. Read More