This model allows you to budget with expected customer orders and schedule your production plan for the next three years.
Our example has four different customer segments and the company produces two products. The major selling point of this demo model is to illustrate how easy it is to extend the model with either additional customer groups, a greater diversity of products, or both.
Imagine that you have built a model and brought it to a team meeting with your manager group. Of course they will be impressed with your model, but typically say the following:
"We are planning to introduce a new business unit in our sales channel, handling the sales in the northern region. Can your model accommodate this?"
Previously, you would have to withdraw yourself to a corner of the room. You would start with adding the element to the range and its subranges. Then large portions of your model would be undefined, and you would need to find all array variables where this range is in use and correct with new input values if needed. This could take some time, depending on the size and complexity of the model. When all the initial values are well defined, you would be able to resume and say:
"The new business unit is now added, what are the figures you would like to input?"
See a demonstration video.
Now, with Dynamic Ranges you can from within the user interface:
All this will be done within a few minutes!
So if you suspect that a range in your model might be extended in the future, why not make it a Dynamic Range! The model will be more flexible in use, as well as available for end users to tweak and play with!
The above video is shown using Flash. If you cannot see it, please download the latest Flash player.