Inventory Management Excel1 - Free Download | Page 5
4.1, 3333 votes
Please vote for this template if it helps you.
Inventory Management Excel1 Page 5
Inventory Management Excel1
C. Collection&Calculation, MSH/INFORM, Inventory Management Assessment Tool (D03699BEB07CECEE5ECDBF29CEE05073.xls)], version 1
TODAY'S DATE ______________________________
A B C D E F G H
#
Name of product Unit
# DAYS out of stock within
the last 100 days. Starting
date / /
Last stock balance
recorded on stock
cards. Do not correct
errors!
Physical quantity
(based on actual
count)
Difference between
recorded and physical
values (E-F)
Absolute value of G |G|
(remove minus signs
from results in column G)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
N= Totals:
Total number of products in the study
I Count of records that are accurate (number of zeros in column G)
J Count of records less than physical counts (numb. of negative results in column G)
K Count of records greater than physical counts (numb. positive results in column G)
The maximum for L is N, the number of products in the study.
L Total products in stock (total number of
products present (not zero) in column F)
INVENTORY MANAGEMENT ASSESSMENT TOOL (IMAT)
C. DATA COLLECTION AND CALCULATION SHEET
ORGANIZATION ______________________________
Inventory Management Excel1 Previous Page Inventory Management Excel1 Next Page
source: msh.org
Inventory Management Excel1
Previous

5/13

Next