please explain step by step how to get part A and B using the formula or excel if posible.

As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far: Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. Youestimate labor cost to be $250.00 (5 booths with 2 people each). Even if nothing is sold, yeur labor cost will be $250.00, so you decide to consider this a fixed cost. Booth rental, which is a contractual cost at $50.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-even point in dollars for the St. Cloud Theatre Company =$ (round your response to two decimal places). b) Based on the given information, the per night break-even point in servings for wine = servings (round your response to one decimal place). Solution BEPS=i=1n(1pivi)wiF Break-Even Point in $ a In contrast to single product BEPS=i=1n(1pivi)wlFBEPS=1v/pF Break-Even Point in $ a Break-Even Point in for product i. Units for product i > Revenue product i is > Units of product i is needed to generate at needed to sell at break break even point even point BEPSi=wi(BEP$)BEPxi=piBEPSi=plwi(BEP$)