Inventory Management Excel1 - Free Download | Page 6
4.1, 3333 votes
Please vote for this template if it helps you.
Inventory Management Excel1 Page 6
Inventory Management Excel1
D. Results, MSH/INFORM, Inventory Management Assessment Tool (D03699BEB07CECEE5ECDBF29CEE05073.xls), version 1
INDICATOR PURPOSE FORMULA RESULTS IDEAL RANGE
Record-keeping indicators: Use indicators 1 (including 1a and 1b) and 2 together to determine the accuracy of your record-keeping system.
I
INDICATOR 1
N
100% 0 to 100%
J
INDICATOR 1A
N
0%
0 to 100%
K
INDICATOR 1B
N
0%
0 to 100%
Total Column H
INDICATOR 2
Total Column F
0%
Stock level monitoring indicators: Use indicators 3 and 4 to determine your system's capacity to maintain a range of products in stock.
L
INDICATOR 3
N
100%
0 to 100%
Total Column D
INDICATOR 4
N x 100 days
0%
0 to 100%
If you are using the Excel version of the IMAT: The spreadsheet will automatically display your results based on the data you entered on the "Data Collection and Calculation" sheet. Print
this page out and look at it in conjunction with the "Graphs" and "Analysis" pages. If you are using the paper version of the IMAT: Use the formulas provided below to calculate your
indicator results and then study this page in conjunction with the "Graphs" and "Analysis" sheets.
x100
Indicates the proportion of records that under-
count physical counts.
x100
x100
D. RESULTS
INVENTORY MANAGEMENT ASSESSMENT TOOL (IMAT)
0 to total of
column F x100
Indicator 2: Ratio of inventory variation to
physical stock (expressed as a
percentage)
x100
Indicator 1: Percentage of stock records
that is accurate
x100
Indicator 4: Average percentage of time
that products are out of stock
Indicator 3: Percentage of products
available
Indicator 1a: Percentage of recorded
balances that is less than physical
counts
Indicator 1b: Percentage of recorded
balances that is greater than physical
counts
x100
Indicates the quality of the record-keeping
system by identifying the proportion of records
that is accurate.
Indicates the proportion of records that over-
count physical counts.
Indicates the severity of record-keeping errors.
Indicates the system's capacity to maintain a
constant supply of products over time by
minimizing the duration of stockouts.
Measures the system's effectiveness in
maintaining a full range of products in stock (at
the time of the assessment).
Inventory Management Excel1 Previous Page Inventory Management Excel1 Next Page
source: msh.org
Inventory Management Excel1
Previous

6/13

Next