Manufacturing Template

• Overview
• Non-financial data required
• Assign specific report codes to key accounts
• Manufacturing Financial Metrics page
• Top Three Cost of Sales
• Direct Costs % to Revenue
• Materials Cost Per Unit
• Manufacturing Metrics page
• Units Manufactured
• Units Per Transaction
• Average Revenue Per Transaction
• Stock Turn
• Debt Burden Percentage
  ‍
  

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

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

Direct Costs % to Revenue

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

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

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

Manufacturing Metrics page

Units Manufactured

Formula: Volume
Report codes used: OPR.VOL

Units Per Transaction

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

Average Revenue Per Transaction

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

Stock Turn

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

Debt Burden Percentage

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

‍