Heading

Digiview Stencils

Budgeting and Forecasting Stencil

This Stencil contains the following datasets that make up the graphs:
  • Financial Top-Down/Bottom-Up Budgeting
  • Rolling Financial Forecasting
  • Profit & Loss, Balance Sheet and Planning & Forecasting
  • Variance Analysis
Financial Top-Down/Bottom-Up Budgeting 

Description
Compilation of  annual, quarterly and monthly budgets on a Top-Down and or Bottom-UP budgeting basis per division. Make comparisons between each type of budget to determine the most suitable for your business. Compare current to previous years actual and budgeted variances against increase in revenue generated.

Value to you
Gain a clear understanding of where best to provide funding for the best possible return. Determine the relationship between value driven expenditure and mandatory cost expenditure.

Variance Analysis 

Description
The report provides a variance analysis of the annual comparative measurements (represented monthly) in real terms for the following:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
You gain an understanding of the performance of each measured metric in real terms, providing a three year window on how your business has performed.

Rolling Financial Forecasting 

Description
Rolling forecasts continuously asses direction of business instead of annual, once off budgeting and forecasting.  Provides simple projections of what is most likely to happen based on current action plans.

Value to you
Rolling budgets provide the business with a real means to continuously measure and manage spend in relation to revenue earned with the view to maintain consistent margins were possible.

Forecasting

Description
Overall, per division and per location information for Profit & Loss and Balance Sheet Planning & Forecasting. The report provides annual comparative monthly forecasted and actual values for:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
Enables you to start building projections against each of the important Profit & Loss as well as Balance sheets measurements of your business. This assists Management to build consistency into their business.

Cashflow and Planning Stencil

This Stencil contains the following datasets that make up the graphs:
  • Working Capital Turnover Ratio
  • Operating Cash Flow
  • Cash Rotation Cycle (365/cash cycle)
  • Cash Flow from Financing Activities
  • Cash Flow
  • Cash Conversion Cycle
  • Accounts Receivable Turnover
  • Accounts Receivable
  • Accounts Payable Turnover
  • Accounts Payable
Working Capital Turnover Ratio 

Description
Measures the financial health of your business by analysing readily available resources that could be used to meet any short-term obligations. The working capital turnover ratio (also referred to as net sales to working capital) indicates the effectiveness of your business in using it's working capital.

Value to you
A high turnover ratio indicates that management is  efficient in using a firm's short-term assets and liabilities to support sales.

Cash Rotation Cycle (365/cash cycle) 

Description
It measures how quickly and efficiently your business extracts cash from operations. Measures how fast your business can convert cash on hand into inventory and accounts payable, through sales and accounts receivable, and then back into cash.

Value to you
Use this information to gauge the management effectiveness and overall health of your business.  A low number means your business has a positive cash cycle and is efficiently managing operations. It might be a way to help investors convert stock picks into cash as well.

Cash Flow

Description
The total amount of money being transferred into and out of your business.

Value to you
Cash Flow management provides you with important insight into the ability of your business to fund its operations and the exposure it has. It also provides you with a clear understanding of the extent to which loans are required to support operations.  A positive cash flow provides certainty to operations and their ability to invest or provide shareholders with dividends.

Accounts Receivable Turnover

Description
The receivables turnover ratio is an activity ratio measuring how efficiently your company uses its assets. Receivables turnover ratio can be calculated by dividing the net value of credit sales during a given period by the average accounts receivable during the same period.

Value to you
Understand the rate at which your business collects on outstanding accounts.  A high ratio implies either that your business operates on a cash basis or that its extension of credit and collection of accounts receivable is efficient.

Accounts Payable Turnover

Description
The rate at which your company pays off suppliers and other expenses. Accounts payable turnover ratio is calculated by taking the total purchases made from suppliers, or cost of sales, and dividing it by the average accounts payable amount during the same period.

Value to you
A high ratio means there is a relatively short time between purchase of goods and services and payment for them. Conversely, a lower accounts payable turnover ratio usually signifies that your business is slow in paying its suppliers.

Operating Cash Flow 

Description
The amount of cash generated by regular business operations. In financial accounting, operating cash flow (OCF), cash flow provided by operations, cash flow from operating activities (CFO) or free cash flow from operations (FCFO), refers to the amount of cash your business generates from the revenue it brings in, excluding costs associated with long-term investment on capital items

