Inventory Curve
  • Home
    • The Inventory Curve
    • Inventory Snapshots
    • GMROI
    • Cash to Cash Cycle
    • Tracking Financials
    • Strategic Profit Model
    • Improving Performance
    • The Work We ALL Do
    • On-Line Store
    • About
    • PDF Files
    • Home
    • Pages
      • The Inventory Curve
      • Inventory Snapshots
      • GMROI
      • Cash to Cash Cycle
      • Tracking Financials
      • Strategic Profit Model
      • Improving Performance
      • The Work We ALL Do
      • On-Line Store
      • About
      • PDF Files
Inventory Curve
  • Home

ONLine Store

This content is FREE!


Over the years as I have worked in the field of supply chain with broad interests specifically related to inventory, operations, materials and systems as well as the other functional areas; I've discovered new ideas, concepts and practices that extend the body of knowledge. 

I'm particularly grateful to the many members of the Council of Logistics Management (now the Council of Supply Chain Management Professionals) who were willing to mentor and freely share their knowledge with me.  

To that end, as I now wind down my professional career, I'm making these tools available for FREE.  I hope that they are valuable to you and that you can use them in your work and study.


These Interactive Spreadsheets are available:


Interactive Strategic Profit Model (SPM)

 

Enter basic financial data for a company in the Data Entry page and this Excel Spreadsheet calculates and displays two graphical versions of an organizations finances.  It also calculates GMROI and the Cash to Cash Cycle.


For more information see the Strategic Profit Model page. 


Strategic Profit Model Practical Considerations


 A one-page document with additional comments for the effective use of the SPM.


Interactive SPM for Non-profits


A version of the SPM modified for tax-exempt organizations that uses the IRS form 990 as input.


GMROI Lot Size Calculator


This interactive spreadsheet allows the evaluation of an items profitability using GMROI based on different price/quantity breaks.

Using GMROI to Evaluate Purchasing Quantity Price Breaks 

is a  companion paper to the GMROI Lot Size Calculator.  


It explores the relationship between cost and profitability using Gross Margin Return on Inventory Investment (GMROI) with a surprising result: in many cases, getting a lower cost comes at the expense of higher order minimums which translate to lower turnover and as a result, yield a lower GMROI. This means that the higher margin obtained through a lower cost is more than offset by the lower inventory turnover. For more information on GMROI, see the GMROI page on this website. 



Downloadable file — Interactive SPM

Interactive Strategic Profit Model (SPM)

Interactive SPM (xlsx)

Download

Downloadable PDF — SPM Practical Considerations

SPM Practical Considerations — additional information to extend your use of the SPM download.

SPM - Practical Considerations (pdf)Download

Downloadable file — Interactive SPM for non-Profits

Interactive Strategic Profit Model (SPM) for non-Profits.


Extends the concepts of the SPM to non-profits and uses the IRS form 990 for input.

Intractive SPM for Non-Profits (xlsx)

Download

Downloadable file — GMROI Lot Size Calculator

GMROI Lot Size Calculator 0314 (xlsx)

Download

Downloadable PDF — GMROI and Quantity Breaks

GMROI and Quantity Break document addresses the relationship between quality/price breaks and profitability for individual items.

GMROI and Quantity Breaks (pdf)Download

Inventory Curve logo with DServcie Mark

Inventory Curve, LLC, Thornton, Colorado, USA

Looking at inventory performance improvement through a different lens.

Copyright © 2021 Inventory Curve - All Rights Reserved.


Powered by GoDaddy

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept