ACCT307-Summer2021-DAProject.xlsm

Overview

Data Analytics Project Overview

DUE DATE: Friday, June 25 at 11:59PM

Follow the steps below to complete this assignment (worth 300 points total):

1) The Sales Data worksheet will serve as the dataset for all tasks outlined on the Sales Instructions worksheet. For each task, please complete the steps as specified using various formulas and/or functions in Excel. Each task can be completed using an application of a topic or combination of topics covered in Excel videos. Refer to the content on the Sales Reference worksheet to the extent that you find appropriate.

2) Please note that gross inefficiencies [such as but not limited to (a) using manual text in formulas instead of cell references and (b) inconsistent formulas (where one formula in an array is meaningfully different than the other)] should be avoided whenever possible for full credit to be awarded.

3) Save your Excel file with the name “Last Name.First Name – ACCT 307-01 – DA Project”

When finished:

Submit your final version on Titanium before the deadline. Double check that you have named the file properly and followed all steps to the best of your ability. If you have questions before completion, please do not hesitate to let me know!

DAP Rubric

DA Project

ACCT 307 – Spring 2021

Total Earned Points Total Possible Points 100% (Functional, Amazingly Efficient) 90% (Functional, Very Efficient) 80% (Functional, Somewhat Efficient) 70% (Functional, Lacking Efficiency) 60% (Functional with Minor Flaws) 50% (Functional with Moderate Flaws) 40% (Functional with Severe Flaws) 30% (Not Functional but Close) 20% (Not Functional but Great Attempt) 10% (Not Functional but Decent Attempt) 0% (Missing)

Instruction 1 – Sort 12 1 100% 4%

Instruction 2 – Month 12 2 90% 4%

Instruction 3 – Data Validation 12 3 80% 4%

Instruction 4 – Text Conversion + Sales 84 4 70% 28%

Instruction 5 – COGS 12 5 60% 4%

Instruction 6 – Collections 12 6 50% 4%

Instruction 7 – Pivot Tables 48 7 40% 16%

Instruction 8 – Pivot Charts 48 8 30% 16%

Instruction 9 – MACROs 60 9 20% 20%

Instruction 10 – MACROs (Optional EC) 15 10 10% 5%

TOTAL 0.00 300 11 0% X

0%

Sales Instructions

INSTRUCTIONS:

1) Sort this dataset simultaneously first by Date (oldest to newest) and then by Salesperson (SP-01 to SP-23).

2) To the right of the Date column insert a new column called Month. Populate this column with a formula that extracts the month from the appropriate values in the Date column. You can format the month data however you would like.

3) Use the appropriate technique in the Date column only to create a rule which disallows any values other than those between 1/1/2020 and 12/31/2020.

4) Create a new column called Sales and populate it with the appropriate calculation (in dollars). The calculation is as follows: Sales = [# units * (Product SP/unit per Sales Reference worksheet)] + [# units * (Material SP/unit)] + [# units * (Size SP/unit)]. Before you can perform this calculation, you will need to take information from the Sales Data worksheet and look it up on the information from the Sales Reference worksheet to find each set of values to plug into the formula. In addition, you need to find a way to convert the data from each worksheet to match formats (as opposed to the inconvenient two different formats they have now, i.e., PROD-001 vs. Product 1). As always, you should make sure to show all of your work to the extent that I can verify the methods that you used, and preferably you should use formulas and systematic approaches (i.e., avoiding manually-typed text and judgment). Using helper columns is acceptable. I recommend looking at text manipulation and conditional formulas for the text conversion part of this instruction. Good luck!

5) Create a new column called COGS and populate it with the appropriate calculation (in dollars). The calculation is similar to that for Sales, only using the COGS (instead of the Sales column) information from the Sales Reference worksheet.

6) Create a new column called Collections and populate it with the appropriate calculation (in dollars). Collections = Sales * Collection %.

7) Using Pivot Tables: Create a series of tables. Table A: a table displaying total sales and total collections by salesperson. Table B: a table displaying total sales and total collections by month. Tables C-D: two cross-sectional tables with Table C displaying total sales and Table D total collections, both by salesperson [rows] and month [columns]. Please label the tables 7A, 7B, and 7C-7D accordingly.

8) Using Pivot Chart: Create a series of charts which correspond to the pivot tables 7A, 7B, and 7C-7D. The charts should be intuitive to understand, so for example… what you want to end up with here is something that would make sense to someone in your organization above you who didn’t look at the data but could get questions answered (such as who performed worst/best?, did we have any seasonal trends?, etc.) by looking at your charts. As long as the charts are based on the Pivot Table data, you may use any methods you would like to optimize the visualization of the information, including using duplicates of Pivot Tables (to keep your answer to 7 distinct from Pivot Tables you manipulate for the purposes of visualization).

9) Using MACROs: Create two MACROs. Each MACRO should faithfully replicate the steps involved in each Instruction. Select one instruction to automate from each of the following groupings using the Record Macro function. Name each of your MACROs “MACRO #” where “#” is the number of the instruction you are replicating (i.e., MACRO 3 for Instruction 3).

MACRO 9a: Instruction 1 or 2 or 3

MACRO 9b: Instruction 4 or 5 or 6

10) ** FOR UP TO 7.5 POINTS OF EXTRA CREDIT PER MACRO ** Using MACROs: Create one or two more MACROs. Name each of your MACROs “MACRO #” where “#” is the number of the instruction you are replicating (i.e., MACRO 7 for Instruction 7).

