hello, how are you? I would like to quote please a business analytics assignment.is about : Probability Distributions.It would be for Thursday, August 25 at 9am Pacific time. apa style. thank you
Prescriptive Report (15%) BUSI 650: Business Analytics Individual Prescriptive Model: Launching a Cafe in Uptown Chicago Grading: 15% of overall grade Submission: 9PM, Aug 28th on Turnitin Wanting to retire and pursue her passion of small-business ownership, Rose has asked you for help regarding her decision on opening up a cafe in uptown Chicago (Edgewater). The objective is to reach financial sustainability or profitability within 2 years, and break even with her initial capital investment. Specifically, she needs help with the following: - Which shop front location should she rent? - Which products and pricing models should she offer? - What is the monthly cash flow for the business? - Should she open up a cafe? Please use the resources attached below in addition to any other sources you can find to assess the profitability of each option, the overall landscape, and provide a final recommendation to Rose. 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, with your supporting tables and figures included in the appendix. Your report should have the following sections. This is an individual report: Executive Summary, Introduction, Methods, Results, Discussion, Conclusion Rubric (total of 15 points): (1) Executive Summary with recommendation clearly stated (1) Introduction (3) Methods (3)Assumptions (3) Results (1) Assessing the profitability of each option (1) Reporting the monthly cost, revenue, and profit of the business (1) Graphical representation of the data (6) Discussion (5) Analysis of the overall landscape (1) Additional insights that may affect the business (political, legal, climate, etc) (1) Conclusion Store Information Initial investment: $20,000 CAD Available properties: https://www.loopnet.ca/search/retail-space/edgewater-chicago-il/for-lease/ # of customers/day: make assumptions based on the demographic data. Note that # customers may vary depending on weekday/weekend, seasons, etc. Items purchased: You can assume that every customer will buy 1 beverage (100% chance), and may purchase food with it. Please see the probabilities below. You are free to change these numbers if you’d like to propose a new pricing model as well. Classification Item Cost of Goods Sold ($CAD) Selling Price ($ CAD) Probability of Purchase Beverage Coffee (drip) 1.00 3.50 30% Coffee (espresso) 1.20 4.00 45% Tea 1.00 3.00 25% Food Pastries/Snacks 1.50 3.00 20% Meal 5.00 10.00 10% Cost Assumptions: - Staffing: You can assume that Rose will be the only staff, no need for additional staffing costs. - Utilities (Water, Electricity, Wifi, etc): You can assume this as a 10% addition to overall rent (ie. cost of utilities will be an additional 10% of monthly rent). - Equipment & Furniture: You can assume this is included in initial investment. - Cost of Goods Sold: See Table Above. You can assume that COGS includes cups, milk, sugar, etc. Additional Resources: Edgewater Census Information (2020): https://www.point2homes.com/US/Neighborhood/IL/Cook-County/Chicago/Edgewat er-Demographics.html Edgewater Demographic Report (July 2022): https://www.cmap.illinois.gov/documents/10180/126764/Edgewater.pdf More Edgewater Statistics: https://statisticalatlas.com/neighborhood/Illinois/Chicago/Edgewater/Overview https://www.loopnet.ca/search/retail-space/edgewater-chicago-il/for-lease/ https://www.point2homes.com/US/Neighborhood/IL/Cook-County/Chicago/Edgewater-Demographics.html https://www.point2homes.com/US/Neighborhood/IL/Cook-County/Chicago/Edgewater-Demographics.html https://www.cmap.illinois.gov/documents/10180/126764/Edgewater.pdf https://statisticalatlas.com/neighborhood/Illinois/Chicago/Edgewater/Overview Sample Report Executive Summary (1) NOTE: This is an individual assignment. Don’t forget your title page before this with section #s. STATE YOUR RECOMMENDATION & main reasoning. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis interdum sed neque quis ultrices. Proin luctus sem vel quam tincidunt, id maximus enim ullamcorper. Morbi sagittis malesuada pharetra. Sed efficitur diam sed ipsum pharetra, vitae viverra augue vestibulum. Sed eget leo quis urna egestas molestie. Cras imperdiet vel nunc quis vestibulum. Mauris feugiat ipsum eu hendrerit tincidunt. Nulla nec dignissim purus. Cras imperdiet ligula elit, nec scelerisque quam elementum ac. Nunc congue condimentum tincidunt. Donec ut lectus ut purus fermentum pellentesque. Fusce venenatis lectus ac lacinia viverra. Etiam maximus mi et ante ultrices sollicitudin. Nam et lorem diam. Fusce eleifend arcu risus, non posuere ipsum suscipit id. Nullam eget ligula tristique, feugiat metus vitae, rhoncus leo. Introduction (1) Business Context Proin porta eros id lorem cursus aliquam. In massa neque, porta eu dictum at, sollicitudin pharetra tortor. Nunc non nibh ac neque lacinia vulputate. Curabitur rutrum bibendum sapien, feugiat rhoncus lacus ultricies in. In at nulla varius, porta urna vel, tincidunt mauris. Aliquam finibus massa eget tempor fringilla. Goal of Report. Methods (3) 1-2 sentences on general methodology. Aenean viverra, nibh non molestie pellentesque, nisl massa interdum nibh, eu commodo urna ligula eget massa. Aliquam imperdiet felis in turpis tincidunt suscipit. Followed by 5-10 assumptions - Nam diam nibh, aliquam ut justo eu, rhoncus viverra orci. Nulla porta malesuada nunc. - Cras non orci dignissim, egestas tellus vel, placerat dolor. - Integer pellentesque purus nec sem pellentesque, ac sagittis odio vulputate. - Donec semper mauris lacus. Aliquam eget magna sit amet mauris lacinia pharetra. - Nunc mollis sodales mauris, ac rhoncus tellus ultrices et. Results (3) Discuss the main options you looked at and their respective profitabilities. You can attach 1 table (max 1) here if it helps your discussion, or put to appendix. Quisque ut congue dolor. In imperdiet justo sit amet rutrum luctus. In vitae fermentum justo, eu commodo risus. Mention the cost/revenue structure. Fusce accumsan tincidunt nunc, viverra cursus lectus sollicitudin vitae. Maecenas finibus eu risus pretium sagittis. Donec commodo dui ac ex gravida, sit amet congue nunc imperdiet. See Figure ____. Nam blandit, diam id fringilla consectetur, diam enim ornare massa, eu faucibus risus lorem a odio. Phasellus ut tincidunt ligula, et varius tortor. Aenean consequat nec ex et varius. Maecenas semper sollicitudin odio semper ornare. Sed massa elit, pretium non elit sit amet, rutrum finibus justo. State final recommendation. Discussion (6) 6 points total, there should be at least 6 sentences here with unique ideas about the landscape. The last point is for unique and original ideas. Don’t forget to answer the questions in the prompt. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis interdum sed neque quis ultrices. Proin luctus sem vel quam tincidunt, id maximus enim ullamcorper. Morbi sagittis malesuada pharetra. Sed efficitur diam sed ipsum pharetra, vitae viverra augue vestibulum. Sed eget leo quis urna egestas molestie. Cras imperdiet vel nunc quis vestibulum. Mauris feugiat ipsum eu hendrerit tincidunt. Nulla nec dignissim purus. Cras imperdiet ligula elit, nec scelerisque quam elementum ac. Nunc congue condimentum tincidunt. Donec ut lectus ut purus fermentum pellentesque. Conclusion (1) Restate your recommendation and summarize the report. Fusce venenatis lectus ac lacinia viverra. Etiam maximus mi et ante ultrices sollicitudin. Nam et lorem diam. Fusce eleifend arcu risus, non posuere ipsum suscipit id. Nullam eget ligula tristique, feugiat metus vitae, rhoncus leo. Limit is 4 pages for all of the sections, excluding title page, references, appendix. References 1. 2. Appendix Instrucciones: Prescriptive report Executive Summary · This is a summary for the executives, who do not have time to read the report · Start by giving a quick business context & the overall recommendation · Then 1-2 sentences per section on the rest of the report · Summarize at the end · This section should be stand-alone. Give to a friend not in BUSI650 to read, they should understand it. Introduction · Business Context · Expectations for what is to come in the report Methods: · If something NOT in the report instructions is crucial to your analysis, you MUST write it under assumptions · Use APA citations whenever needed. I’m expecting there to be references to all sources of data. · Some of this space can be for your preliminary calculations ie. # of customers/day, and need to be CLEARLY communicated. . As always, present the numbers, then the steps to get there. · I am expecting list form for improved readability. · I am expecting a minimum of 5 assumptions. · Do not include the assumptions already listed in the report instructions Results: · This is your space to show the analysis that you have done. · You should be describing the data and calculations that you did to assess the profitability. · No discussion is expected here, you are JUST PRESENTING the data · This should be approximately 1 paragraph, and up to 1 figure can be in the body of the report. Anything else can go in the appendix. Discussion: · 1 point per discussion point (max 5). · Be comprehensive and consider all aspects of the business · Last point comes from a high quality analysis that shows deep business insight, or identifying something interesting that is often missed. . I’m expecting 20% of reports to get this. Prove me wrong! Conclusion: · Summarize what was done in the report · Make sure you answer the question Final notes: · If you do NOT answer all of the questions asked in the report, it is a FAIL. · This is the last individual report, do your best and have fun with it. · I’m expecting the average for this to be ~80%. · Use the writing center, office hours, tutors as resources . Message me on Teams is fastest way to get a response. I will be active during weekdays, and rarely check messages on the weekend. · Deadline has been extended to 28th at 11:59PM. . No excuses for late submissions, communicate with me if you anticipate issues in advance. · Remember: you’re not competing against each other, there is no bell curve. You’re going against my expectations.