What is the method of making the breakeven statement?

1, as shown in the figure, all the red numbers in the table must be entered through the formula. The formula is marked. This process is to dynamically analyze the Excel breakeven chart through the following controls. Select the table data area-click Insert-Recommended Chart-Scatter chart with smooth lines and data markers.

2. Method/step 1 step 1, breakeven point sales formula If the fixed cost of a product is12,000 yuan, the unit variable cost is 100 yuan, and the price is 2 10 yuan, try to determine the breakeven point sales.

3. Make a table, enter the formula "= (d 31-c 31) * e 31-b 31"in the cell F3 1, and select the menu command.

4. Basic formula: sales revenue = sales volume * sales unit price; Total cost = fixed cost+unit variable cost * sales volume; Break-even point sales = fixed cost/(sales unit price-unit variable cost); Break-even point income = break-even point sales * average sales unit price In this experiment, the amortization fee is 5% and the tax is 2%.