MACRO 10a: Instruction 7

MACRO 10b: Instruction 8

Sales Reference

Product SP / Unit COGS / Unit Material SP / Unit COGS / Unit Size SP / Unit COGS / Unit Customer Location Commissions Calculation

Product 1 $ 2,911 $ 1,747 Gold $ 64 $ 28 XS $ 50 $ 14 Customer 1 MSA 19 Threshold percentage 80.00%

Product 2 $ 9,689 $ 5,523 Silver $ 49 $ 22 S $ 85 $ 27 Customer 2 MSA 59 Commission rate 0.50%

Product 3 $ 6,167 $ 4,502 Bronze $ 38 $ 18 M $ 175 $ 56 Customer 3 MSA 7

Product 4 $ 5,130 $ 2,719 Copper $ 36 $ 16 L $ 330 $ 89 Customer 4 MSA 53

Product 5 $ 5,507 $ 4,406 Brass $ 36 $ 14 XL $ 1,000 $ 410 Customer 5 MSA 63

Product 6 $ 1,315 $ 579 Sapphire $ 32 $ 16 Customer 6 MSA 8

Product 7 $ 1,802 $ 1,189 Ruby $ 30 $ 17 Customer 7 MSA 42

Product 8 $ 2,640 $ 1,716 Emerald $ 28 $ 16 Customer 8 MSA 9

Product 9 $ 9,776 $ 5,866 Topaz $ 27 $ 10 Customer 9 MSA 9

Product 10 $ 4,570 $ 3,016 Jade $ 26 $ 11 Customer 10 MSA 37

Product 11 $ 3,286 $ 2,267 Amethyst $ 26 $ 13 Customer 11 MSA 72

Product 12 $ 9,894 $ 7,816 Garnet $ 25 $ 11 Customer 12 MSA 46

Product 13 $ 2,795 $ 1,286 Aquamarine $ 22 $ 9 Customer 13 MSA 75

Product 14 $ 7,488 $ 5,766 Peridot $ 19 $ 7 Customer 14 MSA 47

Product 15 $ 3,443 $ 2,479 Tanzanite $ 18 $ 9 Customer 15 MSA 4

Product 16 $ 702 $ 442 Opal $ 16 $ 5 Customer 16 MSA 27

Product 17 $ 3,995 $ 1,918 Moonstone $ 15 $ 5 Customer 17 MSA 52

Product 18 $ 8,575 $ 5,831 Jasper $ 14 $ 5 Customer 18 MSA 55

Product 19 $ 4,264 $ 3,155 Citrine $ 11 $ 4 Customer 19 MSA 27

Product 20 $ 9,304 $ 6,234 Quartz $ 10 $ 3 Customer 20 MSA 31

Product 21 $ 4,537 $ 2,813 Customer 21 MSA 51

Product 22 $ 2,765 $ 2,018 Customer 22 MSA 4

Product 23 $ 9,843 $ 6,103 Customer 23 MSA 56

Product 24 $ 4,835 $ 1,982 Customer 24 MSA 38

Product 25 $ 4,351 $ 3,307 Customer 25 MSA 22

Product 26 $ 5,791 $ 3,533 Customer 26 MSA 48

Product 27 $ 5,409 $ 3,786 Customer 27 MSA 23

Product 28 $ 828 $ 571 Customer 28 MSA 62

Product 29 $ 9,342 $ 4,110 Customer 29 MSA 31

Product 30 $ 9,353 $ 5,051 Customer 30 MSA 24

Product 31 $ 8,943 $ 5,008 Customer 31 MSA 44

Product 32 $ 8,451 $ 6,507 Customer 32 MSA 23

Product 33 $ 6,860 $ 3,361 Customer 33 MSA 73

Product 34 $ 6,556 $ 4,524 Customer 34 MSA 65

Product 35 $ 7,161 $ 5,084 Customer 35 MSA 48

Product 36 $ 2,300 $ 1,656 Customer 36 MSA 42

Product 37 $ 6,968 $ 4,041 Customer 37 MSA 29

Product 38 $ 214 $ 146 Customer 38 MSA 71

Product 39 $ 8,499 $ 5,949 Customer 39 MSA 25

Product 40 $ 8,761 $ 5,782 Customer 40 MSA 44

Product 41 $ 9,187 $ 4,685 Customer 41 MSA 21

Product 42 $ 8,235 $ 6,588 Customer 42 MSA 43

Product 43 $ 404 $ 267 Customer 43 MSA 16

Product 44 $ 828 $ 455 Customer 44 MSA 24

Product 45 $ 7,491 $ 5,319 Customer 45 MSA 58

Product 46 $ 8,426 $ 5,393 Customer 46 MSA 75

Product 47 $ 6,727 $ 4,440 Customer 47 MSA 48

Product 48 $ 2,182 $ 1,658 Customer 48 MSA 39

Product 49 $ 8,861 $ 6,646 Customer 49 MSA 35

Product 50 $ 9,657 $ 5,311 Customer 50 MSA 17

Product 51 $ 3,458 $ 1,729 Customer 51 MSA 41

Product 52 $ 4,861 $ 2,333 Customer 52 MSA 22

Product 53 $ 5,680 $ 3,181 Customer 53 MSA 57

Product 54 $ 8,403 $ 6,386 Customer 54 MSA 22

