Excel Problem !!! about Pivot Chart and Table. due tonight

Shelly Cashman Excel 2013 Chapter 8: SAM Project 1a Precision Guitars WORKING WITH PIVOTTABLES AND PIVOTCHARTS PROJECT DESCRIPTION Troy Bellevue is the national sales manager for Precision Guitars. Troy wants to analyze sales by region, and has asked you to create a workbook detailing sales in Region 1. You will need to create tables with sales data for each guitar type as well as a summary table for all guitars sales. Then you will need to add PivotTables and PivotCharts to further analyze the data. GETTING STARTED Download the following file from the SAM website: o SC_Excel2013_C8_P1a_FirstLastName_1.xlsx Open the file you just downloaded and save it with the name: o o SC_Excel2013_C8_P1a_FirstLastName_2.xlsx Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. With the file SC_Excel2013_C8_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. Go to the 2013-2016 Guitar Sales Chart worksheet. Remove the 4-year Sales Average field from the PivotChart. 2. Format the PivotChart title using the Gradient Fill - Orange, Accent 4, Outline - Accent 4 WordArt Style. 3. Format the PivotChart as described below: a. Change the data series format to Cylinder. b. Change the fill of the Back and Side walls of the chart to Gradient Fill using the From Center option in the Variations section of the Gradient submenu. (Hint: Depending on the existing formatting of the back or side walls of the chart, the From Center option may be available in the Light section of the Gradient submenu.) Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a 4. Go to the 2016 Guitar Sales worksheet and select cell B4. Create a new worksheet, then create a blank PivotTable report in the new worksheet. (Hint: The PivotTable report should be based on the table GuitarSales2016.) a. Change the name of the worksheet containing the PivotTable report to Electric PivotTable Report. b. Add the Model and Customer fields (in that order) to the Rows area of the PivotTable Fields task pane. c. Add the Quantity and Total Amount fields (in that order) to the Values area of the PivotTable Fields task pane. (Hint: The name of the fields should be changed to Sum of Quantity and Sum of Total Amounts.) d. Apply the Currency number format, with 0 decimal places, to the Sum of Total Amount field. e. Add the Type field to the Filters area of the PivotTable Fields task pane. Use the filter to display only records for Electric guitars (not Acoustic or Acoustic-Electric) in the PivotTable report. 5. Return to the 2016 Guitar Sales worksheet. Create a PivotChart directly from the data in that table in a new worksheet. Rename the new worksheet Quantity Sold Report then update the PivotChart as described below: a. Add the Type field to the Legend (Series) area of the PivotChart Fields task pane. b. Add the Customer field to the Axis (Category) area of the PivotChart Fields task pane. c. Add the Quantity field to the Values area of the PivotChart Fields task pane. Change the title of this field to Quantity Sold in 2016. d. Select row 1 and insert two new rows into the workbook. e. In cell A1, enter the text Precision Instrument Manufacturing and apply the Title cell style to the cell. f. In cell A2, enter the text Guitars Sold to All Customers in 2016 and apply the Title cell style to the cell. g. Move and resize the PivotChart so that the top, left corner appears in cell A14 and the bottom, right corner appears in cell E33. 6. Go to the Customer PivotTable Report worksheet. Refresh the PivotTable report data (Hint: After refreshing the PivotTable data, the Total 2016 Sales value for Ace Guitar World should be 7158). 7. Apply the Pivot Style Medium 13 to the PivotTable report. 8. Modify the Sum of Order# field (in column B) as described below: a. Summarize the values in the column using the COUNT function. b. Change the name of the field to Total 2016 Orders. 9. Modify the number format of the Total 2016 Sales field, so that the values display in the Currency number format, with 0 decimal places. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a 10. Add a new calculated field to the end of the PivotTable report as described below: a. Enter the text Income per Guitar as the field title. b. Use the formula ='Total Amount'/Quantity for the field. c. Apply the Currency number format, with 0 decimal places, to the field. d. Change the custom name of the calculated field to Average Income per Guitar Sold. 11. Go to the Model PivotTable Report worksheet and make the following updates: a. Change the layout of the PivotTable report to the Compact form view. b. Hide the Field Headers in the PivotTable report. c. Update the PivotTable options to turn off auto fitting of column widths. 12. Format the Customer slicer using the Slicer Style Light 5. Then, use the slicer to filter the PivotTable report to only display data for Jackson Music School, Patriot's Hill Music, and Westwood Music Academy. 13. Add another slicer to the Model PivotTable report based on the Type field, then complete the following actions: a. Resize and reposition the Type slicer, so that the top, left corner is located in cell P18 and the bottom, right corner is located in cell R24. b. Format the slicer using the Slicer Style Light 5. c. Use the slicer to filter the PivotTable report to only display data for Acoustic and Electric guitars. (Hint: The PivotTable should already be filtered using the Customer Slicer.) 14. Go to the 2013-2017 Sales Forecast worksheet. Create a Line with Markers chart based on the non-adjacent range A3:F3 and A7:F7. (Hint: The Line with Markers graph is a type of 2-D Line graph) Move and resize the chart so that the top, left corner is in cell A9 and the bottom, right corner is in cell F21. 15. Format the Line with Markers chart as described below: a. Change the title of the chart to Guitar Sales - Actual and Forecast. b. Set the Minimum bounds for the Vertical axis to 20000.0 c. Add a Primary Vertical Axis title to the chart. Change the Primary Vertical Axis title to Dollars (U.S.). d. Add a Primary Horizontal Axis title to the chart. Change the Primary Horizontal Axis title to Year. e. Select the 2017 Data Point on the chart, change the size of the marker to 8, and the fill color of the marker to Red, Accent 6. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a 16. Go to the Acoustic Electric - Trendline worksheet. Add a Linear trendline to the chart with the following options: a. Set the trendline to forecast two-periods forward. b. Display the R-squared value on the chart. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a Final Figure 1: 2013-2016 Guitar Sales Chart worksheet Microsoft product screenshots used with permission from Microsoft Corporation. Copyright 2014 Cengage Learning. All Rights Reserved. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a Final Figure 2: Electric PivotTable Report worksheet Copyright 2014 Cengage Learning. All Rights Reserved. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a Final Figure 3: Quantity Sold Report worksheet Copyright 2014 Cengage Learning. All Rights Reserved. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a Final Figure 4: Customer PivotTable Report worksheet Copyright 2014 Cengage Learning. All Rights Reserved. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a Final Figure 5: Model PivotTable Report worksheet Final Figure 6: 2013-2017 Sales Cengage Learning. worksheet Copyright 2014 Forecast All Rights Reserved. Copyright 2014 Cengage Learning. All Rights Reserved. Shelly Cashman Excel 2013| Chapter 8: SAM Project 1a Final Figure 7: Acoustic Electric - Trendline worksheet Copyright 2014 Cengage Learning. All Rights Reserved. Copyright 2014 Cengage Learning. All Rights Reserved. Shelly Cashman Excel 2013 Chapter 8: SAM Project 1a Precision Guitars WORKING WITH PIVOTTABLES AND PIVOTCHARTS Author: YuHan Li Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Precision Instrument Manufacturing 2013-2016 Guitar Sales Model A100 A105 A110 A115 A120 A150 AE100 AE110 AE115 AE120 E100 E105 E110 Type Price/unit 2013 Sale2014 Sale2015 Sale2016 Sales Acoustic $99.00 $5,742 $5,940 $4,158 $2,970 Acoustic $149.00 $1,192 $1,490 $1,639 $1,490 Acoustic $119.00 $4,522 $5,236 $3,094 $3,213 Acoustic $209.00 $1,045 $627 $418 $627 Acoustic $249.00 $1,245 $747 $498 $747 Acoustic $409.00 $1,227 $818 $1,227 $818 Acoustic-Ele $149.00 $4,172 $4,619 $5,662 $6,705 Acoustic-Ele $179.00 $9,935 $9,935 $10,561 $11,456 Acoustic-Ele $209.00 $7,315 $8,569 $7,733 $5,852 Acoustic-Ele $309.00 $3,245 $4,017 $4,326 $5,253 Electric $79.00 $5,688 $7,031 $5,688 $4,582 Electric $149.00 $1,937 $2,533 $2,831 $4,470 Electric $209.00 $11,077 $8,569 $5,852 $6,061 Precision Instrument Manufacturing Total Sales by Guitar Type 2013 - 2016 $30,000 $25,000 Data Column C Column D Column E Column F $20,000 Dollar (U.S.) $15,000 $10,000 $5,000 $- Type Acoustic Guitar T ype Acoustic-Electric Electric Precision Instrument Manufacturing 2016 Guitar Sales Order # Customer 1 Maui Guitar Center 2 Westwood Music Academy 3 Maui Guitar Center 4 Maui Guitar Center 5 Jackson Music School 6 Jackson Music School 7 Jackson Music School 8 Firefly Music and Arts 9 Ace Guitar World 10 Westwood Music Academy 11 Starz Music Center 12 Firefly Music and Arts 13 Ace Guitar World 14 Ace Guitar World 15 Starz Music Center 16 Earle's Guitar Emporium 17 Westwood Music Academy 18 Starz Music Center 19 Earle's Guitar Emporium 20 Firefly Music and Arts 21 Starz Music Center 22 Maui Guitar Center 23 Maui Guitar Center 24 Maui Guitar Center 25 Ace Guitar World 26 Starz Music Center 27 Patriot's Hill Music 28 Patriot's Hill Music 29 Patriot's Hill Music 30 Ace Guitar World 31 Jackson Music School 32 Jackson Music School 33 Jackson Music School 34 Earle's Guitar Emporium 35 Westwood Music Academy 36 Firefly Music and Arts 37 Earle's Guitar Emporium 38 Earle's Guitar Emporium 39 Ace Guitar World 40 Earle's Guitar Emporium 41 Starz Music Center 42 Earle's Guitar Emporium 43 Ace Guitar World 44 Patriot's Hill Music 45 Patriot's Hill Music 46 Patriot's Hill Music 47 Westwood Music Academy 48 Firefly Music and Arts 49 Patriot's Hill Music 50 Maui Guitar Center Total Type Customer ID Date Model Acoustic-Electric 323 1/1/2016 AE100 Acoustic-Electric 229 1/1/2016 AE115 Acoustic-Electric 323 1/1/2016 AE110 Acoustic-Electric 323 1/1/2016 AE120 Electric 301 1/10/2016 E100 Electric 301 1/10/2016 E110 Acoustic 301 1/10/2016 A110 Acoustic 250 1/15/2016 A100 Acoustic-Electric 160 1/15/2016 AE115 Acoustic-Electric 229 2/15/2016 AE115 Acoustic 170 2/15/2016 A100 Acoustic 250 3/15/2016 A100 Electric 160 3/15/2016 E105 Acoustic-Electric 160 4/1/2016 AE110 Electric 170 4/14/2016 E100 Acoustic-Electric 151 5/1/2016 AE120 Acoustic 229 5/15/2016 A100 Acoustic-Electric 170 5/15/2016 AE115 Acoustic-Electric 151 6/1/2016 AE115 Acoustic 250 6/15/2016 A100 Acoustic-Electric 170 7/1/2016 AE110 Acoustic 323 7/5/2016 A110 Electric 323 7/5/2016 E105 Acoustic 323 7/5/2016 A115 Acoustic-Electric 160 7/5/2016 AE100 Electric 170 8/1/2016 E100 Acoustic 422 8/1/2016 A105 Electric 422 8/1/2016 E100 Acoustic-Electric 422 8/1/2016 AE110 Electric 160 8/5/2016 E110 Acoustic 301 8/10/2016 A110 Acoustic-Electric 301 8/10/2016 AE100 Electric 301 8/10/2016 E110 Acoustic-Electric 151 8/13/2016 AE115 Acoustic-Electric 229 8/15/2016 AE115 Acoustic 250 8/15/2016 A100 Acoustic 151 9/1/2016 A120 Electric 151 9/13/2016 E105 Electric 160 10/1/2016 E110 Electric 151 10/13/2016 E110 Acoustic 170 ### A150 Acoustic 151 11/13/2016 A110 Acoustic-Electric 160 ### AE100 Electric 422 12/1/2016 E100 Acoustic-Electric 422 12/1/2016 AE110 Acoustic 422 12/1/2016 A105 Acoustic-Electric 229 ### AE115 Acoustic-Electric 250 ### AE100 Acoustic-Electric 422 12/1/2016 AE110 Acoustic-Electric 323 1/1/2016 AE110 Quantity Price/unit Total Amount 10 $149.00 Err:509 3 $209.00 Err:509 10 $179.00 Err:509 10 $309.00 Err:509 13 $79.00 Err:509 12 $209.00 Err:509 6 $119.00 Err:509 4 $99.00 Err:509 5 $209.00 Err:509 3 $209.00 Err:509 10 $99.00 Err:509 4 $99.00 Err:509 10 $149.00 Err:509 4 $179.00 Err:509 10 $79.00 Err:509 7 $309.00 Err:509 5 $99.00 Err:509 3 $209.00 Err:509 3 $209.00 Err:509 3 $99.00 Err:509 9 $179.00 Err:509 10 $119.00 Err:509 12 $149.00 Err:509 3 $209.00 Err:509 12 $149.00 Err:509 15 $79.00 Err:509 5 $149.00 Err:509 10 $79.00 Err:509 10 $179.00 Err:509 3 $209.00 Err:509 6 $119.00 Err:509 15 $149.00 Err:509 4 $209.00 Err:509 5 $209.00 Err:509 3 $209.00 Err:509 4 $99.00 Err:509 3 $249.00 Err:509 8 $149.00 Err:509 5 $209.00 Err:509 5 $209.00 Err:509 2 $409.00 Err:509 5 $119.00 Err:509 3 $149.00 Err:509 10 $79.00 Err:509 10 $179.00 Err:509 5 $149.00 Err:509 3 $209.00 Err:509 5 $149.00 Err:509 10 $179.00 Err:509 11 $179.00 Err:509 Err:508 Precision Instrument Manufacturing 2016 Guitar Sales by Customer Customer Ace Guitar World Type Acoustic-Electric Electric Earle's Guitar Emporium Acoustic Acoustic-Electric Electric Firefly Music and Arts Acoustic Acoustic-Electric Jackson Music School Acoustic Acoustic-Electric Electric Maui Guitar Center Acoustic Acoustic-Electric Electric Patriot's Hill Music Acoustic Acoustic-Electric Electric Starz Music Center Acoustic Acoustic-Electric Electric Westwood Music Academy Acoustic Acoustic-Electric Total Result Data Sum - Order # 173 91 82 226 79 69 78 124 76 48 114 38 32 44 127 46 58 23 268 73 123 72 132 52 39 41 111 17 94 1275 Sum - Quantity Sum - Total Amount 42 #VALUE! 24 #VALUE! 18 #VALUE! 36 #VALUE! 8 #VALUE! 15 #VALUE! 13 #VALUE! 20 #VALUE! 15 #VALUE! 5 #VALUE! 56 #VALUE! 12 #VALUE! 15 #VALUE! 29 #VALUE! 66 #VALUE! 13 #VALUE! 41 #VALUE! 12 #VALUE! 60 #VALUE! 10 #VALUE! 30 #VALUE! 20 #VALUE! 49 #VALUE! 12 #VALUE! 12 #VALUE! 25 #VALUE! 17 #VALUE! 5 #VALUE! 12 #VALUE! 346 #VALUE! Precision Instrument Manufacturing 2016 Guitar Sales by Model and Month Sum - Quantity Model A100 A105 A110 A115 A120 A150 AE100 AE110 AE115 AE120 E100 E105 E110 Total Result Date Customer Jan Firefly Music and Arts Starz Music Center Westwood Music Academy Patriot's Hill Music Earle's Guitar Emporium Jackson Music School Maui Guitar Center Maui Guitar Center Earle's Guitar Emporium Starz Music Center Ace Guitar World Firefly Music and Arts Jackson Music School Maui Guitar Center Ace Guitar World Maui Guitar Center Patriot's Hill Music Starz Music Center Ace Guitar World Earle's Guitar Emporium Starz Music Center Westwood Music Academy Earle's Guitar Emporium Maui Guitar Center Jackson Music School Patriot's Hill Music Starz Music Center Ace Guitar World Earle's Guitar Emporium Maui Guitar Center Ace Guitar World Earle's Guitar Emporium Jackson Music School Feb Mar Apr 4 4 10 MayJun Jul Aug Sep Oct 4 3 Nov This shape represents a slicer. Slicers are supported in Excel 2010 or later. Dec 5 5 5 5 6 6 10 3 3 2 12 3 5 15 10 4 21 10 20 9 5 3 5 3 3 3 3 3 10 15 10 7 10 13 10 10 8 12 3 12 84 13 14 14 15 6 46 4 80 5 5 11 12 8 43 If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used. Precision Instrument Manufacturing Guitar Sales - Actual and Forecast Electric Acoustic Acoustic Electric Total 2013 $14,973 $45,160 $24,666 $84,799 2014 $14,858 $32,778 $27,140 $74,776 2015 $11,034 $28,282 $28,282 $67,598 2016 $9,865 $25,507 $29,266 $64,638 2017 $9,766 $24,270 $30,309 $64,345 Precision Instrument Manufacturing Acoustic Electric Guitar 2013-2017 Sales $32,500 $30,000 $27,500 Dollars (U.S.) $25,000 $22,500 $20,000 2013 2014 2015 Year 2016 2017 Shelly Cashman Excel 2013 Chapter 8: SAM Project 1a Precision Guitars WORKING WITH PIVOTTABLES AND PIVOTCHARTS Author: YuHan Li Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Precision Instrument Manufacturing 2013-2016 Guitar Sales Model A100 A105 A110 A115 A120 A150 AE100 AE110 AE115 AE120 E100 E105 E110 Type Price/unit 2013 Sale2014 Sale 2015 Sale 2016 Sales Acoustic $99.00 $5,742 $5,940 $4,158 $2,970 Acoustic $149.00 $1,192 $1,490 $1,639 $1,490 Acoustic $119.00 $4,522 $5,236 $3,094 $3,213 Acoustic $209.00 $1,045 $627 $418 $627 Acoustic $249.00 $1,245 $747 $498 $747 Acoustic $409.00 $1,227 $818 $1,227 $818 Acoustic-Ele $149.00 $4,172 $4,619 $5,662 $6,705 Acoustic-Ele $179.00 $9,935 $9,935 $10,561 $11,456 Acoustic-Ele $209.00 $7,315 $8,569 $7,733 $5,852 Acoustic-Ele $309.00 $3,245 $4,017 $4,326 $5,253 Electric $79.00 $5,688 $7,031 $5,688 $4,582 Electric $149.00 $1,937 $2,533 $2,831 $4,470 Electric $209.00 $11,077 $8,569 $5,852 $6,061 $70,000 $60,000 $50,000 Data Sum - 2013 Sales Sum - 2014 Sales Sum - 2015 Sales Sum - 2016 Sales $40,000 Dollar (U.S.) $30,000 $20,000 $10,000 $- Acoustic Acoustic-Electric Guitar T ype Electric T otal Result Type Electric Model E100 Customer Data Sum - Quantity Jackson Music Scho Patriot's Hill Music Starz Music Center E105 Ace Guitar World Earle's Guitar Em Maui Guitar Center E110 Ace Guitar World Earle's Guitar Em Jackson Music Scho Total Result Sum - Total Amount 58 #VALUE! 13 #VALUE! 20 #VALUE! 25 #VALUE! 30 #VALUE! 10 #VALUE! 8 #VALUE! 12 #VALUE! 29 #VALUE! 8 #VALUE! 5 #VALUE! 16 #VALUE! 117 #VALUE! Precision Instrument Manufacturing Guitars Sold to All Customers in 2016 Sum - Quantity Type Customer Acoustic Ace Guitar World Earle's Guitar Emporium Firefly Music and Arts Jackson Music School Maui Guitar Center Patriot's Hill Music Starz Music Center Westwood Music Academy Total Result Acoustic-Electric Electric Total Result 24 18 42 8 15 13 36 15 5 20 12 15 29 56 13 41 12 66 10 30 20 60 12 12 25 49 5 12 17 75 154 117 346 180 160 140 120 100 80 60 40 20 0 T ype Acoustic Acoustic-Electric Electric Precision Instrument Manufacturing 2016 Guitar Sales Order # Total Customer 1 Maui Guitar Center 2 Westwood Music Academy 3 Maui Guitar Center 4 Maui Guitar Center 5 Jackson Music School 6 Jackson Music School 7 Jackson Music School 8 Firefly Music and Arts 9 Ace Guitar World 10 Westwood Music Academy 11 Starz Music Center 12 Firefly Music and Arts 13 Ace Guitar World 14 Ace Guitar World 15 Starz Music Center 16 Earle's Guitar Emporium 17 Westwood Music Academy 18 Starz Music Center 19 Earle's Guitar Emporium 20 Firefly Music and Arts 21 Starz Music Center 22 Maui Guitar Center 23 Maui Guitar Center 24 Maui Guitar Center 25 Ace Guitar World 26 Starz Music Center 27 Patriot's Hill Music 28 Patriot's Hill Music 29 Patriot's Hill Music 30 Ace Guitar World 31 Jackson Music School 32 Jackson Music School 33 Jackson Music School 34 Earle's Guitar Emporium 35 Westwood Music Academy 36 Firefly Music and Arts 37 Earle's Guitar Emporium 38 Earle's Guitar Emporium 39 Ace Guitar World 40 Earle's Guitar Emporium 41 Starz Music Center 42 Earle's Guitar Emporium 43 Ace Guitar World 44 Patriot's Hill Music 45 Patriot's Hill Music 46 Patriot's Hill Music 47 Westwood Music Academy 48 Firefly Music and Arts 49 Patriot's Hill Music 50 Maui Guitar Center Type Customer ID Date Model Acoustic-Electric 323 1/1/2016 AE100 Acoustic-Electric 229 1/1/2016 AE115 Acoustic-Electric 323 1/1/2016 AE110 Acoustic-Electric 323 1/1/2016 AE120 Electric 301 1/10/2016 E100 Electric 301 1/10/2016 E110 Acoustic 301 1/10/2016 A110 Acoustic 250 1/15/2016 A100 Acoustic-Electric 160 1/15/2016 AE115 Acoustic-Electric 229 2/15/2016 AE115 Acoustic 170 2/15/2016 A100 Acoustic 250 3/15/2016 A100 Electric 160 3/15/2016 E105 Acoustic-Electric 160 4/1/2016 AE110 Electric 170 4/14/2016 E100 Acoustic-Electric 151 5/1/2016 AE120 Acoustic 229 5/15/2016 A100 Acoustic-Electric 170 5/15/2016 AE115 Acoustic-Electric 151 6/1/2016 AE115 Acoustic 250 6/15/2016 A100 Acoustic-Electric 170 7/1/2016 AE110 Acoustic 323 7/5/2016 A110 Electric 323 7/5/2016 E105 Acoustic 323 7/5/2016 A115 Acoustic-Electric 160 7/5/2016 AE100 Electric 170 8/1/2016 E100 Acoustic 422 8/1/2016 A105 Electric 422 8/1/2016 E100 Acoustic-Electric 422 8/1/2016 AE110 Electric 160 8/5/2016 E110 Acoustic 301 8/10/2016 A110 Acoustic-Electric 301 8/10/2016 AE100 Electric 301 8/10/2016 E110 Acoustic-Electric 151 8/13/2016 AE115 Acoustic-Electric 229 8/15/2016 AE115 Acoustic 250 8/15/2016 A100 Acoustic 151 9/1/2016 A120 Electric 151 9/13/2016 E105 Electric 160 10/1/2016 E110 Electric 151 10/13/2016 E110 Acoustic 170 10/15/2016 A150 Acoustic 151 11/13/2016 A110 Acoustic-Electric 160 11/15/2016 AE100 Electric 422 12/1/2016 E100 Acoustic-Electric 422 12/1/2016 AE110 Acoustic 422 12/1/2016 A105 Acoustic-Electric 229 12/15/2016 AE115 Acoustic-Electric 250 12/15/2016 AE100 Acoustic-Electric 422 12/1/2016 AE110 Acoustic-Electric 323 1/1/2016 AE110 Quantity Price/unit Total Amount 10 $149.00 Err:509 3 $209.00 Err:509 10 $179.00 Err:509 10 $309.00 Err:509 13 $79.00 Err:509 12 $209.00 Err:509 6 $119.00 Err:509 4 $99.00 Err:509 5 $209.00 Err:509 3 $209.00 Err:509 10 $99.00 Err:509 4 $99.00 Err:509 10 $149.00 Err:509 4 $179.00 Err:509 10 $79.00 Err:509 7 $309.00 Err:509 5 $99.00 Err:509 3 $209.00 Err:509 3 $209.00 Err:509 3 $99.00 Err:509 9 $179.00 Err:509 10 $119.00 Err:509 12 $149.00 Err:509 3 $209.00 Err:509 12 $149.00 Err:509 15 $79.00 Err:509 5 $149.00 Err:509 10 $79.00 Err:509 10 $179.00 Err:509 3 $209.00 Err:509 6 $119.00 Err:509 15 $149.00 Err:509 4 $209.00 Err:509 5 $209.00 Err:509 3 $209.00 Err:509 4 $99.00 Err:509 3 $249.00 Err:509 8 $149.00 Err:509 5 $209.00 Err:509 5 $209.00 Err:509 2 $409.00 Err:509 5 $119.00 Err:509 3 $149.00 Err:509 10 $79.00 Err:509 10 $179.00 Err:509 5 $149.00 Err:509 3 $209.00 Err:509 5 $149.00 Err:509 10 $179.00 Err:509 11 $179.00 Err:509 Err:508 Precision Instrument Manufacturing 2016 Guitar Sales by Customer Customer Ace Guitar World Type Acoustic-Electric Electric Earle's Guitar Emporium Acoustic Acoustic-Electric Electric Firefly Music and Arts Acoustic Acoustic-Electric Jackson Music School Acoustic Acoustic-Electric Electric Maui Guitar Center Acoustic Acoustic-Electric Electric Patriot's Hill Music Acoustic Acoustic-Electric Electric Starz Music Center Acoustic Acoustic-Electric Electric Westwood Music Academy Acoustic Acoustic-Electric Total Result Data Count - Order # Sum - Quantity 7 4 3 7 2 3 2 5 4 1 6 2 1 3 7 2 4 1 7 2 3 2 6 2 2 2 5 1 4 50 Sum - Total Amount 42 #VALUE! 24 #VALUE! 18 #VALUE! 36 #VALUE! 8 #VALUE! 15 #VALUE! 13 #VALUE! 20 #VALUE! 15 #VALUE! 5 #VALUE! 56 #VALUE! 12 #VALUE! 15 #VALUE! 29 #VALUE! 66 #VALUE! 13 #VALUE! 41 #VALUE! 12 #VALUE! 60 #VALUE! 10 #VALUE! 30 #VALUE! 20 #VALUE! 49 #VALUE! 12 #VALUE! 12 #VALUE! 25 #VALUE! 17 #VALUE! 5 #VALUE! 12 #VALUE! 346 #VALUE! Precision Instrument Manufacturing 2016 Guitar Sales by Model and Month Sum - Quantity Model A100 A105 A110 A115 A120 A150 AE100 AE110 AE115 AE120 E100 E105 E110 Total Result Customer Firefly Music and Arts Starz Music Center Westwood Music Academy Patriot's Hill Music Earle's Guitar Emporium Jackson Music School Maui Guitar Center Maui Guitar Center Earle's Guitar Emporium Starz Music Center Ace Guitar World Firefly Music and Arts Jackson Music School Maui Guitar Center Ace Guitar World Maui Guitar Center Patriot's Hill Music Starz Music Center Ace Guitar World Earle's Guitar Emporium Starz Music Center Westwood Music Academy Earle's Guitar Emporium Maui Guitar Center Jackson Music School Patriot's Hill Music Starz Music Center Ace Guitar World Earle's Guitar Emporium Maui Guitar Center Ace Guitar World Earle's Guitar Emporium Jackson Music School Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 4 4 3 4 10 5 5 5 5 6 6 10 3 3 2 12 3 5 15 10 4 21 10 20 9 5 3 5 3 3 3 3 3 7 10 13 10 10 10 15 10 8 12 3 5 5 12 4 84 13 14 14 15 6 46 80 11 12 8 43 This shape represents a slicer. Slicers are supported in Excel 2010 or later.If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel 2003 or earlier, the slicer cannot be used. Precision Instrument Manufacturing Guitar Sales - Actual and Forecast Electric Acoustic Acoustic Electric Total 2013 $14,973 $45,160 $24,666 $84,799 2014 $14,858 $32,778 $27,140 $74,776 2015 $11,034 $28,282 $28,282 $67,598 2016 $9,865 $25,507 $29,266 $64,638 2017 $9,766 $24,270 $30,309 $64,345 $32,500 $30,000 $27,500 Dollars (U.S.) $25,000 $22,500 $20,000 2013 2014 2015 Year 2016 2017