Value to you
dividing cash flow from operations (CFO) by current liabilities) indicates the number of times your business can pay off current debts with cash generated in the same time period.

Cash Flow from Financing Activities 

Description
Demonstrates the financial strength of your business. It accounts for inflows and outflows of cash resulting from debt issuance and financing, the issuance of any new stock, dividend payments, and any repurchase of existing stock.

Value to you
This category in your business's cash flow statement  accounts for external activities that enable you to raise capital. In addition to raising capital, financing activities also include repaying investors, adding or changing loans, or issuing more stock.

Cash Conversion Cycle

Description
Demonstrates the amount of time it takes for money invested in your business to come back to the organization in the form of increased revenue. Also known as the 'cash' or 'operating' cycle. 'Days inventory outstanding' is a measurement of how long it takes to convert your outstanding inventory into cash. This metric is calculated by dividing the average inventory by its cost of sales per day.

Value to you
Use this information to gauge the management effectiveness and overall health of your business.

Accounts Receivable 

Description
The amount of money your business is owed by customers. A DSO (Days sales outstanding) can vary from month to month, and over the course of a year with your business's seasonal business cycle.

Value to you
The Debtor Days ratio shows you the average number of days your customers are taking to pay you. This is important to understand from a cash flow perspective and if your organization has sufficient funds to service its monthly expenses.

Accounts Payable

Description
Shows the amount of money your business owes its suppliers. Days payable outstanding (DPO) is the average payable period that measures how long it takes your business to pay its invoices from trade creditors, such as suppliers.

Value to you
Gives you an insight into whether your business is taking full advantage of available trade credit available and estimates the average time it takes your business to settle its debts with trade suppliers.

Cost Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Financial Top-Down/Bottom-Up Budgeting
  • Rolling Financial Forecasting
  • Profit & Loss, Balance Sheet and Planning & Forecasting
  • Variance Analysis
Selling General and Administrative Expenses (SG&A)

Description
Selling, general and administrative expense (SG&A) is reported on the income statement as the sum of all direct and indirect selling expenses and all general and administrative expenses (G&A) of your business. It includes all the costs not directly tied to making a product or performing a service.

Value to you
This informs you of all direct and indirect selling expenses and all general and administrative expenses (G&A) of your business. It includes all the costs not directly tied to making a product or performing a service.

 Efficiency Ratio

Description
Looks at how efficient your business is at generating revenue. It takes the total costs (excluding interest expense) and divides it by its total revenue to calculate your business's level of efficiency and understand the cost to generate revenue.

Value to you
Indicates your business efficiency ratio - the lower the ratio, the better (50% is generally regarded as the maximum optimal ratio). An increase in the efficiency ratio indicates either increasing costs or decreasing revenues.

  Inventory Turnover 

Description
The number of times your business is able to sell off it's in-stock inventory in a given period.

Value to you
Average inventory is used instead of ending inventory because your company' merchandise can fluctuate greatly throughout the year. Stock turnover is a measure of operational efficiency. Specifically, it tells you how many times stock or inventory is being sold and purchased over a given time period. A low turnover rate may point to overstocking, obsolescence, or deficiencies in the product line or marketing effort.

Cost Per Unit  

Description
The price to produce, store, and sell one unit of a particular product including fixed and variable costs of production. The cost per unit is commonly derived when your business produces a large number of identical products. The cost per unit is derived from the variable costs and fixed costs incurred by a production process, divided by the number of units produced.

Value to you
Understanding Cost per Unit provides insight into the value of inventory, and informs you of changes to values as the costs (both fixed and variable) change. Understanding Cost per unit also provides insight into required sales volumes for breaking even and profit based on fixed and variable cost considerations.

COGS (Cost of Goods Sold) / Cost of Sales  

Description
Represents the cost of materials and direct labour used to produce a good. Cost of Goods Sold, (COGS), can also be referred to as cost of sales (COS), cost of revenue, or product cost, depending on if it is a product or service. It includes all the costs directly involved in producing a product or delivering a service. These costs can include labour, material, and shipping.

Value to you
COGS or COS provides you with an understanding of what the total cost is when selling goods or services and assists in determining what the selling price should be.

Cost Variance Analysis     

