# 3. Diagram the Problem

The first stage in building the model is drawing an influence diagram - which we will learn how to do in this lesson.

**Influence diagrams**

- Before we jump into building the model, we need to first structure the model

- Influence diagrams are a graphical way of structuring the model

- They are allow you to experiment with different structures without getting mired in detail

**Interesting links**

- Click here to learn more about price elasticity

The previous lesson, Framing the Problem, created necessary boundaries for our model. It's now very tempting to open up a spreadsheet and start manipulating data and building formulas. However, experience modelers resist jumping from a problem statement straight into Excel because a lot of critical thinking around the model structure and the relationships between variables is yet to be done. Instead, they visualize the model on an Influence diagram or alternatively a Flowchart. Influence diagrams allow you to quickly create multiple design options for a model without having to focus on the details too early on in the modeling process. Powell and Batt's Influence diagrams consist of four elements each with their own shape. The first of these is the decision variable which is an input to the model over which the company has total control. An example of a decision variable would be the price of the product that you are selling. Next are parameters, which are also inputs to the model and can be fixed or assumed. However, they are not under the control of the company. An example of a parameter would be the market growth rate. Third, we have intermediate variables, which are calculated from formulas and serve to help you find the final element, which is the outcome measure. To understand Influence diagrams in more detail, let's create a simple Influence diagram for the total revenue of a manufactured product. I find it easier to start with the output and work backwards, so I'll put total revenue on the right-hand side of this slide. I know that revenue is price multiplied by quantity sold. Price is controlled by the company so it's a decision variable and shaped as a parallelogram. Quantity, on the other hand, is not controlled by the company. It's controlled by the demand for the product. So I'll add Quantity Sold as an intermediate variable. Demand is a function of price and price elasticity. Elasticity determines how the quantity sold changes with an increase or decrease in price. If you're interested in learning more about elasticity, check out some of my links in the show notes below this video. Unfortunately, the company doesn't control elasticity of demand, so we'll include it as a parameter shaped as a rectangle. This completes a simple Influence diagram for the total revenue of our manufactured product. As an exercise, pause the video and try on a sheet of paper to develop an Influence diagram for Total Cost and then combine your two outputs to create an Influence diagram for Total Profit. Then un-pause the video and I'll show you my answer.

Let's start by adding Total Cost as an outcome. I know that total cost is equal to total variable cost plus fixed cost. Fixed costs like rent, light, and heating cannot be changed in the near term and so I've included as parameters. Variable cost, on the other hand, is a function of unit cost and the quantity sold, so it's actually connected to the total revenue model. To finish up our Influence diagram I'll create a profit output and link both total revenue and total cost to this outcomes. Total revenue and total cost are now intermediate variables. So in the final version of the influence diagram I've changed their shape to take account of this fact. Armed with this influence diagram, we can now quickly create an excel profit model which would have been more difficult if we had skipped this step.

Even for a simple profit model such as this one, you can see how the influence diagram can serve to quickly structure your thinking. In the next lesson, we'll see how influence diagrams are even more necessary for complex problems such as Zippy Airways.

# Contents

#### 1. Introduction to Modeling

2 mins

#### 2. Framing the Problem

3 mins

#### 3. Diagram the Problem

3 mins

#### 5. Lay Out Model in Excel

3 mins

#### 6. Build Simplified Model

4 mins

#### 7. Sensitivity Analysis

4 mins

#### 9. Estimating Market Demand

5 mins

#### 10. Complex Model formulas

5 mins

#### 11. Perform Checks on Model

4 mins

#### 12. Calculate Model Outputs

3 mins

#### 14. Goalseek and Solver

4 mins

#### 18. Limitations of the Model

2 mins