Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer questions B and C question B- the total quantity of airframe fasteners purchased. question C- the total cost of all orders places with
please answer questions B and C
Convert the accompanying database to an Excel table to find: a. The total cost of all orders. b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Click the icon to view the database. a. The total cost of all orders is $713387.5. b. The total quantity of airframe fasteners purchased is airframe fasteners. Convert the accompanying database to an Excel table to find: a. The total cost of all orders, b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Click the icon to view the database. a. The total cost of all orders is $713387.5 b. The total quantity of airframe fasteners purchased is airf Database Supplier Hulkey Fasteners Alum Sheeting Manley Valve Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Fast-Tie Aerospace Manley Valve Steelpin Inc. Durable Products Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Hulkey Fasteners Manley Valve Hulkey Fasteners Steelpin Inc. Steelpin Inc. Item Cost Quantity Cost per order 0 $4.25 $82,875.00 19,500 $4.25 13,000 $55,250.00 $1.25 600 $750.00 $24,150.00 23,000 24,500 $25,725.00 . Item Description Airframe fasteners Airframe fasteners Hatch Decal Shielded Cableift $1.05 Shielded Cableift. $1.05 $1.10 17,500 $1.05 22,500 $650.00 125 $3.75 $90.00 $2.45 $1.05 $19,250.00 $23,625.00 $81,250.00 $15.937.50 Shielded Cableift. Shielded Cableift. Machined Valve Bolt-nut package Pressure Gauge O-Ring Shielded Cable/t Shielded Cable/tt $1.00 Electrical Connector $1.25 4,250 100 $9,000.00 1,300 $3,185.00 22,500 $23,625.00 $18,100.00 18,100 5,600 90 $7,000.00 $10,845.00 $120.50 Pressure Gauge Hatch Decal $0.75 700 $525.00 Electrical Connector $1.65 4,500 $7,425.00 Boll-nut package $3.75 4,200 $15,750.00 Print Done 1 Convert the accompanying database to an Excel table to find: a. The total cost of all orders. b. The total quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Click the icon to view the database. a. The total cost of all orders is $ 713387.5. b. The total quantity of airframe fasteners purchased is airf Database Steelpin Inc. Fast-Tie Aerospace Manley Valve Steelpin Inc. Durrable Products Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Hulkey Fasteners Manley Valve Hulkey Fasteners Steelpin Inc. Steelpin Inc. Alum Sheeting Hulkey Fasteners Steelpin Inc.. Steelpin Inc. Manley Valve Hulkey Fasteners $1.10 $1.05 Shielded Cable/ft. Shielded Cable/ft. Machined Valve Bolt-nut package Pressure Gauge O-Ring $650.00 $3.75 $90.00 $2.45 $1.05 Shielded Cable/ft Shielded Cable/ft $1.00 Electrical Connector $1.25 Pressure Gauge $120.50 Hatch Decal $0.75 Electrical Connector $1.65. Bolt-nut package Control Panel $3.75 $255.00 Electrical Connector $1.25 Electrical Connector $1.65 $3.75 Bolt-nut package O-Ring $2.85 Airframe fasteners $4.25 17,500 22,500 125 4,250 100 1,300 22,500 18,100 5,600 90 700 4,500 4,200 706 5,500 4,850 4,150 1500 17,500 $19,250.00 $23,625.00 $81,250.00 $15,937.50 $9,000.00 $3,185.00 $23,625.00 $18,100.00 $7,000.00 $10,845.00 $525.00 $7,425.00 $15,750.00 $180,030.00 $6,875.00 $8,002.50 $15,562.50 $4,275.00 $74,375.00 question B- the total quantity of airframe fasteners purchased.
question C- the total cost of all orders places with manley valve.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started