A chain coffee shop company is considering adding a new line of business of offering small foods and snacks. The CEO of the company hired you as a financial analyst to help the company decide if it is economical to add foods and snacks to its business or not.
You have spent some time gathering information and talking to people in the company and you collected following information.
Complete the following questions and please come up with the solving process and the formulas you used.
- Please do everything in one word or pdf file. You need to use excel to complete the case. Copy and paste excel tables into your report, if needed. Thanks.