Equipment Inventory

Equipment Inventory

Aspen Falls Firefighting Equipment Inventory

Eq ui

pm en

t S ta

tis tic

s Minimum Supply Level 3 Maximum Supply Level 190 Lowest Cost $11 Highest Cost $1,299 Total in Supply 1,988 Average Supply Level 34 Average Cost $185

Quantity in

Supply Item

Cost

Each Type Category

Supply

Level Check Supplier

146 Coil Headphones $30 Radio Communication Level OK Cost OK 190 Radio Strap/Holder $45 Radio Communication Level OK Cost OK

3 Retractable Mic Keeper $20 Radio Communication Order Cost OK 41 Leather Radio Holder $25 Radio Communication Level OK Cost OK 20 10″ Zipper Boots $320 Boots Footwear Level OK Check new supplier 21 Leather Fire Boots $340 Boots Footwear Level OK Check new supplier 26 Rubber Lug Boot $109 Boots Footwear Level OK Cost OK 27 Rubber Fire Boots $169 Boots Footwear Level OK Cost OK 28 Rubber Bunker Boots $129 Boots Footwear Level OK Cost OK 10 Hazmat Boot $149 Boots Footwear Level OK Cost OK 25 Fire Gloves $89 Gloves Outerwear Level OK Cost OK 27 Proximity Gear Gloves $124 Gloves Outerwear Level OK Cost OK

9 Extrication Gloves $77 Gloves Extrication Gear Order Cost OK 34 Rescue Glove Liners $39 Gloves Outerwear Level OK Cost OK 17 Extrication Coat $223 Coat Extrication Gear Level OK Cost OK 14 Extrication Pants $189 Pants Extrication Gear Level OK Cost OK 11 Extrication Coveralls $359 Coveralls Extrication Gear Level OK Check new supplier

9 Gas Mask $259 Safety Safety Equipment Order Cost OK 9 Gas Mask Pouch $35 Safety Safety Equipment Order Cost OK

13 Respirator $369 Safety Safety Equipment Level OK Check new supplier 19 Coverall with Hood $159 Coveralls Outerwear Level OK Cost OK 45 Disaster Safe Bag $13 Safety Safety Equipment Level OK Cost OK 10 Chemical Overboot $52 Boots Footwear Level OK Cost OK 10 Haz-Mat Boots $89 Boots Footwear Level OK Cost OK 57 Disaster Kit $99 Safety Safety Equipment Level OK Cost OK 10 Helmet $229 Helmet Outerwear Level OK Cost OK 51 Structural Fire Helmet $179 Helmet Outerwear Level OK Cost OK 25 Helmet with Eye Shield $339 Shield Safety Equipment Level OK Check new supplier

8 Megaphone $79 Megaphone Communication Order Cost OK 53 Barrier Tape $12 Tape Traffic Level OK Cost OK 18 Fire Pants $649 Pants Outerwear Level OK Check new supplier 19 Fire Coat $989 Coat Outerwear Level OK Check new supplier 25 Proximity Coat $1,299 Coat Outerwear Level OK Check new supplier 17 Proximity Pants $1,059 Pants Outerwear Level OK Check new supplier 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK 87 Rope Gloves $32 Gloves Outerwear Level OK Cost OK 28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK 35 EMS Jacket $399 Coat Outerwear Level OK Check new supplier 47 EMS Pants $289 Pants Outerwear Level OK Cost OK 89 Breakaway Vest $29 Vest Outerwear Level OK Cost OK 15 Mesh Vest $17 Vest Outerwear Level OK Cost OK 25 Mesh Traffic Vest $29 Vest Outerwear Level OK Cost OK 89 Reflective Nylon Vest $11 Vest Outerwear Level OK Cost OK 16 Handheld Remote Siren $289 Siren Traffic Level OK Cost OK 19 Siren $189 Siren Traffic Level OK Cost OK 27 Traffic Baton $19 Baton Traffic Level OK Cost OK 37 Flare Beacon Kit $305 Light Traffic Level OK Check new supplier 90 Flares with Stands $99 Light Traffic Level OK Cost OK 26 Traffic Flashlight $18 Light Traffic Level OK Cost OK 56 Night Barrier Tape $15 Tape Traffic Level OK Cost OK 17 Water Rescue Kit $119 Safety Water Rescue Level OK Cost OK

Eq ui

pm en

t S ta

tis tic

s

Lastname_Firstname_e04_Fire_Equipment.xlsx Equipment

Page 1 of 7 e04_Fire_Equipment_ann_solution.pdf

Skills for Success
Text Box
In the student’s electronic file, check for the following item(s): 1. Insert SUM and AVERAGE functions 2. Insert MAX and MIN functions 3. Insert IF function in columns F and G 4. Freeze rows 1 through 11 5. Create Excel table and add Total row 6. Convert Excel table to a range 7. Format large worksheets to print
Skills for Success
Text Box
Merge B3:D9 and change orientation
Skills for Success
Line
Skills for Success
Text Box
Apply custom formats and data bars
Skills for Success
Line
Skills for Success
Text Box

The post Equipment Inventory appeared first on best homeworkhelp.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"