NOTE: Your solution should be submitted in Canvas. You may prepare your solution using Word, Excel, or a hand-written papter document that can be scanned and submitted as a .pdf document. Maximum points will be awarded for solutions that are legible and clearly labeled. Less points will be awarded for solutions that are confusing and hard to read. Please include your name and student ID on your solution. Restaurant Information: Following the COVID pandemic, there was a shortage of good restaurants in Columbus. Jordan Burr decided to open a restaurant to capitalize on the opportunity. The restaurant's sales mix and contribution margin since opening are as follows: Jordan is considering a fetv options in order to improve profits. Jordan has a target net income of $176,000. The restaurant's fixed costs are $352,000 each year. INSTRUCTIONS: FOR EACH SCENARIO BELOW, CALCULATE TOTAL SALES AND SALES FOR EACH FOOD ITEM. SHOW YOUR COMPUTATIONS FOR EACH SCENARIO - (a), (b), and (c). (a) To achieve the target net income with the current sales mix and contribution margins above, calculate total restaurant sales and the sales of each food item. (b) Jordan desires to evaluate the impact of certain changes in an attempt to increase sales volumes, as follows: (i) Reduce the contribution margin ratio on Entrees to 10% by reducing sales prices for Entrees. (ii) Increase the contribution margin ratio on Desserts to 50% by reducing variable costs for Desserts. The restaurant's sales mix and contribution margins following these change are as follows: With these changes, calculate total restaurant sales and the sales of each food item to achieve the target net income. (c) Jordan leams that the restaurant can expand into adjacent space, but the additional space will increase fixed costs by 50%. Including the changes in scenario (b) and the increase in fixed costs, calculate total restaurant sales and the sales of each food item to achieve the target net income