Cost, Revenue, and Operational Modeling

Modeling Applications Illustrated

Different modelling applications are constructed to simulate any complex business case. If you are still using Excel to do your what-if analyses, you need to learn how to Supercharge your Spreadsheets and move into the new era of modelling.

• Fuel Price Changes. What happens to my cost to serve a customer?

• A distribution center (DC) closes, what happens to my cost structures or where is the best place to position the DC?

• What happens to my profitability if I reroute routes?

• What happens to my customer profitability if I am able to reduce offload and stopping times?

• What should my required compensation rates be if interest rates change or my company changes it's return on net assets?

• A facility capacity, functionality or layout changes. What will the impact be on product profitability?

• We are considering different truck capacities, how will this affect my customer and route profitability?

• Based on a given sales plan, what maintenance plan are we looking at for our fleet? Further if it is a leased fleet, what will lease charges be for the period?

• We are considering different modes of transport. Is it more cost effective to containerize deliveries and ship via rail or use a third party option?

• Considering that I know the various cost components of a parcel delivery that considers start and finishing locations, method of payment, delivery urgency, transportation mode, size and weight, nature of parcel contents and it's packaging. Can I produce a quotation mechanism with that information? What if I can't quantify any of those cost components?

If you have a difficult or even a simple question, that you need the answer to, or need and easier way to find the answer, we would like to hear about it. Give us a call.