there should be detailed excel spreadsheets and also a detailed analysis

Purchase the case online at {cost $9.25 CAD) htt 5: www.ive ublishin .ca 5 roduct kitsch-wines-ex andin -durin -a- andemic 01t5c00000D5AOUAA3 Kitsch Wines: Expanding During a Pandemic The following instructions & questions may be used to guide your case writing report & presentation: 1. Prepare a thorough industry, competitive, and customer analysis of Kitsch Wines: 3. identify recent trends in the Canadian and BC wine and restaurant markets. How will these trends affect Kitsch Wines (KW) and its future performance? What impact will COVlD-19 have? b. Who are KW's competitors? What is KW's competitive advantage? is it sustainable? c. Who are K W's customers? What do they want? d. Overall, what are KW's strengths and weaknesses? While it is not mandatory, consider performing a SWOTanalysis. 2. Prepare a thorough analysis of Kitsch Wines statement of cash flows: 3. From 2019 to 2020, what cash was generated from operations and how was it generated? What are the largest sources and uses of cash ? What does the cash flow statement tell you about Kitsch wines financing and investing patterns? What does this mean for the company going forward? 3. Prepare a thorough analysis of Kitsch Wines' key ratios (from those provided in the case): a. How do the ratios compare year over year? How do the ratios camp are to the industry and competitors 4. Calculate and thoroughly analyze otherfinancial ratios {not provided by the case) for Kitsch Wines: {Minimum 3) a. Why did you select the ratios calculated over other possible ratios? Why are they of significance to Kitsch Wines? b. if possible, compare the ratio selected year after year and provide analysis. c. if possible, perform research to identify industry or competitor benchmarks for these new ratios you calculated. 5. Identify the qualitative & quantitative pros and cons of the production tasting room expansion with and without a restaurant and propose a decision: a. Does this overall situation fit with K W's current operations goals? b. How should your cash flow and ratio analysis be considered in this decision ? *Note: The case goes into significant detail on the various costs associated with the tasting room and restaurant expansion. This detail was provided for managerial accounting analysis to be performed you are NOT responsible for performing this managerial differential/incremental based analysis. Your analysis related to the expansion and restaurant can be limited to a qualitative analysis and quantitatively connecting to your cash flow and ratio analysis\" 6. Based on all your analysis and decisions, create an action plan for Kitsch Wines: 3. Consider their current plans of tasting room and restaurant expansion as well as any new recommendations you have. b. Consider the primary risks associated with your decision and suggest how to mitigate those risks