Problem: 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.