Here's the detail that makes up the “Inventory Analysis Master Summary” report.


Inventory Analysis
Detail — by Dept. & Point-of-use loc.

Period: /1 - /15
Customer: Fleming Mfg.
Department: 37
Point-of-use-location: 07

  Packaged Reorder
Point
Reorder
Quantity
Times
Ordered
Purchases Inventory
Value
Purchase
Value
Inventory
Turns
SCR-00030
10-24 x 1/2 soc hd cap scr USA
100   200   200   1   200   $27.72   $18.48   0.7  
SCR-00038
3/8-16 x 2 1/4 soc hd cap scr USA
50   0   50   10   500   8.25   164.90   20.0  
SCR-00039
1/2-13 x 1 1/2 soc hd cap scr USA
50   200   200   3   600   149.73   299.46   2.0  
SCR-00048
5/16-18 X 3/4 FLAT HD SOC CAP USA
100   200   200   1   200   53.13   35.42   0.7  
SCR-00096
8-32 X 3/8 sl rnd hd m/s z
100   300   300   2   600   5.22   6.96   1.3  
SCR-000102
10-32 x 3/4 SL RND HD M/S Z
50   50   50   0   0   19.28   0   0.0  

Definitions:
Inventory value = Reorder point + 1/2 reorder quantity x cost
Inventory turns = Purchase value ÷ inventory value


Previous report
100% Employee Owned
Browse/Order 
fasteners fastener bolts screws rivet screw head dj screw machine screw nuts bolts industrial supply
Home Contact Get mailing
Quote Site map About us
...offering the industry's only $100 Service Guarantees