Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra With Applications

Authors: Gareth Williams

8th Edition

1449679579, 9781449679576

More Books

Students also viewed these Mathematics questions