solve the question

Le Grind Coffee Distributors Mara Comas and Javier Bianchi often tell the Le Grind Cafe customers the story of how they fell in love the first time they literally bumped into each other at a coffee shop near their Austin, Texas campus. At that time, they were sophomores majoring in business. After mutually apologizing to each other, they learned of their shared passion for great coffee and delicious baked goods. They described similar dreams of developing a coffee distribution business that sold the highest quality award-winning organis, fair trade roasted coffee beans. Their following dates were spent finding, visiting, and evaluating as many highly rated coffee shops and bakeries as they could afford! Fast forward ten years: After graduating and working in professional accounting for five years, Mara and Javier officially started their "Le Grind Coffee Distributors" business three years ago in Austin, Texas. Their suppliers provide year-round organic, fair-trade coffee from Columbia, Ethiopia, Guatemala, and Hawail. Le Grind roasts and sells coffee in 5- and 10-pound vacuum sealed bags so that it says fresh and has a reliable transport and shelf life until use. The roasting variety includes light roast, medium roast, dark roast, and expresso. Le Grind added a new coffee from Uganda in their second year. Also, Le Grind has developed two coffee blends, a pumpkin spice seasonal product for the autumn, and a holiday spice seasonal product for year end festivities. In their first year, they built their business distributing colles to many customers in Texas, Oklahoma, and New Mexico. During their second year, they expanded to Louisiana and Arkansas, During their third year, the expanded further to new customers in Alabama, Mississippi, and Tennessee. They have enjoyed continuous growth each year and are now serving many customers colles shops, restaurants, hotels, grocery stores and corporations ( such as accounting firms) in these eight U.S. siales. Mara and Javier are thrilled about how their accounting education prepared them for their successful business launch. However, even though they enjoy growth in new customers and increasing sales revenues and net income each year, they are interested in performing data analysis to better understand what is happening to their sales sales mix that could be negatively impacting their gross margin (Gross Profit/Sales Revenues). which has decreased 2.4% between 2023 and 2025. Here are their summary comparative income statements from the past three years: Le Grind Comparative Income Statements 2023 2024 2025 Sales Revenues $6.131,630 100 %% $ 58,068,728 100 9% $ 202,203,205 100 %% Cost of Goods Sold J.418642 35876 13.284.917 36 5%% 117,635,222 Gross Profit 2.712 958 25,683.791 41946 84,568, 083 Operating 1.819 489 18 575 212 62681,025 Net Income Case Question: 1. Describe the possible motivations for Le Grind Coffee Distributors to perform a gross margin data analysis. Then create at least three possible objective questions (one descriptive and two diagnostic) that they would want answered to gain insights into what is making their gross margin decrease from 2023 to 2025. Feel free to review the data provided with the case to guide your answer. 2. Utilize Excel to conduct your analysis, summarize your findings, and upload the final document to Moodle