Decision Support Systems (DSS): Solving the "What-If" Problems

🔷 

Decision Support Systems (DSS)

Solving "What-If" Problems with Data

⏱️ 14 min read 📊 What-If Analysis 📈 Scenario Planning

The Question That Changes Everything

What if I expand my goat fattening project by 20%? What if feed prices rise next season? What if I hire two more workers? Every business owner asks these questions. Most answer them with a shrug, a guess, or a worried night of sleep. A few answer them with data. The difference between guessing and knowing is a Decision Support System.

A Decision Support System, or DSS, is not a crystal ball. It will not tell you the future. But it will show you several possible futures, calculate the likely outcomes of each, and help you choose the path that best fits your goals. For small businesses, farmers, and community enterprises, a DSS can be the difference between a decision that grows your income and one that quietly drains it.

What Is a Decision Support System?

A Decision Support System is a tool or method that helps you analyze data to make better decisions. It does not make decisions for you. It gives you the information to decide wisely. Think of a DSS as a flight simulator for your business. Before a pilot flies a new route, she practices in a simulator. She can test what happens in a storm, with low fuel, or with a heavy load, without risking a real plane. A DSS lets you do the same thing with your business decisions. You can test expansion, price changes, or new hires in a safe, calculated environment before committing real money.

According to the World Bank's data storytelling guide, effective decision support transforms raw data into narrative insight. Data alone is not the story. The story is what you do with the data. A DSS helps you find that story. It takes the numbers you have collected through your transaction processing system and accounting records and turns them into a picture of what could happen next.

For small enterprises, a DSS does not require expensive software. A spreadsheet with simple formulas can be a powerful DSS. The key is structured thinking. You define the variables that matter, test scenarios that reflect real possibilities, and compare the outcomes. The tool is simple. The discipline is what creates value.

The Three Types of "What-If" Analysis

Not all what-if questions are the same. A good DSS helps you answer three distinct types of questions, each with its own purpose and method.

Scenario Analysis: Testing Complete Futures

Scenario analysis involves creating a few complete stories about the future. Typically, you create a Best Case, a Worst Case, and a Most Likely Case. For a poultry farm, the Worst Case might be feed prices rising 20%, egg prices dropping 10%, and a disease outbreak killing 15% of the flock. The Most Likely Case might be feed prices rising 5%, egg prices stable, and no disease. The Best Case might be feed prices stable, egg prices rising 10%, and excellent flock health. You calculate profit under each scenario. The range of outcomes tells you how resilient your business is.

Sensitivity Analysis: Testing One Variable

Sensitivity analysis asks a more focused question: How much does my outcome change when I change one input? If I raise my price by 5 birr, how much does profit change? By 10 birr? By 15 birr? This reveals which variables matter most. If profit is very sensitive to feed cost, you focus your energy on feed efficiency. If profit is not sensitive to labor cost, you stop worrying about small changes in wages. Sensitivity analysis helps you prioritize your attention.

Goal Seek: Working Backward

Goal Seek reverses the question entirely. Instead of asking "What happens if I change X?", it asks "What X do I need to achieve Y?" If I want 50,000 birr profit next quarter, how many eggs must I sell? This is powerful for planning. You define the destination, and the DSS tells you the path. Goal Seek turns ambition into a specific, measurable target.

How to Build a Simple DSS in a Spreadsheet

You do not need special software. Google Sheets or Microsoft Excel can be a fully functional DSS. Here is how to build one in five steps.

1

Define your model. List your inputs and your output. Inputs might include price per unit, quantity sold, feed cost, labor cost, and other expenses. Your output is profit. Create a formula: Profit equals price times quantity, minus the sum of all costs.

2

Set up a data table. List a range of possible values for one input. For example, price from 5 birr to 15 birr in 2-birr increments. Link your profit formula to the table. Excel and Sheets will calculate profit for every price point.

3

Create scenarios. Use Excel's Scenario Manager, or simply create separate columns for Best, Worst, and Likely cases. Change multiple inputs at once and compare results.

4

Visualize the results. A simple bar chart showing profit under each scenario makes the insight obvious. The World Bank guide notes that visualizations should support the key message, not distract from it.

5

Review and update. A DSS is only as good as the data you feed it. Review your model monthly. Update your inputs with real numbers from your transaction records.

Real Application: Wereilu Eco-Poultry

