60.1K

Verified Solution

Link Copied!

Eunice manages a Thai restaurant in a primarily Asian section of a major West Coast city. She is interested in determining dolar sales and number of guests needed to break even and to generane desired profts. Her check average (seling price) is $16.00, her variable cost per unit (quest) $5 60, and her fxed costs are $170.000 3. a a Complete the following grid, and determine her before-tax prof SP VC CM 170 24,000.00 40% ax rate Before-tax 3.b. Using the information from part a, calculate the function for "Rounded achieve desired after-tax profit following. (Spreadsheet hint Use the ROUNDUP up-Break-even point in guest served and "Rounded up-Guests served to Break-even point in sales dollars Break-even point in Rounded up guests served Sales dollars to achieve desired after tax proft Guests served to achieve desired after tax profitRounded up- 3.c. Based on her calculations, Eunice doesmt think that she to achieve her desired after-tax profit. Therefore, she has decided to make some changes to improve her situation. $1 00, decrease her variable cost percentage by 5%, and lower her fixed costs by $5,000. After hese changes, what are Eunice's sales dollars and guests served to achieve her after-tax profit? can attract as many guests as she needs Due to these changes, she has been able to reduce her selling price by Comple Use the ROUNDUP function for te the following grid and calculations. (Spreadsheet hint Rounded up-Guests served to achieve desired after-tax profit Per Unit (Guest) Percentage SP VC CM Fixed costs Sales dollars to achieve desired after tax profit Guests served to achieve desired after tax profit Rounded up

Answer & Explanation Solved by verified expert

See Answer