Homework Help is Here – Start Your Trial Now!
Business
Finance
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.

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.

Cornerstones of Cost Management (Cornerstones Series)
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter4: Activity-based Costing
Section: Chapter Questions
Problem 36P: Reducir, Inc., produces two different types of hydraulic cylinders. Reducir produces a major...
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. The total quantity of airframe fasteners purchased.

c. The total cost of all orders placed with Manley Valve.

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 $1.00 $1.25 $100.50 $0.75 $1.65 $3.75 $255.00 $1.25 $1.65 $3.75 $2.85 $4.25 Quantity Cost per order 19,500 12,000 570 23,000 22,500 17,500 22,500 125 4,250 100 18,400 5,600 70 700 $82,875.00 $45,000.00 1,300 22,500 $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 4,500 4,200 706 5,500 4,850 4,150 1400 18,500 $627.00 $24,150.00 $23,625.00 $19,250.00 $23,625.00 $81,937.50 $15,937.50 $8,000.00 $3,185.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 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 $1.00 $1.25 $100.50 $0.75 $1.65 $3.75 $255.00 $1.25 $1.65 $3.75 $2.85 $4.25 Quantity Cost per order 19,500 12,000 570 23,000 22,500 17,500 22,500 125 4,250 100 18,400 5,600 70 700 $82,875.00 $45,000.00 1,300 22,500 $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 4,500 4,200 706 5,500 4,850 4,150 1400 18,500 $627.00 $24,150.00 $23,625.00 $19,250.00 $23,625.00 $81,937.50 $15,937.50 $8,000.00 $3,185.00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
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
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
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