Description
A cost variance is the difference between an actual expenditure and the expected (or budgeted) expenditure.  This is the difference in the actual versus expected unit volume of whatever is being measured, multiplied by the standard price per unit.

Value to you
This assists you in the budgeting and planning of the business from both a cost and selling price perspective.

Debt Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Quick Ratio/Acid Test
  • Debt to Equity Ratio
  • Debt Ratio
  • Current Ratio
  • Bad Debt
Quick Ratio/Acid Test   

Description
Shows the ability of your business to meet any short-term financial liabilities, such as upcoming bills.

Value to you
While a quick ratio lower than 1 does not necessarily mean your business is going into default or bankruptcy, it could mean that your business is relying heavily on inventory or other assets to pay its short term liabilities. The higher the quick ratio, the better your business's liquidity position.

 Debt to Equity Ratio  

Description
Measures how your business is funding its growth and using shareholder investments. The D/E ratio indicates how much debt your business is using to finance its assets relative to the value of shareholders' equity.

Value to you
In general, a high debt-to-equity ratio indicates that your business may not be able to generate enough cash to satisfy its debt obligations. However, low debt-to-equity ratios may also indicate that your business is not taking advantage of the increased profits that financial leverage may bring.

 Debt Ratio  

Description
The amount of debt that your business currently has. The debt ratio is defined as the ratio of total debt to total assets, expressed as a decimal or percentage. It can be interpreted as the proportion of your business's assets that are financed by debt.

Value to you
A Debt ratio of 15% or lower is healthy and 20% or higher is considered a warning sign.

Current Ratio   

Description
Measures the ability of your business to pay all of its debts over a given time period.

Value to you
If your business has a high Current Ratio (anywhere above 1) then you are capable of paying your short-term obligations. The higher the ratio, the more capable your business. On the other hand, if your  current ratio is below 1, this suggests that your business is not able to pay off short-term liabilities with cash.

Bad Debt    

Description

Through the direct write-off method and allowance method, noncollectable debt (usually written off as an expense) is calculated.  Makes us of a method to determine the 'bad debt reserve' or 'bad debt provision'. The report also reflects previous bad debt percentages and current economic conditions.

Value to you

Helps you accurately portray of accounts receivable on the balance sheet - taking into account debts that are noncollectable.  Helps determine the 'bad debt reserve or 'bad debt provision' number, including previous bad debt percentages and current economic conditions.

Investment Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Saving Levels Due to Improvement Efforts
  • Return on Innovation Investment (ROII)
  • Inventory Assets Ratio
  • Innovation Spending Analysis
  • Investment Break Even Time Analysis
  • Percentage Investment in current and new Products / Services
Saving Levels Due to Improvement Efforts

Description
If you are looking at investing in improvements, or merging operations (or even companies). This KPI looks at the dollar value of the savings achieved as a result of these investments.

Value to you
These reports provide the required measures for you to understand the value derived through your investment into process improvement within your business.

Return on Innovation Investment (ROII) 

Description
This is calculated by looking at the revenue from new products, or the number of new products meeting a revenue threshold. This is typically only reviewed if you have an innovation department or budget.

Value to you
Return on Innovation Investment (ROII) is a reasonable, aggregate measuring stick for innovation. Viewed from a revenue or profitability perspective.

Inventory Assets Ratio  

Description
Inventory assets are goods or items of value that your business plans to sell for profit. These items include any raw production materials, merchandise, and products that are either finished or unfinished.  The cost of merchandise purchased or manufactured, but not yet sold, may be a good leading indicator of preparedness for growth or even slowing growth. Inventory to assets ratio Inventory/Total Assets—shows the portion of assets tied up in inventory.

Value to you
Inventory Assets are considered a part of your business assets. Basically, inventory assets are your sale able inventory. Generally, a lower ratio is considered better. Accounts receivable turnover Net (credit) Sales/Average Accounts Receivable—gives a measure of how quickly credit sales are turned into cash.

 Innovation Spending Analysis 

Description
Innovation is defined as the process of idea evaluation, selection, development, and implementation of new or improved products, services, or programs. The objectives of Innovation are:
1. Increased number of new ideas
2. Improved quality of ideas
3. More efficient implementation of quality ideas
4. Improved resultant success achieved from the implementation of new ideas.

