BUSI 650: Business Analytics Prescriptive Report: BeanWater Co. Franchising Grading: 15% of overall grade Submission: Feb 26, 2023 Sagar is interested in opening up a franchise for a popular coffee chain, BeanWater Co., in downtown Vancouver and has contracted your firm to analyze three neighborhoods to identify the best location for the store. The objective is to generate as much profit as possible within 5 years. Based on the information provided below and your own research, in which neighborhood should Sagar open the franchise? You are free to make assumptions as necessary, but please make note of it in the report. This report should be no longer than 4 pages, double spaced, APA format, graphics included in text. The cover sheet does not contribute to the page limit. Please submit your report as a PDF document. Your report should have the following sections: Executive Summary, Introduction, Methods, Results, Discussion, Conclusion Rubric (total of 15 points): (1) Executive Summary with recommendation clearly stated ( 1 full page) (1) Introduction (4) Methods (2) Assumptions (2) Describing how costs and revenue were calculated (2) Results (7) Reporting the monthly or cumulative profit of each location (1) Summarizing the takeaway from the numerical modeling (6) Discussion (bullet points OK ) (6) Analyze the impact of 3 non-model related factors on each location (1) Conclusion Items burchased