Inventory Analysis

This workbook may be used to analyze inventory balances utilizing a variety of inventory ratios.  On the Input worksheet, enter figures for sales, cost of sales, finished goods, work in process, and raw materials in the appropriate columns by year.  Cost of sales amounts should be entered as a positive number.  The Analysis worksheet automatically calculates various inventory ratios based on the figures entered on the Input worksheet.  Input amounts may be automatically cleared or rolled forward to the next year by clicking on the appropriate button on the Input worksheet.