Transcript Inventory Count / Order Call

Inventory Count / Order Call-In
Spreadsheet
ORDER CALL-IN SPREADSHEET
DEPARTMENT NAME :
ASC
Master Sheet
ACCOUNTING UNIT:
LINE # SERVICE
Blanket PO
217
OPHTHOMOLOGY
380799
218
OPHTHOMOLOGY
380799
221
OPHTHOMOLOGY
380799
222
OPHTHOMOLOGY
223
OPHTHOMOLOGY
224
OPHTHOMOLOGY
225
OPHTHOMOLOGY
226
OPHTHOMOLOGY
227
OPHTHOMOLOGY
229
OPHTHOMOLOGY
230
OPHTHOMOLOGY
231
OPHTHOMOLOGY
232
OPHTHOMOLOGY
380713
233
OPHTHOMOLOGY
380713
234
OPHTHOMOLOGY
235
OPHTHOMOLOGY
380713
236
OPHTHOMOLOGY
237
OPHTHOMOLOGY
380176
238
OPHTHOMOLOGY
380176
239
OPHTHOMOLOGY
380176
240
OPHTHOMOLOGY
380171
241
OPHTHOMOLOGY
242
OPHTHOMOLOGY
INVENTORY
VENDOR
NUMBER
21706
29722
19907
41704
27937
29770
27938
27939
27940
38942
38941
38940
36854
36853
36801
36815
37338
29724
29725
30647
31258
24833.3
NAME
Alcon
Alcon
Alcon
Dutch Ophthalmics
AMO/ALLERGAN
AMO/ALLERGAN
AMO/ALLERGAN
AMO/ALLERGAN
AMO/ALLERGAN
AMO/ALLERGAN
AMO/ALLERGAN
AMO/ALLERGAN
Quest
Quest
Quest
Quest
Quest
O&M / BD / Visitec
O&M / BD / Visitec
O&M / BD / Visitec
Dermapac
Escalon Ophth.
Fisher Scientific
CAT #
8065-990002
611.74
681.05
vbl-10-s-usa
OPO-50
OPO-39
OPOR3020L
OPOCE3020
OPOS20L
OPOR3019L
SOV681199
SOV681198
dcp213-uni
dcp315-uni
dcp315-bi
dcr508-uni
dcp213-bi
585008
581280
585158
8804
TR9880-11
08-757-12
DESCRIPTION
Crescent knife
Iris Retractor
Grieshaber Ultrasharp
trypan blue solution
Sovereign disposable pack
Guilotine vitrectomy disposable
Laminar tip; straight 20GA/30 degree
Laminar tip; curved 20GA/30 degree
Laminar sleeve yellow; 20GA
Straight 19GA Laminar Tip
CATARACT EXTRACTION UNIT (INK)
CATARACT EXTRACTION UNIT (PAPER)
unilateral 2mm dcp procedure kit
unilateral 3mm dcp procedure kit
bilateral 3mm dcp procedure kit
Unitlateral 5mm Balloon DCR Procedure kit
bilateral 2mm dcp procedure kit
Cystotome / Irr / .40 X 16mm
Anterior Chamber Cannula, 27GA Angled
Cortical Cleaving Hydrodissector
Green baggies
DCR Probe
Petri 100 X 15mm, Standard
Min
Max
UOM
bx/6
bx/4
bx/6
bx/10
bx/6
ea
bx/6
bx/6
bx/6
Quantity
6
5
0
1
4
6
2
2
3
Quantity
10
10
1
2
8
10
4
4
6
EA
EA
ea
ea
ea
ea
ea
bx/10
bx/10
bx/10
ca
bx/5
cs/500
1
1
3
2
2
2
2
4
4
3
1
1
1
1
1
4
3
2
3
3
8
8
5
2
2
1
Day on Hand Worksheet
ASC Inventory Recording Worksheet
Inventory Date =
Days On Hand =
Weighted Days On Hand=
Total $ Value of Inventory On Hand =
Item
Location
3213840029982
3213840039665
3213840029720
3213840021706
3213840029722
32138400102767
32138400105772
3213840043961
3213840043141
3213840043142
3213840043143
3213840042964
3213840042965
3213840042407
3213840041668
3213840041669
3213840041670
Type
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
N
Description
KNIFE ENDO DISP 3310-B
PLATE DISTAL RADIUS RT STD
VALVE BAERVELDT BAG101-350
KNIFE CRESCENT
RETRACTOR IRIS
EXP TISS ANAT LOW HT 300CC
IMPLANT 650 CC
IMPLANT BREAST 325CC STYLE20
IMPLANT BREAST SIL 20 700CC
IMPLANT BREAST SIL 20 750CC
IMPLANT BREAST SIL 20 800CC
IMPLANT BREAST SILICONE 194CC
IMPLANT BREAST SILICONE 213CC
IMPLANT BREAST SILICONE 234CC
IMPLANT BREAST SILICONE 265CC
IMPLANT BREAST SILICONE 285CC
IMPLANT BREAST SILICONE 304CC
Vendor
A M SURGICAL INC
ACUMED
ADVANCED MEDICAL OPTICS INC
ALCON LABORATORY / SURICAL DIV
ALCON LABORATORY / SURICAL DIV
* ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
ALLERGAN
3/1/08
67.1
47.7
$159,982.90
Catalog #
3310-B
39665
BG101-350
8065990002
611.74
102767
105772
20-325
20-700
20-750
20-800
15-194
15-213
15-234
15-265
15-286
15-304
Annual
Received
Quantity
20.00
4.00
17.00
103.00
120.00
2.00
3.00
4.00
3.00
3.00
3.00
3.00
3.00
3.00
5.00
6.00
6.00
Most
Recent
Price
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Annual
Received
Cost
29,500.00
2,580.00
11,863.00
9,066.06
11,880.00
2,590.00
2,475.00
3,300.00
2,475.00
2,475.00
2,475.00
2,475.00
2,475.00
2,475.00
4,125.00
4,950.00
4,950.00
Daily
Inventory
Usage
Count
0.05
3
0.01
0
0.05
2
0.28
14
0.33
21
0.01
0
0.01
0
0.03
0
0.02
0
0.02
0
0.02
0
0.01
0
0.01
0
0.01
0
0.02
0
0.02
0
0.02
0
UOM
BX
EA
EA
BX
BX
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
Days
Cover
54.8
0.0
42.9
49.6
63.9
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
Weighted $ Value of
Days
Inventory
Cover
on Hand
8.38
$0.00
0.00
$0.00
2.64
$0.00
2.33
$0.00
3.94
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00
0.00
$0.00