Artifact AssignmentArtifact 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 data2. 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 spaced5. 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 IDPrentice East $21,223 $17,855 $24,855 $21,377 $85,310 $21,328 $24,855 $17,855 $3,412 S1001Chirillo Northeast $23,456 $29,550 $24,294 $25,335 $102,635 $25,659 $29,550 $23,456 $4,105 S1002Wong West $19,954 $22,600 $19,448 $26,450 $88,452 $22,113 $26,450 $19,448 $3,538 S1003Baker South $17,564 $25,439 $32,944 $24,000 $99,947 $24,987 $32,944 $17,564 $3,998 S1004Richards North $28,543 $28,540 $24,400 $28,550 $110,033 $27,508 $28,550 $24,400 $4,401 S1005Hite East $19,534 $30,558 $21,844 $19,605 $91,541 $22,885 $30,558 $19,534 $3,662 S1006de 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 S1008Howard North $30,332 $27,407 $26,440 $24,007 $108,186 $27,047 $30,332 $24,007 $4,327 S1009Kerstetter Southwest $27,595 $22,933 $22,422 $21,445 $94,395 $23,599 $27,595 $21,445 $3,776 S1010Morris East $25,395 $27,700 $16,500 $27,500 $97,095 $24,274 $27,700 $16,500 $3,884 S1011Lewis South $35,822 $31,854 $24,384 $31,005 $123,065 $30,766 $35,822 $24,384 $4,923 S1012Jefferson Southwest $20,949 $23,100 $21,774 $27,550 $93,373 $23,343 $27,550 $20,949 $3,735 S1013Patrino West $30,113 $19,554 $25,300 $16,455 $91,422 $22,856 $30,113 $16,455 $3,657 S1014Trowns-Hale Mid Atlantic $18,432 $27,500 $24,399 $70,331 $23,444 $27,500 $18,432 $2,813 S1015Nguyen Southeast $20,995 $24,960 $21,950 $24,855 $92,760 $23,190 $24,960 $20,995 $3,710 S1016Johnsen East $19,668 $18,850 $21,355 $20,540 $80,413 $20,103 $21,355 $18,850 $3,217 S1017OBrien North $26,046 $24,845 $28,575 $22,555 $102,021 $25,505 $28,575 $22,555 $4,081 S1018Tantalo Southwest $18,366 $23,846 $26,587 $28,456 $97,255 $24,314 $28,456 $18,366 $3,890 S1019Parker West $32,007 $28,095 $27,497 $21,687 $109,286 $27,322 $32,007 $21,687 $4,371 S1020Blaisedell Midwest $29,332 $26,489 $25,656 $28,057 $109,534 $27,384 $29,332 $25,656 $4,381 S1021Capuano East $16,494 $21,374 $24,294 $26,487 $88,649 $22,162 $26,487 $16,494 $3,546 S1022Nihil Northeast $21,084 $24,217 $32,804 $27,044 $105,149 $26,287 $32,804 $21,084 $4,206 S1023Arthur Southeast $18,456 $23,654 $28,560 $27,475 $98,145 $24,536 $28,560 $18,456 $3,926 S1024Specter North $29,566 $24,637 $25,831 $32,564 $112,598 $28,150 $32,564 $24,637 $4,504 S1025Klump West $30,543 $27,237 $18,934 $26,945 $103,659 $25,915 $30,543 $18,934 $4,146 S1026George Northeast $15,776 $21,759 $24,370 $29,316 $91,221 $22,805 $29,316 $15,776 $3,649 S1027Fredricks South $26,427 $23,869 $28,503 $26,190 $104,989 $26,247 $28,503 $23,869 $4,200 S1028Spittler Southeast $22,066 $25,313 $26,440 $37,438 $111,257 $27,814 $37,438 $22,066 $4,450 S1029Hernandez Southwest $19,967 $30,528 $27,047 $29,411 $106,953 $26,738 $30,528 $19,967 $4,278 S1030Little East $31,740 $27,475 $27,994 $36,895 $124,104 $31,026 $36,895 $27,475 $4,964 S1031Iwamoto North $28,755 $29,952 $25,349 $28,485 $112,541 $28,135 $29,952 $25,349 $4,502 S1032Davies Midwest $21,665 $20,638 $27,368 $14,787 $84,458 $21,115 $27,368 $14,787 $3,378 S1033Fowler South $32,496 $23,426 $27,648 $27,365 $110,935 $27,734 $32,496 $23,426 $4,437 S1034Graciele West $19,953 $31,364 $20,143 $38,564 $110,024 $27,506 $38,564 $19,953 $4,401 S1035Sandoval Northwest $27,749 $26,489 $18,897 $31,659 $104,794 $26,199 $31,659 $18,897 $4,192 S1036Amberson Southeast $19,089 $22,474 $26,579 $31,854 $99,996 $24,999 $31,854 $19,089 $4,000 S1037Edward North $24,445 $37,534 $28,543 $22,749 $113,271 $28,318 $37,534 $22,749 $4,531 S1038Brooks Southwest $38,953 $17,449 $26,538 $25,967 $108,907 $27,227 $38,953 $17,449 $4,356 S1039Humbert East $17,066 $26,409 $24,769 $37,557 $105,801 $26,450 $37,557 $17,066 $4,232 S1040Marino Northeast $24,286 $25,396 $27,456 $17,463 $94,601 $23,650 $27,456 $17,463 $3,784 S1041Patterson Southeast $22,779 $18,803 $25,317 $29,426 $96,325 $24,081 $29,426 $18,803 $3,853 S1042Truscott West $16,579 $23,946 $38,166 $26,703 $105,394 $26,349 $38,166 $16,579 $4,216 S1043MacMurtrie Midwest $28,365 $16,887 $31,957 $23,894 $101,103 $25,276 $31,957 $16,887 $4,044 S1044Bowser South $22,749 $26,358 $27,485 $17,940 $94,532 $23,633 $27,485 $17,940 $3,781 S1045Marianetti North $19,955 $28,542 $29,577 $24,500 $102,574 $25,644 $29,577 $19,955 $4,103 S1046Everett Mideast $28,640 $19,945 $28,865 $18,552 $96,002 $24,001 $28,865 $18,552 $3,840 S1047Rebondot West $33,266 $17,603 $26,345 $16,879 $94,093 $23,523 $33,266 $16,879 $3,764 S1048Shelton Northwest $39,543 $26,489 $18,609 $27,470 $112,111 $28,028 $39,543 $18,609 $4,484 S1049Yang South $18,232 $29,869 $30,253 $32,776 $111,130 $27,783 $32,776 $18,232 $4,445 S1050Quincy Mideast $22,654 $27,543 $36,475 $15,377 $102,049 $25,512 $36,475 $15,377 $4,082 S1051Bradford East $26,835 $22,557 $14,568 $25,432 $89,392 $22,348 $26,835 $14,568 $3,576 S1052