Product 55 $ 9,235 $ 4,618 Customer 55 MSA 30

Product 56 $ 4,419 $ 1,989 Customer 56 MSA 62

Product 57 $ 1,078 $ 636 Customer 57 MSA 60

Product 58 $ 606 $ 255 Customer 58 MSA 55

Product 59 $ 6,625 $ 4,306 Customer 59 MSA 64

Product 60 $ 309 $ 213 Customer 60 MSA 30

Product 61 $ 8,473 $ 3,728 Customer 61 MSA 1

Product 62 $ 3,478 $ 1,600 Customer 62 MSA 7

Product 63 $ 9,134 $ 6,028 Customer 63 MSA 1

Product 64 $ 6,735 $ 3,165 Customer 64 MSA 19

Product 65 $ 876 $ 464 Customer 65 MSA 36

Product 66 $ 5,141 $ 2,622 Customer 66 MSA 60

Product 67 $ 9,067 $ 4,896 Customer 67 MSA 68

Product 68 $ 159 $ 97 Customer 68 MSA 47

Product 69 $ 7,085 $ 3,826 Customer 69 MSA 17

Product 70 $ 9,164 $ 6,965 Customer 70 MSA 19

Product 71 $ 2,194 $ 1,624 Customer 71 MSA 74

Product 72 $ 6,706 $ 4,627 Customer 72 MSA 36

Product 73 $ 9,492 $ 3,987 Customer 73 MSA 39

Product 74 $ 499 $ 309 Customer 74 MSA 13

Product 75 $ 5,459 $ 3,057 Customer 75 MSA 58

Product 76 $ 7,645 $ 4,969 Customer 76 MSA 15

Product 77 $ 6,781 $ 4,679 Customer 77 MSA 19

Product 78 $ 6,457 $ 3,551 Customer 78 MSA 70

Product 79 $ 4,119 $ 1,730 Customer 79 MSA 6

Product 80 $ 5,249 $ 3,517 Customer 80 MSA 30

Product 81 $ 4,567 $ 3,654 Customer 81 MSA 23

Product 82 $ 5,626 $ 3,094 Customer 82 MSA 63

Product 83 $ 6,546 $ 3,797 Customer 83 MSA 39

Product 84 $ 2,033 $ 1,423 Customer 84 MSA 67

Product 85 $ 6,901 $ 4,348 Customer 85 MSA 10

Product 86 $ 1,463 $ 1,053 Customer 86 MSA 19

Product 87 $ 8,174 $ 5,231 Customer 87 MSA 51

Product 88 $ 5,604 $ 3,699 Customer 88 MSA 74

Product 89 $ 4,233 $ 2,751 Customer 89 MSA 14

Product 90 $ 6,761 $ 4,868 Customer 90 MSA 51

Product 91 $ 9,704 $ 5,628 Customer 91 MSA 32

Product 92 $ 2,185 $ 1,573 Customer 92 MSA 13

Product 93 $ 1,658 $ 829 Customer 93 MSA 47

Product 94 $ 7,400 $ 4,440 Customer 94 MSA 49

Product 95 $ 1,123 $ 651 Customer 95 MSA 8

Product 96 $ 5,217 $ 2,922 Customer 96 MSA 41

Product 97 $ 2,399 $ 984 Customer 97 MSA 20

Product 98 $ 9,343 $ 7,007 Customer 98 MSA 68

Product 99 $ 2,352 $ 1,058 Customer 99 MSA 37

Product 100 $ 5,225 $ 2,874 Customer 100 MSA 37

Product 101 $ 6,362 $ 2,736 Customer 101 MSA 24

Product 102 $ 4,920 $ 2,854 Customer 102 MSA 30

Product 103 $ 2,726 $ 1,281 Customer 103 MSA 19

Product 104 $ 2,477 $ 1,759 Customer 104 MSA 37

Product 105 $ 3,360 $ 1,613 Customer 105 MSA 58

Product 106 $ 7,944 $ 6,117 Customer 106 MSA 29

Product 107 $ 9,809 $ 5,199 Customer 107 MSA 59

Product 108 $ 7,854 $ 5,655 Customer 108 MSA 35

Product 109 $ 1,581 $ 996 Customer 109 MSA 12

Product 110 $ 4,829 $ 2,994 Customer 110 MSA 38

Product 111 $ 7,397 $ 5,474 Customer 111 MSA 28

Product 112 $ 3,547 $ 2,660 Customer 112 MSA 36

Product 113 $ 4,953 $ 2,922 Customer 113 MSA 49

Product 114 $ 8,543 $ 6,407 Customer 114 MSA 26

Product 115 $ 9,596 $ 4,414 Customer 115 MSA 51

Product 116 $ 118 $ 57 Customer 116 MSA 5

Product 117 $ 7,144 $ 3,501 Customer 117 MSA 67

Product 118 $ 7,398 $ 5,770 Customer 118 MSA 31

Product 119 $ 9,781 $ 6,847 Customer 119 MSA 6

Product 120 $ 4,756 $ 3,615 Customer 120 MSA 72

Product 121 $ 1,047 $ 764 Customer 121 MSA 28

Product 122 $ 6,574 $ 3,616 Customer 122 MSA 12

Product 123 $ 9,564 $ 7,460 Customer 123 MSA 20

Product 124 $ 1,406 $ 970 Customer 124 MSA 3

