microsoft office assignments

profilewshna1
e04_fire_equipment_ann_solution.pdf

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
Find and replace words
Skills for Success
Line

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

Skills for Success
Text Box
Insert SUM and AVERAGE functions
Skills for Success
Line
Skills for Success
Text Box
Create Sparkline in B22
Skills for Success
Line
Skills for Success
Line
Skills for Success
Text Box
Insert MAX and MIN functions

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

Skills for Success
Line
Skills for Success
Text Box
Create worksheet copies

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

Skills for Success
Text Box
Filter Excel table
Skills for Success
Line
Skills for Success
Text Box
Create Excel table and add Total row
Skills for Success
Line

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

Skills for Success
Line
Skills for Success
Text Box
Filter Excel table

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

Skills for Success
Text Box
Convert Excel table to a range
Skills for Success
Line