Cases

Learn how our customers use Cubeplan and why they chose us.

COMGAS Comgas

COMGAS

Natural Gas / Brazil

BG Group wanted an analytic decision tool to explore and optimize the effects of changing consumer tariffs to be used by natural gas distribution companies in several parts of the world, including Comgas,the largest natural gas distribution company in Brazil. Setting energy prices for consumers in competitive markets is particularly challenging for regulated utilities. The company aims to maximize business value while meeting constraints of public regulatory agencies.

The tool had to model the price elasticity of demand, capital investments, and the effects on operating costs over time. This information feeds a financial model to evaluate the effect on financial returns and company value.

One of the main uses of the planning model implemented at Comgas is to explore and discover the combination of tariffs and investments that maximize company outputs captured on financial statements.

The benefits of collaboration through implementing an integrated planning model has spread deeply in the Comgas organization, driving the creation of an integrated planning department formed by representatives from every area of the company.

Coca-Cola Andina

Embotelladora Coca-Cola Andina S.A.

Food & Beverage / Argentina

Embotelladora Andina S.A. produces, distributes, and markets Coca-Cola products through operations in Chile, Brazil, Argentina and Paraguay. Andina Argentina S.A. operations cover several provinces of Argentina accounting for 1.9 million Km2, representing 68% of the Argentine territory and 41% of its total population.

Andina was experiencing problems commonly associated with the use of spreadsheets: inconsistent assumptions, undetected errors, and a lot of manual work. Business Analysts time was wasted time error checking and validating data rather than exploring how to add value to the company.

In 2013 Coca-Cola Andina selected Cubeplan for developing and implementing an Integrated Business Planning Model. The reasons for the selection were user friendliness, flexibility and scalability, influence diagrams for representing business logic, graphical representation of every step in the calculation, interpretable formulation language, easy what-if analysis, multiple scenario comparisons, and finally user controlled management and collaboration.

After 6 months of development, the model was in place and users were trained to take full control of model use and administration.

The model rapidly produces the Business Plan and Rolling Forecast. It provides answers to critical questions such as:

  • How much is the contribution margin per SKU?
  • In which production facility is it more profitable to produce?
  • From which distribution center is it more profitable to supply a particular region?

Renault

Renault Américas

Automotive / Latin America

The Renault Group has been making cars since 1898. Operating in 115 countries with 38 production sites and 13,300 sales outlets, Renault offers a broad range of innovative, safe and increasingly environmentally-friendly vehicles.The Renault Production Way ensures Renault's capital equipment achieves an optimal level of performance. It ranks among the most competitive and most flexible in the automotive sector and is continuously improving through the application of Renault-Nissan Alliance best practices.

The entire Latin American market is supplied with production from four plants located in different countries; however, demand and industrial production need to be analyzed as a group.

A Cubeplan S&OP Model was developed for the company. The model allows balancing demand and supply by optimizing the allocation of production to markets according to organizational strategies while meeting the capacity constraints of both the production line and the supply chain.

With Cubeplan's web-based access and advanced access control the same model is shared among people located in all plants. The impacts of decisions made on one location can be instantly analyzed by the whole group resulting in more informed and collaborative decisions.

EDP

Energías de Portugal (EDP)

Electricity / Brazil

EDP Brazil generates, distributes, and supplies electricity in the major states of Brazil. The firm is controlled by EDP - Energías de Portugal, one of the largest European operators in the electricity and gas sectors. EDP in Brazil went public on the Stock Exchange of Sao Paulo in July 2005, adhering to the highest standards of corporate governance. Since 2009, EDP Brazil has centralized the budgeting and financial control function of business planning.

The challenges of implementing centralized planning included providing timely responses to the dynamism of the business units, accommodating more complex simulations, establishing better operational control, and allow for more agility in communications during the budgeting process. EDP Brazil initiated a process to find the best tool for developing and implementing an Integrated Planning Model.

After extensively analyzing alternatives Cubeplan was chosen because its capacity to deal with huge models, programming flexibility, scenario management, user collaborative ambient and ability to be integrated with existing company software architecture.

The benefits of Cubeplan implementation were not limited to financial planning and control re-design but also resulted in increased knowledge through the collaboration of different business units involved in the development of the Integrated Planning Model.

Panama Canal Authority Panama Canal Authority

Panama Canal Authority (ACP)

Transportation / Panama

The Panama Canal is a 77 km (48 mi) ship canal in Panama that joins the Atlantic and Pacific Ocean and is a key conduit for international maritime trade. On September 7 of 1977, the President of the United States, Jimmy Carter and Omar Torrijos of Panama signed a treaty guaranteeing the permanent neutrality of the canal. The treaty led to full Panamanian control effective at noon on December 31, 1999, and the Panama Canal Authority (ACP) assumed command of the waterway. The treaty sets out the restrictions on setting tolls.

To support the Toll Setting Process of the Panama Canal, a Planning Model was developed for computing the cost of transporting goods through several maritime routes.

CDEEE

Corporación Dominicana de Empresas Eléctricas Estatales (CDEEE)

Electricity / Dominican Republic

CDEEE is the state-owned administrator and regulator of all companies in the energy sector in the Dominican Republic. Electricity subsidies is one of the most important lines in the country's annual budget.

During the oil price peak occurred in 2008 the need for electricity subsidies increased and became a presidential concern. The CDEEE has the task of accurately estimating the amount of subsidy the government has to finance. The process of estimating the subsidy took 2 weeks and its accuracy was in doubt.

To speed up that process and to gain transparency and confidence a model that projects the entire energy sector of Dominican Republic was developed.

The model includes projecting demand for each region and tariff category. It also includes a module for dispatching power units while minimizing the cost of supply. Latter operational expenditures and investments were projected.

By implementing a Cubeplan-based solution, the time for estimating subsidies has been reduced to hours and the planning model is used for several other purposes including generating financial statements for each company.

Hospital del trabajador de santiago

Hospital del Trabajador de Santiago

Healthcare / Chile

This leading Chilean institution wanted an integrated planning model that helped them understand how to extract the maximum value from its infrastructure and decide the best way to grow

The model includes all parts of hospital business allowing them to answer several types of critical business questions.

ILUMNO
Cases Education

ILUMNO

Education / USA & Latin America

ILUMNO (former Whitney University System) offers best practices procedures to optimize administrative functions of its clients by providing high-quality academic resources and state-of-the-art procedures.

As part of these services, Novix has developed a model that allows consistent projections of student enrollment, revenue, and instructional cost.

Universities did not have a system in which both revenue and professor cost were linked, as a result, the budget building was complex and sensibilization to different hypothesis was tedious and time-consuming.

The implemented model captures each University particularities which are determined by the dynamic of each institution; its local framework; and the legal, cultural, and economic factors of the country in which they are located.

Tuition scenarios, marketing campaigns for new students, or persistence increment programs impact can be easily and consistently evaluated in a few clicks.

Benchmarking & Best Practices transmission among universities is promoted by the existence of a module including standard KPIs.