Explore BrainMass

Breakeven- in units, in dollars

17. You are in the business of selling widgets. You retail these fine looking widgets for $25.00 a piece and you have 1,000 of them in inventory. If your total fixed costs are $150,000 and your total variable costs are $10,000 what is:

Your breakeven in units________________________

Your breakeven in dollars______________________

Prove that this is truly your breakeven figures by creating a simple income statement showing your Revenues, Fixed Costs, Variable Costs, and Net Income.

Please respond in Excel.

Solution Summary

The solution calculates Breakeven- in units and in dollars.