Question: Breaking Even : Best Cycle specializes in making custom racing road bikes. The company wants to determine how many bikes Best Cycle needs to sell
Breaking Even: Best Cycle specializes in making custom racing road bikes. The company wants to determine how many bikes Best Cycle needs to sell per year to break even (i.e., achieving a zero profit when total cost equals total revenue). The spreadsheet named "Breaking Even" provides details of the bike price (Cell C5), unit cost (Cell C7), and fixed cost (Cell C8) of the production. Using the "Goal Seek" feature in Excel, find the demand that will enable the company to break even. Enter the break-even demand in the nearby box
| Mountain Cycle | ||
| 5 | Bike Price | $ 2,500 |
| 6 | Demand | |
| 7 | Unit Cost | $ 1,575 |
| 8 | Fixed Cost | $ 65,000 |
| 9 | Revenue | |
| 10 | Variable Cost | |
| 11 | Profit | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