Product 125 $ 9,595 $ 7,100 Customer 125 MSA 19

Product 126 $ 4,619 $ 3,695 Customer 126 MSA 70

Product 127 $ 4,904 $ 3,040 Customer 127 MSA 15

Product 128 $ 1,904 $ 1,409 Customer 128 MSA 42

Product 129 $ 7,735 $ 4,100 Customer 129 MSA 57

Product 130 $ 5,732 $ 4,356 Customer 130 MSA 39

Product 131 $ 7,364 $ 4,860 Customer 131 MSA 35

Product 132 $ 8,551 $ 5,473 Customer 132 MSA 2

Product 133 $ 8,892 $ 7,114 Customer 133 MSA 50

Product 134 $ 6,188 $ 4,393 Customer 134 MSA 53

Product 135 $ 6,532 $ 3,005 Customer 135 MSA 54

Product 136 $ 1,699 $ 1,070 Customer 136 MSA 48

Product 137 $ 2,081 $ 874 Customer 137 MSA 41

Product 138 $ 6,604 $ 3,764 Customer 138 MSA 66

Product 139 $ 8,568 $ 6,169 Customer 139 MSA 13

Product 140 $ 7,741 $ 4,954 Customer 140 MSA 19

Product 141 $ 5,814 $ 4,361 Customer 141 MSA 15

Product 142 $ 9,054 $ 4,618 Customer 142 MSA 35

Product 143 $ 3,152 $ 1,954 Customer 143 MSA 54

Product 144 $ 6,645 $ 4,452 Customer 144 MSA 70

Product 145 $ 2,515 $ 1,484 Customer 145 MSA 37

Product 146 $ 9,354 $ 6,735 Customer 146 MSA 18

Product 147 $ 6,487 $ 2,660 Customer 147 MSA 41

Product 148 $ 1,325 $ 570 Customer 148 MSA 66

Product 149 $ 1,868 $ 1,308 Customer 149 MSA 12

Product 150 $ 182 $ 87 Customer 150 MSA 3

Product 151 $ 2,134 $ 1,344

Product 152 $ 6,574 $ 3,221

Product 153 $ 7,826 $ 3,678

Product 154 $ 4,666 $ 2,193

Product 155 $ 407 $ 309

Product 156 $ 4,939 $ 2,618

Product 157 $ 9,663 $ 7,441

Product 158 $ 7,703 $ 6,162

Product 159 $ 5,292 $ 3,810

Product 160 $ 3,780 $ 1,512

Product 161 $ 3,526 $ 2,821

Product 162 $ 8,099 $ 6,074

Product 163 $ 3,328 $ 1,398

Product 164 $ 7,867 $ 4,170

Product 165 $ 9,728 $ 7,588

Product 166 $ 6,122 $ 4,775

Product 167 $ 6,449 $ 3,676

Product 168 $ 711 $ 455

Product 169 $ 9,853 $ 5,321

Product 170 $ 6,115 $ 4,464

Product 171 $ 6,981 $ 4,258

Product 172 $ 9,704 $ 6,405

Product 173 $ 4,083 $ 1,715

Product 174 $ 434 $ 308

Product 175 $ 2,189 $ 1,313

Product 176 $ 9,793 $ 5,582

Product 177 $ 4,290 $ 2,016

Product 178 $ 6,790 $ 2,784

Product 179 $ 1,269 $ 698

Product 180 $ 2,001 $ 1,541

Product 181 $ 3,777 $ 1,586

Product 182 $ 1,255 $ 628

Product 183 $ 5,891 $ 3,299

Product 184 $ 4,758 $ 3,426

Product 185 $ 6,853 $ 4,934

Product 186 $ 1,046 $ 701

Product 187 $ 2,725 $ 1,880

Product 188 $ 695 $ 521

Product 189 $ 7,746 $ 4,260

Product 190 $ 211 $ 97

Product 191 $ 7,925 $ 4,755

Product 192 $ 7,963 $ 3,822

Product 193 $ 2,127 $ 1,106

Product 194 $ 9,165 $ 5,774

Product 195 $ 6,131 $ 3,311

Product 196 $ 819 $ 483

Product 197 $ 1,017 $ 458

Product 198 $ 626 $ 426

Product 199 $ 7,841 $ 4,077

Product 200 $ 1,659 $ 796

Sales Data

Date Salesperson Customer Product Material Size Warehouse # Units Collection %

3/9/20 SP-01 CUST-079 PROD-001 MATL-Copper SIZE-XL MSA-04 94 100%

6/12/20 SP-04 CUST-018 PROD-001 MATL-Amethyst SIZE-S MSA-70 95 100%

6/20/20 SP-05 CUST-029 PROD-001 MATL-Jasper SIZE-XL MSA-31 54 100%

12/13/20 SP-05 CUST-113 PROD-001 MATL-Jasper SIZE-M MSA-25 9 26%

12/14/20 SP-05 CUST-043 PROD-001 MATL-Citrine SIZE-M MSA-20 43 30%

5/5/20 SP-06 CUST-073 PROD-001 MATL-Jasper SIZE-XS MSA-11 55 100%

1/17/20 SP-07 CUST-085 PROD-001 MATL-Garnet SIZE-M MSA-29 36 100%

1/30/20 SP-07 CUST-048 PROD-001 MATL-Amethyst SIZE-XL MSA-27 58 100%

