Using MIS (10th Edition)
Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter AE, Problem AE9.3

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...

Blurred answer
Students have asked these similar questions
D. S. Malik, Data Structures Using C++, 2nd Edition, 2010
Methods (Ch6) - Review 1. (The MyRoot method) Below is a manual implementation of the Math.sqrt() method in Java. There are two methods, method #1 which calculates the square root for positive integers, and method #2, which calculates the square root of positive doubles (also works for integers). public class SquareRoot { public static void main(String[] args) { } // implement a loop of your choice here // Method that calculates the square root of integer variables public static double myRoot(int number) { double root; root=number/2; double root old; do { root old root; root (root_old+number/root_old)/2; } while (Math.abs(root_old-root)>1.8E-6); return root; } // Method that calculates the square root of double variables public static double myRoot(double number) { double root; root number/2; double root_old; do { root old root; root (root_old+number/root_old)/2; while (Math.abs (root_old-root)>1.0E-6); return root; } } Program-it-Yourself: In the main method, create a program that…
I would like to know the main features about the following 3 key concepts:1. Backup Domain Controller (BDC)2. Access Control List (ACL)3. Dynamic Memory
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning