Artifact Assignment
-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 data
2. Create at least 5 different data charts that communicate important information using the attached spreadsheet.
3. Provide a narrative (Executive Summary) 1 page double spaced- & REFER to each graph on narative.
4. Develop an implementation plan- 1 page double spaced
5. Identify an important KPI from Part Three and Part Four(GROSS PROFIT MARGIN& OPERATING PROFIT MARGIN) that would be important to
measure (provide the equation / calculate if all data is available / Explain why tracking this KPI would be important)
PLEASE SHOW ANY CORRELATION for example _ the temperature drops so then the winter clothes sales go up…= a negative correlation..
Correlation (relationship) show wether it is a positive or negative effect —- causation and correlation.
Include informatin about the Learning outcomes touched up in class
– Competency Learning Outcome#1- Types of Data: Understand the importance and roles of different types of data (financial, economic,
accounting, etc.)
-Competency Learning Outcome#2 -Data Identification- Identify and select data that should be collected for various purposes within the
organization.
Competency Learning Outcome#3 Data Collection- Utilize varied methodologies for collecting necessary data.
Competency Learning Outcome#4- Data Presentation- Select and utilize appropriate formats for presentations and/or analysis of data
Sales Ledger
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
Chirillo Northeast $23,456 $29,550 $24,294 $25,335 $102,635 $25,659 $29,550 $23,456 $4,105 S1002
Wong West $19,954 $22,600 $19,448 $26,450 $88,452 $22,113 $26,450 $19,448 $3,538 S1003
Baker 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