3/22/20 SP-07 CUST-094 PROD-001 MATL-Brass SIZE-M MSA-74 93 100%

5/19/20 SP-07 CUST-108 PROD-001 MATL-Bronze SIZE-XL MSA-62 71 100%

7/25/20 SP-07 CUST-060 PROD-001 MATL-Citrine SIZE-M MSA-47 76 100%

9/29/20 SP-07 CUST-077 PROD-001 MATL-Brass SIZE-XL MSA-72 49 100%

10/20/20 SP-07 CUST-095 PROD-001 MATL-Brass SIZE-L MSA-38 69 100%

10/19/20 SP-08 CUST-129 PROD-001 MATL-Moonstone SIZE-XL MSA-21 17 100%

11/5/20 SP-08 CUST-071 PROD-001 MATL-Topaz SIZE-S MSA-38 54 100%

6/18/20 SP-09 CUST-041 PROD-001 MATL-Sapphire SIZE-XL MSA-45 57 100%

9/14/20 SP-10 CUST-002 PROD-001 MATL-Silver SIZE-S MSA-55 74 100%

8/13/20 SP-11 CUST-112 PROD-001 MATL-Sapphire SIZE-M MSA-39 25 100%

6/6/20 SP-12 CUST-038 PROD-001 MATL-Amethyst SIZE-L MSA-18 38 100%

7/2/20 SP-13 CUST-016 PROD-001 MATL-Brass SIZE-S MSA-66 29 100%

1/27/20 SP-14 CUST-073 PROD-001 MATL-Opal SIZE-S MSA-37 64 100%

4/11/20 SP-14 CUST-136 PROD-001 MATL-Opal SIZE-M MSA-30 98 100%

6/9/20 SP-14 CUST-052 PROD-001 MATL-Bronze SIZE-M MSA-09 26 100%

6/20/20 SP-14 CUST-015 PROD-001 MATL-Quartz SIZE-M MSA-27 86 100%

7/8/20 SP-14 CUST-089 PROD-001 MATL-Moonstone SIZE-M MSA-14 45 100%

7/28/20 SP-14 CUST-148 PROD-001 MATL-Amethyst SIZE-M MSA-44 31 100%

3/30/20 SP-15 CUST-075 PROD-001 MATL-Citrine SIZE-L MSA-75 38 100%

4/15/20 SP-15 CUST-065 PROD-001 MATL-Moonstone SIZE-L MSA-59 12 100%

5/22/20 SP-15 CUST-113 PROD-001 MATL-Moonstone SIZE-XS MSA-62 96 100%

6/25/20 SP-15 CUST-139 PROD-001 MATL-Moonstone SIZE-XS MSA-60 57 100%

6/26/20 SP-15 CUST-097 PROD-001 MATL-Ruby SIZE-S MSA-25 19 100%

7/28/20 SP-15 CUST-071 PROD-001 MATL-Amethyst SIZE-L MSA-75 17 100%

10/20/20 SP-15 CUST-053 PROD-001 MATL-Copper SIZE-M MSA-17 7 0%

4/19/20 SP-16 CUST-064 PROD-001 MATL-Amethyst SIZE-S MSA-57 33 100%

7/15/20 SP-16 CUST-141 PROD-001 MATL-Topaz SIZE-M MSA-71 86 100%

6/14/20 SP-17 CUST-016 PROD-001 MATL-Opal SIZE-L MSA-72 56 100%

11/5/20 SP-17 CUST-135 PROD-001 MATL-Peridot SIZE-L MSA-28 67 100%

12/25/20 SP-17 CUST-146 PROD-001 MATL-Emerald SIZE-L MSA-07 25 36%

3/19/20 SP-18 CUST-007 PROD-001 MATL-Moonstone SIZE-S MSA-54 94 100%

4/26/20 SP-19 CUST-091 PROD-001 MATL-Amethyst SIZE-XL MSA-64 87 100%

5/30/20 SP-20 CUST-017 PROD-001 MATL-Moonstone SIZE-L MSA-08 50 100%

8/6/20 SP-20 CUST-105 PROD-001 MATL-Bronze SIZE-M MSA-52 9 100%

3/6/20 SP-21 CUST-116 PROD-001 MATL-Jade SIZE-M MSA-31 59 100%

6/25/20 SP-21 CUST-085 PROD-001 MATL-Peridot SIZE-S MSA-13 21 100%

8/4/20 SP-21 CUST-048 PROD-001 MATL-Garnet SIZE-S MSA-10 93 100%

10/1/20 SP-21 CUST-049 PROD-001 MATL-Opal SIZE-S MSA-59 29 100%

11/9/20 SP-21 CUST-068 PROD-001 MATL-Copper SIZE-S MSA-17 17 100%

11/30/20 SP-21 CUST-055 PROD-001 MATL-Moonstone SIZE-L MSA-41 70 0%

3/26/20 SP-23 CUST-045 PROD-001 MATL-Topaz SIZE-L MSA-27 75 100%

11/24/20 SP-23 CUST-038 PROD-001 MATL-Ruby SIZE-XS MSA-48 18 54%

4/13/20 SP-01 CUST-124 PROD-002 MATL-Peridot SIZE-S MSA-56 11 0%

5/14/20 SP-01 CUST-114 PROD-002 MATL-Moonstone SIZE-S MSA-11 30 100%

