Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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 $ Database 0 1,300 Supplier Item Description Item Cost Quantity Cost per order Hulkey Fasteners Airframe fasteners $4.25 19,500 $82,875.00 Alum Sheeting Airframe fasteners $3.75 14,000 $52,500.00 Manley Valve Hatch Decal $1.10 580 $638.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 23,000 $24,150.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 21,500 $22,575.00 Steelpin Inc. Shielded Cable/ft. $1.10 17,500 $19,250.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 24,500 $25,725.00 Manley Valve Machined Valve $650.00 125 $81,250.00 Steelpin Inc. Bolt-nut package $3.75 4,250 $15,937.50 Durrable Products Pressure Gauge $80.00 100 $8,000.00 Fast-Tie Aerospace O-Ring $2.45 $3,185.00 Fast-Tie Aerospace Shielded Cable/ft. $1.05 22,500 $23,625.00 Steelpin Inc. Shielded Cable/ft. $1.00 18,300 $18,300.00 Hulkey Fasteners Electrical Connector $1.25 5,600 $7,000.00 Manley Valve Pressure Gauge $100.50 80 $8,040.00 Hulkey Fasteners Hatch Decal $0.75 500 $375.00 Steelpin Inc. Electrical Connector $1.65 4,500 $7.425.00 Steelpin Inc. Bolt-nut package $3.75 4,200 $15.750.00 Alum Sheeting Control Panel $255.00 706 $180,030.00 Hulkey Fasteners Electrical Connector $1.25 5,500 $6,875.00 Steelpin Inc. Electrical Connector $1.65 4,850 $8.002.50 Steelpin Inc. Bolt-nut package $3.75 4,150 $15,562.50 Manley Valve O-Ring $2.45 1400 $3.430.00 Hulkey Fasteners Airframe fasteners $4.25 18,500 $78,625.00 Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting A Concepts Based Introduction

Authors: David Kolitz

1st Edition

1138844977, 978-1138844971

More Books

Students also viewed these Accounting questions

Question

How should a consultant be selected?

Answered: 1 week ago

Question

Why is a consulting contract needed?

Answered: 1 week ago