At Wereilu Eco-Poultry, the team faced a major decision. Should they expand from 500 to 750 chickens? Expansion meant buying more chicks, more feed, and more equipment. It also meant more risk. They needed a way to test the decision before committing.

The what-if questions were clear. What if we buy 250 more chicks? What if feed costs stay the same? What if mortality is 5% instead of 12%, because of better vaccination tracking? What if egg prices drop 10%?

Using a simple spreadsheet, they modeled three scenarios. The Conservative scenario kept the flock at 500 birds with 12% mortality and stable feed costs, projecting 18,000 birr monthly profit. The Moderate scenario expanded to 750 birds with 8% mortality and a 5% feed cost increase, projecting 26,500 birr monthly profit. The Optimistic scenario expanded to 750 birds with 5% mortality and stable feed costs, projecting 34,200 birr monthly profit.

📊 Wereilu Eco-Poultry: Scenario Comparison

Scenario	Expansion	Mortality	Feed Cost	Monthly Profit
Conservative	No expansion	12%	Stable	18,000 birr
Moderate	250 more birds	8%	+5%	26,500 birr
Optimistic	250 more birds	5%	Stable	34,200 birr

The decision became clear. Even the Conservative scenario with expansion, if they could maintain the same mortality rate, would yield 22,000 birr, better than no expansion. But the Moderate scenario was most realistic. They expanded, and the DSS justified the investment to their lender. The numbers told a story that words alone could not.

This is the power of a DSS. It turned "I think we should expand" into "Here are three scenarios, and expansion is profitable in all of them."

DSS and the Information Pyramid

Where does a DSS fit in the broader picture of information systems? It sits at Level 3 of the pyramid.

Level 4 (ESS): Summarizes for leadership. "Overall farm profitability is up 12% this quarter."

Level 3 (DSS): Analyzes what could happen. "If we raise prices 10%, and sales drop 5%, profit increases by 850 birr."

Level 2 (Functional IS): Organizes what happened. "Egg revenue was 9,600 birr; feed costs were 3,200 birr."

Level 1 (TPS): Records what happened. "We sold 1,200 eggs this week."

A DSS depends on levels 1 and 2. Garbage in, garbage out. If your transaction records are incomplete, your DSS will mislead you. This is why the earlier posts in this series, on transaction processing, organization, and accounting, mattered so much. They built the foundation that makes a DSS possible. Without clean data, even the best DSS is useless.

Common Mistakes with DSS

Even with good data and good tools, businesses make mistakes with DSS. Here are four to avoid.

❌ Overcomplicating the model. A DSS with 50 variables is rarely better than one with 5. Start simple. Add complexity only when it changes your decision.

❌ Trusting the model more than reality. A DSS is a tool, not an oracle. It estimates. It does not guarantee. Always validate with real-world results.

❌ Ignoring the range. The most valuable output is often the range of outcomes, not the single number. If the Worst Case is profitable, you can proceed with confidence.

❌ Building a DSS and never using it. A DSS is only valuable if it informs decisions. Build it into your monthly or quarterly planning cycle.

Getting Started: Your First DSS

You do not need to build a complex model. Start with one question. Choose one decision you are facing right now. It might be hiring a part-time worker, buying a new piece of equipment, or raising your prices.

Define the key variables. For hiring, the cost of the worker, the additional revenue they enable, and the training time. For equipment, the purchase cost, the time saved, and the additional capacity it creates. For pricing, the new price, the expected change in sales volume, and the impact on profit.

Create three scenarios. Best, Worst, and Most Likely. Calculate the outcome for each. Make the decision. That is a DSS. It does not require software. It requires structured thinking. As the World Bank guide puts it, data are only the foundation of your narrative and not the story itself. A DSS helps you tell the story of your business's future, before you live it.

🎯 Your Turn

Think of one decision you are facing right now. Write down three scenarios: Best Case, Worst Case, and Most Likely. For each, estimate the outcome. What does the range tell you?

Share your answer in the comments below.

NEXT IN THIS SERIES

AI & Expert Systems: Your Digital Consultant

How AI-powered tools provide specialized knowledge and support smarter decisions.

📚 References:

World Bank. (2022). Data Storytelling Guide.

Bricks. (2025). How to Use What-If Analysis with AI.

Bricks. (2025). How to Do Sensitivity Analysis with AI.

CodeCrunch. (2026). What-If Analysis in Excel.

📍 Published: September 2026 | Part of the "From Data to Decisions" series | Get-Inform