Question: 2. Database Analytics: Purchase Orders Data file posted on Canvas contains data on purchase orders for parts used in airplane assembly. Use this data set

2. Database Analytics: "Purchase Orders Data" file posted on Canvas contains data on purchase orders for parts used in airplane assembly. Use this data set to perform the following: a. Extract all side panel orders with unit cost more than $180. b. Use VLOOKUP function to find the item description, quantity, and cost per order for the following order numbers: Aug11011 and Nov11004. c. Use PivotTables to find the number of orders from each item and filter it by supplier

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

To receive credit for this assignment you must complete the following required elements: DATA BLOCK AREA included and the data cell referenced to your ABC Analysis report. CELL REFERENCING: ABC...

You will be submitting two excel files to Bb for this assignment. REQUIREMENTS: Prepare an analysis of the estimated cost for Adria Manufacturing company's two products contrasting a traditional...

Study the case that starts on page 2 carefully. Then write concise answers to the following questions regarding the internal control system of Duarf, Inc. Clearly label your responses with proper...

Attached is our 2nd Case Study. Please read the case and respond to the 4 questions at the end of the case. The case draws primarily from textbook material presented in Part II, Control and Audit of...

FRAUD AND INTERNAL CONTROL 1. We have learned many Computer Audit Tests related to various types of schemes. If you were a CFE and hired to investigate this Duraf case immediately after the hotline...

Please discuss the following topic: From the perspective of the character "Rachel" in the attached case on embezzlement, please write a synopsis of the ethical dilemma confronting her. Making...

FRAUD AND INTERNAL CONTROL 1. What are the controls in place that under normal conditions should function well to prevent embezzlements or frauds? Identify and list (enumerate distinctly) at least 5...

Takoda Koriyama, whose parents came from Japan, is interested in how corporations operate in Western countries, particularly the United States. In one of his business classes, he and two...

1. Use Eq. (4) to calculate the magnetic field at the midpoint of the two coils used in this experiment when the current through each coil is 1 amp. The number of turns on each coil is 130 and the...

Suppose that Head-First Company now sells both bicycle helmets and motorcycle helmets. The bicycle helmets are priced at $75 and have variable costs of $45 each. The motorcycle helmets are priced at...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".