Tag Archives | productivity

Days Inventory Outstanding

See Also:
Inventory Turnover Ratio
Inventory to Working Capital Ratio
How to Manage Inventory
Days Sales Outstanding (DSO)
Days Payables Outstanding (DPO)
How to Develop Daily Cash Report
13 Week Cash Flow Report
Supply Chain and Logistics

Days Inventory Outstanding

Days inventory outstanding (DIO), defined also as days sales of inventory, indicates how many days on average a company turns its inventory into sales. Value of DIO varies from industry and company. In general, a lower DIO is better. A useful tool in managing and improving inventory turns is a Flash Report!

Days Inventory Outstanding Explanation

Days inventory outstanding ratio, explained as an indicator of inventory turns, is an important financial ratio for any company with inventory. It shows how quickly management can turn inventories into cash. In general, a decrease in days inventory outstanding (DIO) is an improvement to working capital, and an increase is deterioration.

Days Inventory Outstanding Formula

The days inventory outstanding formula can be calculated using the equation below:

(NOTE: Want the 25 Ways To Improve Cash Flow? It gives you tips that you can take to manage and improve your company’s cash flow in 24 hours!. Get it here!)

Days inventory outstanding = (average inventory / cost of goods sold) * 365 days

Days Inventory Outstanding Calculation

Days inventory outstanding calculations cross a myriad of needs and purposes.

Example: a business has $2,500 in inventory on average, $25,000 in cost of goods sold.

Days Inventory outstanding = (2,500 / 25,000) * 365 = 37 days

Days Inventory Outstanding Example

James is the owner of a grocery store. His store, a private seller of groceries to a large suburb, has grown to be a household name in his local area. James now wants to find his days inventory outstanding (DIO) for his store, as well as, select product lines.

James begins by talking to his accountant. The accountant, skilled in his profession, performs this days inventory outstanding analysis:

James’ store has $2,500 in inventory on average, $25,000 in cost of goods sold.

Days Inventory outstanding = (2,500 / 25,000) * 365 = 37 days

James’ store is keeping pace with the national market of grocery stores. In his state, however, James’ store could use a little improvement. James considers options such as clearance item discounts or running coupons on items which he wants to sell faster. These promotions, including lower prices, could produce the inventory turnover which James is looking for.

James now looks to his bookkeeper for up-to-date information on his days inventory outstanding for certain product lines. James allows time to find these measurements and is confident that with the right team, perspective, and motivations he can grow his store further.

Reducing days inventory outstanding is just one of the many ways to improve the cash flow of a company. If you’re looking for 24 ways to improve cash flow, download the free 25 Ways to Improve Cash Flow whitepaper.

days inventory outstanding

Strategic CFO Lab Member Extra

Access your Cash Flow Tuneup Execution Plan in SCFO Lab. This tool enables you to quantify the cash unlocked in your company.

Click here to access your Execution Plan. Not a Lab Member?

Click here to learn more about SCFO Labs

days inventory outstanding

Resources

For statistical information about industry financial ratios, please go to the following websites: www.bizstats.com and www.valueline.com.

2

Too Many Passwords!

I have way too many passwords. To date I have over 75 and counting! How many passwords do you have?

I have a confession. I am “early adopter” of technology. Consequently, I am adding web sites and new tools all the time. Since I bought my Ipad I have ended up buying over 30 apps. A lot of them requiring a new password. It is becoming a full time job managing the passwords. So I came up with a system to track my passwords.

My system is to keep all of my passwords in an excel spreadsheet on our secure server. If I die or get hit by a bus please tell my wife where they are! Unfortunately, even this simple system is getting cumbersome between my computer, Iphone and Ipad. I am looking for a simple solution.

How are you managing your passwords? Is anybody using a 3rd party app or website to manage their passwords? If you like it please let me know.

0

Financial Ratios

Monitoring a company’s performance using ratio analysis and comparing those measures to industry benchmarks often leads to improvements in company performance. Not to mention that financial ratios are often part of loan covenants. The following article provides an overview of the five major categories of financial ratios and links to their description and calculation.

“Financial Ratios are used to measure financial performance against standards. Analysts compare financial ratios to industry averages (benchmarking), industry standards or rules of thumbs and against internal trends (trends analysis). The most useful comparison when performing financial ratio analysis is trend analysis. Financil ratios are derived from the three financial statemtents; Balance Sheet, Income Statement and Statement of Cash Flows.

There are five (5) major categories included in the financial ratios list are:
– Liquidity Ratios
– Activity Ratios
– Debt Ratios
– Profitability Ratios
– Market Ratios…”

More at WikiCFO.com

3