3/5/20 SP-02 CUST-112 PROD-002 MATL-Ruby SIZE-L MSA-42 50 100%

3/16/20 SP-02 CUST-072 PROD-002 MATL-Peridot SIZE-XL MSA-44 86 100%

6/3/20 SP-02 CUST-138 PROD-002 MATL-Silver SIZE-XL MSA-67 12 100%

5/17/20 SP-04 CUST-033 PROD-002 MATL-Copper SIZE-XS MSA-13 28 100%

8/9/20 SP-04 CUST-116 PROD-002 MATL-Copper SIZE-S MSA-49 14 100%

9/21/20 SP-04 CUST-083 PROD-002 MATL-Copper SIZE-XL MSA-36 42 100%

10/30/20 SP-04 CUST-115 PROD-002 MATL-Aquamarine SIZE-XS MSA-28 14 0%

2/15/20 SP-05 CUST-126 PROD-002 MATL-Emerald SIZE-S MSA-09 68 100%

3/4/20 SP-05 CUST-144 PROD-002 MATL-Peridot SIZE-M MSA-48 45 100%

4/11/20 SP-05 CUST-026 PROD-002 MATL-Copper SIZE-L MSA-16 2 100%

7/30/20 SP-05 CUST-097 PROD-002 MATL-Gold SIZE-XS MSA-73 70 100%

10/3/20 SP-05 CUST-014 PROD-002 MATL-Peridot SIZE-M MSA-55 30 100%

10/16/20 SP-05 CUST-148 PROD-002 MATL-Tanzanite SIZE-XS MSA-26 96 100%

11/28/20 SP-05 CUST-085 PROD-002 MATL-Quartz SIZE-L MSA-20 60 46%

7/28/20 SP-06 CUST-077 PROD-002 MATL-Topaz SIZE-L MSA-63 95 100%

9/2/20 SP-06 CUST-136 PROD-002 MATL-Emerald SIZE-S MSA-23 90 100%

1/31/20 SP-07 CUST-045 PROD-002 MATL-Amethyst SIZE-XS MSA-53 27 100%

7/18/20 SP-07 CUST-019 PROD-002 MATL-Tanzanite SIZE-M MSA-55 88 100%

9/23/20 SP-07 CUST-082 PROD-002 MATL-Gold SIZE-L MSA-56 27 100%

6/6/20 SP-08 CUST-148 PROD-002 MATL-Brass SIZE-XS MSA-43 88 100%

8/23/20 SP-08 CUST-066 PROD-002 MATL-Moonstone SIZE-XL MSA-30 64 100%

4/3/20 SP-09 CUST-126 PROD-002 MATL-Copper SIZE-M MSA-20 93 100%

11/25/20 SP-09 CUST-039 PROD-002 MATL-Gold SIZE-M MSA-59 4 74%

4/13/20 SP-11 CUST-013 PROD-002 MATL-Topaz SIZE-XS MSA-07 87 100%

6/28/20 SP-11 CUST-148 PROD-002 MATL-Moonstone SIZE-L MSA-45 91 100%

8/2/20 SP-11 CUST-035 PROD-002 MATL-Peridot SIZE-XL MSA-22 32 100%

4/11/20 SP-12 CUST-116 PROD-002 MATL-Aquamarine SIZE-S MSA-32 53 100%

11/21/20 SP-12 CUST-075 PROD-002 MATL-Citrine SIZE-S MSA-30 81 100%

8/18/20 SP-13 CUST-137 PROD-002 MATL-Garnet SIZE-M MSA-66 77 100%

1/21/20 SP-14 CUST-143 PROD-002 MATL-Ruby SIZE-XL MSA-31 17 100%

3/12/20 SP-14 CUST-130 PROD-002 MATL-Citrine SIZE-L MSA-25 1 100%

8/29/20 SP-14 CUST-048 PROD-002 MATL-Emerald SIZE-XS MSA-42 56 100%

4/19/20 SP-15 CUST-115 PROD-002 MATL-Quartz SIZE-XS MSA-15 57 100%

9/5/20 SP-15 CUST-147 PROD-002 MATL-Garnet SIZE-L MSA-04 47 0%

11/6/20 SP-15 CUST-088 PROD-002 MATL-Jade SIZE-M MSA-23 36 0%

6/7/20 SP-16 CUST-043 PROD-002 MATL-Tanzanite SIZE-M MSA-51 61 100%

10/6/20 SP-16 CUST-030 PROD-002 MATL-Garnet SIZE-M MSA-45 59 100%

10/13/20 SP-16 CUST-002 PROD-002 MATL-Jade SIZE-M MSA-16 46 100%

10/15/20 SP-16 CUST-106 PROD-002 MATL-Gold SIZE-L MSA-27 64 100%

11/13/20 SP-16 CUST-133 PROD-002 MATL-Copper SIZE-XL MSA-20 50 0%

3/12/20 SP-18 CUST-109 PROD-002 MATL-Citrine SIZE-XL MSA-16 62 100%

7/9/20 SP-18 CUST-136 PROD-002 MATL-Aquamarine SIZE-L MSA-04 46 100%

9/18/20 SP-18 CUST-124 PROD-002 MATL-Sapphire SIZE-XS MSA-71 100 100%

11/3/20 SP-18 CUST-032 PROD-002 MATL-Emerald SIZE-XL MSA-61 30 100%

