Bicycles Inventory Data given above. Create a worksheet that contains (1) Histogram of supplier name

Bicycles Inventory Data given above. Create a worksheet that contains
(1) Histogram of supplier names,

(2) Mean,

(3) Median, and

(4) Standard deviation of the cost per sales order.

Write your observations on (5) most frequently used and least frequently used supplier names.

(6) Write how much percentage of cost per sales orders are covered within 1 standard deviation, 2 standard deviations, 3 standard deviations of the mean.

All calculations involved in the worksheet preparation must be completed using appropriate formulae. E Item Cost Quantity А C D F Item Description Supplier Hulkey Fasteners Alum Sheeting 3 Airframe fasteners $ 4.25 19,500 4 $4.25 Airframe fasteners 10,000 Shielded Cable/ft. $ Fast-Tie Aerospace 6 1.05 23,000 Shielded Cable/ft. Shielded Cable/ft. $ Fast-Tie Aerospace 1.05 7 21,500 Steelpin Inc. 8 1.10 17,500 Shielded Cable/ft. $1.05 Fast-Tie Aerospace 22,500 9 $3.75 Bolt-nut package Steelpin Inc. 10 4,250 Durrable Products Pressure Gauge 11 90.00 100 Fast-Tie Aerospace O-Ring Shielded Cable/ft. Shielded Cable/ft. $ 2.45 1,300 12 $ 1.05 $ 1.10 Electrical Connector $1.25 Fast-Tie Aerospace 13 22,500 Steelpin Inc. 14 18,100 Hulkey Fasteners 15 5,600 Hulkey Fasteners Steelpin Inc. Hatch Decal 16 0.75 500 Electrical Connector $ 1.65 17 4,500 Bolt-nut package $ 3.75 $ Steelpin Inc. 4,200 18 Alum Sheeting $255.00 19 Control Panel 406 Electrical Connector $ Hulkey Fasteners 5,500 20 1.25 Electrical Connector $ Steelpin Inc. 21 1.65 4,850 Bolt-nut package $3.75 Steelpin Inc. 4,150 22 Hulkey Fasteners Spacetime Technologies Alum Sheeting Airframe fasteners $ 4.25 15,500 23 $ 3.55 $ 4.25 $ 90.00 Bolt-nut package $ 4,800 24 Airframe fasteners $ 9,000 25 Durrable Products Pressure Gauge 26 120 Electrical Connector $ Steelpin Inc. 27 1.65 4,750 Hulkey Fasteners Airframe fasteners $ 4.25 12,500 28 Shielded Cable/ft. $ 0.95 Electrical Connector $ 1.25 Hulkey Fasteners Hulkey Fasteners Hulkey Fasteners Spacetime Technologies $ 29 25,000 30 5,650 Airframe fasteners $ 4.25 15,000 31 $ 3.55 Bolt-nut package Electrical Connector $ $ 4,585 32 Hulkey Fasteners 5,425 33 1.25 Fast-Tie Aerospace O-Ring Shielded Cable/ft. $ 2.45 1,200 34 $ Steelpin Inc. 35 1.10 16,500 $ 3.55 Spacetime Technologies Bolt-nut package Shielded Cable/ft. $ 4,200 36 $ Hulkey Fasteners 17,500 37 0.95 Spacetime Technologies Gasket Spacetime Technologies Bolt-nut package 38 4.05 1,500 4,250 $ 3.55 39 $3.75 Pylon Accessories Gasket 40 1,980 $ Pylon Accessories Gasket 1,750 41 3.75 Spacetime Technologies Gasket Spacetime Technologies Bolt-nut package 42 4.05 1,550 3.55 4,200 $ 43 $ $ 4.20 Durrable Products Airframe fasteners 44 15,000 O-Ring $ 45 Manley Valve 2.85 1,300 O-Ring Fast-Tie Aerospace $ 2.45 2,500 46 $3.75 47 Pylon Accessories Gasket 1,850 $ 48 Durrable Products Airframe fasteners 4.20 14,000 Hulkey Fasteners Airframe fasteners $ 4.25 14,500 49 $ 50 Pylon Accessories Gasket 3.75 1,800 $ $ 4.20 $ Durrable Products Airframe fasteners 51 10,000 Spacetime Technologies Shielded Cable/ft. 52 15,000 1,250 1.15 3.65 Durrable Products Gasket $ 53 O-Ring $ Manley Valve 1,350 54 2.85 $ 2.95 Pylon Accessories O-Ring 1,500 55 Electrical Connector Fast-Tie Aerospace 5,650 56 1.25 Airframe fasteners Hulkey Fasteners $ 4.25 18,000 57 $ 3.65 Gasket 1,450 Durrable Products 58 $3.00 $ 3.65 Spacetime Technologies O-Ring 59 1,100 1,985 Durrable Products Gasket 60 Spacetime Technologies Bolt-nut package Bolt-nut package $ 3.55 4,600 61 $ Durrable Products 62 3.50 3,900 $ 2.85 Manley Valve O-Ring 63 1,250 64 Durrable Products Gasket $ 3.65 1,470 $220.00 Durrable Products Control Panel 65 550 $3.00 66 Spacetime Technologies O-Ring Alum Sheeting 900 $ $ 4.25 Airframe fasteners 67 10,500 $645.00 68 Steelpin Inc. Machined Valve 100 $100.50 Manley Valve Pressure Gauge 90 69 $655.50 70 Manley Valve Machined Valve 125 Airframe fasteners Hulkey Fasteners $ 4.25 17,000 71 Fast-Tie Aerospace Alum Sheeting O-Ring Bolt-nut package $ 2.45 1,250 72 $ 73 4,500 3.95 $ 220.00 74 Durrable Products Control Panel 500 Manley Valve Steelpin Inc. Alum Sheeting $100.50 $645.00 Pressure Gauge 75 100 Machined Valve 76 150 $255.00 Control Panel 77 500 $100.50 Manley Valve Alum Sheeting Pressure Gauge 78 95 $185.00 Side Panel 79 150 Shielded Cable/ft. Durrable Products 80 1.00 25,000 2.45 Fast-Tie Aerospace 1,500 O-Ring $ 81 $175.00 Fast-Tie Aerospace Side Panel 82 155 17,500 4.25 Hulkey Fasteners Airframe fasteners 83 Steelpin Inc. Side Panel $195.00 84 130 $645.00 Steelpin Inc. Machined Valve 85 120 $ 3.00 $ Spacetime Technologies O-Ring Alum Sheeting 1,050 86 $185.00 Side Panel 87 140 $ $ 1.00 88 Manley Valve Panel Decal 525 $ 0.55 Manley Valve Door Decal 89 150 $175.00 $ 95.00 Fast-Tie Aerospace Side Panel 06 91 150 Pressure Gauge Fast-Tie Aerospace 110 $195.00 92 Steelpin Inc. Side Panel 120 $0.85 Manley Valve Hatch Decal 93 550 $ 95.00 $175.00 $195.00 94 Fast-Tie Aerospace Pressure Gauge 105 Fast-Tie Aerospace Side Panel 95 175 Steelpin Inc. Side Panel 96 110 Door Decal $ 0.55 Manley Valve 97 125 98 99 Sheet1 +

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today!