Case Study #3: Break-Even Analysis of Capacity As manager of the Best Drinks Company in Hayward, you would like to sell drinks at a booth during the one-day major celebration in the Hayward's Central Park. The following table provides information about the drinks that you will be selling: Price per unit, $ Var. cost per unit, $ tems Soft Drinks Wine Coffee Tea Water 1.25 5.95 1.99 1.69 1.49 0.49 2.84 0.79 0.40 0.31 % of Sales 0.25 0.10 0.25 0.05 0.35 You estimate labor cost to be S300 (2 people, S150 dollars each per day at the booth). Even if nothing is sold, your labor cost will be still S300, so you decide to consider this a fixed cost. Booth rental, S500, is also a fixed cost. Apply the total fixed cost for your break-even analysis, and do not annualize the fixed cost. . Questions . What is the break-even volume (in dollars) for selling drinks at the booth? Show your calculations usin;g Excel How much would you expect to sell at the break-even point for each item (in dollars and units)? Present and explain your calculations and results in the Excel file