11/25/20 SP-18 CUST-012 PROD-002 MATL-Sapphire SIZE-L MSA-03 76 75%

4/27/20 SP-20 CUST-057 PROD-002 MATL-Copper SIZE-S MSA-20 96 100%

10/4/20 SP-20 CUST-093 PROD-002 MATL-Ruby SIZE-L MSA-58 61 100%

11/22/20 SP-20 CUST-083 PROD-002 MATL-Ruby SIZE-L MSA-72 59 76%

2/29/20 SP-21 CUST-039 PROD-002 MATL-Amethyst SIZE-S MSA-20 21 100%

6/27/20 SP-21 CUST-084 PROD-002 MATL-Peridot SIZE-M MSA-75 20 100%

7/5/20 SP-21 CUST-081 PROD-002 MATL-Jasper SIZE-S MSA-18 11 100%

7/22/20 SP-21 CUST-021 PROD-002 MATL-Aquamarine SIZE-XS MSA-09 100 100%

10/20/20 SP-21 CUST-013 PROD-002 MATL-Copper SIZE-L MSA-56 54 100%

3/18/20 SP-22 CUST-067 PROD-002 MATL-Aquamarine SIZE-S MSA-22 59 100%

3/31/20 SP-23 CUST-007 PROD-002 MATL-Emerald SIZE-L MSA-67 66 100%

11/21/20 SP-23 CUST-063 PROD-002 MATL-Copper SIZE-XS MSA-20 16 45%

12/12/20 SP-23 CUST-119 PROD-002 MATL-Brass SIZE-S MSA-35 31 73%

4/28/20 SP-01 CUST-146 PROD-003 MATL-Gold SIZE-XS MSA-03 99 100%

6/7/20 SP-01 CUST-129 PROD-003 MATL-Tanzanite SIZE-XS MSA-58 58 100%

3/12/20 SP-02 CUST-012 PROD-003 MATL-Bronze SIZE-L MSA-75 57 100%

8/25/20 SP-02 CUST-140 PROD-003 MATL-Bronze SIZE-L MSA-12 72 100%

1/8/20 SP-03 CUST-093 PROD-003 MATL-Garnet SIZE-XL MSA-62 39 100%

3/31/20 SP-04 CUST-062 PROD-003 MATL-Aquamarine SIZE-XL MSA-55 30 100%

5/4/20 SP-04 CUST-141 PROD-003 MATL-Opal SIZE-L MSA-10 55 100%

8/6/20 SP-04 CUST-018 PROD-003 MATL-Jasper SIZE-S MSA-68 33 100%

8/7/20 SP-04 CUST-101 PROD-003 MATL-Topaz SIZE-XL MSA-67 12 100%

12/5/20 SP-04 CUST-029 PROD-003 MATL-Brass SIZE-S MSA-32 87 67%

3/6/20 SP-05 CUST-119 PROD-003 MATL-Jade SIZE-M MSA-26 1 100%

12/15/20 SP-05 CUST-102 PROD-003 MATL-Silver SIZE-XS MSA-53 95 99%

12/15/20 SP-05 CUST-019 PROD-003 MATL-Citrine SIZE-XS MSA-23 69 55%

1/26/20 SP-06 CUST-107 PROD-003 MATL-Moonstone SIZE-XS MSA-56 66 100%

12/5/20 SP-06 CUST-025 PROD-003 MATL-Jasper SIZE-XS MSA-39 94 0%

2/22/20 SP-07 CUST-123 PROD-003 MATL-Quartz SIZE-XL MSA-71 88 100%

3/27/20 SP-07 CUST-150 PROD-003 MATL-Peridot SIZE-L MSA-22 64 100%

3/28/20 SP-07 CUST-142 PROD-003 MATL-Moonstone SIZE-L MSA-23 19 100%

4/5/20 SP-07 CUST-129 PROD-003 MATL-Jasper SIZE-L MSA-01 34 100%

5/8/20 SP-07 CUST-095 PROD-003 MATL-Silver SIZE-L MSA-24 68 100%

11/29/20 SP-07 CUST-062 PROD-003 MATL-Sapphire SIZE-XL MSA-75 32 72%

11/21/20 SP-08 CUST-023 PROD-003 MATL-Topaz SIZE-XS MSA-35 76 100%

2/3/20 SP-09 CUST-080 PROD-003 MATL-Silver SIZE-L MSA-03 89 0%

3/30/20 SP-09 CUST-017 PROD-003 MATL-Ruby SIZE-XL MSA-30 15 100%

5/30/20 SP-09 CUST-099 PROD-003 MATL-Peridot SIZE-XS MSA-55 33 100%

8/25/20 SP-09 CUST-098 PROD-003 MATL-Jade SIZE-L MSA-30 48 100%

9/24/20 SP-09 CUST-116 PROD-003 MATL-Peridot SIZE-XL MSA-07 1 100%

4/22/20 SP-10 CUST-042 PROD-003 MATL-Brass SIZE-L MSA-08 79 100%

1/26/20 SP-11 CUST-015 PROD-003 MATL-Opal SIZE-S MSA-52 2 100%

2/18/20 SP-11 CUST-055 PROD-003 MATL-Opal SIZE-L MSA-47 56 100%

9/17/20 SP-11 CUST-131 PROD-003 MATL-Topaz SIZE-L MSA-37 85 0%

9/20/20 SP-11 CUST-008 PROD-003 MATL-Quartz SIZE-S MSA-29 83 100%

