Question: pls do using excel As a prospective owner of a club known as the Red Rose, you are interested in determining the volume of sales
pls do using excel
As a prospective owner of a club known as the Red Rose, you are interested in determining the volume of sales dollars necessary for the coming year to reach the break-even point. You have decided to break down the sales for the club into four categories, the first category being beer . Your estimate of the beer sales is that 30,000 drinks will be served. The selling price for each unit will average $1.75; the cost is $1.25. The second major category is meals, which you expect to be 12,000 units with an average price of $12.00 and a cost of $5.00. The third major category is desserts and wine, of which you also expect to sell 12,000 units, but with an average price of $2.75 per unit sold and a cost of $1.25 per unit. The final category is lunches and inexpensive sandwiches, which you expect to total 24,000 units at an average price of $6.00 with a food cost of $3.50. Your fixed cost (.e., rent, utilities, and so on) is $1,600 per month plus $2,000 per month for entertainment a) What is your break even point? b) What is the expected number of meals eaach day if you are open 30 days a month
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
