Operations Reporting 101 for SMB

Updated: June 01, 2010

Based on my own experience in small as well as large businesses, I have listed below the basic data that I believe is necessary to produce appropriate reports and where this data could be sourced from:

Freight:

  • Consignment note details: Softcopy of freight invoice (Excel)
  • Cost of each consignment note: Softcopy of freight invoice (Excel)
  • Sales value of each consignment: Obtain from - IT/Finance

Inventory:

  • Total inventory valuation: Obtain from - IT/Finance
  • Total Sales Revenue: Obtain from - IT/Finance
  • Lines on backorder: Obtain from - IT/Finance
  • Excess Stock value: Obtain from - IT/Finance

Staffing:

  • FTE total hours: Obtain from Payroll/HR
  • Overtime hours: Obtain from Payroll/HR
  • Sick Leave hours: Obtain from Payroll/HR
  • Total Salary Cost: Obtain from Payroll/HR
  • Quantity of orders entered: Obtain from - IT
  • Value of Orders entered: Obtain from - IT/Finance

FREIGHT: By basing these three data items around the consignment note you easily get the cost of freight per sale dollar. The next level of reporting is to use the other data that is included with the consignment note, eg: sum into delivery location/zone, now you can also see which zone is costing the most compared to sales - the relationship is not just dependant on distance from source but also value of the order.

This can be done weekly or monthly with the resulting report indicating any overall delivery cost trends at a higher level, but at the detail (customer level) this can prompt requesting customers to change their ordering profile, eg: minimum value of order.

INVENTORY: This amount of data allows tracking of financial as well as customer servicing. Use sales revenue/total value to ascertain stock turn (You want to show higher stock turn rather than lower).

‘Lines on back-order' is an indicator of your true supply performance and highlights the offending products (and suppliers). If the total quantity of each is added, you can now compare this report to the previous to see trends in supply. This report should be done no less than weekly and will be a snap shot as "backorders" in most systems is a dynamic field (you cannot extract history).

Excess stock is any stock that has not sold for a specified period, the period will depend on a number of factors but the result is a report of products that you must move to reduce expenditure. Actions to mitigate excess stock (a brief all its own) is a critical ongoing function of the SOP process. As you get more proficient using this data - and spreadsheets - it will be easier to drill down to item level across all reports.

STAFFING: This data will help produce reports that indicate efficiency of work, when compared with sales and quantity of orders is indicates not only the effectiveness of the team but also how the ordering profile relative to input cost (similar to freight).

Combining and comparing the data from the different functions can also be used to gain further visibility to the business, for example using the number of lines going to backorder as a percentage of orders placed over the week. Also notice that I request transport suppliers to provide copies of their invoices in Excel format, this can save an untold amount of work and can also be used as an audit trail if there are discrepancies in rates. Hard copies can still be provided to accounts payable for processing if required.

Featured Research
  • Best ERP Features and Benefits for Your Business

    Are you considering investing in ERP software for the first time? Or maybe you already have an ERP solution but you’re worried it’s becoming dated. If either of the above apply to you, read our latest guide on the top ERP features and benefits based on the size of your business. You may be surprised at how versatile and cost-effective it is becoming - regardless of if you own a small business or run a large enterprise. more

  • 9 Spooky Signs You Need a Contact Center Upgrade

    When was the last time you evaluated the performance of your current contact center and the software you are using? The results may be frightening! If it’s been awhile since you invested in contact center software, there is a good chance that your needs have changed or that there are better options available now. Fortunately, it’s relatively easy to determine if you need an upgrade or not. more

  • 7 Ways the Wrong Phone System Can Haunt Your Business

    The wrong phone system could be haunting your business - and we’re talking about problems more serious than ghosts and ghouls. From increased costs to issues with scaling, we’ve identified seven important ways that a less than ideal phone system could be holding you back. You’ll be surprised at how much of a difference this can make to your bottom line too. more

  • Ditch Your Fax Servers

    An in-house fax server gives an IT department centralized management and monitoring over the entire enterprise's faxing. This can help your company track usage and better maintain records for auditing and record keeping. However, there are serious drawbacks that come with utilizing an in-house fax server solution and these range from security to cost-prohibitive pricing. more

  • The IT Manager's Survival Guide

    As an IT manager, maintaining physical fax servers and infrastructure is not a high priority. However, fax capability remains a business need simply because chances are your industry is dependent on its security. What if there was a way to reduce the amount of time spent handling fax complaints and maintaining physical servers? And this way took into account security, cost savings, and freed up your IT resources. Would you be interested? more