Copy of 304 Quiz 2 to submit

# Copy of 304 Quiz 2 to submit - This Quiz has 2 parts The...

This preview shows pages 1–10. Sign up to view the full content.

The second part is to work up 3 pivot tables based on the instructions on the Pivot table problem worksheet, usin the data from the Pivot table data worksheet. Be sure to format and label, as well as make it as professional and presentable as possible. Please turn in one workbook containing the 4 solutions to the digital drop box. This Quiz has 2 parts. The first is to complete a data table using the information provided on the next worksheet.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
g t.
Section: Finan 304 - 001 QUIZ 2 Smith Family's Car Loan Payment Loan amount \$20,000.00 Loan term 24 (number of months) Annual Percentage Rate 6% Monthly payment \$941.47 (prototype formula) Interest Rates: 5%, 6%, 8%, 10%, 12% Loan Terms (in months): 24, 30, 36, 42, 48, 60, 72 Rates \$941.47 5% 6% 8% 10% 12% 24 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 30 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 Months 36 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 42 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 48 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 60 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 72 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 Name: Hannah (Hong) Nguyen

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Create pivot tables to do the following: Part One Part Two Part Three Your manager wants to investigate ordering information for the North sales region for May, 2003. Specifically she wants to know the total number of orders (count of Order Size) for each product for each sales person. Your manager wants to investigate shipment information for the Mace product in the 3rd Quarter of 2003. Specifically she wants to know the total number of units shipped (Shipment size) to each sales region from each plant. Be sure to name fields approprately. Your manager wants to investigate shipment information for the West sales region during March of 2004. Specifically she wants to know the total number of units of each product that were shipped (shipment size) by each plant. Be sure to name fields appropriately. Create a Pivot Chart, and make sure to label!!!
Section: Finan 304 - 001 Micron Technology INC Count of Order Size for Each Product Each Sales Person in North Region by May 2 Order Year 2003 Order Date May Sales Region North Count of Order Size Product Sales Person Ace Mace Tace Grand Total Brown 1 1 Lopez 1 1 2 Miller 1 1 Smith 1 1 Grand Total 2 2 1 5 Name: Hannah (Hong) Nguyen

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2003
Micron Technology INC Shipment Year 2003 Shipment Quarter Qtr3 Product Mace Sum of Shipment Size Plant Sales Region Cleveland Miami Seattle Grand Total East 90 90 North 132 153 115 400 South 129 129 West 129 117 246 Grand Total 480 270 115 865 Number of Units Shipped to Each Sales Region from Each Plant for Mace Product in 3rd Quarter of 2003

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Micron Technology INC Number of Units Shipped for Each Plant in West Region by Product during March, 2004 Shipment Year 2004 Shipment Date Mar Sales Region West Sum of Shipment Size Product Plant Ace Mace Pace Tace Grand Total Miami 108 146 136 108 498 Seattle 132 132 Grand Total 240 146 136 108 630
Order Date Product Order Size Shipment Date Shipment Size Sales Person

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/12/2011 for the course FIN 304 taught by Professor Doug during the Spring '11 term at Boise State.

### Page1 / 22

Copy of 304 Quiz 2 to submit - This Quiz has 2 parts The...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online