Use the case write-up and the data below to complete the analysis (cells highlighted in yellow) Product Profit By Category 2020 Category Retail Price Per Unit Coffee Beverages & Food $12 Cost Per Unit $9 Profit Per Unit $3 Units Sold Total Revenue Total Profit Profit Margin 50,000 $ 600,000 $ 150,000 25% Coffee Beans $20 $10 $10 15,000 $ 300,000 $ 150,000 50% Historical Annual Revenue By Category Category 2017 Coffee Beverages & Food Coffee Beans $518,303 $259,151 2018 $544,218 $272,109 2019 $571,429 2020 2021 $600,000 $ 630,000 $285,714 $300,000 $ 315,000 Break Even Analysis Solution Mobile Application/Coffee Beverages & Food E-Commerce Site/Coffee Beans Cost to Implement $16,700 $15,000 2021 Projected 2021 Total Units to Sell Revenue to Breakeven 2021 Additional Units to sell (compared to 2020) 2021 % Increase units sold (compared to 2020) 2021 Additional units to sell - per month 2021 Additional units to sell - per week $ $ 630,000 315,000 53,891 16,535 2,500 750 5 5 208 63 48 14 Formula Key: Total Revenue Total Profit Profit Margin Break Even Price per unit *# of units sold Profit per unit * # of units sold Total profit/ total revenue (Cost of solution + 2021 Revenue) / Price per unit