QNT/275 University of Phoenix
kelvinfsQNT275r7WeeklyDataSets.xlsx
Week 2
Sample Car # | Color | MPG | Suggest Retail Price | Option Package | Days in Inventory |
1 | Grey | 27.6 | $ 24,390.00 | LX | 1 |
2 | Grey | 32.4 | $ 21,780.00 | Touring | 10 |
3 | Blue | 33.2 | $ 21,149.00 | Touring | 28 |
4 | Black | 34.7 | $ 22,069.00 | LX | 21 |
5 | Blue | 27.2 | $ 22,532.00 | Touring | 16 |
6 | Blue | 26.6 | $ 20,345.00 | Touring | 22 |
7 | Red | 37.3 | $ 22,112.00 | EX | 12 |
8 | Silver | 34.9 | $ 21,289.00 | Touring | 23 |
9 | Silver | 29.6 | $ 24,871.00 | LX | 15 |
10 | Silver | 32.3 | $ 25,389.00 | EX | 8 |
11 | Grey | 31.9 | $ 25,998.00 | EX | 28 |
12 | Red | 26.4 | $ 19,713.00 | LX | 55 |
13 | Black | 34.8 | $ 25,213.00 | EX | 2 |
14 | Silver | 35.9 | $ 24,467.00 | Touring | 33 |
15 | Black | 34.6 | $ 21,402.00 | LX | 17 |
16 | Black | 33.3 | $ 20,351.00 | LX | 14 |
17 | Grey | 33.1 | $ 23,732.00 | Touring | 1 |
18 | Red | 37.5 | $ 24,558.00 | Touring | 2 |
19 | Red | 27.8 | $ 19,167.00 | LX | 18 |
20 | Red | 36.1 | $ 19,903.00 | Touring | 22 |
21 | Blue | 28.8 | $ 22,140.00 | Touring | 19 |
22 | Red | 26.2 | $ 22,180.00 | EX | 41 |
23 | Silver | 27.4 | $ 23,120.00 | Touring | 33 |
24 | Black | 34.9 | $ 19,837.00 | Touring | 21 |
25 | Red | 36.5 | $ 24,666.00 | EX | 31 |
26 | Red | 26.3 | $ 19,446.00 | EX | 35 |
27 | Blue | 31.4 | $ 23,954.00 | Touring | 11 |
28 | Blue | 30.9 | $ 21,201.00 | LX | 3 |
29 | Red | 27.4 | $ 21,346.00 | EX | 26 |
30 | Red | 36 | $ 19,406.00 | EX | 31 |
Week 3
RESULTS OF CONCEPT RATING FOR NEW WINE COOLER | IDEAL TEMPERATURE | ||||||||
Rating of the appeal of the phrase as it relates to the new wine cooler | Total Sample | Gender | Age | 42 | |||||
Male | Female | 21 - 24 | 25 -34 | 35-49 | 62 | ||||
Extremely appealing (5) | 151 | 68 | 83 | 48 | 63 | 40 | 49 | ||
Somewhat appealing (4) | 91 | 51 | 40 | 36 | 32 | 23 | 51 | ||
Neither appealing nor not appealing (3) | 36 | 21 | 15 | 9 | 16 | 11 | 56 | ||
Somewhat unappealing (2) | 13 | 7 | 6 | 4 | 6 | 3 | 43 | ||
Not at all appealing (1) | 9 | 3 | 6 | 4 | 3 | 2 | 41 | ||
40 | |||||||||
48 | |||||||||
55 | |||||||||
QUANTITY PURCHASED PER PERSON IN ONE MONTH | 54 | ||||||||
# of six packs purchased | # people who purchased this amount | 44 | |||||||
0 | 7 | 58 | |||||||
1 | 6 | 47 | |||||||
2 | 6 | 54 | |||||||
3 | 13 | 55 | |||||||
4 | 14 | 44 | |||||||
5 | 12 | 49 | |||||||
6 | 10 | 47 | |||||||
7 | 5 | 57 | |||||||
8 | 5 | 41 | |||||||
9 | 5 | 62 | |||||||
10 | 2 | 47 | |||||||
56 | |||||||||
62 | |||||||||
41 | |||||||||
49 | |||||||||
42 | |||||||||
47 | |||||||||
55 |
Week 4
SAMPLE OF WEEKLY SALES | |||||
Sales Rep # | AverageWeekly Sales($) | Week # | Weekly Sales($) - Rep A | Weekly Sales($) - Rep B | |
1 | 1228 | 1 | 4657 | 5839 | |
2 | 7374 | 2 | 6133 | 2602 | |
3 | 1055 | 3 | 3438 | 2830 | |
4 | 1859 | 4 | 7394 | 4763 | |
5 | 3938 | 5 | 4327 | 3740 | |
6 | 1692 | 6 | 2552 | 1315 | |
7 | 569 | 7 | 7063 | 1599 | |
8 | 4059 | 8 | 7844 | 1629 | |
9 | 3689 | 9 | 6898 | 2416 | |
10 | 607 | 10 | 4003 | 2107 | |
11 | 1370 | 11 | 6884 | 4237 | |
12 | 3735 | 12 | 4007 | 6322 | |
13 | 3305 | 13 | 7214 | 2710 | |
14 | 7228 | 14 | 2358 | 5890 | |
15 | 6279 | 15 | 7745 | 5119 | |
16 | 1671 | 16 | 1337 | 5184 | |
17 | 5708 | 17 | 1052 | 3439 | |
18 | 2569 | 18 | 6056 | 4828 | |
19 | 4163 | 19 | 1495 | 3667 | |
20 | 1519 | 20 | 3530 | 2518 | |
21 | 7734 | 21 | 4749 | 6073 | |
22 | 784 | 22 | 3833 | 5566 | |
23 | 6766 | 23 | 7869 | 4555 | |
24 | 7261 | 24 | 4541 | 5867 | |
25 | 5034 | 25 | 6882 | 6039 | |
26 | 7115 | 26 | 3868 | 1032 | |
27 | 6291 | 27 | 5934 | 4834 | |
28 | 6287 | 28 | 4447 | 3687 | |
29 | 2080 | 29 | 5504 | 2214 | |
30 | 7621 | 30 | 5554 | 4659 | |
31 | 1047 | ||||
32 | 6517 | ||||
33 | 5172 | ||||
34 | 3876 | ||||
35 | 5429 | ||||
36 | 4538 | ||||
37 | 3786 | ||||
38 | 2510 | ||||
39 | 4863 | ||||
40 | 7246 | ||||
41 | 1175 | ||||
42 | 641 | ||||
43 | 4269 | ||||
44 | 7034 | ||||
45 | 3406 | ||||
46 | 2256 | ||||
47 | 3182 | ||||
48 | 5178 | ||||
49 | 4428 | ||||
50 | 1189 | ||||
Week 5
ORDERS VS. SHIPMENTS | CUSTOMERS IN PAST 6 MONTHS | MONTHLY SALES ($) | |||||||
Size | # Ordered | # Received | Customer # | # Visits | $ Purchases | Month | $ Sales | ||
Extra Small | 30 | 23 | 1 | 8 | 468 | Jan | 1375 | ||
Small | 50 | 54 | 2 | 6 | 384 | Feb | 1319 | ||
Medium | 85 | 92 | 3 | 8 | 463 | Mar | 1222 | ||
Large | 95 | 91 | 4 | 2 | 189 | Apr | 1328 | ||
Extra Large | 60 | 63 | 5 | 10 | 542 | May | 1493 | ||
2X Large | 45 | 42 | 6 | 4 | 299 | Jun | 1492 | ||
7 | 6 | 345 | Jul | 1489 | |||||
8 | 2 | 197 | Aug | 1354 | |||||
9 | 4 | 293 | Sep | 1530 | |||||
10 | 1 | 119 | Oct | 1483 | |||||
11 | 3 | 211 | Nov | 1450 | |||||
12 | 9 | 479 | Dec | 1495 | |||||
13 | 7 | 430 | Jan | 1545 | |||||
14 | 7 | 404 | Feb | 1454 | |||||
15 | 6 | 359 | Mar | 1322 | |||||
16 | 10 | 544 | Apr | 1492 | |||||
17 | 9 | 522 | May | 1678 | |||||
18 | 5 | 327 | Jun | 1645 | |||||
19 | 6 | 353 | Jul | 1580 | |||||
20 | 7 | 405 | Aug | 1493 | |||||
21 | 4 | 289 | Sep | 1719 | |||||
22 | 7 | 386 | Oct | 1573 | |||||
23 | 7 | 403 | Nov | 1629 | |||||
24 | 1 | 146 | Dec | 1680 | |||||
25 | 7 | 416 | |||||||
26 | 9 | 485 | |||||||
27 | 3 | 333 | |||||||
28 | 7 | 241 | |||||||
29 | 2 | 391 | |||||||
30 | 6 | 268 |