Case Study Questions and Guidelines for answering;Home Depot is a major retail chain specializing in the sale of construction and home repair and;maintenance products. The company has 2,246 retail stores in North America from which it;generated $77 billion in 2007. Home Depot carries more than 40,000 products in its stores and;employs 331,000 people worldwide.;Suppose you are a buyer for the clothes washer and dryer product line at Home Depot.;You work with seven different brands and numerous models within each brand. One of your;goals is to turn your inventory as many times a year as you can. In order to do so, you want to;identify poorly selling models (and even brands) as quickly as you can. This identification is not;as easy as you might think, because competition is intense among washer and dryer;manufacturers and a new model can quickly capture a substantial portion of another models;market share. Thus, a big seller this year can be a dog (a poor seller) next year.;Another problem is that while some sales trends are national, others pertain to specific;regions. A strong seller in the Southeast may not sell as well in the Northwest. Thus, a brand can;be a big seller in one region and a dog in another.;In answering the following questions, assume you have total sales data for each brand;and model, for each store, for each month. Assume also that you know the stores city and state.;All Questions: Put yourself in the role as a corporate buyer for Home Depot (you work for;Home Depot, you are not a retail customer). Make your answers specific to your role as an;employee of Home Depot.;Question 1: Explain how reporting systems could be helpful to you in your role as a corporate;buyer. Include how it could be used to identify poorly selling models and regional sales trends.;Describe the ways that data on poorly selling models and regional sales trends could be;used to help you do your job as a corporate buyer.;Question 2: Show the structure of at least two reports that you could use to identify poorly;selling models and different sales trends in different regions?;Identify at least two reports that would help you answer the items in the question poorly;selling models and sales trends in different regions. What kind of data would you require on the;reports? How would this data need to be structured this should include information such as;column names and how the data is to be organized on each report.;1;IDS200;Research Assignment 3;Question 3: Write a description of your requirements for one of your reports you stated in;question 2 for an IT professional. Be as complete and thorough as you can in describing your;needs.;Take one of the reports you identified in Question 2 and develop a set of requirements for;that report. These requirements should be written in a way that could go to Home Depots IT;staff so they can implement the reports you need. Describe to them how you would want the;report put together. This would include clearly specifying requirements for what you described;in Question 2 and items such as totals and subtotals required on report;Question 4: Discuss what kind of insights a data mining system might give you on the Home;Depot sales data to help you do your job as a corporate buyer.;Briefly describe data-mining systems. Will they be helpful in providing insights on;Sales data of Home Depot. If yes, discuss what kind of insights on the Home Depot sales data;that a data mining system might give you to help you do your job as a corporate buyer. If not;discuss why you think Data-mining systems will not provide any useful insights on sales data.;Question 5: Determine if a knowledge management system (KMS) could help you identify;poorly selling brands. Describe how a KMS could help you do that or describe why a KMS;would not help you.;Briefly describe knowledge management systems.;Determine if a knowledge;management system (KMS) could help you identify poorly selling brands. If yes, describe how;a KMS could help you do that. If not, describe why a KMS would not help you.;Question 6: Determine if an expert system could help you identify poorly selling brands.;Describe how an expert system would help you do that or describe why an expert system would;not help you.;Briefly describe expert systems. Determine if an expert system could help you identify;poorly selling brands. If yes, describe how an expert system would help you do that. If not;describe why an expert system would not help you.
Paper#33493 | Written in 18-Jul-2015Price : $37