ÿþ<HTML> <HEAD> <TITLE>Inventory Analysis</TITLE> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso8859-1"> <META NAME="description" CONTENT="Financial Calculators, ©1998-2010 KJE Computer Solutions, LLC. For more information please see http://www.dinkytown.net"> <STYLE> <!-- BODY, TABLE, TD, TH, UL, OL, DD, DL, P, BR { font-family: helvetica, arial, sans-serif; font-size: 10pt; } H1 { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } DT { font-family: helvetica, arial, sans-serif; font-size: 10pt; font-weight: bold; } P.footer { font-family: helvetica, arial, sans-serif; font-size: 9pt; } DIV.large { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } --> </STYLE> </HEAD> <!-- Financial Calculators, ©1998-2008 KJE Computer Solutions, LLC. For more information please see: <A HREF="http://www.dinkytown.net">http://www.dinkytown.net</A> --> <SCRIPT LANGUAGE="JavaScript"> <!-- function doLeave() { //alert("leave the applet focus"); document.calcsubmit.btnCallCalc.focus(); } function showbuttons() { var agt = navigator.userAgent.toLowerCase(); var IEMAC = ((agt.indexOf("msie") != -1) && agt.indexOf("mac")!=-1); var N6 = (agt.indexOf("netscape6") != -1 || (agt.indexOf("netscape/6") !=-1 )); if ( N6 ) { return "Netscape 6 is unable to support our detailed reports. Please upgrade to Nescape 7 or higher.<P>"; } if ( IEMAC ) { return "<P>"; } return "<P><FORM name=calcsubmit><INPUT TYPE='button' value='Calculate' Name='btnCallCalc' onClick='document.calculator.calculate()'><INPUT TYPE='button' value='View Report' Name='btnOpenNote' onClick='openNote()'></FORM>"; } function openNote() { var agt=navigator.userAgent.toLowerCase(); var is_aol = (agt.indexOf("aol") != -1); leftpos=0; if (screen) { leftpos=screen.width/2 - 300; } if (is_aol) { var s = " "; s=document.calculator.sJavaScriptReport('HTML'); document.write(s); } else { var OpenWindow=window.open("","newwin","toolbar=yes,menubar=yes,location=no,directories=no,status=no,scrollbars=yes,resizable=yes,copyhistory=no,width=600,height="+(screen.height-120)+",left="+leftpos+",top=5"); var s = " "; s=document.calculator.sJavaScriptReport('HTML'); OpenWindow.document.write(s); OpenWindow.document.close(); OpenWindow.focus(); } } // --> </Script> <BODY bgcolor="#FFFFFF" LINK="#003399" VLINK="#666666" BGCOLOR="#FFFFFF"> <!-- \Title\ --> <P><CENTER><table border=0 bgcolor="#000000" width=468 cellspacing=1 cellpadding=0><tr><td width="100%"><table bgcolor="#FFFFDD" border=0 width=468 cellspacing=1 cellpadding=5><tr><td width="100%" align=center valign=middle><DIV class=large><a href="index.html" STYLE="text-decoration: none">100 Free Tax, Debt and Financial Calculators</a></DIV></td></tr></table></TD></TR></TABLE></CENTER> <!-- \Main Area\ --> <!-- Financial Calculators, ©1998-2008 KJE Computer Solutions, LLC. For more information please see: <A HREF="http://www.dinkytown.net">http://www.dinkytown.net</A> --> <H1>Inventory Analysis</H1><P>This calculator helps you determine how much inventory you should hold, and when you should place inventory orders. The calculation attempts to keep your inventory level as efficient as possible, while maintaining adequate safety stock.<P><CENTER> <!--[if IE]><object name="calculator" classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93" codebase="http://java.sun.com/update/1.6.0/jinstall-6-windows-i586.cab#Version=1,4,0,0" height="400" width="565"><param name="code" value="Inventory" /><param name="archive" value="dinkytown.jar" /> <P style="font-size:1px; color: #ffffff" line-height: 1px><![endif]--><![if !IE]><P style="font-size:1px; color: #ffffff" line-height: 1px><![endif]></P><![if !IE]><APPLET name="calculator" code="Inventory.class" align="baseline" WIDTH="565" HEIGHT="400" archive="dinkytown.jar"><![endif]> <PARAM name="CURRENT_DEMAND_PER_WEEK" value="1000"> <PARAM name="EXPECTED_ANNUAL_GROWTH" value="30"> <PARAM name="SAFETY_STOCK" value="25"> <PARAM name="ORDER_LEAD_TIME_IN_WEEKS" value="4"> <PARAM name="STARTING_INVENTORY" value="5000"> <!--CUSTOM PARAMETERS--> <PARAM name="TEXT_FOR_REPORT" value="<HTML> <HEAD> <TITLE>Inventory Analysis</TITLE> <META HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=iso8859-1'> <META NAME='description' CONTENT='Financial Calculators, &QCPQ;1998-2010 KJE Computer Solutions, LLC. For more information please see http://www.dinkytown.net'> <STYLE> <!-- BODY, TABLE, TD, TH, UL, OL, DD, DL, P, BR { font-family: helvetica, arial, sans-serif; font-size: 10pt; } H1 { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } DT { font-family: helvetica, arial, sans-serif; font-size: 10pt; font-weight: bold; } P.footer { font-family: helvetica, arial, sans-serif; font-size: 9pt; } DIV.large { font-family: helvetica, arial, sans-serif; font-size: 13pt; font-weight: bold; } --> </STYLE> </HEAD> <BODY bgcolor='#FFFFFF' LINK='#003399' VLINK='#666666' BGCOLOR='#FFFFFF'> <CENTER><table border=0 bgcolor='#000000' width=468 cellspacing=1 cellpadding=0><tr><td width='100%'><table bgcolor='#FFFFDD' border=0 width=468 cellspacing=1 cellpadding=5><tr><td width='100%' align=center valign=middle><DIV class=large>Inventory Analysis</DIV></td></tr></table></TD></TR></TABLE></CENTER> <H1>Over the WEEKS_OF_ANALYSIS weeks your average inventory needs are TARGET_AVERAGE_INVENTORY units.</H1>**GRAPH**<P>Over the next WEEKS_OF_ANALYSIS weeks your average inventory needs are TARGET_AVERAGE_INVENTORY units. Your minimum inventory at any time during this period is projected at MINIMUM_INVENTORY units and your maximum inventory is MAXIMUM_INVENTORY units. This assumes an EXPECTED_ANNUAL_GROWTH annual growth rate with an initial demand for your product at CURRENT_DEMAND_PER_WEEK per week. <P><CENTER><table border=0 bgcolor='#000000' width=95% cellspacing=1 cellpadding=0><tr><td width='100%'><table bgcolor='#FFFFFF' border=0 width=100% cellspacing=1 cellpadding=5> <TR BGCOLOR='#CCCCCC'><TD COLSPAN=2><CENTER><B>Results for next WEEKS_OF_ANALYSIS weeks</B></CENTER></TD></TR> <TR><TD><b>Average inventory </b> </TD><TD>TARGET_AVERAGE_INVENTORY units</TD></TR> <TR><TD><b>Maximum inventory </b> </TD><TD>MAXIMUM_INVENTORY units</TD></TR> <TR><TD><b>Minimum inventory </b> </TD><TD>MINIMUM_INVENTORY units</TD></TR> <TR><TD><b>Inventory ordered </b> </TD><TD>TOTAL_INVENTORY_ORDERED units</TD></TR> <TR><TD><b>Number of orders </b> </TD><TD>TOTAL_NUMBER_OF_ORDERS </TD></TR> <TR><TD><b>Starting safety stock </b> </TD><TD>STARTING_SAFETY_STOCK units</TD></TR> <TR><TD><b>Ending safety stock </b> </TD><TD>ENDING_SAFETY_STOCK units</TD></TR> </TABLE></TD></TR></TABLE></CENTER> <P><CENTER><table border=0 bgcolor='#000000' width=95% cellspacing=1 cellpadding=0><tr><td width='100%'><table bgcolor='#FFFFFF' border=0 width=100% cellspacing=1 cellpadding=5> <TR BGCOLOR='#CCCCCC'><TD COLSPAN=2><CENTER><B>Input Summary</B></CENTER></TD></TR> <TR><TD><b>Starting inventory </b> </TD><TD>STARTING_INVENTORY </TD></TR> <TR><TD><b>Ending inventory </b> </TD><TD>ENDING_INVENTORY </TD></TR> <TR><TD><b>Initial demand per week </b> </TD><TD>CURRENT_DEMAND_PER_WEEK</TD></TR> <TR><TD><b>Annual growth rate </b> </TD><TD>EXPECTED_ANNUAL_GROWTH </TD></TR> <TR><TD><b>Order lead time in weeks </b> </TD><TD>ORDER_LEAD_TIME_IN_WEEKS </TD></TR> <TR><TD><b>Safety stock percent</b> </TD><TD>SAFETY_STOCK</TD></TR> </TABLE></TD></TR></TABLE></CENTER> <P><DIV class=large>Inventory balances for WEEKS_OF_ANALYSIS weeks</DIV> <HR SIZE=1> **REPEATING GROUP** <BR> <HR SIZE=1> <CENTER><P class=footer> Information and interactive calculators are made available to you as self-help tools for your independent use and are not intended to provide investment advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues. </P></CENTER><br><br> </BODY> </HTML> "> <H1><CENTER>This Financial Calculator requires SUN's Java"! Plug-in. If you see this message you will need to download SUN's Java"! Plug-in. This can be done automatically by clicking the yellow bar at the top of your browser and choosing  Install ActiveX Control . </CENTER></H1> <OL> You can also get SUN's Java"! Plug-in here: <A href="http://www.java.com/en/download/download_the_latest.jsp" target=_blank><b>Get the Java"! Plug-in!</b></A> <P>For more information about this Plug-in please visit: <A href="http://www.dinkytown.net/money/sunjvm.html" target=_blank><b>SUN's Java"! Plug-in</b></A> <BR>For more information these financial calculators please visit: <A href="http://www.dinkytown.net" target=_blank><b>Financial Calculators from KJE Computer Solutions, LLC</b></A> </OL><!--[if IE]></OBJECT><![endif]--><![if !IE]></APPLET><![endif]> </CENTER><CENTER><SCRIPT>document.write(showbuttons())</SCRIPT> </CENTER> <H1>Definitions</H1><P><TABLE align='center' WIDTH="95%"><TR><TD><DL><!--DEFN_START--> <DT><B>Initial demand per week</B><DD>Your initial expected demand per week.<P> <DT><B>Annual growth rate</B><DD>What you expect your annual sales growth to be over the next year.<P> <DT><B>Safety stock</B><DD>Expressed as a percent of your sales, this is the level of inventory you require as safety stock. This stock is used to protect against out of stock situations.<P> <DT><B>Order lead time in weeks</B><DD>How long it takes an order for more inventory to be received into inventory. This calculator assumes orders arrive in one batch with a known lead time, arriving just as stock is exhausted.<P> <DT><B>Starting inventory</B><DD>Amount of inventory you currently have on hand. <!--DEFN_END--></DL></TD></TR></TABLE> <BR> <HR SIZE=1> <CENTER> <P class=footer> Information and interactive calculators are made available to you as self-help tools for your independent use and are not intended to provide investment advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues. </P></CENTER> <BR> </BODY> </HTML>