
Explanation of Solution
a.
Modify the Data analysis if Desert Gear Supply does not release 3-D designs:
If Desert Gear Supply decides not to release its 3-D design files at any price, one needs to remove the parts provided by it from consideration and repeat the data analysis,
The Orders and parts view without gear supply is represented as:
The screen shot of Orders and Parts View:
The customer summary without desert gear supply is represented as:
The screen shot of Customer Summary:
Explanation of Solution
b.
Repeat the analysis with different criteria:
- Large customers have ordered more than 900 parts.
- Frequent purchases are occurred minimum 25 times per year.
- Average order of 3 or less are qualified as small quantities.
- The parts which cost less than $75 are inexpensive parts.
- The shipping weight is less than 4 pounds.
The Big Customer table with new criteria of large customers who have ordered more than 900 parts are represented as:
The screen shot of Big Customers – Part 2:
Explanation of Solution
c.
Mention how the second set of criteria changes the result:
The second set of criteria changes the result in the following ways:
- The part number 200-211 is excluded from these assumptions and the revenue potential is reduced...
Explanation of Solution
d.
Mention recommendations that one can make in light of analysis:
It can be concluded that the revenue potential i...

Want to see the full answer?
Check out a sample textbook solution
Chapter AE Solutions
Using MIS (10th Edition)
- I would like help to resolve the following case, thank youarrow_forwardI need help with the following casearrow_forwardQ2) by using SHI-Tomasi detector method under the constraints shown in fig. 1 below find the corner that is usful to use in video-steganography? 10.8 ...... V...... 0.7 286 720 ke Fig.1 Threshold graph. The plain test is :Hello Ahmed the key is: 3a 2x5 5b 7c 1J 55 44 2X3 [ ] 2x3arrow_forward
- What significant justification is there for the -> operator in C and C++?arrow_forwardMultidimensional arrays can be stored in row major order, as in C++, or in column major order, as in Fortran. Develop the access functions for both of these arrangements for three-dimensional arrays.arrow_forwardWhat are the arguments for and against Java’s implicit heap storage recovery, when compared with the explicit heap storage recovery required in C++? Consider real-time systems.arrow_forward
- 8. Name and Email AddressesWrite a program that keeps names and email addresses in a dictionary as key-value pairs. The program should display a menu that lets the user look up a person’s email address, add a new name and email address, change an existing email address, and delete an existing name and email address. The program should pickle the dictionary and save it to a file when the user exits the program. Each time the program starts, it should retrieve the dictionary from the file and unpickle it. How would the user be able to use the program?arrow_forwardPlease solve and answer the question correctly please. Thank you!!arrow_forwardPlease solve and answer the question correctly please. Thank you!!arrow_forward
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning


