Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b.
Fantastic news! We've Found the answer you've been seeking!
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.
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Converting a database into excel table supplier item description item cost quantity cost per order h... View the full answer
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these accounting questions
-
Convert the Store and Regional Sales database to an Excel table. For the Store and Regional Sales database, apply a four traffic light icon set to visualize the distribution of the number of units...
-
Hack's Berries faces a short-run total cost of production given by TC = Q3 - 12 Q2 + 100Q + 1,000. a. What is the level of Hack's fixed cost? b. What is Hack's short-run average variable cost of...
-
The accompanying table shows the price and yearly quantity sold of souvenir T-shirts in the town of Crystal Lake according to the average income of the tourists visiting. a. Using the midpoint...
-
In Exercises solve the first-order differential equation by any appropriate method. y' = 2x1 - y
-
Marshall Company recently approached Johnson Corporation regarding manufacturing a special order of 4,000 units of product CRB2B. Marshall would reimburse Johnson for all variable manufacturing costs...
-
Write each expression as a sum and/or difference of logarithms. Express powers as factors. In (x-4)72/3 2-1 x > 4
-
Elliott started business on 1 July 2025. The accounting system includes a sales journal, a purchases journal, a cash receipts journal, a cash payments journal and a general journal. The chart of...
-
The Polishing Department of Harbin Manufacturing Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production:...
-
In the video below, critique the introduction and conclusion that was delivered in a speech on "Cyber Security." What are the speaker's weaknesses?
-
Q1. Review the following accounts, subtotals, and totals; (1) describe your observations; and then (2) identify what your observations indicate. A response is given for PPE, net to help with...
-
Y Ltd., a Canadian-controlled private corporation, spent $800,000 in SR&ED current expenditures and $600,000 in SR&ED capital expenditures. Y's taxable income the previous year was $400,000 and Y is...
-
Save all of your sales receipts for 1 month. At the end of the month calculate the total sales tax paid and annualize the amount by multiplying it by 12. Compare this amount to your total state...
-
Assume you can save $4,000 a year (about $80 per week) after graduation. Set a financial goal for yourself and specify the time frame and cost. Calculate the interest rate required to achieve the...
-
Investigate a specific financial planning issue or decision that involves the use of the time va lue of money concepts. Describe why it is necessary to make a time value of money calculation....
-
In a biological system, N2 is often bubbled through a fermentor to maintain anaerobic conditions. As the N2 bubbles through the fermentor, the gas strips water from the liquid. Consider an isothermal...
-
Using a financial calculator, determine the future value of $5,000 invested at 12 percent for 40 years with annual compounding. What rate of interest would result in the same future value if the...
-
A simple trust has a distributable net income (DNI) of $45,000 and net accounting income of $50,000, all from taxable sources. The trust has a sole beneficiary, Nick. The trust reports on a calendar...
-
You are standing at x = 9.0 km and your assistant is standing at x = 3.0 km. Lightning bolt 1 strikes at x = 0 km and lightning bolt 2 strikes at x = 12.0 km. You see the flash from bolt 2 at t = 10...
-
The Excel file Myatt Steak House provides 5 years of data on key business results for a restaurant. Identify the leading and lagging measures, find the correlation matrix, and propose a cause and...
-
The number and frequency of Atlantic hurricanes annually from 1940 through 2012 is shown here. a. Find the probabilities of 0 12 hurricanes each season using these data. b. Assuming a Poisson...
-
An information system consultant is bidding on a project that involves some uncertainty. Based on past experience, if all went well (probability 0.1), the project would cost $ 1.2 million to...
-
If someone is in the 22 percent marginal tax bracket, is that persons entire income taxed at 22 percent? Why or why not?
-
What are the major categories of adjustments to gross income? For a taxpayer in the 22 percent marginal tax bracket, how much would adjustments totaling $10,000 save in taxes?
-
Although the basic principles of personal finance are the same for men and women, what are the social and demographic factors that make these decisions especially important for women?
Study smarter with the SolutionInn App