Artifact Assignment

Refer to the sales data on the attached Excel spreadsheet I provided you.Refer to the sales data on the attached Excel spreadsheet I provided you.Use Excel to develop charts or graphs of what you think is relevant or important to know if you were the manager of this company with this sales data.There must be a narrative portion to this assignment—that is the Executive Summary. The Executive Summary should be at least one page, double-spaced. It should describe what it is you are analyzing, what you are looking for, the conclusions, and recommendations that would help your company improve.
Using the attached data file complete the following:1. Complete an analysis of the data2. Create at least 5 different data charts that communicate important information3. Provide a narrative (Executive Summary)4. Develop an implementation plan5. Identify an important KPI from Part Three and Part Four that would be important to measure (provide the equation / calculate if all data is available / Explain why tracking this KPI would be important)
27-Jun-2012 Commission rate 4% Total number of employees 18 Employees resigned 1Sales Ledger Top 3 Employees: Name Region Q1 Q2 Q3 Q4 Total Average Highest Lowest Commission Employee ID Prentice East $21,223 $17,855 $24,855 $21,377 $85,310 $21,328 $24,855 $17,855 $3,412 S1001 Enrique Lewis $30,766Chirillo Northeast $23,456 $29,550 $24,294 $25,335 $102,635 $25,659 $29,550 $23,456 $4,105 S1002 Sam Richards $27,508Wong West $19,954 $22,600 $19,448 $26,450 $88,452 $22,113 $26,450 $19,448 $3,538 S1003 Oscar Howard $27,047Baker South $17,564 $25,439 $32,944 $24,000 $99,947 $24,987 $32,944 $17,564 $3,998 S1004 Richards North $28,543 $28,540 $24,400 $28,550 $110,033 $27,508 $28,550 $24,400 $4,401 S1005 Hite East $19,534 $30,558 $21,844 $19,605 $91,541 $22,885 $30,558 $19,534 $3,662 S1006 de Moret West $20,585 $29,667 $27,595 $13,605 $91,452 $22,863 $29,667 $13,605 $3,658 McWilliams South $24,957 $31,322 $15,330 $27,550 $99,159 $24,790 $31,322 $15,330 $3,966 S1008 Howard North $30,332 $27,407 $26,440 $24,007 $108,186 $27,047 $30,332 $24,007 $4,327 S1009 Kerstetter Southwest $27,595 $22,933 $22,422 $21,445 $94,395 $23,599 $27,595 $21,445 $3,776 S1010 Morris East $25,395 $27,700 $16,500 $27,500 $97,095 $24,274 $27,700 $16,500 $3,884 S1011 Lewis South $35,822 $31,854 $24,384 $31,005 $123,065 $30,766 $35,822 $24,384 $4,923 S1012 Jefferson Southwest $20,949 $23,100 $21,774 $27,550 $93,373 $23,343 $27,550 $20,949 $3,735 S1013 Patrino West $30,113 $19,554 $25,300 $16,455 $91,422 $22,856 $30,113 $16,455 $3,657 S1014 Trowns-Hale Mid Atlantic $18,432 $27,500 $24,399 $70,331 $23,444 $27,500 $18,432 $2,813 S1015 Nguyen Southeast $20,995 $24,960 $21,950 $24,855 $92,760 $23,190 $24,960 $20,995 $3,710 S1016 Johnsen East $19,668 $18,850 $21,355 $20,540 $80,413 $20,103 $21,355 $18,850 $3,217 S1017 OBrien North $26,046 $24,845 $28,575 $22,555 $102,021 $25,505 $28,575 $22,555 $4,081 S1018 Tantalo Southwest $18,366 $23,846 $26,587 $28,456 $97,255 $24,314 $28,456 $18,366 $3,890 S1019 Parker West $32,007 $28,095 $27,497 $21,687 $109,286 $27,322 $32,007 $21,687 $4,371 S1020 Blaisedell Midwest $29,332 $26,489 $25,656 $28,057 $109,534 $27,384 $29,332 $25,656 $4,381 S1021 Capuano East $16,494 $21,374 $24,294 $26,487 $88,649 $22,162 $26,487 $16,494 $3,546 S1022 Nihil Northeast $21,084 $24,217 $32,804 $27,044 $105,149 $26,287 $32,804 $21,084 $4,206 S1023 Arthur Southeast $18,456 $23,654 $28,560 $27,475 $98,145 $24,536 $28,560 $18,456 $3,926 S1024 Specter North $29,566 $24,637 $25,831 $32,564 $112,598 $28,150 $32,564 $24,637 $4,504 S1025 Klump West $30,543 $27,237 $18,934 $26,945 $103,659 $25,915 $30,543 $18,934 $4,146 S1026 George Northeast $15,776 $21,759 $24,370 $29,316 $91,221 $22,805 $29,316 $15,776 $3,649 S1027 Fredricks South $26,427 $23,869 $28,503 $26,190 $104,989 $26,247 $28,503 $23,869 $4,200 S1028 Spittler Southeast $22,066 $25,313 $26,440 $37,438 $111,257 $27,814 $37,438 $22,066 $4,450 S1029 Hernandez Southwest $19,967 $30,528 $27,047 $29,411 $106,953 $26,738 $30,528 $19,967 $4,278 S1030 Little East $31,740 $27,475 $27,994 $36,895 $124,104 $31,026 $36,895 $27,475 $4,964 S1031 Iwamoto North $28,755 $29,952 $25,349 $28,485 $112,541 $28,135 $29,952 $25,349 $4,502 S1032 Davies Midwest $21,665 $20,638 $27,368 $14,787 $84,458 $21,115 $27,368 $14,787 $3,378 S1033 Fowler South $32,496 $23,426 $27,648 $27,365 $110,935 $27,734 $32,496 $23,426 $4,437 S1034 Graciele West $19,953 $31,364 $20,143 $38,564 $110,024 $27,506 $38,564 $19,953 $4,401 S1035 Sandoval Northwest $27,749 $26,489 $18,897 $31,659 $104,794 $26,199 $31,659 $18,897 $4,192 S1036 Amberson Southeast $19,089 $22,474 $26,579 $31,854 $99,996 $24,999 $31,854 $19,089 $4,000 S1037 Edward North $24,445 $37,534 $28,543 $22,749 $113,271 $28,318 $37,534 $22,749 $4,531 S1038 Brooks Southwest $38,953 $17,449 $26,538 $25,967 $108,907 $27,227 $38,953 $17,449 $4,356 S1039 Humbert East $17,066 $26,409 $24,769 $37,557 $105,801 $26,450 $37,557 $17,066 $4,232 S1040 Marino Northeast $24,286 $25,396 $27,456 $17,463 $94,601 $23,650 $27,456 $17,463 $3,784 S1041 Patterson Southeast $22,779 $18,803 $25,317 $29,426 $96,325 $24,081 $29,426 $18,803 $3,853 S1042 Truscott West $16,579 $23,946 $38,166 $26,703 $105,394 $26,349 $38,166 $16,579 $4,216 S1043 MacMurtrie Midwest $28,365 $16,887 $31,957 $23,894 $101,103 $25,276 $31,957 $16,887 $4,044 S1044 Bowser South $22,749 $26,358 $27,485 $17,940 $94,532 $23,633 $27,485 $17,940 $3,781 S1045 Marianetti North $19,955 $28,542 $29,577 $24,500 $102,574 $25,644 $29,577 $19,955 $4,103 S1046 Everett Mideast $28,640 $19,945 $28,865 $18,552 $96,002 $24,001 $28,865 $18,552 $3,840 S1047 Rebondot West $33,266 $17,603 $26,345 $16,879 $94,093 $23,523 $33,266 $16,879 $3,764 S1048 Shelton Northwest $39,543 $26,489 $18,609 $27,470 $112,111 $28,028 $39,543 $18,609 $4,484 S1049 Yang South $18,232 $29,869 $30,253 $32,776 $111,130 $27,783 $32,776 $18,232 $4,445 S1050 Quincy Mideast $22,654 $27,543 $36,475 $15,377 $102,049 $25,512 $36,475 $15,377 $4,082 S1051 Bradford East $26,835 $22,557 $14,568 $25,432 $89,392 $22,348 $26,835 $14,568 $3,576 S1052

READ ALSO :   project cycles