Customer Company Size
Large Corporate
Region
- America
Country
- United States
Product
- Decision Lens
Tech Stack
- Microsoft Excel
- Web-based solution
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Digital Expertise
- Productivity Improvements
Technology Category
- Analytics & Modeling - Data-as-a-Service
Applicable Functions
- Business Operation
Use Cases
- Demand Planning & Forecasting
Services
- Cloud Planning, Design & Implementation Services
About The Customer
The customer in this case study is the Office of the Chief Information Officer (OCIO) in Washington State Government. The OCIO is responsible for ensuring that the state's annual IT budget of over $900 million is spent in a way that advances the governor’s policy objectives. The projects must either improve revenue or reduce costs and have a direct and positive impact on citizens or public safety. The OCIO is tasked with analyzing complex IT projects and providing a set of easy-to-read recommendations. The OCIO also wanted to ensure agencies planned IT investments using certain key drivers such as building them in the cloud, implementing strong cybersecurity measures, using agile development techniques, and thinking about how technology can fuel further efficiencies and innovations.
The Challenge
The Office of the Chief Information Officer (OCIO) in Washington State Government is tasked with ensuring that the state's annual IT budget of over $900 million is spent in a way that advances the governor’s policy objectives. The projects must either improve revenue or reduce costs and have a direct and positive impact on citizens or public safety. In 2013, State agencies proposed 86 different projects that were either level 2 (medium risk/complexity) or level 3 (high risk/complexity) IT projects. The projects ranged from settling tax boundary disputes to tracking marijuana from seed to sale to Medicaid shopping plans. The challenge was to analyze these complex IT projects and provide a set of easy-to-read recommendations that even technophobes can understand. The legislature asked the OCIO to create a prioritized list that ranked the projects as high, medium, or low.
The Solution
The OCIO initially built a Microsoft Excel model to analyze and rank the projects. However, the model was not sophisticated enough to reflect everything that was important in evaluating projects. Minor changes in the model could have major implications but it was hard to identify which changes were causing issues. The OCIO then decided to use Decision Lens, a web-based solution for collaborative prioritization and resource optimization. Decision Lens is based on Thomas L Saaty’s Analytic Hierarchy Process which applies both mathematics and psychology to prioritize. The OCIO revamped the process for weighting the criteria to include not just members of the OCIO but input from the Office of Financial Management and input from members of the Technology Services Board (TSB).
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Pepsico's Transformation to Smarter Sales Forecasting with Designer Cloud
PepsiCo, a global consumer packaged goods company, faced a significant challenge in calibrating sales forecasting to supply the right product quantities to its retailers. The sales forecast incorporated a variety of data, including warehouse data, store stock data, and promotional forecast data, all of which were provided by retailers in different file formats and delivered using various methods. The primary challenge was the speed of preparing a sales forecast. With the existing Microsoft Access and Excel-based processes, the time required to prepare this data was so extensive that analysts could only leverage it once a month or not at all. This inefficiency risked under or oversupplying retailers, potentially impacting PepsiCo's business operations and customer relationships.

Case Study
Gexa Energy and AutoGrid's Innovative Demand Response Programs in ERCOT
Gexa Energy, a leading retail electricity provider in Texas, was seeking to introduce new demand response programs for its commercial and industrial customers in the Electric Reliability Council of Texas (ERCOT) market. The challenge was to provide a platform that would allow these customers to lower their energy bills by adjusting their energy consumption during peak energy demand or high wholesale electricity prices. The solution needed to be intelligent, scalable, and offer both manual and automated options for adjusting energy consumption. The demand response programs needed to include Emergency Response Service (ERS), Real-Time Price Response (RTPR), and 4 Coincident Peak (4CP).

Case Study
ZettaNet's Agile Juniper Network Meets Booming Digital Demand in Australia
ZettaNet, a privately-held company based in Perth, Australia, was facing a significant challenge due to the exponential demand for enterprise network, data center, and cloud services in the region. The company's business growth necessitated an upgrade of their core network to meet the increasing bandwidth requirements of their customers. The customers, which primarily include managed service providers, were demanding 1 Gbps connectivity between locations. These service providers then deliver network, data center, cloud, and voice services to a diverse range of customers including local businesses, schools, hospitals, residential communities, and government offices in Western and Southern Australia. The challenge for ZettaNet was to meet this high-capacity network services demand while maintaining profitability.
Case Study
Procter & Gamble Implements Terra Technology's Demand Sensing for Improved Forecast Accuracy
Procter & Gamble (P&G) faced significant challenges in accurately forecasting short-term demand for their consumer products. Their existing 24-month forecast provided a good overview for monthly or weekly production, but it was insufficient for the immediate needs of supply chain planning and manufacturing teams. These teams required a short-term forecast to plan production effectively and avoid 'fire-fighting' practices. P&G needed a solution that could provide accurate short-term demand forecasts to ensure agility and flexibility in manufacturing, especially for products with very short production and order lead times. The company explored various solutions but found that most big software companies lacked the agility to meet their specific demand sensing needs. Terra Technology's Real-Time Forecasting, later known as Demand Sensing (DS), emerged as a promising solution due to its specialized focus on consumer packaged goods (CPG) demand planning and forecasting.
Case Study
MARS Incorporated: Leading a Global Digital Transformation
MARS Incorporated, a multinational manufacturer, faced significant challenges in digitizing and standardizing processes across its mid-markets globally. The company's reliance on legacy solutions necessitated continuous, time-consuming upgrades and made data compilation and comparison across different regions and business units difficult. Excel spreadsheets were extensively used for forecasting in smaller markets, leading to disconnected processes, siloed working environments, and increased risk of data inconsistencies and inaccuracies in demand forecasting. MARS also struggled with a lack of visibility across its midmarket footprint, scattered critical data across various systems and spreadsheets, a low degree of automation, and insufficient statistical analytics for demand planning. The absence of a standard process for demand planning made it challenging to consolidate KPIs and gain a comprehensive view of demand trends and supply chain performance.

Case Study
Enterprise AI for Demand Forecasting and Production Scheduling in Global Agribusiness
A global agribusiness and food manufacturer, producing over 80 million pounds of food products per year across eight production lines, faced significant challenges in demand forecasting and production scheduling. The company's only customer, a global retailer, exhibited highly variable demand, leading to discrepancies with the manufacturer's weekly demand forecast. Traditional demand forecasting solutions, based on statistical algorithms, were unable to cope with the short lead times and daily sales orders due to the short shelf life of food products. This resulted in unfulfilled customer orders. Additional rule-based solutions procured to improve production scheduling also failed to optimize schedules and significantly improve manufacturing operations.