Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 9, Problem 9.5UYK
Explanation of Solution
Use of knowledge about Lift for major national big-box stores:
- Market basket analysis is used to find the pattern of items bought by the customers and predict the future purchase decisions of the customers.
- It determines how the customers buy goods together and the seller needs to know this pattern as more cross selling opportunity can be created.
- A lift compares products and shows the relative increase or decrease in base probability of one product when other products are purchased.
- If one can know all the items that have a high lift then he or she can take advantage of that knowledge.
- The store can have lucrative offers and discount on one item with the added knowledge that the probability of sale of the related item also increases by a lot.
- The store put the items together physically or sells both the items in a combo package knowing that most likely both the items will be purchased together.
For example:
One can place a particular brands conditioner along with the same brands shampoo as a combo package knowing the probability that if a customer purchases shampoo, he or she is most likely to buy conditioner of the same brand...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.
Figure 2-32 shows data that Garden Glory collects about properties and services.
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.
Figure 2-32 shows data that Garden Glory collects about properties and services.
PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate)SERVICE (ServiceDate, Description, Amount)
PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate)
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.
Figure 2-32 shows data that Garden Glory collects about properties and services.
Suppose Garden Glory decides to add the following table:
SERVICE-FEE (PropertyID, ServiceID, Description, Amount)
Add this table to what you consider to be the best design in your answer to part B. Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure 2-31? If not, modify the design so that this data will work. State the assumptions implied by this…
Chapter 9 Solutions
Using MIS (10th Edition)
Ch. 9.3 - Prob. 1EGDQCh. 9.3 - Prob. 2EGDQCh. 9.3 - Prob. 3EGDQCh. 9.3 - Prob. 4EGDQCh. 9.6 - Prob. 1BFSQCh. 9.6 - Prob. 2BFSQCh. 9.6 - Prob. 3BFSQCh. 9.6 - Prob. 4BFSQCh. 9.9 - Prob. 1SGDQCh. 9.9 - Prob. 2SGDQ
Ch. 9.9 - Prob. 3SGDQCh. 9.9 - Prob. 4SGDQCh. 9.9 - Prob. 5SGDQCh. 9.9 - Prob. 9.1ARQCh. 9.9 - Prob. 9.2ARQCh. 9.9 - Prob. 9.3ARQCh. 9.9 - Prob. 9.4ARQCh. 9.9 - Prob. 9.5ARQCh. 9.9 - Prob. 9.6ARQCh. 9.9 - Prob. 9.8ARQCh. 9.9 - Prob. 9.9ARQCh. 9 - Prob. 9.1UYKCh. 9 - Prob. 9.2UYKCh. 9 - Prob. 9.3UYKCh. 9 - Prob. 9.4UYKCh. 9 - Prob. 9.5UYKCh. 9 - Prob. 9.6UYKCh. 9 - Prob. 9.7UYKCh. 9 - Prob. 9.8UYKCh. 9 - Prob. 9.9CE9Ch. 9 - Prob. 9.1CE9Ch. 9 - Prob. 9.11CE9Ch. 9 - Prob. 9.12CE9Ch. 9 - Prob. 9.13CE9Ch. 9 - Prob. 9.14CE9Ch. 9 - Prob. 9.15CE9Ch. 9 - Prob. 9.16CS9Ch. 9 - Prob. 9.17CS9Ch. 9 - Prob. 9.18CS9Ch. 9 - Prob. 9.19CS9Ch. 9 - Prob. 9.22MML
Knowledge Booster
Similar questions
- Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services. Given your assumptions, comment on the appropriateness of the following designs: PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate,…arrow_forwardIdentify the competitive advantage strategy applied in each of the following short scenarios. Motivate your choice based on your readings and the scenario. The Village bank has lowered their banking fees for customers by emailing them their monthly statements instead of printing them and posting them each month.arrow_forwardYou are working with a client as a Chief Technology Officer, and you have produced a graph to help your client understand how each of the investment accounts will behave over time. Write your client a report outlining an investment forecast and recommending in which type of account they should invest. In your report, to support your claims you should use comparisons of the data and an explanation of the chart trendlines on the next tab. Address whether the client is looking to invest short term (five years or less) or long term (longer than five years). Which of the chart types on the following Excel page, titled “Chart Types” will be most useful for supporting your recommendations? Why?arrow_forward
- Customer and Plan are linked in two ways. Compare and contrast the two.arrow_forwardYou are interested in looking at how competition affects gas prices, where you think that if a gas station has more competitors nearby, it will tend to have lower prices. To test this, you decide to use a natural experiment in which a chain of gas stations ("Thrifty") suddenly closed. This closure occurred between June and October of 2012, and meant that gas stations that were previous close to a Thrifty station experienced less competition than before. On the other hand, those stations that were not close to a Thrifty station did not experience any change in competition. You decide to use a differences in differences design, in which gas stations located near a Thrifty station at the start of 2012 are the treatment group and those that were not located near a Thrifty at the start of 2012 are the control group. You look at how prices change before and after the exit of Thrifty. This is plotted in the below graph, where the solid line represents the average price of stations that were…arrow_forwardSuppose you own a travel agency in a large city. You have many corporate clients, but growth has slowed somewhat. Some long-term employees are getting discouraged, but you feel that there might be a way to make technology work in your favor. Use your imagination and do a SWOT analysis: Suggest at least one strength, one weakness, one opportunity, and one threat that your business faces.arrow_forward
- Zora Bank limited is a medium sized bank that was recently purchased and the new owner now finds that there are numbers of delinquent loans. They have hired you as a consultant to make recommendations on the categorizing and writing down of these delinquent loans. They also want you to recommend a system that will see the loans being realistically or valued in the future. The owners have also asked that your recommendation show the effects on the income statement for each step that you are proposing. Your recommendations should set all three steps as they relate to provisioning that you would advise the bank to take. A problem or default loan can be defined as a loan for which the repayments are overdue. List two credit operational deficiencies that financial Institutions have control over, that if not adequately addressed by them, may cause the Institute to experience default and problem loansarrow_forwardSouthland Corporation's decision to produce a new line of recreational products resulted in the need to construct either a small plant or a large plant. The best selection of plant size depends on how the marketplace reacts to the new product line. To conduct an analysis, marketing management has decided to view the possible long run-demand as low, medium or high. The following table shows the projected profit in millions of dollars: Plant Size Low Medium High Small 150 200 200 Large 50 200 500 a. What is the decision to be made, and what is the chance event for Southland's problem? b. Construct a decision tree. c. Recommend a decision based on use of the optimistic, conservative, and minimax regret approaches.arrow_forwardPropose a customer segmentation model using FFC entity to promote customers with the appropriate rewards defined for each segment and and extend your designarrow_forward
- Use the Excel template VLC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $200 per visit, the frequency of repurchase is 7 times per year, the contribution margin is 23 percent, and the average customer defection rate is 19 percent?arrow_forwardSuppose you want to predict the churn rate. Consider the two models M1 and M2. Based on the confusion matrix, M1 has an accuracy of 75% and cost of 4017. Meanwhile, M2 has an accuracy of 80% and cost of 5236. Which is the better model and why? * It depends on the business case which errors the stakeholders want to minimize and which predictions they want to maximize. M1 is the better model because it has a lower cost meaning the errors are minimized and the accuracy shows that the model was able to capture customers that will not churn. M2 is the better model because it has a O higher accuracy so the model was able to capture all churn customers. None because you need to use ROC O (receiver operating characteristic) to better evaluate the two models.arrow_forwardUse the following Scenario and develop required HTA Sally needs to plan a vacation for her family. She decides to hop on TravelSmart.com and do both the research and reservations there. She begins by researching the top family-friendly destinations as recommended by TravelSmart.com customers. She wants to compare the travel time, travel costs, hotel costs, hotel availability, and amusement activities for each destination. For each of those criteria, Sally gave a weighting to help her make her decision. She finally settled on the destination that required the least travel time, cheapest travel costs, moderate hotel costs, good availability, and a large selection of activities for the whole family. From that spot, Sally begins searching for the flights and hotels that meet her criteria. She decides to save those results for later because she wants to be sure the whole family is in agreement before she makes the reservations with her credit card.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Management Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning