The following steps may be accomplished by inserting new spreadsheets into the workbook. 8. Analytical Procedures: (without using a Pivot table) Calculate Gross and Net Sales by Customer Calculate Gross Sales by ProductLine/Product Class Calculate Fred Raineys Sales Commission Answer the following Questions: Which Customer bought the most measured by Gross Sales? Which Customer bought the least measured by Gross Sales? Which Customer was most profitable? Which Customer was least profitable?

ExtCost 13350 Qty 150000 1000 50 40 16 12 24 12 24 12 SOID SOLine SODate CustID 1001 1 4/16/16 C573 1002 1 4/21/16 C202 1002 2 4/21/16 C202 1002 3 4/21/16 C202 1002 4 4/21/16 C202 1003 1 4/28/16 C253 1003 2 4/28/16 C253 1003 3 4/28/16 C253 1004 1 5/5/16 C912 1004 2 5/5/16 C912 1005 1 5/18/16 C742 1005 2 5/18/16 C742 1006 1 1 6/1/16 C071 1007 1 6/4/16 C436 1007 2 2 6/4/16 C436 1008 1 6/13/16 C592 1008 2 6/13/16 C592 1008 3 6/13/16 C592 1009 1 7/17/16 C071 1009 2 7/24/16 0071 1010 1 8/4/16 C912 1011 1 8/5/16 C202 1012 1 8/10/16 C573 1013 1 8/11/16 C592 1014 1 8/15/16 C573 1014 2 8/15/16 C573 1014 3 8/15/16 C573 1015 1 8/21/16 C071 1016 1 8/28/16 C253 1016 2 9/21/16 C253 1017 1 10/12/16 C573 1017 2 10/12/16 C573 1018 1 10/22/16 C912 1019 1 11/5/16 C071 1020 1 1 11/10/16 C253 1020 2 11/10/16 C253 1020 3 11/10/16 C253 1021 1 11/15/16 C592 1021 2 11/15/16 C592 1022 1 11/20/16 C436 1022 2 11/20/16 C436 1022 3 11/20/16 C436 . Cust Name General Aerospace Gulfstream Gulfstream Gulfstream Gulfstream Triumph Triumph Triumph Rollys Royce Rollys Royce Honeywell Honeywell Boeing MOOG MOOG Rockwell Collins Rockwell Collins Rockwell Collins Boeing Boeing Rollys Royce Gulfstream General Aerospace Rockwell Collins General Aerospace General Aerospace General Aerospace Boeing Triumph Triumph General Aerospace General Aerospace Rollys Royce Boeing Triumph Triumph Triumph Rockwell Collins Rockwell Collins MOOG MOOG MOOG ItemID Item Name C012 #12 Wire S301 Low Press Switch S1000 Simple Sensor S1100 Low Press Sensor SER100 Installation Services S1000 Simple Sensor S1100 Low Press Sensor S1200 High PressSensor S1300 CorrosiveResistantSensor SER200 Repair Services RH711 Housing-Switch RH811 Housing Sensor S1200 High PressSensor H301 HighToleranceSingleSwitch H302 HighToleranceDualSwitch H301 HighToleranceSingleSwitch H302 High ToleranceDualSwitch SER300 Design Services S1300 CorrosiveResistant Sensor S1300 CorrosiveResistant Sensor S1300 CorrosiveResistantSensor S1000 Simple Sensor RHB11 Housing-Sensor S1400 DiaphramaticSensor S301 Low PressSwitch S302 High PressSwitch SER200 Repair Services S1200 High PressSensor S301 Low PressSwitch S302 High PressSwitch 24-Jun SheetStock - 6 by 24 12-Dec SheetStock - 12 by 12 S1300 CorrosiveResistant Sensor S1200 High Press Sensor 507 ConnectorPackage 9010 Bar Stock 9020 RodStock RHB11 Housing-Sensor SER300 Design Services S1100 Low PressSensor S1200 High Press Sensor S1300 CorrosiveResistant Sensor 50 50 100 50 50 50 50 120 75 35 100 25 75 Price 0.08 77.00 155.00 175.00 150.00 155.00 175.00 225.00 380.00 150.00 35.00 78.00 150.00 110.00 145.00 110.00 145.00 250.00 300.00 300.00 380.00 155.00 78.00 115.00 75.00 95.00 150.00 205.00 75.00 95.00 4.50 3.65 380.00 175.00 47.50 3.00 3.50 78.00 250.00 175.00 215.00 400.00 Cost 0.089 69,000 56.000 67.000 95.000 56.000 67.000 125.000 201.000 105.000 27.500 32.750 125.000 82.000 97.000 82.000 97.000 175.000 201.000 201.000 201.000 56.000 32.750 145.000 69.000 78.500 105.000 125.000 69.000 78.500 3.950 3.360 201.000 125.000 35.000 2.500 2.500 32.750 175.000 67.000 125.000 201.000 ExtPrice 12000 77000 7750 7000 2400 1860 4200 2700 9120 1800 1750 3900 15000 5500 7250 5500 7250 30000 22500 10500 38000 3875 5850 5175 3750 4750 3600 20500 2250 2850 450 1825 38000 17500 1425 300 350 2730 15000 8750 10750 20000 GrossProfit -1350 8000 4950 4320 880 1188 2592 1200 4296 540 375 2262.5 2500 1400 2400 1400 2400 9000 7425 3465 17900 2475 3393.75 -1350 300 FIRESTONE FEL!!!!!!! DI NADIA " !!!?**?!!!! GP Percent -0.1125 0.103896104 0.638709677 0.617142857 0.366666667 0.638709677 0.617142857 0.444444444 0.471052632 0.3 0.214285714 0.580128205 0.166666667 0.254545455 0.331034483 0.254545455 0.331034483 0.3 0.33 0.33 0.471052632 0.638709677 0.580128205 -0.260869565 0.08 0.173684211 0.3 0.390243902 0.08 0.173684211 0.122222222 0.079452055 0.471052632 0.285714286 0.263157895 0.166666667 0.285714286 0.580128205 0.3 0.617142857 0.418604651 0.4975 . 45 . 50 50 24 100 30 30 100 500 100 100 30 100 100 35 60 50 825 1080 8000 180 495 55 145 17900 5000 375 50 100 1583.75 4500 5400 4500 9950 . 50 50 SUM 153624 442660 300559 142101 n/a ExtCost 13350 Qty 150000 1000 50 40 16 12 24 12 24 12 SOID SOLine SODate CustID 1001 1 4/16/16 C573 1002 1 4/21/16 C202 1002 2 4/21/16 C202 1002 3 4/21/16 C202 1002 4 4/21/16 C202 1003 1 4/28/16 C253 1003 2 4/28/16 C253 1003 3 4/28/16 C253 1004 1 5/5/16 C912 1004 2 5/5/16 C912 1005 1 5/18/16 C742 1005 2 5/18/16 C742 1006 1 1 6/1/16 C071 1007 1 6/4/16 C436 1007 2 2 6/4/16 C436 1008 1 6/13/16 C592 1008 2 6/13/16 C592 1008 3 6/13/16 C592 1009 1 7/17/16 C071 1009 2 7/24/16 0071 1010 1 8/4/16 C912 1011 1 8/5/16 C202 1012 1 8/10/16 C573 1013 1 8/11/16 C592 1014 1 8/15/16 C573 1014 2 8/15/16 C573 1014 3 8/15/16 C573 1015 1 8/21/16 C071 1016 1 8/28/16 C253 1016 2 9/21/16 C253 1017 1 10/12/16 C573 1017 2 10/12/16 C573 1018 1 10/22/16 C912 1019 1 11/5/16 C071 1020 1 1 11/10/16 C253 1020 2 11/10/16 C253 1020 3 11/10/16 C253 1021 1 11/15/16 C592 1021 2 11/15/16 C592 1022 1 11/20/16 C436 1022 2 11/20/16 C436 1022 3 11/20/16 C436 . Cust Name General Aerospace Gulfstream Gulfstream Gulfstream Gulfstream Triumph Triumph Triumph Rollys Royce Rollys Royce Honeywell Honeywell Boeing MOOG MOOG Rockwell Collins Rockwell Collins Rockwell Collins Boeing Boeing Rollys Royce Gulfstream General Aerospace Rockwell Collins General Aerospace General Aerospace General Aerospace Boeing Triumph Triumph General Aerospace General Aerospace Rollys Royce Boeing Triumph Triumph Triumph Rockwell Collins Rockwell Collins MOOG MOOG MOOG ItemID Item Name C012 #12 Wire S301 Low Press Switch S1000 Simple Sensor S1100 Low Press Sensor SER100 Installation Services S1000 Simple Sensor S1100 Low Press Sensor S1200 High PressSensor S1300 CorrosiveResistantSensor SER200 Repair Services RH711 Housing-Switch RH811 Housing Sensor S1200 High PressSensor H301 HighToleranceSingleSwitch H302 HighToleranceDualSwitch H301 HighToleranceSingleSwitch H302 High ToleranceDualSwitch SER300 Design Services S1300 CorrosiveResistant Sensor S1300 CorrosiveResistant Sensor S1300 CorrosiveResistantSensor S1000 Simple Sensor RHB11 Housing-Sensor S1400 DiaphramaticSensor S301 Low PressSwitch S302 High PressSwitch SER200 Repair Services S1200 High PressSensor S301 Low PressSwitch S302 High PressSwitch 24-Jun SheetStock - 6 by 24 12-Dec SheetStock - 12 by 12 S1300 CorrosiveResistant Sensor S1200 High Press Sensor 507 ConnectorPackage 9010 Bar Stock 9020 RodStock RHB11 Housing-Sensor SER300 Design Services S1100 Low PressSensor S1200 High Press Sensor S1300 CorrosiveResistant Sensor 50 50 100 50 50 50 50 120 75 35 100 25 75 Price 0.08 77.00 155.00 175.00 150.00 155.00 175.00 225.00 380.00 150.00 35.00 78.00 150.00 110.00 145.00 110.00 145.00 250.00 300.00 300.00 380.00 155.00 78.00 115.00 75.00 95.00 150.00 205.00 75.00 95.00 4.50 3.65 380.00 175.00 47.50 3.00 3.50 78.00 250.00 175.00 215.00 400.00 Cost 0.089 69,000 56.000 67.000 95.000 56.000 67.000 125.000 201.000 105.000 27.500 32.750 125.000 82.000 97.000 82.000 97.000 175.000 201.000 201.000 201.000 56.000 32.750 145.000 69.000 78.500 105.000 125.000 69.000 78.500 3.950 3.360 201.000 125.000 35.000 2.500 2.500 32.750 175.000 67.000 125.000 201.000 ExtPrice 12000 77000 7750 7000 2400 1860 4200 2700 9120 1800 1750 3900 15000 5500 7250 5500 7250 30000 22500 10500 38000 3875 5850 5175 3750 4750 3600 20500 2250 2850 450 1825 38000 17500 1425 300 350 2730 15000 8750 10750 20000 GrossProfit -1350 8000 4950 4320 880 1188 2592 1200 4296 540 375 2262.5 2500 1400 2400 1400 2400 9000 7425 3465 17900 2475 3393.75 -1350 300 FIRESTONE FEL!!!!!!! DI NADIA " !!!?**?!!!! GP Percent -0.1125 0.103896104 0.638709677 0.617142857 0.366666667 0.638709677 0.617142857 0.444444444 0.471052632 0.3 0.214285714 0.580128205 0.166666667 0.254545455 0.331034483 0.254545455 0.331034483 0.3 0.33 0.33 0.471052632 0.638709677 0.580128205 -0.260869565 0.08 0.173684211 0.3 0.390243902 0.08 0.173684211 0.122222222 0.079452055 0.471052632 0.285714286 0.263157895 0.166666667 0.285714286 0.580128205 0.3 0.617142857 0.418604651 0.4975 . 45 . 50 50 24 100 30 30 100 500 100 100 30 100 100 35 60 50 825 1080 8000 180 495 55 145 17900 5000 375 50 100 1583.75 4500 5400 4500 9950 . 50 50 SUM 153624 442660 300559 142101 n/a