Homework Help is Here – Start Your Trial Now!
Business
Accounting
Convert the accompanying database to an Excel table to​ find:   a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is ​$?????? enter your response here.

Convert the accompanying database to an Excel table to​ find:   a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is ​$?????? enter your response here.

Financial Reporting, Financial Statement Analysis and Valuation
Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Chapter4: Profitability Analysis
Section: Chapter Questions
Problem 18PC
See similar textbooks
icon
Related questions
Question
Convert the accompanying database to an Excel table to​ find:
 
a.The total cost of all orders.
b.Thetotal quantity of airframe fasteners purchased.
c. The total cost of all orders placed with Manley Valve.
Question content area bottom
Part 1
a. The total cost of all orders is
​$?????? enter your response here.
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 $4.25 Airframe fasteners $4.25 Hatch Decal $1.25 Shielded Cable/ft. $1.05 Shielded Cable/ft. $1.05 Shielded Cable/ft. $1.10 Shielded Cable/ft. $1.05 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 Item Cost Bolt-nut package O-Ring Airframe fasteners $650.00 $3.75 $80.00 $2.45 $1.05 $1.00 $1.25 $120.50 $0.75 $1.65 $3.75 $255.00 $1.25 $1.10 $3.75 $3.75 $4.25 Quantity Cost per order 19,500 $82,875.00 12,000 $51,000.00 560 23,000 22,500 17,500 25,500 $700.00 $24,150.00 $23,625.00 $19,250.00 $26,775.00 125 $81,250.00 4,250 $15,937.50 100 $8,000.00 1,300 $3,185.00 22,500 $23,625.00 18,400 $18,400.00 5,600 $7,000.00 90 $10,845.00 600 $450.00 4,500 $7,425.00 4,200 $15,750.00 606 $154,530.00 5,500 $6,875.00 4,850 $5,335.00 4,150 $15,562.50 1300 $4,875.00 15,500 $65,875.00
Transcribed Image Text: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 $4.25 Airframe fasteners $4.25 Hatch Decal $1.25 Shielded Cable/ft. $1.05 Shielded Cable/ft. $1.05 Shielded Cable/ft. $1.10 Shielded Cable/ft. $1.05 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 Item Cost Bolt-nut package O-Ring Airframe fasteners $650.00 $3.75 $80.00 $2.45 $1.05 $1.00 $1.25 $120.50 $0.75 $1.65 $3.75 $255.00 $1.25 $1.10 $3.75 $3.75 $4.25 Quantity Cost per order 19,500 $82,875.00 12,000 $51,000.00 560 23,000 22,500 17,500 25,500 $700.00 $24,150.00 $23,625.00 $19,250.00 $26,775.00 125 $81,250.00 4,250 $15,937.50 100 $8,000.00 1,300 $3,185.00 22,500 $23,625.00 18,400 $18,400.00 5,600 $7,000.00 90 $10,845.00 600 $450.00 4,500 $7,425.00 4,200 $15,750.00 606 $154,530.00 5,500 $6,875.00 4,850 $5,335.00 4,150 $15,562.50 1300 $4,875.00 15,500 $65,875.00
Expert Solution
steps

Step by step

Solved in 4 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost classification
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS