site Object ( [id] => ukaatoal [siteArray] => Array ( [id] => ukaatoal [name] => Tips & Advice Business Database [url] => businessdatabase.indicator-flm.co.uk [folder] => [query] => nl in ('UKTACDAL','UKTABMAL','UKTAENAL','UKTAHSAL','UKTAITAL','UKTAPSAL','UKTATXAL','UKTAVAAL','UKPPPSAL','UKPPPRAL','UKTPTPAL') [artnl] => nl [cookiedom] => indicator-flm.co.uk [locale] => en_GB.utf-8 [dictionary] => default_english [dzquery] => na [bymailid] => na [csemail] => customer.services@indicator-flm.co.uk [comurl] => www.tipsandadvice-businessdatabase.co.uk [gaid] => 0aecf2e1-89c1-466c-b5e2-c194ac507d5d [edimail] => c.chauca@indicator.es,eleanor.morris@indicator-flm.co.uk,sue.hart@indicator-flm.co.uk [hasdz] => [hasisearch] => [haslib] => 1 [hasdup] => 1 [topinterval] => 60 [bossappend] => [nrofpages] => 08 [enable] => 1 [orderfrom] => orderuk@indicator-flm.co.uk [kt_user] => webservice [kt_password] => paChac4v [folder_id] => 6828 [maintenance] => [commonid] => ukaatoal [thematization] => [dev_url] => aav5test.indicator-flm.co.uk [dev_folder] => [language] => EN [country] => uk [ds] => [solr_query] => UKTACDAL,UKTABMAL,UKTAENAL,UKTAHSAL,UKTAITAL,UKTAPSAL,UKTATXAL,UKTAVAAL,UKPPPSAL,UKPPPRAL,UKTPTPAL [alternative_ids] => Array ( ) ) [ezineArray] => Array ( ) [fcfArray] => Array ( ) [promArray] => Array ( ) [_sitePropArray] => Array ( ) [_siteReplArray] => Array ( ) [addressArray] => Array ( [publishing_director] => Duncan Callow [publishing_director_phone] => 01233 653507 [fax] => (01233) 647100 [registration_number] => 3599719 [email] => subscriptions@indicator-flm.co.uk [commonwebsite] => www.indicator-flm.co.uk [street_house] => Calgarth House [loyalty_mail] => online.support@indicator-flm.co.uk [loyalty_fax] => (01233) 647100 [essentials_template] =>
Indicator - FL Memo Ltd
Tel: (01233) 653500. Fax: (01233) 647100
customer.services@indicator-flm.co.uk
www.indicator-flm.co.uk
Calgarth House
39-41 Bank Street
Ashford, Kent TN23 1DQ
VAT GB 726 598 394
Registered in England
Company Registration No. 3599719
Many businesses believe that they consistently carry more stock than is needed. As holding stock means tying up cash, then ideally you would want to keep stock at minimum levels to meet sales forecasts and keep production running smoothly. So how can you help the board make sense of how well stock is being handled?
Stock turnover kpi
A classic operating efficiency key performance indicator (KPI), based on readily available financial information, is “stock turnover”; this shows how fast stock is moving through the business. A high turnover could indicate a healthy and liquid inventory with lower demands on cash flow, but it could also mean stock shortages. A low turnover suggests overstocking although that could just be down to seasonal demand. These different interpretations show that calculating the average from only two days in a period (beginning and end of the period) is highly dangerous if they are not representative days.
Our Stock Turnover Calculator uses a moving average calculation to avoid this potential “unrepresentative” issue.
Use more than one kpi
Be wary of suggesting a change to the company’s stock policy purely based on stock turnover KPIs. If the board sees a stock turnover KPI which suggests inventory is rapidly piling up beyond what’s needed, the typical reaction is to enforce a clampdown on new purchases. However, this can create material shortages which can cause missed shipments, depressed revenue and customer service but increased stock and costs. Calculate additional KPIs for stock management, such as:
Adding these as separate sheets to your stock turnover calculator workbook will enable the board to get a handle on the stock level position.