Case Study & Building Data for Decision Making at Home Depot Home Depot is a major retail chain specializing in the sale of construction, home repair, and maintenance products. The company has more than 2240 retail stores in North America and employs over 340 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, and to ao 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 model's 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 on the East Coast may not sell as well on the West Coast. In other words, a brand can be a big seller in one region and a dog in another. When answering the following questions, assume that you have total sales data for each brand and model, for each store, and for each month. Also assume that you know the store's city and province. 2. Show the structure of one or two reports you could use to identify poorly selling models. How would you structure the reports to identify different sales trends in different regions? 3. For one of these reports, write a description of your requirements that would be suitable for communication to an IT professional. Be as complete and thorough as you can in describing your needs. Case Study & Building Data for Decision Making at Home Depot Home Depot is a major retail chain specializing in the sale of construction, home repair, and maintenance products. The company has more than 2240 retail stores in North America and employs over 340 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, and to ao 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 model's 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 on the East Coast may not sell as well on the West Coast. In other words, a brand can be a big seller in one region and a dog in another. When answering the following questions, assume that you have total sales data for each brand and model, for each store, and for each month. Also assume that you know the store's city and province. 2. Show the structure of one or two reports you could use to identify poorly selling models. How would you structure the reports to identify different sales trends in different regions? 3. For one of these reports, write a description of your requirements that would be suitable for communication to an IT professional. Be as complete and thorough as you can in describing your needs