# 3. Diagram the Problem

Overview

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

Summary

1. Why Create Diagrams? (00:04)

After framing the problem, it’s a good idea to create a diagram of the problem, such as an influence diagram. This lets you design the model without needing to focus too much on the details or the implementation in Excel at an early stage of the process.

2. Elements of an Influence Diagram (00:41)

Powell and Batt’s influence diagrams contain four different components:

• A decision variable is a model input that the company controls, for example the price of their product. A decision variable is represented by a parallelogram.
• A parameter is a model input that the company cannot control, for example the market growth rate. A parameter is represented by a rectangle.
• An intermediate variable is calculated through formulas. For example the company’s total revenue can be calculated using the product price and other variables. An intermediate variable is represented by an oval.
• The outcome is the final value of interest in the model, and is also calculated from formulas. For example, a company’s total profit can be calculated from their total revenue and costs. The outcome is represented by an octagon.
3. Creating a Simple Influence Diagram (01:20)

We want to create a simple influence diagram for the revenue of a company manufacturing a product. We start with the outcome, which is total revenue. Revenue is determined by the product price and the quantity sold. Price can be added as a decision variable, while quantity is an intermediate variable, as it depends on the price and elasticity. Elasticity is a parameter. By combining all these elements together, we create a simple influence diagram.

4. Adding Costs to the Diagram (02:41)

We can add total cost as another outcome. This depends on fixed costs, which is a parameter, and variable costs, which is an intermediate variable. Variable costs depend on unit cost, which is a parameter, and quantity sold, which provides a link between our revenue model and our cost model.

To consider profits, we can create another outcome representing profits, linked to total revenue and total cost. When we do this, revenue and cost are no longer outcomes; instead they are intermediate variables.

5. Resource: More about elasticity (03:53)

Transcript

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

02:54

03:06

03:56

02:29

03:11

04:59

04:02

02:31

05:56

05:33

04:13

03:23

05:33

04:40

04:44

06:51

03:33

#### 18. Limitations of the Model

02:03

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.