2/10/20 SP-12 CUST-128 PROD-003 MATL-Brass SIZE-XS MSA-08 22 100%

6/3/20 SP-12 CUST-071 PROD-003 MATL-Bronze SIZE-L MSA-14 81 100%

1/10/20 SP-13 CUST-090 PROD-003 MATL-Brass SIZE-XL MSA-49 84 0%

3/17/20 SP-13 CUST-054 PROD-003 MATL-Amethyst SIZE-L MSA-20 99 95%

1/17/20 SP-15 CUST-006 PROD-003 MATL-Quartz SIZE-M MSA-57 47 100%

2/6/20 SP-15 CUST-065 PROD-003 MATL-Peridot SIZE-L MSA-11 49 100%

3/7/20 SP-15 CUST-008 PROD-003 MATL-Jade SIZE-L MSA-08 10 100%

7/1/20 SP-15 CUST-109 PROD-003 MATL-Brass SIZE-L MSA-32 27 100%

12/29/20 SP-15 CUST-062 PROD-003 MATL-Jasper SIZE-XS MSA-01 82 0%

6/7/20 SP-16 CUST-132 PROD-003 MATL-Copper SIZE-L MSA-28 78 100%

11/5/20 SP-16 CUST-059 PROD-003 MATL-Topaz SIZE-S MSA-50 12 0%

3/20/20 SP-17 CUST-072 PROD-003 MATL-Silver SIZE-XS MSA-37 23 100%

5/3/20 SP-17 CUST-134 PROD-003 MATL-Peridot SIZE-M MSA-15 71 100%

4/4/20 SP-18 CUST-077 PROD-003 MATL-Emerald SIZE-XL MSA-04 93 100%

5/10/20 SP-18 CUST-097 PROD-003 MATL-Bronze SIZE-M MSA-52 9 100%

9/3/20 SP-18 CUST-120 PROD-003 MATL-Bronze SIZE-M MSA-29 27 100%

2/1/20 SP-19 CUST-117 PROD-003 MATL-Copper SIZE-M MSA-08 88 100%

1/17/20 SP-20 CUST-023 PROD-003 MATL-Garnet SIZE-S MSA-29 38 100%

9/15/20 SP-20 CUST-059 PROD-003 MATL-Peridot SIZE-XS MSA-10 45 100%

2/25/20 SP-21 CUST-149 PROD-003 MATL-Tanzanite SIZE-L MSA-35 88 100%

5/14/20 SP-21 CUST-142 PROD-003 MATL-Quartz SIZE-XS MSA-04 14 100%

9/9/20 SP-21 CUST-083 PROD-003 MATL-Jasper SIZE-XL MSA-50 62 100%

9/10/20 SP-21 CUST-139 PROD-003 MATL-Garnet SIZE-S MSA-54 83 100%

6/30/20 SP-22 CUST-082 PROD-003 MATL-Garnet SIZE-XS MSA-31 61 100%

3/27/20 SP-23 CUST-037 PROD-003 MATL-Quartz SIZE-XL MSA-26 85 100%

11/10/20 SP-23 CUST-024 PROD-003 MATL-Tanzanite SIZE-XS MSA-08 2 100%

11/30/20 SP-23 CUST-072 PROD-003 MATL-Citrine SIZE-L MSA-50 76 42%

6/14/20 SP-01 CUST-053 PROD-004 MATL-Jasper SIZE-XS MSA-51 42 100%

6/20/20 SP-01 CUST-006 PROD-004 MATL-Gold SIZE-L MSA-50 36 100%

7/28/20 SP-01 CUST-013 PROD-004 MATL-Gold SIZE-S MSA-62 35 100%

7/28/20 SP-01 CUST-083 PROD-004 MATL-Moonstone SIZE-XL MSA-40 92 100%

2/5/20 SP-02 CUST-016 PROD-004 MATL-Brass SIZE-M MSA-01 62 100%

3/6/20 SP-02 CUST-110 PROD-004 MATL-Silver SIZE-XS MSA-13 74 100%

3/16/20 SP-02 CUST-082 PROD-004 MATL-Bronze SIZE-XL MSA-51 58 100%

6/4/20 SP-02 CUST-005 PROD-004 MATL-Aquamarine SIZE-L MSA-17 76 100%

8/7/20 SP-02 CUST-116 PROD-004 MATL-Topaz SIZE-M MSA-44 7 100%

11/29/20 SP-02 CUST-063 PROD-004 MATL-Citrine SIZE-L MSA-51 96 30%

1/31/20 SP-03 CUST-100 PROD-004 MATL-Topaz SIZE-L MSA-42 74 100%

2/21/20 SP-03 CUST-110 PROD-004 MATL-Silver SIZE-XL MSA-07 32 100%

3/26/20 SP-03 CUST-069 PROD-004 MATL-Tanzanite SIZE-XL MSA-39 39 100%

9/25/20 SP-03 CUST-125 PROD-004 MATL-Tanzanite SIZE-XS MSA-09 85 100%

1/30/20 SP-04 CUST-112 PROD-004 MATL-Copper SIZE-S MSA-15 27 100%

2/21/20 SP-04 CUST-034 PROD-004 MATL-Emerald SIZE-L MSA-12 77 100%

6/18/20 SP-04 CUST-092 PROD-004 …

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 929 473-0077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 30% with the discount code GURUH