Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 9, Problem 9.6UYK
Explanation of Solution
Mention the use of RFM analysis for Costco:
Costco can use RFM analysis in order to understand its customer better and can identify certain situations or various trends which need attention.
RFM analysis:
RFM stands for Recency, Frequency and Monetary. It is an analytical technique to determine which customers are best among all by checking recent purchase date (Recency), how often the customer purchases (Frequency) and how much the customer spends (Monetary).
Customers having a score of [5, 5, 5]:
- A customer in the following group has the highest points in Recency, Frequency and Monetary.
- It shows that he or she is a loyal and very important customer and deserves highest level of service to reward his or her loyalty.
Customers having a score of [3, 5, 5]:
- A customer in the following group has the average points in Recency, Frequency and Monetary and lies in the middle group.
- It shows that he or she is a loyal and very important customer and effort need to be made to find out the reasons for which he or she has not been a recent customer.
- Efforts need to be made to ask the customer for feedback for previous purchases.
Customers having a score of [5, 2, 5]:
- A customer in the following group has the highest points in Recency, low points in Frequency and highest points in Monetary and lies in next to top group...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Q: Why are we using LINQ?Give some examples to demonstrate your point.
the requirements for TAL Distributors have changed. A number and a name now identify each storehouse. Units of each item may be stored in multiple storehouses, and it is important to know precisely how many items are stored in each storehouse. In addition, TAL Distributors now want to manage information about the suppliers from which it purchases items. For each item, TAL Distributors needs to know the number and name of each supplier as well as the expected lead time for delivering each item. (Lead time is the amount of time a supplier is expected to take to deliver the item after TAL Distributors has ordered it.) Each item can have many suppliers, and each supplier can supply many items. Using this information, convert the following unnormalized relation to fourth normal form:
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.
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.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. 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)arrow_forwardGarden 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…arrow_forwardGarden 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_forward
- Damon Davis was putting the finishing touches on the paperwork for Drano Plumbing. He estimated that the net profit would be $50,000. When he tallied the columns on the Balance Sheet, he saw that the debit column equaled $400,000 and the credit column totaled $300,000. What was the most likely reason for the discrepancy in results? If this was not the root of the problem, what should he do to identify the source of the problem?arrow_forwardExplain why the redemption criteria are so high.arrow_forwardCalculate the CV of 2 products and compare stability. Data is given below: Week-1: onion-52, potato-22 Week-2: onion-48, potato-23 Weak-3:Onion -50, Potato-52 Weak-4:Onion-69, Potato-65 Week-5: onion-69, potato-51 Week-6: onion-71, Potato-61 Weak-7:Onion-63, Potato- 37 Weak-8: Onion-68, Potato- 41 Weak-9: onion-66, potato-37 Weak 10 onion 43, potato-30 Solve the mathematical problem in Python Programming language. And give the screenshot of the output.arrow_forward
- Solve The AOA Question .arrow_forwardHow can outlier values be treated?arrow_forwardDamon Davis was working on the Drano Plumbing Company's spreadsheet. He estimated a $50,000 net profit. When he added up the column totals on the Balance Sheet, the totals were $400,000 for debit and $300,000 for credit. What was the most likely reason for the disparity? What should he do if this was not the problem?arrow_forward
- Question 2: Muscat Auto Workshop is a vehicle service centre located in the city of Muscat, which provides vehicle maintenance/repair services.The charges of vehicle maintenance/repair are based on the type of the service. Details of charges are as follow: Basic Tuning: 50 OMRSoftware Re-installation: 60 OMR Parts Replacement: 100 OMR Body Paint: 120 OMR The workshop offers 10% discounts to the customers who have membership of the service centre. You are required to draw a flow chart diagram and write a C++ computer program that takes customer’s name, car plate number, membership status(Y/N) and the required service (mentioned above). The program outputs the input data and maintenance charges based on the service provided by the service centre with discount, if applies.arrow_forwardYour country has adopted the World Trade Organisation (WTO) valuation methods for imports and exports.Write short notes on two of the following WTO customs valuation methods:(i) Method 1 – Transaction value (ii) Method 2 – Transaction value of identical goods (b) Owing to the high incidences of dumping goods in the country, the tax authority in your country has sought your professional advice on how to end this vice. Outline some of the measures that the authority can utilize in preventing dumping of goods. (c) (i) State the conditions which should be fulfilled before an exemption from payment of tax isgranted under the VAT and Customs and Excise Acts. (ii) Explain the procedure for applying for such an exemption under the VAT and Customs and Excise Acts.arrow_forwardDamon Davis was finalising Drano Plumbing's paperwork. He projected a $50,000 net profit. When he added up the columns on the Balance Sheet, he saw that the debit column amounted to $400,000 and the credit column amounted to $300,000. What was the most probable cause of the outcome discrepancy? If this was not the cause of the issue, how should he proceed to ascertain its origin?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole