Example Customised Modelling Solutions
Introduction: We have developed fit for purpose and customised modelling solutions in Excel to suit the unique requirements of each business. These have evolved as the businesses lacked the required transparent management information to effectively plan, cost or monitor the business. All examples delivered significant results, improved productivity or greatly reduced risk and errors. We use visual management techniques to enhance information understanding and decisions.
Scope: We use our financial and operational expertise and have developed:
Excel development principles applied
Key Features by Model Type:
a) Master Schedules
Scope: We use our financial and operational expertise and have developed:
- Master Schedules - for operational planning.
- KPI Dashboards (financial and operational).
- Product Costing Estimating models (integrating product and process features and options).
- Hourly Rate developments (sometimes requiring P&L redesign using design template below).
- Sales and Operations Planning (S&OP) process and models.
- Simplified Financial summaries using the "Dupont" model.
- Debtor financing draw-down calculations for input to cash flow worksheets.
- Debtor Finance - pre-implementation assessment scenarios.
- A combination of these to assist M&A integration decisions and assessments.
Excel development principles applied
- Using advanced functions, the models are developed to maximise user productivity by simplifying entries. The user does not have to be an Excel expert.
- Drop down box choice options used.
- Warning messages or colour codes used to highlight issues automatically.
- Integrated flow charts.
- Customised summary reports using pivot tables.
Key Features by Model Type:
a) Master Schedules
- Daily or weekly schedules by product / process types.
- Resource loading – highlights under / over loads.
- Gross material requirements determined – where applicable.
- Integrates process methodologies or IP unique to the business.
- Selects compatible combinations.
- Financial and operational summaries - run times, set up time.
- User focuses on what customer requires, not how to manufacture or process.
- Integrates packaging material and freight costs where applicable.
Model Type / Example
|
Industry / Product
|
Key Outcomes / Features
|
Financial modelling - 3 way (P&L, Balance Sheet, Cash Flow) and Debtor Finance Examples
|
Multiple businesses:
|
|
KPI Dashboards – financial & operational
|
Multiple businesses:
|
Operational Dashboard includes:
|
Hourly Rate Development
|
Multiple businesses:
|
|
Master Schedule with integrated Sales & Operating Plan
|
|
|
Product Estimate Costings
|
|
|
Product Estimate Costings
|
|
|
Master Schedule & high level MRP
|
|
|
Master Schedule
|
|
|
Master Schedule
|
|
|
|