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:

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Information Security Risk and Vulnerability Assessment 1- Which TCP/IP protocol is used to convert the IP address to the Mac address? Explain 2-What popular switch feature allows you to create communication boundaries between systems connected to the switch3- what types of vulnerability directly related to the programmer of the software?4- Who ensures the entity implements appropriate security controls to protect an asset? Please do not use AI and add refrence

Find the voltage V0 across the 4K resistor using the mesh method or nodal analysis. Note: I have already simulated it and the value it should give is -1.714V

Resolver por superposicion

Answer 2

Expert Solution & Answer

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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

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

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

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

Answer 8

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:

Answer 9

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:

Answer 10

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:

Answer 11

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:

Answer 12

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

Answer 13

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

Answer 14

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Answer 15

Explanation of Solution

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...

Answer 16

Expert Solution & Answer

Answer 17

Expert Solution & Answer

Answer 18

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 19

Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2 Ch. AE - Prob. AE2.1 Ch. AE - Prob. AE2.2 Ch. AE - Prob. AE3.1 Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1 Ch. AE - Prob. AE4.2 Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2

Explanation of Solution

Explanation of Solution

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?

Chapter AE Solutions

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

d.

Mention recommendations that one can make in light of analysis:

It can be concluded that the revenue potential i...