Value to you
This provides tangible insights into the impact of innovation on your organisation in both financial an non financial terms. It provides insight into the Return on Product Development Expense.

Investment Break Even Time Analysis  
Description

The time it takes your business to break even from its investment in a new product or process.

Value to you
If the costs are big up front, this measure can help you understand how long it will take to recoup these expenses. Break-even analysis is a useful tool to study the relationship between fixed costs, variable costs and returns. A break-even point defines when an investment will generate a positive return

Percentage Investment in current and new Products / Services   

Description
Used for measuring investments in different lines of your business. You might measure the percentage of your investment in organic products vs. total investment in products overall.

Value to you
Indicates the percentage of your total capital spend that is allocated to innovation investment.

Profitability Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • ROI (Return on Investment)
  • ROE (Return on Equity)
  • ROA (Return on Assets)
  • Return on Capital Employed
  • Operating Profit Margin
  • Net Profit MarginNet Profit
  • Gross Profit Margin
  • Gross Profit
ROI (Return on Investment)  

Description
Shows the efficiency of an investment. ROI measures the gain or loss generated on an investment relative to the amount of money invested. ROI is usually expressed as a percentage and is typically used for personal financial decisions, to compare your business's profitability or to compare the efficiency of different investments.

Value to you
This provides an understanding on what the return on your investments is, and whether or not, it was worth the investment.

 ROE (Return on Equity) 

Description
The amount of net income your business generates compared to the amount of shareholders’ equity.

Value to you
This provides insight into the expected return on your equity within the business. Return on equity (ROE) is an important measure for evaluating how effectively your business's management team is managing the capital that shareholders entrust to it.

 ROA (Return on Assets) 

Description
Indicates how profitable your business is relative to its total assets.

Value to you
(ROA) Return on assets measures your ability to use assets to produce net income.

Return on Capital Employed 

Description
Measures your business's profitability and the efficiency with which its capital is employed.

Value to you
It is a useful measure for comparing the relative profitability of companies after taking into account the amount of capital used.

Operating Profit Margin  

Description
Measures income after variable costs of production are considered. Operating margin is a measure of profitability. It indicates how much of each dollar of revenues is left over after both costs of goods sold and operating expenses are considered.

Value to you
Each employee in a small business drives the margins lower. Your Operating profit percentage goals on average should be a minimum of 15 to 20 percent, depending on your type of business and the rate of return.

Net Profit Margin   

Description
The percentage of your business's revenue that is net profit.

Value to you
Net profit margin is defined as a percentage of revenue. For a high volume, high competition business a profit margin of 4% may be good. While for your business that is niche and/or requires a long-term investment before generating returns, margins as high as 55% are not unusual. Your net profit percentage goals on average should be a minimum of 10 to 15%.

Net Profit  

Description
The amount of money your business makes after taking out all expenses and other costs.

Value to you
Provides key information of the actual profitability of your business.

 Gross Profit Margin  

Description
The percentage of revenue that is profit after the cost of production and sales is considered.

Value to you
Although there is no average gross profit margin for a small retail business, many small businesses operate within the parameters of having between a gross profit margin of 25 percent and 35 percent. It is important to remember that when operating expenses rise, it becomes necessary to increase the gross profit margin.

Gross Profit  

Description
Your business's profit after the cost of production and sales is considered.

Value to you
Provides key information of the actual Gross Profit margin which on average should be between 25% and 45%.

Revenue Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Operating Income Margin
  • Net Sales Income
  • EBT
  • EBITDA
  • Asset Utilization
  • EBIT
Operating Income Margin 

Description
Operating margin is a measure of profitability. It indicates how much of each dollar of revenues is left over after both costs of goods sold and operating expenses are considered.

Value to you
It is expressed as a percentage of sales and then shows the efficiency of your business controlling the costs and expenses associated with business operations

 Net Sales Income  

Description
The amount of sales after subtracting discounts, returns, and damaged goods.

Value to you
Provides a realistic view of actual sales less direct costs associated to spoiled goods.

Operating Income Margin Earnings Before Tax  (EBT)
Description

EBT, a line item on your  business's income statement, shows your  company's earnings with the cost of goods sold (COGS), interest, depreciation, general and administrative expenses, and other operating expenses deducted from gross sales.

Value to you
Indicates the ability of your business to produce income on its operations in a given year.

