ADMN 368v1_Assignment2_Instructions
pdf
keyboard_arrow_up
School
University of British Columbia *
*We aren’t endorsed by this school
Course
01
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
Pages
3
Uploaded by mehaksanay
Assignment 2: Acme Auto Parts Corp. PQ Basics This assignment builds on data presented in Assignment 1 for Acme Auto Parts Corp. (AAP). AAP sells parts for four makes of luxury automobiles (Audi, BMW, Lexus, Mercedes) in six regions across Canada: British Columbia, Prairies, Ontario, Quebec, Atlantic, and Northern. Open the file Assignment Resources>Assignment 2>Acme Auto Parts Corp. ASSIGN 2 data set at [. . .].xlsx. Each row of data in the worksheet “Acme Data Set” shows the region and date of each sale, description of parts, quantity sold, selling price and cost data for the years 2024–2026 by make and part. This time, only per-unit selling price and cost data are shown (red box). Assume there are no spelling or other errors in the data. ADMN368v1 - Assignment 2 @Athabasca University
Page 1 of 3
July 18/2023
Requirement 1 Open a blank Excel workbook. Import the workbook Assignment Resources>Assignment 2>Acme Auto Parts Corp. ASSIGN 2 data set at [. . .] .xlsx. Reproduce the data below. Do all steps in Power Query. Besides exhibiting best practices for queries, ensure your query exhibits the following: •
columns deleted as applicable. •
columns named as shown below. •
gross profit calculated for each row [Quantity × (Sell. Price – Cost)]. •
final gross profit calculation step renamed “Calc. GP” with a brief description of this step in its properties. •
data sorted alphabetically by Region, then in chronological order by Date of Sale. Requirement 2 In the same worksheet, create a PivotTable and PivotChart sorted by Region (highest grand total gross profit to lowest), then Make (highest grand total gross profit to lowest). Otherwise, format the data as you see fit. Your display should be clear and informative. An example is shown under Requirement 3. ADMN368v1 - Assignment 2 @Athabasca University
Page 2 of 3
July 18/2023
Requirement 3 In the same worksheet, interpret the data in fewer than 100 words. ADMN368v1 - Assignment 2 @Athabasca University
Page 3 of 3
July 18/2023
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help