Question
In many industries throughout the world, suppliers compete for business by submitting quotes for work, services, or products. A key criterion used to determine the
In many industries throughout the world, suppliers compete for business by submitting quotes for work, services, or products. A key criterion used to determine the winning quote is the dollar amount of the quote, but other factors include expected quality, estimated delivery time of the product, or quoted completion time of the work. The focus of this case is a supplier of equipment to the automotive industry. The products of interest in this case are various precision metal components used in a range of automotive applications, such as braking systems, drive trains, and engines. Some of the products will be used in the manufacture or assembly of new automobiles (i.e., original equipment), while others will be used as replacement parts in automobiles already on the road (i.e., aftermarket). The Task The supplier wants to increase sales and expand its market position. Many of the quotes provided to prospective customers in the past haven't resulted in orders. Do the data provide any indication why? Are there certain situations that make it more or less likely that a customer will place an order?
The data set LotsSales contains 550 records for quotes provided over a six-month period. The variables in the data set are: Quote The quoted price, in dollars, for the order Time to Delivery The quoted number of calendar days within which the order is to be delivered Part Type OE = original equipment; AM = aftermarket Status Whether the quote resulted in a subsequent order within 30 days of receiving the quote: Lost = the order was not placed; Won = the order was placed.
a. Determine if order-winning is associated with part type, OE or AM.
b. Explore if or whether lost sales opportunities are related to pricing. Is it possible that the company's prices are too high, and that customers are moving to lower cost providers? Let's explore the relationship between Status and Quote.
c. We now want to explore if or whether lost sales opportunities are related to Time to Delivery. Let's explore the relationship between Status and Time To Delivery.
d. Now place all the variables inside of the model. Determine which variables are significant.
e. Use the JMP prediction profiler to further explore the effects of these three predictors and comment.
Data:
Quote | Time to delivery | Part Type | Status |
3452 | 6 | OE | Won |
429 | 9 | AM | Won |
102 | 14 | OE | Won |
1153 | 16 | OE | Lost |
102 | 11 | OE | Won |
2313 | 46 | AM | Lost |
2681 | 63 | OE | Lost |
5486 | 35 | AM | Won |
845 | 16 | OE | Lost |
1115 | 40 | AM | Won |
2088 | 30 | AM | Won |
628 | 26 | AM | Won |
2213 | 61 | AM | Lost |
2847 | 90 | AM | Lost |
4190 | 61 | AM | Lost |
106 | 161 | AM | Lost |
608 | 88 | AM | Lost |
4176 | 31 | OE | Lost |
783 | 7 | AM | Lost |
1862 | 94 | AM | Lost |
5912 | 17 | OE | Lost |
470 | 26 | OE | Lost |
752 | 36 | AM | Lost |
1335 | 23 | OE | Lost |
1198 | 31 | AM | Lost |
1915 | 3 | AM | Won |
1616 | 32 | AM | Won |
1394 | 2 | AM | Lost |
2148 | 22 | AM | Lost |
354 | 24 | AM | Lost |
557 | 32 | AM | Lost |
4007 | 45 | AM | Lost |
323 | 72 | OE | Lost |
16185 | 18 | AM | Won |
1607 | 13 | OE | Lost |
2353 | 5 | AM | Lost |
91 | 6 | AM | Won |
970 | 5 | AM | Won |
2290 | 9 | OE | Lost |
855 | 28 | AM | Lost |
5689 | 14 | AM | Lost |
131 | 0 | AM | Won |
1833 | 62 | OE | Won |
1215 | 22 | AM | Won |
4840 | 11 | AM | Lost |
6520 | 13 | AM | Won |
4591 | 50 | AM | Lost |
514 | 9 | AM | Lost |
5417 | 107 | OE | Won |
1054 | 1 | AM | Won |
2275 | 7 | AM | Lost |
1447 | 2 | AM | Won |
832 | 28 | OE | Lost |
6939 | 32 | AM | Won |
307 | 32 | AM | Lost |
5138 | 52 | AM | Won |
6410 | 31 | AM | Won |
2488 | 31 | AM | Won |
1471 | 2 | AM | Lost |
507 | 28 | AM | Won |
2620 | 69 | AM | Lost |
2020 | 18 | AM | Won |
281 | 32 | OE | Lost |
319 | 49 | AM | Won |
1979 | 81 | AM | Lost |
3981 | 37 | AM | Lost |
1933 | 11 | AM | Lost |
4327 | 10 | AM | Won |
2865 | 63 | AM | Lost |
1602 | 68 | AM | Lost |
578 | 87 | AM | Lost |
2089 | 29 | AM | Lost |
1358 | 9 | AM | Lost |
1443 | 3 | OE | Lost |
5333 | 9 | AM | Lost |
999 | 166 | OE | Lost |
2775 | 65 | AM | Won |
2646 | 74 | OE | Won |
2047 | 29 | AM | Lost |
2128 | 30 | AM | Lost |
3447 | 5 | OE | Won |
380 | 73 | AM | Lost |
489 | 43 | OE | Lost |
6933 | 3 | OE | Lost |
740 | 15 | OE | Lost |
941 | 38 | AM | Won |
2815 | 9 | AM | Won |
378 | 24 | AM | Won |
3687 | 51 | OE | Lost |
793 | 52 | AM | Lost |
932 | 17 | AM | Lost |
2187 | 7 | AM | Won |
5470 | 5 | AM | Lost |
1525 | 36 | AM | Lost |
3235 | 36 | AM | Won |
5108 | 14 | OE | Lost |
5555 | 85 | OE | Lost |
865 | 5 | AM | Lost |
1753 | 90 | AM | Won |
4526 | 19 | AM | Won |
157 | 40 | AM | Lost |
2062 | 38 | OE | Won |
5373 | 81 | AM | Won |
1874 | 10 | AM | Won |
11290 | 12 | AM | Lost |
64 | 42 | AM | Lost |
939 | 47 | AM | Won |
3718 | 37 | AM | Won |
5999 | 45 | AM | Lost |
1896 | 33 | OE | Lost |
5449 | 5 | AM | Won |
457 | 17 | AM | Won |
11665 | 44 | AM | Won |
3941 | 36 | OE | Lost |
1468 | 21 | AM | Lost |
5015 | 7 | AM | Won |
2039 | 36 | AM | Lost |
5403 | 1 | AM | Won |
2753 | 28 | OE | Won |
1953 | 28 | OE | Won |
6315 | 2 | OE | Lost |
385 | 26 | OE | Won |
2101 | 18 | AM | Won |
8039 | 37 | AM | Lost |
873 | 9 | AM | Lost |
590 | 1 | AM | Won |
2630 | 28 | OE | Won |
3081 | 35 | AM | Won |
1645 | 23 | OE | Won |
1344 | 40 | OE | Lost |
4206 | 10 | AM | Won |
1478 | 5 | AM | Won |
2623 | 18 | OE | Won |
4823 | 26 | AM | Lost |
362 | 50 | AM | Won |
3751 | 11 | AM | Lost |
319 | 21 | OE | Won |
1670 | 24 | OE | Won |
2236 | 115 | AM | Lost |
2655 | 26 | OE | Won |
7392 | 12 | OE | Won |
1179 | 26 | AM | Won |
1597 | 90 | AM | Lost |
5427 | 11 | AM | Lost |
423 | 36 | AM | Won |
10443 | 59 | AM | Won |
1183 | 76 | AM | Won |
1818 | 24 | AM | Won |
2714 | 15 | AM | Lost |
337 | 48 | AM | Won |
2010 | 183 | AM | Lost |
121 | 10 | AM | Won |
4933 | 17 | AM | Won |
1134 | 6 | AM | Won |
195 | 18 | AM | Won |
738 | 11 | AM | Won |
516 | 74 | AM | Won |
3228 | 19 | OE | Lost |
2709 | 135 | OE | Lost |
2372 | 58 | AM | Won |
1835 | 40 | OE | Lost |
253 | 16 | AM | Won |
5741 | 11 | OE | Lost |
2492 | 40 | OE | Lost |
5347 | 30 | OE | Lost |
1428 | 4 | OE | Won |
4516 | 20 | AM | Won |
1256 | 26 | AM | Lost |
208 | 24 | AM | Won |
2793 | 14 | AM | Won |
313 | 44 | AM | Lost |
178 | 4 | AM | Lost |
15 | 8 | AM | Won |
3991 | 29 | AM | Lost |
3714 | 11 | AM | Won |
4505 | 16 | AM | Lost |
10527 | 1 | AM | Lost |
145 | 3 | OE | Lost |
2262 | 124 | AM | Won |
1866 | 38 | AM | Lost |
2244 | 55 | AM | Lost |
54 | 30 | AM | Lost |
1343 | 2 | AM | Won |
976 | 17 | OE | Lost |
18278 | 76 | AM | Lost |
1721 | 40 | AM | Lost |
7024 | 11 | AM | Lost |
8156 | 47 | AM | Won |
687 | 14 | AM | Lost |
1215 | 7 | AM | Lost |
595 | 30 | AM | Lost |
2666 | 60 | AM | Lost |
17351 | 3 | AM | Won |
2580 | 18 | AM | Won |
161 | 8 | AM | Won |
5633 | 2 | OE | Won |
5941 | 3 | AM | Won |
3469 | 29 | AM | Won |
1505 | 12 | OE | Won |
3192 | 4 | AM | Lost |
1006 | 88 | AM | Lost |
2937 | 10 | AM | Won |
4190 | 15 | AM | Won |
1498 | 13 | OE | Won |
1153 | 122 | AM | Lost |
4049 | 12 | OE | Won |
1415 | 138 | AM | Lost |
619 | 6 | AM | Won |
341 | 12 | AM | Lost |
2780 | 104 | AM | Won |
4268 | 78 | OE | Lost |
2885 | 74 | AM | Lost |
1095 | 4 | AM | Won |
2834 | 10 | AM | Lost |
2003 | 45 | AM | Lost |
229 | 59 | OE | Lost |
3798 | 15 | AM | Won |
258 | 55 | AM | Won |
2148 | 19 | AM | Won |
331 | 22 | AM | Lost |
660 | 73 | OE | Won |
2337 | 32 | AM | Won |
13817 | 52 | AM | Won |
601 | 12 | AM | Won |
387 | 38 | AM | Lost |
992 | 29 | AM | Won |
341 | 14 | AM | Won |
2025 | 12 | AM | Lost |
6684 | 6 | AM | Won |
752 | 17 | OE | Won |
6301 | 33 | OE | Lost |
498 | 11 | AM | Won |
4694 | 0 | AM | Won |
2104 | 71 | AM | Lost |
2222 | 0 | AM | Won |
222 | 20 | AM | Won |
348 | 34 | OE | Won |
508 | 45 | AM | Lost |
1997 | 28 | AM | Won |
953 | 4 | OE | Lost |
2333 | 1 | OE | Won |
603 | 82 | OE | Won |
3659 | 12 | AM | Won |
1747 | 19 | OE | Lost |
92 | 85 | AM | Lost |
1293 | 73 | AM | Lost |
4070 | 9 | AM | Won |
9190 | 1 | OE | Won |
1605 | 8 | AM | Won |
816 | 43 | OE | Lost |
986 | 4 | OE | Won |
612 | 69 | AM | Won |
2095 | 40 | AM | Lost |
11080 | 35 | AM | Lost |
858 | 6 | AM | Lost |
7066 | 6 | AM | Won |
2347 | 17 | AM | Lost |
1047 | 47 | AM | Lost |
3947 | 26 | AM | Won |
2886 | 7 | AM | Won |
6477 | 126 | OE | Lost |
682 | 7 | AM | Lost |
82 | 9 | AM | Won |
2309 | 31 | AM | Lost |
44 | 34 | AM | Lost |
7209 | 32 | AM | Lost |
104 | 7 | AM | Won |
253 | 27 | OE | Lost |
3160 | 11 | AM | Lost |
695 | 51 | AM | Won |
9788 | 45 | OE | Lost |
260 | 7 | OE | Won |
1137 | 4 | AM | Lost |
2771 | 40 | AM | Lost |
750 | 51 | AM | Lost |
3667 | 5 | OE | Won |
696 | 79 | AM | Lost |
2275 | 17 | AM | Won |
552 | 15 | OE | Won |
2876 | 31 | OE | Lost |
8521 | 47 | OE | Won |
51 | 11 | AM | Won |
1115 | 72 | AM | Lost |
6305 | 20 | AM | Lost |
232 | 26 | AM | Won |
478 | 56 | OE | Won |
5251 | 12 | AM | Won |
751 | 4 | AM | Won |
1157 | 96 | AM | Lost |
3686 | 50 | AM | Lost |
3441 | 1 | AM | Lost |
22 | 20 | OE | Won |
260 | 4 | OE | Lost |
3863 | 50 | AM | Lost |
2580 | 22 | OE | Lost |
9699 | 28 | OE | Won |
147 | 37 | OE | Lost |
1034 | 3 | OE | Lost |
582 | 39 | AM | Won |
691 | 63 | AM | Won |
1115 | 38 | AM | Won |
4935 | 39 | AM | Lost |
2505 | 16 | AM | Lost |
7186 | 83 | OE | Lost |
2534 | 9 | AM | Won |
5306 | 13 | AM | Lost |
2176 | 2 | OE | Lost |
10037 | 78 | AM | Won |
930 | 9 | OE | Lost |
1963 | 15 | AM | Won |
1405 | 63 | AM | Lost |
2596 | 43 | OE | Lost |
2330 | 44 | AM | Won |
7163 | 40 | AM | Won |
2338 | 158 | AM | Lost |
1185 | 89 | AM | Lost |
1250 | 31 | AM | Won |
3 | 6 | OE | Won |
12958 | 26 | OE | Lost |
922 | 63 | AM | Won |
1193 | 28 | AM | Lost |
837 | 18 | AM | Won |
3966 | 2 | AM | Won |
3899 | 29 | OE | Won |
5604 | 14 | AM | Lost |
4558 | 59 | AM | Lost |
1751 | 12 | AM | Lost |
3087 | 14 | AM | Lost |
3199 | 3 | OE | Lost |
3965 | 9 | OE | Lost |
175 | 10 | AM | Won |
552 | 41 | AM | Won |
663 | 3 | AM | Lost |
2282 | 12 | AM | Won |
4795 | 31 | OE | Won |
12290 | 30 | AM | Won |
555 | 7 | AM | Lost |
1584 | 13 | AM | Won |
121 | 22 | AM | Won |
6756 | 17 | AM | Lost |
689 | 49 | OE | Won |
2375 | 171 | AM | Lost |
132 | 50 | AM | Won |
7936 | 45 | AM | Lost |
2696 | 105 | AM | Lost |
4872 | 2 | OE | Lost |
998 | 65 | OE | Lost |
1944 | 39 | AM | Won |
12684 | 2 | AM | Won |
2982 | 92 | AM | Lost |
7353 | 40 | OE | Lost |
199 | 32 | AM | Lost |
821 | 18 | AM | Won |
2158 | 18 | AM | Lost |
3228 | 9 | OE | Won |
1510 | 25 | AM | Won |
476 | 3 | OE | Won |
278 | 30 | AM | Won |
2832 | 12 | OE | Won |
1005 | 12 | AM | Lost |
1885 | 1 | AM | Won |
2220 | 40 | OE | Won |
2062 | 8 | AM | Lost |
2915 | 14 | OE | Won |
1419 | 46 | OE | Won |
1461 | 1 | AM | Won |
9597 | 18 | OE | Lost |
520 | 34 | AM | Lost |
906 | 32 | AM | Won |
2764 | 37 | OE | Lost |
963 | 1 | AM | Won |
1939 | 7 | AM | Lost |
88 | 21 | AM | Won |
787 | 2 | AM | Lost |
660 | 22 | AM | Won |
384 | 137 | OE | Lost |
1121 | 6 | AM | Won |
4627 | 67 | OE | Lost |
6324 | 9 | AM | Won |
3036 | 24 | OE | Lost |
877 | 16 | OE | Lost |
2510 | 42 | AM | Won |
419 | 73 | AM | Won |
1481 | 39 | AM | Lost |
56 | 20 | AM | Lost |
6596 | 1 | AM | Won |
979 | 58 | AM | Lost |
777 | 3 | AM | Won |
2928 | 6 | OE | Lost |
2510 | 19 | AM | Lost |
1184 | 60 | AM | Won |
4292 | 5 | OE | Lost |
523 | 4 | AM | Won |
3532 | 50 | AM | Won |
1698 | 15 | AM | Won |
3441 | 12 | AM | Won |
335 | 33 | OE | Won |
3567 | 7 | AM | Won |
5821 | 60 | OE | Won |
90 | 9 | OE | Won |
2437 | 39 | AM | Lost |
842 | 28 | AM | Won |
221 | 31 | AM | Won |
3358 | 1 | AM | Lost |
599 | 28 | AM | Won |
5256 | 3 | AM | Lost |
1156 | 40 | OE | Won |
1750 | 8 | AM | Won |
6755 | 7 | AM | Won |
5865 | 65 | OE | Lost |
873 | 6 | AM | Lost |
1277 | 8 | AM | Won |
2734 | 24 | AM | Lost |
117 | 4 | AM | Won |
1786 | 47 | AM | Won |
448 | 90 | AM | Lost |
9053 | 12 | OE | Won |
493 | 0 | AM | Won |
505 | 15 | AM | Lost |
237 | 37 | AM | Lost |
2212 | 30 | AM | Lost |
806 | 70 | AM | Lost |
2387 | 5 | AM | Lost |
2212 | 21 | OE | Lost |
1608 | 27 | OE | Lost |
4827 | 68 | AM | Lost |
6688 | 54 | AM | Lost |
4407 | 25 | OE | Won |
1193 | 38 | AM | Won |
44 | 11 | OE | Won |
2398 | 8 | OE | Lost |
822 | 68 | AM | Won |
2366 | 85 | AM | Lost |
0 | 28 | OE | Lost |
6147 | 11 | AM | Lost |
231 | 46 | AM | Won |
3909 | 7 | AM | Lost |
9677 | 96 | AM | Lost |
5726 | 116 | AM | Lost |
2951 | 17 | OE | Won |
3270 | 6 | AM | Won |
18 | 11 | AM | Won |
1830 | 37 | OE | Lost |
6903 | 64 | AM | Won |
506 | 11 | AM | Won |
2632 | 80 | OE | Lost |
4199 | 54 | AM | Won |
341 | 31 | AM | Won |
4770 | 71 | AM | Lost |
5972 | 29 | OE | Lost |
671 | 9 | AM | Lost |
993 | 34 | AM | Won |
3631 | 5 | OE | Lost |
547 | 17 | AM | Won |
3168 | 68 | OE | Lost |
1470 | 16 | OE | Won |
1350 | 57 | AM | Won |
3822 | 1 | AM | Lost |
7401 | 24 | AM | Lost |
4439 | 28 | OE | Won |
1216 | 51 | AM | Lost |
3505 | 30 | AM | Lost |
367 | 66 | AM | Won |
4961 | 29 | AM | Won |
2341 | 8 | AM | Won |
4189 | 55 | OE | Lost |
768 | 19 | AM | Won |
2874 | 36 | AM | Won |
4881 | 31 | AM | Lost |
16604 | 48 | AM | Won |
5765 | 29 | AM | Won |
10034 | 12 | OE | Won |
1997 | 26 | OE | Lost |
1498 | 13 | AM | Won |
4536 | 33 | AM | Won |
5170 | 0 | AM | Won |
50 | 29 | AM | Won |
2727 | 5 | AM | Won |
207 | 8 | AM | Won |
3130 | 42 | AM | Won |
266 | 9 | AM | Won |
889 | 46 | AM | Won |
6883 | 26 | OE | Lost |
5837 | 3 | AM | Won |
5425 | 12 | AM | Lost |
4162 | 74 | AM | Won |
10018 | 23 | AM | Lost |
631 | 3 | AM | Won |
1583 | 18 | AM | Lost |
4357 | 4 | AM | Lost |
2113 | 10 | OE | Lost |
5465 | 36 | AM | Won |
16 | 13 | AM | Won |
2869 | 3 | AM | Won |
1537 | 24 | AM | Won |
2648 | 106 | AM | Lost |
6020 | 18 | AM | Won |
4155 | 23 | AM | Lost |
365 | 83 | OE | Lost |
1185 | 26 | AM | Won |
2231 | 4 | OE | Lost |
119 | 4 | AM | Won |
2867 | 3 | AM | Won |
3350 | 3 | AM | Won |
698 | 66 | AM | Lost |
2086 | 4 | OE | Won |
570 | 51 | AM | Lost |
5059 | 5 | AM | Won |
3892 | 20 | AM | Won |
593 | 12 | AM | Won |
387 | 36 | AM | Lost |
2857 | 58 | AM | Lost |
3352 | 28 | OE | Lost |
1390 | 7 | AM | Won |
5809 | 37 | OE | Won |
1883 | 37 | AM | Lost |
2399 | 29 | AM | Lost |
6193 | 9 | OE | Won |
3737 | 81 | OE | Lost |
5197 | 18 | AM | Won |
1333 | 36 | AM | Lost |
2251 | 57 | AM | Lost |
4155 | 47 | OE | Lost |
3506 | 20 | AM | Won |
2849 | 16 | AM | Lost |
1108 | 14 | AM | Won |
903 | 5 | AM | Lost |
2309 | 51 | OE | Won |
414 | 9 | AM | Won |
9611 | 5 | OE | Lost |
4730 | 35 | AM | Won |
20540 | 22 | AM | Lost |
1057 | 8 | OE | Won |
3340 | 25 | AM | Won |
3139 | 69 | AM | Lost |
2672 | 39 | AM | Lost |
2672 | 22 | OE | Lost |
490 | 30 | OE | Won |
10997 | 14 | OE | Won |
3388 | 23 | AM | Won |
3070 | 30 | OE | Lost |
894 | 64 | OE | Lost |
1268 | 30 | AM | Won |
740 | 22 | AM | Won |
1313 | 8 | AM | Lost |
1481 | 32 | AM | Lost |
1432 | 65 | OE | Lost |
1369 | 36 | OE | Won |
440 | 63 | AM | Won |
580 | 54 | OE | Lost |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started