Earnings before interest, tax, depreciation and amortization (EBITDA) 

Description
EBITDA margin is an assessment of your operating profitability as a percentage of total revenue. It is equal to earnings before interest, tax, depreciation and amortization (EBITDA) divided by total revenue.

Value to you
This measure attempts to achieve true business operations which makes it the best measure for valuing your company.  Investors acquiring a company use EBITDA as a proxy for cash flow and the amount of profit that can be made from its current assets and operations.

Operating Income Margin

Description
Total revenue earned for every dollar of assets your business owns.

Value to you
An increasing asset utilization means your business is operating more efficiently with each dollar of assets it has. This ratio is frequently used to compare your business's efficiency over time

Earnings  before interest and taxes (EBIT) 

Description
EBIT Margin is the ratio of Earnings before Interest and Taxes to net revenue - earned.  An indicator of your business's profitability with expenses removed and interest and tax excluded.

Value to you
It is a measure of your business's profitability on sales over a specific time period.

Sales Budgeting and Forecasting Stencil

This Stencil contains the following datasets that make up the graphs:
  • Financial Top-Down/Bottom-Up Budgeting
  • Rolling Financial Forecasting
  • Profit & Loss, Balance Sheet and Planning & Forecasting
  • Variance Analysis
Sales Top-Down/Bottom-Up Budgeting

Description
Compilation of  annual, quarterly and monthly budgets on a Top-Down and or Bottom-UP budgeting basis per division. Make comparisons between each type of budget to determine the most suitable for your business. Compare current to previous years actual and budgeted variances against increase in revenue generated.

Value to you
Gain a clear understanding of where best to provide funding for the best possible return. Determine the relationship between value driven expenditure and mandatory cost expenditure.

Examples of graphs
Variance Analysis 

Description
The report provides a variance analysis of the annual comparative measurements (represented monthly) in real terms for the following:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
You gain an understanding of the performance of each measured metric in real terms, providing a three year window on how your business has performed.

Rolling Financial Forecasting 

Description
Description:  Rolling forecasts continously asses direction of business instead of annual, once off budgeting and forecasting.  Provides simple projections of what is most likely to happen based on current action plans.

Value to you
Rolling budgets provide the business with a real means to continuously measure and manage spend in relation to revenue earned with the view to maintain consistent margins were possible.

Profit & Loss, Balance Sheet and Planning & Forecasting 

Description
Overall, per division and per location information for Profit & Loss and Balance Sheet Planning & Forecasting. The report provides annual comparative monthly forecasted and actual values for:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
Enables you to start building projections against each of the important Profit & Loss as well as Balance sheets measurements of your business. This assists Management to build consistency into their business.

Sales Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Sales Trend Analysis (By Product; Geography; Customer)
  • Sales Channel Analysis
  • Sales lifecycle Analysis
  • Unit Sales Volume Analysis
  • Sales Forecast Accuracy
  • Sales Growth Analysis
  • Sales-mix and Revenue Variance Analysis
 Sales Trend Analysis (By Product; Geography; Customer) 

Description
A sales analysis report shows the trends that occur in a company's sales volume over time. In its most basic form, a sales analysis report shows whether sales are increasing or declining.

Value to you
This analysis is important to understand both your customer and where demand is derived by customer, region and for which products or services. This will also provide you with the trends of demand and inform you what needs to change if anything.

Example of graph

Sales Channel Analysis

Description
Percentage of sales revenue derived per channel (website; social media; mobile applications; face to face; direct marketing) per product or service.

Value to you
Provides insight into which channels are reaching your market most effectively.

Sales lifecycle Analysis

Description

The sales lifecycle analysis examines the sales process and determines which part of the sales process is performing well and which requires additional attention. The Analysis looks at both prospects and actual customers.

Value to you
This assists in understanding which part of the sales lifecycle is operating well and which part is not.

Sales Forecast Accuracy

Description
The proximity of the forecasted quantity of sales to the actual quantity of sales.

Value to you
Mean Absolute Percent Error (MAPE) is a very commonly used metric for forecast accuracy. Since MAPE is a measure of error, high numbers are bad and low numbers are good.

 Sales  Growth Analysis

Description
The change in an organization's sales from one reporting period to another.

