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. 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.

Database Supplier Hulkey Fasteners Alum Sheeting Manley Valve Fast-Tie Aerospace Fast-Tie Aerospace 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 Item Description Airframe fasteners Airframe fasteners Hatch Decal Shielded Cable/ft. Shielded Cable/ft. Shielded Cable/ft. Shielded Cable/ft. Machined Valve Bolt-nut package Pressure Gauge O-Ring Shielded Cable/ft. Shielded Cable/ft. Electrical Connector Pressure Gauge Hatch Decal Electrical Connector Bolt-nut package Control Panel Electrical Connector Electrical Connector Bolt-nut package O-Ring Airframe fasteners Item Cost $4.25 $3.75 $1.10 $1.05 $1.05 $1.10 $1.05 $655.50 $3.75 $80.00 $2.45 $1.05 Quantity Cost per order 19,500 $82,875.00 12,000 $45,000.00 570 $627.00 23,000 22,500 17,500 22,500 $0.75 $1.65 $3.75 $255.00 $1.25 $1.65 $3.75 $2.85 $4.25 125 4,250 100 1,300 22,500 18,400 5,600 $1.00 $1.25 $100.50 70 700 4,500 4,200 706 5,500 4,850 4,150 1400 18,500 $24,150.00 $23,625.00 $19,250.00 $23,625.00 $81,937.50 $15,937.50 $8,000.00 $3,185.00 $23,625.00 $18,400.00 $7,000.00 $7,035.00 $525.00 $7,425.00 $15,750.00 $180,030.00 $6,875.00 $8,002.50 $15,562.50 $3,990.00 $78,625.00

Step by Step Solution

3.55 Rating (165 Votes )

There are 3 Steps involved in it

Step: 1

Converting a database into excel table supplier item description item cost quantity cost per order h... 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

Business Analytics Methods Models And Decisions

Authors: James R. Evans

2nd Edition

321997824, 978-1119298588, 978-0321997821

More Books

Students also viewed these Accounting questions

Question

Are all direct costs variable? Explain.

Answered: 1 week ago

Question

Calculate the missing values

Answered: 1 week ago