Microsoft Office Assignments

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

Quantity in

Supply Item

Cost

Each Type Category

Supply

Level Check Supplier

38 Water Rescue Vest $99 Safety Water Rescue Level OK Cost OK 4 Water Tether System $59 Safety Water Rescue Order Cost OK

18 Wildfire Helmet $59 Helmet Outerwear Level OK Cost OK 17 Full-Brim Helmet $59 Helmet Outerwear Level OK Cost OK 58 Firefighting Goggles $49 Helmet Safety Equipment Level OK Cost OK 31 Water Throw Bag $59 Safety Water Rescue Level OK Cost OK 32 Dry Bag $18 Safety Water Rescue Level OK Cost OK

Edited by: Your Name

11/1/2012 12:23

Lastname_Firstname_e04_Fire_Equipment.xlsx Equipment

Page 2 of 7 e04_Fire_Equipment_ann_solution.pdf

Date Quantity

Purchased Cost Each

Total Monthly

Cost January 1, 2010 20 $16.00 $320.00 February 1, 2010 20 $15.50 $310.00 March 1, 2010 10 $16.00 $160.00 April 1, 2010 20 $15.25 $305.00 May 1, 2010 15 $16.00 $240.00 June 1, 2010 15 $16.25 $243.75 July 1, 2010 10 $16.25 $162.50 August 1, 2010 10 $16.50 $165.00 September 1, 2010 10 $17.00 $170.00 October 1, 2010 20 $16.25 $325.00 November 1, 2010 10 $17.00 $170.00 December 1, 2010 10 $17.50 $175.00 Total $2,746.25 Average Cost $228.85 Minimum Cost $160.00 Maximum Cost $325.00

Cost Trend

Aspen Falls

Cost of Mesh Vests

Lastname_Firstname_e04_Fire_Equipment.xlsx Vest

Page 3 of 7 e04_Fire_Equipment_ann_solution.pdf

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 Type Category Supply Level Total

Cost 25 Proximity Coat Coat Outerwear Level OK $32,475 19 Fire Coat Coat Outerwear Level OK $18,791 17 Proximity Pants Pants Outerwear Level OK $18,003 35 EMS Jacket Coat Outerwear Level OK $13,965 47 EMS Pants Pants Outerwear Level OK $13,583 18 Fire Pants Pants Outerwear Level OK $11,682 37 Flare Beacon Kit Light Traffic Level OK $11,285 51 Structural Fire Helmet Helmet Outerwear Level OK $9,129 90 Flares with Stands Light Traffic Level OK $8,910

190 Radio Strap/Holder Radio Communication Level OK $8,548 25 Helmet with Eye Shield Shield Safety Equipment Level OK $8,475 21 Leather Fire Boots Boots Footwear Level OK $7,140 20 10″ Zipper Boots Boots Footwear Level OK $6,400 57 Disaster Kit Safety Safety Equipment Level OK $5,643 28 Safety Harness Safety Safety Equipment Level OK $5,572 13 Respirator Safety Safety Equipment Level OK $4,797 16 Handheld Remote Siren Siren Traffic Level OK $4,624 27 Rubber Fire Boots Boots Footwear Level OK $4,563

146 Coil Headphones Radio Communication Level OK $4,378.54 11 Extrication Coveralls Coveralls Extrication Gear Level OK $3,949 17 Extrication Coat Coat Extrication Gear Level OK $3,791 38 Water Rescue Vest Safety Water Rescue Level OK $3,762 28 Rubber Bunker Boots Boots Footwear Level OK $3,612 19 Siren Siren Traffic Level OK $3,591 27 Proximity Gear Gloves Gloves Outerwear Level OK $3,348 19 Coverall with Hood Coveralls Outerwear Level OK $3,021 29 Chest Harness Safety Safety Equipment Level OK $2,871 58 Firefighting Goggles Helmet Safety Equipment Level OK $2,842

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Sort by Cost

Page 4 of 7 e04_Fire_Equipment_ann_solution.pdf

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 Total

Cost

9 Gas Mask $259 Safety Safety Equipment Order Cost OK $2,331 9 Gas Mask Pouch $35 Safety Safety Equipment Order Cost OK $315

57 Disaster Kit $99 Safety Safety Equipment Level OK Cost OK $5,643 28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK $5,572 13 Respirator $369 Safety Safety Equipment Level OK Check new supplier $4,797 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK $2,871 45 Disaster Safe Bag $13 Safety Safety Equipment Level OK Cost OK $585 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK $385

Total $139 $22,499

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Supply Level

Page 5 of 7 e04_Fire_Equipment_ann_solution.pdf

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 Total

Cost

28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK $5,572 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK $2,871 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK $385

Total 3

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Harness

Page 6 of 7 e04_Fire_Equipment_ann_solution.pdf

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 Total

Cost

9 Gas Mask $259 Safety Safety Equipment Order Cost OK $2,331 9 Extrication Gloves $77 Gloves Extrication Gear Order Cost OK $693 8 Megaphone $79 Megaphone Communication Order Cost OK $632 9 Gas Mask Pouch $35 Safety Safety Equipment Order Cost OK $315 4 Water Tether System $59 Safety Water Rescue Order Cost OK $236 3 Retractable Mic Keeper $20 Radio Communication Order Cost OK $60

