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
pls do using excel As a prospective owner of a
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!