Question: Create a CVP chart and equations using the following figures to calculate the break-even point in dollars. The Old Mill Restaurant has an average check

Create a CVP chart and equations using the following figures to calculate the break-even point in dollars. The Old Mill Restaurant has an average check of $24.15. Its variable costs were 44% of total sales, and the fixed costs were $28,112.

please use Excel if you can, thank you very much

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 Accounting Questions!

Extra Credit FAB210 Cost ControlStudent Name_____________________________________________________________ 1. (10 points) For one 3-hour dinner period in a restaurant that has 150 seats. Server Number...

Food and beverage sales will both increase by 5% Food and beverage cost percentages will remain the same Please complete the change and upcoming year columns based on the following information:...

4. (10 points) Income Statement with Budget Please complete the change and upcoming year columns based on the following information: Food and beverage sales will both increase by 5% Food and beverage...

Please complete the change and upcoming year columns based on the following information: Food and beverage sales will both increase by 5% Food and beverage cost percentages will remain the same...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

Can you review my paper, please? Executive Summary The food service industry has been the most growing in Ohio.Bagel Bliss is located at 6370 5 th street in downtown Cleveland, Ohio.The company is an...

Listen to the following videos and then complete the assignments using the changed numbers on the guidance report. Place your answers on the guidance report. Open the Guidance Report and rework the...

I have attached the corresponding lessons for assignment 8, it usually includes practice problems at the bottom that look similar to the assignment. ASSIGNMENT 7 JOB ORDER COSTING Directions: After...

Last year you recently started work as an employee of Powershop (an energy provider) in Australia, working in their IT department. You were pleased to secure this job and are proud to work for a...

For the data given in Example 7.3.3, test the goodness-of-fit that the data follows: (a) The gamma pdf and (b) The Weibull pdf. Example 7.3.3 4, 41-18 29998 43333 44222 55544 76666

You are interested in buying a share of stock in CAD Cerporation. Yoe expest a dividend puyment of 5 0 . 5 0 next year and that the dividend will grow by 5 % per year thereafter, You desire a 1 0 $...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

9. Are your presentation aids solid, and do they back up your main points (without overwhelming your speech)?

7. Have you defined your terms clearly and related unfamiliar terms to familiar ideas?

3. Locate a persuasive speech that you found particularly compelling. Print it out and edit it, removing any and all of the material that you feel is persuasive in nature (for example, the speakers...