25 Proximity Coat $1,299 Coat Outerwear Level OK Check new supplier $32,475 19 Fire Coat $989 Coat Outerwear Level OK Check new supplier $18,791 17 Proximity Pants $1,059 Pants Outerwear Level OK Check new supplier $18,003 35 EMS Jacket $399 Coat Outerwear Level OK Check new supplier $13,965 47 EMS Pants $289 Pants Outerwear Level OK Cost OK $13,583 18 Fire Pants $649 Pants Outerwear Level OK Check new supplier $11,682 37 Flare Beacon Kit $305 Light Traffic Level OK Check new supplier $11,285 51 Structural Fire Helmet $179 Helmet Outerwear Level OK Cost OK $9,129 90 Flares with Stands $99 Light Traffic Level OK Cost OK $8,910

190 Radio Strap/Holder $45 Radio Communication Level OK Cost OK $8,548 25 Helmet with Eye Shield $339 Shield Safety Equipment Level OK Check new supplier $8,475 21 Leather Fire Boots $340 Boots Footwear Level OK Check new supplier $7,140 20 10″ Zipper Boots $320 Boots Footwear Level OK Check new supplier $6,400 57 Disaster Kit $99 Safety Safety Equipment Level OK Cost OK $5,643 28 Safety Harness $199 Safety Safety Equipment Level OK Cost OK $5,572 13 Respirator $369 Safety Safety Equipment Level OK Check new supplier $4,797 16 Handheld Remote Siren $289 Siren Traffic Level OK Cost OK $4,624 27 Rubber Fire Boots $169 Boots Footwear Level OK Cost OK $4,563

146 Coil Headphones $30 Radio Communication Level OK Cost OK $4,378.54 11 Extrication Coveralls $359 Coveralls Extrication Gear Level OK Check new supplier $3,949 17 Extrication Coat $223 Coat Extrication Gear Level OK Cost OK $3,791 38 Water Rescue Vest $99 Safety Water Rescue Level OK Cost OK $3,762 28 Rubber Bunker Boots $129 Boots Footwear Level OK Cost OK $3,612 19 Siren $189 Siren Traffic Level OK Cost OK $3,591 27 Proximity Gear Gloves $124 Gloves Outerwear Level OK Cost OK $3,348 19 Coverall with Hood $159 Coveralls Outerwear Level OK Cost OK $3,021 29 Chest Harness $99 Safety Safety Equipment Level OK Cost OK $2,871 58 Firefighting Goggles $49 Helmet Safety Equipment Level OK Cost OK $2,842 26 Rubber Lug Boot $109 Boots Footwear Level OK Cost OK $2,834 87 Rope Gloves $32 Gloves Outerwear Level OK Cost OK $2,784 14 Extrication Pants $189 Pants Extrication Gear Level OK Cost OK $2,646 89 Breakaway Vest $29 Vest Outerwear Level OK Cost OK $2,581 10 Helmet $229 Helmet Outerwear Level OK Cost OK $2,290 25 Fire Gloves $89 Gloves Outerwear Level OK Cost OK $2,225 17 Water Rescue Kit $119 Safety Water Rescue Level OK Cost OK $2,023 31 Water Throw Bag $59 Safety Water Rescue Level OK Cost OK $1,829 10 Hazmat Boot $149 Boots Footwear Level OK Cost OK $1,490 34 Rescue Glove Liners $39 Gloves Outerwear Level OK Cost OK $1,326 18 Wildfire Helmet $59 Helmet Outerwear Level OK Cost OK $1,062 41 Leather Radio Holder $25 Radio Communication Level OK Cost OK $1,025 17 Full-Brim Helmet $59 Helmet Outerwear Level OK Cost OK $1,003 89 Reflective Nylon Vest $11 Vest Outerwear Level OK Cost OK $979 10 Haz-Mat Boots $89 Boots Footwear Level OK Cost OK $890 56 Night Barrier Tape $15 Tape Traffic Level OK Cost OK $840 25 Mesh Traffic Vest $29 Vest Outerwear Level OK Cost OK $725 53 Barrier Tape $12 Tape Traffic Level OK Cost OK $636 45 Disaster Safe Bag $13 Safety Safety Equipment Level OK Cost OK $585 32 Dry Bag $18 Safety Water Rescue Level OK Cost OK $576 10 Chemical Overboot $52 Boots Footwear Level OK Cost OK $520 27 Traffic Baton $19 Baton Traffic Level OK Cost OK $513 26 Traffic Flashlight $18 Light Traffic Level OK Cost OK $468 11 Radio Chest Harness $35 Safety Safety Equipment Level OK Cost OK $385 15 Mesh Vest $17 Vest Outerwear Level OK Cost OK $255

Total 59

Edited by: Your Name

11/1/2012 12:23

Aspen Falls Firefighting Equipment Inventory

E qu

ip m

en t S

ta tis

tic s

Lastname_Firstname_e04_Fire_Equipment.xlsx Inventory

Page 7 of 7 e04_Fire_Equipment_ann_solution.pdf