I'm not sure how to create a breakeven graph with this information.
Unit sales price - $120
Unit variable price - $75
Fixed cost - $4500
I figured out that it would breakeven at $100 television sets, but I'm not sure how to create the graph. Could someone help me please?
You will not breakeven at a $ amount, you break even on a quantity Q.
Total revenue is P*Q = 120*Q. Total cost is 4500 + 75*Q. Breakeven occurs when total cost=total revenue -- 120*Q=4500+75*Q. Solve for Q. You can graph the solution also. Both total cost and total revenue are lines. Put $ on the y axis, Q on the x axis.
how do u make one on excel?
how do i do a break even graph on excel
no idea lol
no idea lol
im doing gcse i need help on how to make a break even chart
yes y6es yes yes i am very heffy that u told me because i got 32inch cok but now is 1 inch help me suk it off
To create a breakeven graph in Excel, you can follow these steps:
1. Open a new Excel worksheet and enter the following data in three separate columns:
- Column A: Quantity (Q), starting from 0 and gradually increasing.
- Column B: Total Cost, calculated using the formula "=4500 + 75*A1" (assuming A1 is the first cell in Column A).
- Column C: Total Revenue, calculated using the formula "=120*A1" (again, assuming A1 is the first cell in Column A).
2. Highlight the cells in all three columns with data (A1:CXX, where XX is the last row with data) by clicking and dragging.
3. Click on the "Insert" tab in the Excel ribbon menu and select the type of chart you want for your breakeven graph (e.g., a line graph).
4. A chart will be inserted on the worksheet using the selected data. You can customize the chart style, axis labels, and other elements as desired.
5. You can further enhance your breakeven graph by adding a horizontal line to indicate the breakeven point. To do this:
- Click on the chart to activate the Chart Tools.
- In the "Design" tab, click on the "Add Chart Element" button.
- Select "Lines" from the drop-down menu, and then choose "Line" under "Drop Lines".
- A horizontal line will appear on the graph. Right-click on the line and select "Format Data Series".
- In the Format Data Series pane, choose a solid line type, adjust the line color, and set the line position to the breakeven point.
By following these steps, you should be able to create a breakeven graph in Excel that visually represents the relationship between quantity, total cost, and total revenue.