SC_EX365_2021_2a__2
xlsx
keyboard_arrow_up
School
Johnson County Community College *
*We aren’t endorsed by this school
Course
CIS-201
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
5
Uploaded by Brook1234321
Author:
Note:
Shelly C
Roadrunner Online
FORMAT WORKSHEETS
Nicole Fullerton
Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the
website.
Cashman Excel 365/2021 | Module 2: SAM Project 1a
M
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
Warehouse Bins
Bin List
Bin #
Location
Size
B107
Row 2, slot 4
Large
B108
Row 2, slot 2
Medium
B109
Row 2, slot 3
Small
B110
Row 2, slot 1
Small
B201
Row 1, slot 2
Medium
B208
Row 1, slot 5
Large
B209
Row 2, slot 5
Large
B227
Row 3, slot 3
Medium
B300
Row 3, slot 4
Small
B305
Row 3, slot 2
Large
B310
Row 3, slot 1
Large
Last Updated
5/4/2024
Warehouse Inventory
Inventory Value:
Inventory Items:
$
3,594.00
11
SKU
Description
Bin #
Location
Quantity
Cost
Inventory Value
Reorder
RF2465
Air filter
B305
Row 3, slot 2
30
15
$
7.00
210
0
OF1288
Oil filter
B310
Row 3, slot 1
24
15 $
12.00
288
0
WB6541
Wiper blades
B201
Row 1, slot 2
10
8 $
15.00
150
0
BF2270
Brake fluid
B108
Row 2, slot 2
5
8 $
16.00
80
Reorder
BP1538
Brake pad
B107
Row 2, slot 4
20
10 $
40.00
800
0
BC4529
Brake caliper
B109
Row 2, slot 3
15
10
$
8.00
120
0
SP2442
Spark plug
B227
Row 3, slot 3
30
20 $
10.00
300
0
IC1045
Ignition coil
B110
Row 2, slot 1
5
5 $
40.00
200
Reorder
SB3002
Stabilizer bar
B209
Row 1, slot 5
10
5 $
30.00
300
0
HL6209
Headlight
B208
Row 2, slot 5
30
15 $
35.00
1050
0
RC1577
Radiator cap
B300
Row 3, slot 4
12
10
$
8.00
96
0
Average Cost:
$
20.09
Minimum Cost:
$
7.00
Maximum Cost:
$
40.00
Reorder
Quantity