Manufacturing Template

Overview

The manufacturing template combines some of the key metrics manufacturing businesses should focus on. These metrics are split across the Manufacturing Financial Metrics and Manufacturing Sales Metrics pages in Spotlight. To make the most of the template, you will need to:

  • Source non-financial data
  • Assign specific report codes to key accounts
  • Evaluate the formulas and customise using the formula builder if necessary. Some businesses may measure these metrics differently due to seasonality, setup of accounts or other factors.

Non-financial data required

Most manufacturing metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:

  • Number of sales transactions
  • Number of items sold
  • Volume (Number of items manufactured)

You can manually enter the data into the non-financial tab under Customise Data.

Assign specific report codes to key accounts

Most report codes needed for the template are automatically assigned by Spotlight. However, for the metrics to calculate correctly you may need to assign some report codes manually. To do this, open Customise Data and locate the following accounts, then to assign the specified report code click the report code button:

  • Direct wages - EXP.COS.WAG (Expenses > Cost of goods sold > Direct wages)
  • Purchases - EXP.COS.PUR (Expenses > Cost of goods sold > Purchases)
  • Stock - ASS.CUR.INY (Assets > Current assets > Inventory)

Manufacturing Financial Metrics page

Top Three Cost of Sales

Manufacturing Financial Metrics Top Three Cost of Sales

Formula: Cost of sales [YTD]
Report codes used: EXP.COS

Direct Costs % to Revenue

Manufacturing Financial Metrics Direct Costs to Revenue

Formula: Direct Wages / Trading Revenue * 100
Report codes used: EXP.COS.WAG, REV.TRA

Materials Cost Per Unit

Manufacturing Financial Metrics Materials Cost Per Unit

Formula: (Cost of Goods Sold - Direct Wages) / Volume
Report codes used: EXP.COS, EXP.COS.WAG, OPR.VOL

Labour Cost Per Unit

Manufacturing Financial Metrics Labour Cost Per Unit

Formula: Direct Wages / Volume
Report codes used: EXP.COS.WAG, OPR.VOL

Manufacturing Metrics page

Units Manufactured

Manufacturing Metrics Units Manufactured

Formula: Volume
Report codes used: OPR.VOL

Units Per Transaction

Manufacturing Metrics Units Per Transaction

Formula: Items sold / sales transactions
Report codes used: SAL.ITE, SAL.TRA

Average Revenue Per Transaction

Manufacturing Metrics Average Revenue Per Transaction2

Formula: Trading revenue / sales transactions
Report codes used: REV.TRA, SAL.TRA

Stock Turn

Manufacturing Metrics Stock Turn

Formula: Purchases / average closing inventory
Report codes used: EXP.COS.PUR, ASS.CUR.INY

Debt Burden Percentage

Manufacturing Metrics Debt Burden Percentage

Formula: (Interest Expense / (Total Expenses - Cost of Sales)) * 100
Report codes used: EXP.INT, EXP, EXP.COS

Still need help?
Get in touch!