Value to you
The amount a company derives from sales compared to a previous, corresponding period of time in which the latter sales exceed the former. Sales growth is considered positive for a company's survival and profitability.

Example of graph

Sales-mix and Revenue Variance Analysis

Description
The revenue variance for an accounting period is the difference between budgeted and actual revenue. A favourable revenue variance occurs when actual revenues exceed budgeted revenues, while the opposite is true for an unfavourable variance.

Value to you
Variance analysis is the quantitative investigation of the difference between actual and planned behaviour. This analysis is used to maintain control over a business.

 Unit Sales Volume Analysis 

Description

The amount of sales in a reporting period, expressed in the number of units sold.

Value to you
Sales volume equals the quantity of items a business sells during a given period, such as a year or fiscal quarter. Sales - or sales revenue - equals the dollar amount a company makes during the period under review.

Example of graph

 

Sales Person Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Monthly Sales Expenses Ratio
  • Sales lifecycle Analysis per Sales Person
  • Cross & Up Selling Analysis
 Monthly Sales Expenses Ratio 

Description
Costs incurred by your sales department—including salaries and commissions.

Value to you
This provides insight into the direct costs of sales for your business in relation to the monthly revenue earned.

Example of graph

Sales lifecycle Analysis per Sales Person  

Description
The sales lifecycle analysis examines the sales process and determines which part of the sales process is performing well and which requires additional attention per sales parson. The Analysis looks at both prospects and actual customers.

Value to you
This assists in understanding which part of the sales lifecycle is operating well and which part is not per sales person.

 Cross & Up Selling Analysis

Description
Cross-Sell and Up-Sell. Cross-sell involves the sale of multiple products offered by a single product/service provider to a new or existing customer. Up-sell is selling higher value products/services to an existing customer.

Value to you
This measurement provides a clear understanding of how well each sales person is both Cross and Up selling your products and services.

Example of graph

Marketing Budgeting and Forecasting Stencil

This Stencil contains the following datasets that make up the graphs:
  • Financial Top-Down/Bottom-Up Budgeting
  • Rolling Financial Forecasting
  • Profit & Loss, Balance Sheet and Planning & Forecasting
  • Variance Analysis
Financial Top-Down/Bottom-Up Budgeting 

Description
Compilation of  annual, quarterly and monthly budgets on a Top-Down and or Bottom-UP budgeting basis per division. Make comparisons between each type of budget to determine the most suitable for your business. Compare current to previous years actual and budgeted variances against increase in revenue generated.

Value to you
Gain a clear understanding of where best to provide funding for the best possible return. Determine the relationship between value driven expenditure and mandatory cost expenditure.

 Variance Analysis 

Description
The report provides a variance analysis of the annual comparative measurements (represented monthly) in real terms for the following:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
You gain an understanding of the performance of each measured metric in real terms, providing a three year window on how your business has performed.

 Rolling Financial Forecasting 

 Description

 Rolling forecasts continuously asses direction of business instead of annual, once off budgeting and forecasting.  Provides simple projections of what is most likely to happen based on current action plans.

Value to you
Rolling budgets provide the business with a real means to continuously measure and manage spend in relation to revenue earned with the view to maintain consistent margins were possible.

Profit & Loss, Balance Sheet and Planning & Forecasting 

Description
Overall, per division and per location information for Profit & Loss and Balance Sheet Planning & Forecasting. The report provides annual comparative monthly forecasted and actual values for:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
Enables you to start building projections against each of the important Profit & Loss as well as Balance sheets measurements of your business. This assists Management to build consistency into their business.

Products, Channels, Customers Profitability Analysis Stencil 

This Stencil contains the following datasets that make up the graphs:
  • Channel of demand for information used by customers
  • ROI on marketing activities
  • Key Customer Growth Analysis
  • Key Customer Profitability Growth Analysis
  • Product/ Geography Growth Analysis
  • Product / Geography Profitability Analysis
Channel of demand for information used by customers 

Description
Percentage of sales revenue derived per channel (website; social media; mobile applications; face to face; direct marketing) per product or service.

Value to you
This measurement provides you  with an understanding of where the sources of demand for your products and services are coming from and will assist with your budgeting.

 ROI on marketing activities 

Description
Evaluate and prioritize market opportunities and spend considerations by understading the average return on investment ROI on (website; social media; mobile applications; face to face; direct marketing)  channel marketing/sales campaigns

