NP_EX_6-4_Seacation
.xlsx
keyboard_arrow_up
School
Portland Community College *
*We aren’t endorsed by this school
Course
216A
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
30
Uploaded by DoctorWaterBuffaloPerson4021
Seacation
Author
Valentino Christianto
Date
11/6/2023
Purpose
To track inventory at the Seacation warehouse and determining restocking numbers, costs, and days
Seacation
Inventory Summary
INVENTORY VA
Items
Quantity in Stock
Inventory Value
Items to Restock
Items That Don't Need Restocking
Restocking Cost
This shape represents a table slicer. Table slicers are not supported in this version of Excel.
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2007 or earlier, the slicer can't be used.
This shape represents a table slicer. Table slicers are not supported in this version of Excel.
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2007 or earlier, the slicer can't be used.
5.12
94.88%
Items to Restock
Items Tha
ALUES
21
410 $198,166.57
21
389 $18,503.53
2%
%
at Don't Need Restocking
Seacation
Items to Restock
Part ID
Description
Warehouse
Bin
Unit Cost
Stock Qty
EL-208-24-1
Cartridge fuses 3A large
Row 1
1
$31.45
190
EL-220-36-1
Fuse, Automotive, 5 amp
Row 1
1
$55.86
170
EL-237-49-1
Cartridge fuses 15A AGC (Large)
Row 1
1
$36.61
230
EL-291-77-1
Deck Bulbs 24-pack
Row 1
1
$59.11
119
EL-321-75-1
Blower switch
Row 1
1
$35.41
290
EL-372-45-1
Solenoid, relief
Row 1
1
$44.56
230
EL-399-34-1
Cartridge fuses 2A large
Row 1
1
$40.95
138
EL-981-86-1
Flashlight bulbs kit
Row 1
1
$31.02
200
EL-994-32-1
Spark plug
Row 1
1
$56.42
230
RE-257-55-4
Snap Shackle, Plastic Lewmar
Row 1
1
$48.13
274
RE-332-47-4
Raw Water Service Kit
Row 1
1
$42.90
196
RE-538-57-4
Fast Cure 5200
Row 1
1
$22.75
216
RE-629-46-4
Crewfit rearm kits
Row 1
1
$45.51
260
EL-198-80-1
Shore power adaptor--European
Row 1
2
$42.94
221
EL-788-32-1
Fuses 800 amp
Row 1
2
$45.56
200
RE-344-50-4
Tef Gel lg
Row 1
2
$36.26
191
RE-363-49-4
Safety glasses
Row 1
2
$39.80
130
RE-605-90-4
Adhesive strips
Row 1
2
$38.26
123
EL-108-47-1
Sensors and circuit boards--misc
Row 1
3
$47.53
188
EL-277-33-1
Cartridge fuses 1D large
Row 1
3
$46.90
160
EL-286-94-1
Cartridge fuses 3A medium
Row 1
3
$56.92
130
EL-438-82-1
Cartridge fuses 1A AGC (Large)
Row 1
3
$44.95
197
EL-478-13-1
Deck Bulbs 8-pack
Row 1
3
$56.09
260
EL-595-25-1
Starter, 12V, S115 (P2873155)
Row 1
3
$53.15
260
EL-686-56-1
Cartridge fuses 4A small
Row 1
3
$50.81
230
EL-701-19-1
Fuses 600 amp
Row 1
3
$54.20
116
EL-974-26-1
Cartridge fuses 2A medium
Row 1
3
$49.34
215
EL-991-61-1
Switch Kit, Model 4900
Row 1
3
$63.77
290
RE-600-77-4
Diaphram for crank case breather
Row 1
3
$39.35
206
RE-851-76-4
Lifecaulk
Row 1
3
$38.80
223
EL-192-83-1
Alternator, Spare, new style
Row 1
4
$45.61
130
EL-580-11-1
Switch, High Temperature, 96 deg
Row 1
4
$56.18
153
EL-680-50-1
Cartridge fuses 3A small
Row 1
4
$65.75
330
EL-726-15-1
8 conductor wire
Row 1
4
$33.18
193
EL-886-39-1
Oven ignition activation switch
Row 1
4
$68.08
200
EL-926-81-1
Cartridge fuses 2A small
Row 1
4
$50.10
200
RE-137-24-4
Cutting oil
Row 1
4
$9.16
115
RE-207-70-4
Valve Replacement Kit 4900
Row 1
4
$22.11
229
RE-257-82-4
Gaskets Kit
Row 1
4
$43.98
248
RE-365-64-4
Easyouts set
Row 1
4
$42.46
160
RE-470-77-4
Insulating tape 10
Row 1
4
$40.86
230
RE-879-97-4
Staylock Formers--5/16"
Row 1
4
$25.96
330
EL-141-70-1
Vibration isolator
Row 1
5
$32.81
160
EL-162-42-1
Gas propane spare sensor
Row 1
5
$45.40
260
EL-328-87-1
Rebuilt Lavac Head Pump Row 1
5
$36.66
223
EL-336-72-1
Cartridge fuses 9A small
Row 1
5
$46.14
290
EL-353-56-1
Navigation light bulb 25W
Row 1
5
$38.55
200
EL-541-94-1
Fuseholders
Row 1
5
$42.13
138
RE-110-13-4
Motor kit
Row 1
5
$37.90
260
RE-296-33-4
Loctite--blue
Row 1
5
$28.49
130
RE-297-82-4
Wooden plugs (cones)
Row 1
5
$38.44
230
RE-490-12-4
Epoxy putty quickset
Row 1
5
$41.50
107
RE-514-72-4
Wireties--misc
Row 1
5
$34.11
126
EL-104-37-1
Shore power female plug
Row 1
6
$42.71
290
EL-114-99-1
Relay, 12V-70A
Row 1
6
$37.26
248
EL-367-28-1
Breaker Single 25 Amp
Row 1
6
$46.13
200
EL-374-35-1
Trouble light
Row 1
6
$34.01
230
EL-641-88-1
Cartridge fuses 10A GMA (Small)
Row 1
6
$33.90
177
EL-867-85-1
Breaker Double 40 Amp
Row 1
6
$40.97
290
EL-911-16-1
Cartridge fuses blue ceramic
Row 1
6
$56.24
160
EL-915-45-1
Thermostat
Row 1
6
$63.49
260
EL-930-92-1
Shore power male plug
Row 1
6
$20.38
230
RE-485-79-4
Duct tape
Row 1
6
$40.56
200
RE-709-30-4
Spurs bearing kit
Row 1
6
$37.27
290
RE-995-29-4
Fast Cure 5200
Row 1
6
$45.77
160
EL-102-42-1
Flashlights
Row 1
7
$20.00
167
EL-103-67-1
Cartridge fuses 1A small
Row 1
7
$59.86
290
EL-151-94-1
Cartridge fuses 3.15A small
Row 1
7
$48.07
119
EL-479-56-1
Solenoid Propane
Row 1
7
$40.27
230
EL-615-36-1
Deck Bulbs 12-pack
Row 1
7
$33.23
160
EL-633-65-1
Cartridge fuses 7A large
Row 1
7
$44.29
290
EL-636-67-1
Cartridge fuses 20A large
Row 1
7
$49.23
260
EL-786-18-1
Solenoid, insulated 12V
Row 1
7
$53.31
330
EL-844-10-1
Breaker Single 10 Amp
Row 1
7
$50.02
230
EL-871-16-1
Cartridge fuses 3A small
Row 1
7
$49.70
240
EL-935-27-1
Fuse, Automotive, 50 amp
Row 1
7
$47.89
149
EL-997-87-1
Hart interface 300 amp fuse
Row 1
7
$54.43
289
RE-203-70-4
Refigeration oil
Row 1
7
$35.26
206
RE-407-24-4
Staylock wedges--5/16", 7X19
Row 1
7
$37.53
130
RE-810-78-4
Masking tape, narrow
Row 1
7
$40.26
160
RE-831-74-4
Wood glue
Row 1
7
$44.84
230
RE-898-62-4
Sticky back--misc
Row 1
7
$15.93
260
RE-929-52-4
Leak Test Kit
Row 1
7
$39.41
230
EL-115-23-1
Breaker Double 20 Amp
Row 1
8
$17.43
83
EL-376-40-1
Cabin Bulbs 8-pack
Row 1
8
$46.04
175
EL-601-29-1
Stop Solenoid, Assembly
Row 1
8
$43.23
200
EL-647-27-1
Cartridge fuses 1D medium
Row 1
8
$38.71
160
EL-692-41-1
Relay, Start/-Ve Earth, 12V
Row 1
8
$47.81
290
EL-761-26-1
Cartridge fuses 30A med
Row 1
8
$29.46
290
EL-891-87-1
Cartridge fuses 40A huge
Row 1
8
$32.90
290
EL-989-38-1
Bulb LED Aircraft Lights
Row 1
8
$47.34
200
RE-190-70-4
Spray nozzle
Row 1
8
$36.78
230
RE-381-33-4
Cooler, Gearbox Oil
Row 1
8
$38.81
279
RE-393-17-4
Aluminum epoxystick
Row 1
8
$23.10
230
RE-774-18-4
Insulating tape 20
Row 1
8
$35.85
278
RE-883-96-4
Sail patching kit
Row 1
8
$41.45
290
EL-186-79-1
Water Temperature Sensor
Row 1
9
$37.77
171
EL-191-89-1
Alternator voltage regulator
Row 1
9
$55.44
230
EL-200-45-1
Spare Spreader Light Bulbs 12v
Row 1
9
$58.49
160
EL-318-75-1
Sender/Switch
Row 1
9
$39.59
230
EL-324-50-1
Cartridge fuses 10A large
Row 1
9
$37.49
262
EL-393-19-1
VHF antenna
Row 1
9
$45.91
157
EL-491-58-1
Hand pump--hydraulics only
Row 1
9
$50.26
230
EL-583-53-1
Halogen light bulbs 10W
Row 1
9
$44.43
251
EL-676-15-1
Alternator 175 amp fuses
Row 1
9
$47.54
290
EL-687-80-1
Cartridge fuses 40A large
Row 1
9
$39.49
108
EL-770-44-1
Thermocouple solenoid
Row 1
9
$38.08
245
EL-808-86-1
Breaker Double 30 Amp
Row 1
9
$64.20
84
EL-858-79-1
Cartridge fuses 25A AGC (Large)
Row 1
9
$48.38
330
EL-905-88-1
Multimeter
Row 1
9
$55.07
184
EL-949-39-1
Battery cable--heavy black
Row 1
9
$59.54
188
RE-309-59-4
Loctite--red
Row 1
9
$45.63
290
RE-509-31-4
Vang seal kit
Row 1
9
$28.60
160
RE-610-80-4
Mustang Survival Rearm Kits
Row 1
9
$38.91
224
RE-685-72-4
Glacier Bay first aid kit
Row 1
9
$28.62
260
RE-737-27-4
Emergency hull repair kit
Row 1
9
$35.30
230
RE-884-66-4
Shower rebuild kit
Row 1
9
$34.96
246
EL-115-31-1
Cartridge fuses 20A huge
Row 1
10
$67.85
250
EL-119-63-1
Shore power inlet
Row 1
10
$57.08
165
EL-161-56-1
Cabin Bulbs 12-pack
Row 1
10
$49.39
200
EL-240-47-1
Inverter, Voltage, 12V to 24V
Row 1
10
$48.98
230
EL-258-39-1
Batteries, special lithium
Row 1
10
$23.91
290
EL-412-58-1
Alternator 225 amp fuses
Row 1
10
$58.55
186
EL-533-68-1
Cartridge fuses 3A large
Row 1
10
$40.45
99
EL-574-58-1
Breaker Single 5 Amp
Row 1
10
$60.61
198
EL-607-75-1
Cabin Bulbs 24-pack
Row 1
10
$67.60
130
EL-621-10-1
Cartridge fuses 5A large
Row 1
10
$55.31
227
EL-660-30-1
Cartridge fuses 8A large
Row 1
10
$48.72
223
EL-746-77-1
Navigation light bulb 10W
Row 1
10
$41.85
113
EL-750-88-1
Alternator, spare, old style
Row 1
10
$28.33
226
EL-755-86-1
Cartridge fuses 1D small
Row 1
10
$33.87
90
RE-139-64-4
Silicone--clear
Row 1
10
$20.62
130
RE-249-17-4
Wood kit
Row 1
10
$26.14
186
RE-478-68-4
Life-Seal White
Row 1
10
$34.20
160
RE-764-74-4
Shaft seal O-ring kit
Row 1
10
$42.56
209
EL-296-73-1
Heater fault control box
Row 1
11
$23.26
260
EL-381-74-1
Breaker Double 10 Amp
Row 1
11
$32.29
176
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help