Case Background, Objectives, and Motivation For as long as he can remember, Jean-Luc Fournier dreamed of owning his own bakery. After attending Le Cordon Bleu Paris, he worked hard in his hometown of Aix-en-Provence at his mentors bakery, Boulangerie Jacques. While celebrating in Marseilles for his promotion to head baker, he met an up-and-coming pastry chef, Emma, who was studying the art of French pastries. After a year, they wed and moved to Emmas hometown of New York City. Together they knew they could fulfill Jean-Lucs dream of opening his own bakery by bringing a little bit of France to New York Citys Upper West Side. With Jean-Lucs bakery experience and Emmas pastry experience, they opened Lucs Boulangerie & Patisserie in early 2020. After a difficult year, the bakery finally started doing well in early 2021. It continued to do well in 2022, and Jean-Luc decided to seek outside help to ensure the fledgling business would support them in their future endeavors. Jean-Luc has hired your firm to help him determine the direction he needs to take for optimal profitability. The boulangerie currently offers a wide range of daily-made breads, tarts, and pastries. The daily offerings vary some, and holiday-related baked goods are only available around the specific holidays. In addition to their baked goods, they serve both hot and cold sandwiches and drinks. Other than the cost of goods sold, Lucs has the following expenses: rent $70,000 per year (including electricity), payroll and benefits $100,000 per year, and general selling and administrative expenses $35,000 per year. Because fourth quarter numbers for 2022 are not yet available, you need to forecast revenues and cost of goods sold for the quarter. Assume that other expenses didnt change significantly from the previous year. Provide a comparative analysis of the two years, highlighting any trends you see. Make recommendations based on your analyses. Jean-Luc is thinking about changing his menu and possibly offering fewer items. He would like assistance determining which items are most profitable and if he should discontinue offering any. Jean-Luc also desperately needs a vacation but does not have another baker who can keep the shop open. To take his vacation, he would close Lucs Boulangerie & Patisserie for two weeks. Using analytics, provide the two weeks that would be best for his vacation. Finally, is there any other data you would like to have in order to provide more information for Jean-Luc? Why? Extra Credit (optional): Perform any other analysis you think would be useful to Jean-Luc. You do not have to include this in the presentation. At the end of the report include an Extra Credit section and discuss your findings from the additional analysis. Instructions Data Analysis: Use the data provided for your analysis. You will need to explore and gain an understanding of the data. You may use Excel to do this, but you must use Alteryx for data 1 preparation. All steps must be documented in Alteryx and in the required report. Tableau is to be used for the visualizations and any dashboards you create. You may also use a Tableau story as an alternative to a PowerPoint presentation. Report: You are required to document all the steps you take in the planning, analyzing, and reporting in a written report. You may use visualizations in your report. This document should be a formal report using proper grammar, capitalization, punctuation, and proper sentence and paragraph structure. You should have an introduction and a conclusion. You may use bullet points sparingly if appropriate, but each point must be explained. I do not want lists of bullet points. The report should also have a cover page and a table of contents. Submissions will be evaluated on: The quality of the opening and conclusion in the presentation The clarity of the graph(s) and visualizations The logic of the data story The feasibility and usefulness of the conclusions/recommendation(s) The presentation design and delivery The quality and completeness of the accompanying written report. Before you record your presentation, I suggest you perform the following steps: 1. Complete the Plan stage of the MOSAIC data analysis process. You may use Excel to understand your data. Everything else must be done in Alteryx and Tableau. 2 2. For the Analyze stage, conduct your data preparation using Alteryx. Perform your data analysis using Tableau. Make sure what you use is appropriate for your analysis. 3. Use Tableau visualizations for the Report stage. Be sure to use visualizations that best support your conclusion(s) and recommendation(s). You may use other tools such as Excel sparingly, but make sure it makes sense to do so. Using Excel because you do not know how to use a formula in Tableau is not a valid reason to not use Tableau