Value to you
Be in a position to better understand where you organisation should be focusing its marketing actvities.

Key Customer Growth Analysis

Description
Percentage of revenue growth for the top 20 percent of your customers
Value to you
Understand which of your key customers are growing and by what percent year on year for your business.

Key Customer Profitability Growth Analysis

Description
Percentage of profitability growth for the top 20 percent of your customers

Value to you
Understand which of your key customers are providing you with what profitability and by what percent year on year for your business.

Product/ Geography Growth Analysis 

Description
Percentage of product revenue growth for a defined period, measured by product and region.

Value to you
Understand which of your key customers are growing and by what percent year on year for your business.

 Product / Geography Profitability Analysis

Description
Percentage of product profitability growth for a defined period, measured by product and region.

Value to you
Understand which of your key customers are providing you with what profitability and by what percent year on year for your business.

Marketing Cost Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Marketing Expense Ratio
  • Cost per Click (Google Ads)
  • Promotions Analysis
Marketing Expense Ratio

Description
Encompasses the total costs incurred by the marketing department, including advertising, salaries, research, and surveys.

Value to you
This measure provides an indication of the marketing cost incurred in order to generate sales.

Cost per Click (Google Ads)

Description
Measures the cost of a pay-per-click advertising campaign (such as Google AdWords).

Value to you
This measure provides an indication of the marketing cost for Google Ads

Marketing Expense Ratio

Description
Promotion is any form of communication a business or organization uses to inform, persuade, or remind people about its products and improve its public image.  Promotional analysis is a technique of evaluating success or failure of a promotion using past time series data. It can be understood as discovering a correlation between sales patterns and marketing efforts which includes promotions offered and advertising.

Value to you
This measure informs you on how effective a promotion has been.

Operations Stencils

The following Stencils will be launching soon...
  • Capacity Planing
  • Inventory Forecasting and Optimization
  • Materials Management
  • Procurement Analysis
  • Production Forecast and Planning
  • Supplier Rating
Contact us to enquire about these Stencils

Supply Chain Stencils

The following Stencils will be launching soon...
  • Demand Planning
  • Cost to Serve
  • Integrated Capacity Planning
  • Daily & Weekly Workload Planning
  • Financial Insights Across the Supply Chain
  • What-if and What-for Analysis to Forecast
  • Material and Production Line Needs
  • Supply Chain Dashboard and KPIs
Contact us to enquire about these Stencils

Human Capital Budgeting and Forecasting Stencil

This Stencil contains the following datasets that make up the graphs:
  • Financial Top-Down/Bottom-Up Budgeting
  • Rolling Financial Forecasting
  • Profit & Loss, Balance Sheet and Planning & Forecasting
  • Variance Analysis
Financial Top-Down/Bottom-Up Budgeting 

Description
Compilation of  annual, quarterly and monthly budgets on a Top-Down and or Bottom-UP budgeting basis per division. Make comparisons between each type of budget to determine the most suitable for your business. Compare current to previous years actual and budgeted variances against increase in revenue generated.

Value to you
Gain a clear understanding of where best to provide funding for the best possible return. Determine the relationship between value driven expenditure and mandatory cost expenditure.

Variance Analysis  

Description
The report provides a variance analysis of the annual comparative measurements (represented monthly) in real terms for the following:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
You gain an understanding of the performance of each measured metric in real terms, providing a three year window on how your business has performed.

 Rolling Financial Forecasting  

Description
Description:  Rolling forecasts continously asses direction of business instead of annual, once off budgeting and forecasting.  Provides simple projections of what is most likely to happen based on current action plans.

Value to you
Rolling budgets provide the business with a real means to continuously measure and manage spend in relation to revenue earned with the view to maintain consistent margins were possible.

Profit & Loss, Balance Sheet and Planning & Forecasting  

Description
Overall, per division and per location information for Profit & Loss and Balance Sheet Planning & Forecasting. The report provides annual comparative monthly forecasted and actual values for:  Gross Profit, EBIT (Earnings before Income Tax), Net Profit, Retained Income, Customer Control Account (Debtors), Fixed Assets (Equipment; Furniture etc.), Creditors Control Account (Creditors)

Value to you
Enables you to start building projections against each of the important Profit & Loss as well as Balance sheets measurements of your business. This assists Management to build consistency into their business.

