Assignment 8: Kent-Chick Sensitivity Analysis in Excel Kent-Chick is a restaurant that currently offers only chicken sandwiches. Currently they sell 400 chicken sandwiches per week. Kent-Chick's owner has noticed an increased demand for hamburgers and she is considering adding hamburgers to the menu. The variable cost of a single chicken sandwich is $2.50. The variable cost of a single hamburger is $3.00. Currently, Kent-Chick has fixed costs of $200; adding the hamburgers to their menu will cost the restaurant an additional $350 per week in fixed costs. The owner predicts that if hamburgers are added to the menu, 25% of their current customers will switch from purchasing a chicken sandwich to purchasing a hamburger, and another 14% of their customers will now purchase a hamburger in addition to a chicken sandwich. She further predicts that introducing the hamburger will bring in an additional 90 new customers each week, and that these new customers will only purchase a hamburger. Currently the restaurant is charging $4.50 per chicken sandwich, and the owner intends to charge $5.00 per hamburger. In Assignment 7, you determined the impact on Kent-Chick of introducing hamburgers given the predictions above. In this Assignment, you need to conduct your own sensitivity analysis to determine if you can change the impact on Kent-Chick with the marketing decisions you make. The owner's ultimate goal is to make $2,000 in net profit per week. What would you recommend the owner do in order to achieve this goal? Raise prices? Reduce costs? Attract new customers or encourage more customers to purchase both a chicken sandwich and a hamburger? Any other ideas? Conduct a sensitivity analysis using your Excel workbook from last week to see how close you can get to the owner's $2,000 net profit goal. Communicate your recommendation in a concise yet effective manner. Submit your recommendation on a separate tab in your Excel workbook, and prepare a presentation to present to the owner of Kent-Chick next week