Equipment Inventory

Equipment Inventory

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
The post Equipment Inventory

CLICK HERE TO ORDER NOW!!

 

Leave a Reply

Your email address will not be published. Required fields are marked *