Human Capital Cost and Profitability Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Revenue per FTE (Full time employee)
  • Cost Per Hire
  • Percentage of Cost of Workforce
  • Human Capital Value Added (HCVA)
New releases - launching soon!
  • HR Performance Management
  • HR Planning, Budgeting and Forecast
  • Employee Costs Monitoring
  • Benefits and Incentive Planning
  • Skills Mapping
  • HR Dashboards and KPIs
  • Organizational alignment to roles and processes
Revenue per FTE (Full time employee) 

Description
Demonstrates how expensive an organization is to run.

Value to you
This measurement informs you of the revenue earned per FTE Employee.

 Cost Per Hire 

Description
The average cost of hiring a new employee, including advertising fees, employee referrals, travel expenses, relocation expenses, and recruiter costs.

Value to you
This measure informs you of the real cost to employ a new perosn into the organisation excuding their salary or wages costs.

Percentage of Cost of Workforce 

Description
The cost of the workforce as compared to all costs can be measured by summing all salaries and dividing by the total company costs within a given time period.

Value to you
This measure informas you of the direct cost of labour in relation to all your expenses.

Human Capital Value Added (HCVA)

Description
By taking all non-employee related costs away from the revenue and dividing the result by the number of full-time employees, you can deduce how profitable the average worker in an organization is.

Value to you
This measure informs you of how profitable the business is per employee.

Customer Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Customer Lifetime Value
  • Customer Acquisition Cost
  • Customer Lifetime Value / Customer Acquisition Cost
  • Average Annual Sales Volume Per Customer
  • Average Annual Expenses to Serve One Customer
Customer Lifetime Value

Description
The net profit an organization anticipates gaining from a customer over the entire length of a relationship helps to determine the costs/benefits of acquisition efforts.

Value to you
To identify your High Value Customers (HVC), first you want to calculate the Customer Lifetime Value (CLV) of each customer and then rank them by the results.

Customer Acquisition Cost 

Description
The cost to acquire one new customer.

Value to you
This measure provides a clear understanding of the cost to acquire new customers

Customer Lifetime Value / Customer Acquisition Cost

Description
The ratio of customer lifetime value to customer acquisition cost should ideally be greater than one, as a customer is not profitable if the cost to acquire is greater than the profit they will bring to a company.

Value to you
This measure informs you if it is profiable for you to take on a customer or not.

Average Annual Sales Volume Per Customer

Description
This is the average amount of sales per customer, expressed in currency.

Value to you
This informs you of the average value of revenue obtain per customer and can influence your customer retetion strategy.

 Example of graph



 Average Annual Expenses to Serve One Customer

Description
This is the average amount needed to serve one customer.

Value to you
This measurement assist in understanding what it costs your business to serve a single customer on average.

Customer Retention Analysis Stencil

This Stencil contains the following datasets that make up the graphs:
  • Repeat Customer Rate (RCR)
  • Purchase Frequency Metric
  • Time Between Purchases (TBP) metric
  • Average Order Value
Repeat Customer Rate (RCR)

Description
The Repeat Customer Rate (RCR) measures the percentage of customers who are willing to make a second purchase from you. The higher this metric is, the more likely it is that customers will return to you.

Value to you
This informs you of how well your company is doing in generating loyalty among its customer base.

Purchase Frequency Metric

Description
The Purchase Frequency (PF) is tied to your repeat customer rate, and your retention rate will fall if the purchase frequency falls.

Value to you
Your PF indicates how often the average customer buys something from you.

Time Between Purchases (TBP) metric

Description
Time Between Purchases (TBP) metric, which shows you how many times a year a customer buys from you. Once you learn how long it takes the average customer to buy again, you can predict purchasing patterns and implement retention strategies to tug at their purse strings.

Value to you
Your TBP is an invaluable metric for maximizing revenue.

 Average Order Value

Description
You need to know the actual worth of each purchase, and the Average Order Value (AOV) metric gives you the average amount of money each customer spends per purchase.

Value to you
The more your existing customers spend per transaction, the less you’ll need to pursue new customers through costlier techniques.

Governance and Compliance Stencils

The following Stencils will be launching soon...
  • Auditing Compliance
  • Maturity and capability Analysis
Contact us to enquire about these Stencils
TOP