Business Modelling

1
Business Modelling

• Lecture 6

2
Forecasting
Sales Costs
3
A different view
Blue shows the profit
4
Assessing the viability of the forecast

• Why are there peaks and troughs?
• Will patterns continue in the same way?
• How resilient is the forecast to variation?

5
Setting up a model to test resilience

• Add in a drop down menu relating to percentage
  changes in costs and revenue.
• Make the relevant cells respond to the value
  selected

6
The Control Toolbox

• VBA Interface
• Can use combo boxes or list boxes to provide a
  selection.

7
Control Toolbox

• Select View from the main menu
• Choose the Toolbars option
• Choose Control Toolbox

Combo box
8
Properties
Linked Cell the cell where the
Value is stored List Fill range the cell
range which stores the
selection of values
9
Properties contd
Linked Cell z26 List Fill range
u2130 (paint colour white)
10
Linking in cells to the combo box.
This cell will modify the revenue based on the
value in z26 i.e. the Linked cell of the combo
box.
11
Example
Costs set at plus 30 Revenue set at 30
12
Shown graphically
Note loss of profit from March to September.