Sign Up, Its Free

We have launched one more exciting feature on the site!! Now, as a Vendor apart from selling tools and templates, you can also provide hourly consultation!

Vendors who will register with us until 30.09.2020, will get the benefit of "subscription-free" registration. Vendors who are registering post 30.09.2020 might have to pay a yearly subscription fee for using our platform. So, get registered soon and spread the word.

We are launching with few Categories... However, we will be continuously multiplying our bucket list with exciting categories and sub-categories of different fields and professions!!

If you are a Vendor looking to sell tools in any specific category which is not present at the moment on our platform, for instance, say "Branding and Strategy." Simply, email us along with one of your sample business tools on "support@icrestmodels.com" and we will add the same after verifying.

We have our showcased inventory as well so that the upcoming vendors can view the quality of business tools we are looking for.

What's New

Inventory Analysis and Management

Type of Business : Accounting and Finance

Price : USD 25 25.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    In this publication I will discuss how to analyze inventory, communicate findings of your analysis and make practical use of them. The main areas covered by the analysis are inventory balance movements, days inventory outstanding, turnover, seasonality, aging, planning orders

  • Full Description

    In this publication I will discuss how to analyze inventory, communicate findings of your analysis and make practical use of them. The main areas covered by the analysis are: 1. Understand what drives your inventory balances. This includes analyzing the movements of inventory by product and seeing which products affected the change to the largest extent. This analysis includes a horizontal waterfall showing the changes graphically. Inventory balances are reduced by the sales and increased by the purchases. There is another visual tool, also based on horizontal waterfall chart, showing the effect of these two factors and giving an idea of how total inventory flows compare to inventory balances. 2. Days Inventory Outstanding. Unlike many other calculations which take inventory balance at some date and COGS (or revenues) in that period, I am using a formula taking the actual COGS in prior (or subsequent) periods and returning the actual number of days covered by the inventory balance. Writing this formula is clearly an Excel challenge which is solved in a smart way using the OFFSET, MMULT and other functions. I am giving two alternative calculations here: based on past and future sales. 3. Inventory seasonality – many business are prone to seasonal changes in sales which affects inventory balances, turnover and cost of sales. 4. Aging of inventory – this part explains how to calculate inventory reserve and demonstrates inventory balances by products and by age groups in a professionally designed chart. 5. Planning orders taking into account inventory requirements and delivery time. Many of the methods used in this publication can be applied to other types of financial analysis (e.g. making aging of accounts receivable, planning cash receipts based on sales payment terms). As a bonus, the publication explains in detail how to create a horizontal waterfall chart. This is a smart and efficient type of chart visualizing variances between the numbers. It will surely make your presentations look professional and your reports - impress your clients, managers and colleagues. This chart is compatible with all versions of Excel.

  • Table of Content
    No. Content
    Inventory Analysis and Management inventory balance movements days inventory outstanding inventory turnover seasonality aging planning orders
  • Reviews

    No Review. Write a review and be the first.

Related Products