CompExcel_Pivot_Table_Project_Data(1)

CompExcel_Pivot_Table_Project_Data(1) - Store ID Store City...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Store ID Store City Sale Date Product Type cjm Total $41,987 lok Total $55,828 mwm Total $47,033 Nashua Total $144,848 cew Total $28,927 jss Total $49,002 mtw Total $57,981 tjs Total $39,696 Salem Total $175,606 emm Total $59,559 jse Total $56,237 maj Total $55,241 mmm Total $70,111 Woburn Total $241,148 Grand Total $561,602 Invoice Number Store State Salespers on ID Manufact urer ID Manufacturer Name Product ID Sale Amount Sum of Sale Amount Store ID Product Type 1 2 3 Grand Total Premium Desktop 84919 55077 40576 180572 Premium Notebook 72264 52893 49715 174872 Notebook 40040 26903 22947 89890 Desktop 30839 28383 17457 76679 Inkjet Printer 9892 9056 6767 25715 Laserjet Printer 3194 3294 7386 13874 Grand Total 241148 175606 144848 561602 Data Product TypeSum of 1 Sum of 2 Sum of 3 Premium Not 72264 52893 49715 Premium Des 84919 55077 40576 Notebook 40040 26903 22947 Laserjet Prin 3194 3294 7386 Inkjet Printer 9892 9056 6767 Desktop 30839 28383 17457 Grand Total 241148 175606 144848 The following three product types are selling well at each store: Premium Notebook, Premium Desktop and the Notebook. Based on this analysis, I would recommend each store manager to build up more inventory for those top three best-selling products, and make promotions for those less popular products together with the purchase of best-selling products. In this case, each store can also increase their less Sale Date Jun Sum of Sale Amount Store State Store City MA NH Grand Total Nashua 0.00% 54.03% 26.46% Salem 0.00% 45.97% 22.51% Woburn 100.00% 0.00% 51.03% Grand Total 100.00% 100.00% 100.00% #2: 26.46% of total sales revenue in June were sold in Nashua. 54.03% of total sales revenue in June were generated in NH. Store State NH Sale Date Jan Sum of Sale Amount Store City Nashua Salem Grand Total Total 40.18% 59.82% 100.00% 59.82% of New Hampshire sales revenues in January were generated in the Salem store. Sale Date Mar Sum of Sale Amount Store City Product Type Nashua Salem Woburn Grand Total Desktop 3.53% 4.11% 5.55% 13.19% Inkjet Printer 0.88% 1.76% 1.56% 4.21% Laserjet Printer 1.33% 0.55% 0.66% 2.54% Notebook 4.31% 5.41% 6.57% 16.30% Premium Desktop 5.59% 10.98% 16.33% 32.89% Premium Notebook 8.59% 10.91% 11.36% 30.86% Grand Total 24.23% 33.73% 42.03% 100.00% Sum of Sale Amount Sale Date Manufacturer Name Jan Feb Mar Apr May Jun Grand Total Compaq 3.78% 3.15% 4.87% 2.47% 3.18% 4.55% 22.00% Epson 0.34% 0.22% 0.16% 0.46% 0.40% 0.27% 1.86% Hewlett-Packard 5.75% 3.91% 3.68% 2.18% 3.59% 3.57% 22.68% IBM 0.31% 1.87% 0.65% 1.46% 2.67% 2.52% 9.49% Lexmark 0.47% 0.51% 0.45% 0.47% 0.30% 0.43% 2.62% Sony 5.28% 2.52% 4.31% 5.30% 5.08% 4.95% 27.43% Toshiba 0.72% 3.92% 1.96% 3.39% 1.80% 2.14% 13.93% Grand Total 16.65% 16.10% 16.08% 15.73% 17.02% 18.42% 100.00% Salesperson ID emm Manufacturer Name Sony Count of Product Type Sale Date Product Type Jan Mar Apr May Jun Grand Total Desktop 2 2 Notebook 1 1 2 Premium Desktop 1 1 2 Premium Notebook 2 2 4 Grand Total 2 2 1 2 3 10 Salesperson ID...
View Full Document

This document was uploaded on 11/16/2011.

Page1 / 18

CompExcel_Pivot_Table_Project_Data(1) - Store ID Store City...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online