Question

Project #1 - Break Even Analysis A simple break even analysis asks the question: How many...

Project #1 -

Break Even Analysis A simple break even analysis asks the question: How many books do you have to sell in order to make back your initial investment, otherwise known as breaking even. We make this calculation by looking at the total income, or gross sales, and equating it to the sum of the fixed costs, variable costs and profit from the items. Breaking even means that you go from negative profit to positive profit and the actual point where that transition occurs is when profit is equal to zero.

Gross Sales = Price per Unit * # of Units Sold

Fixed Costs do not change Variable

Costs = Cost per Unit * # of Units sold

1) Gross Sales = Fixed Costs + Variable Costs

2) P*X = FC + V*X + Profit; Profit = 0

3) P*X = FC + V*X

4) P*X – V*X = FC

5) X(P-V) = FC

6) X = FC/(P-V)

So the way to calculate the total number of units needed to break even, X, which is calculated by FC/(P-V). Please explain your logic/process, some of the calculations from excel and graphs if appropriate.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Break Even Analysis Instructions: Find the Break Even point (in units) using the following financial statement....
Break Even Analysis Instructions: Find the Break Even point (in units) using the following financial statement. Assume rent, insurance, and loan interest are fixed expenses. The other expenses are variable, including the cost of goods sold. SAMPLE CELL PHONE COMPANY PROFIT AND LOSS STATEMENT August 2015 Operating Revenue: Product Sales $12,000.00 $500*24 phones Service Sales $3,000.00 $125*24 service plans Total Operating Revenue $15,000.00 Operating Expenses: Cost of Goods Sold $7,000.00 $291.67*24 phones Gross Profit $8,000.00 Operating Expenses: Rent $1,500.00 Insurance...
Break-Even Sales Under Present and Proposed Conditions Battonkill Company, operating at full capacity, sold 109,100 units...
Break-Even Sales Under Present and Proposed Conditions Battonkill Company, operating at full capacity, sold 109,100 units at a price of $102 per unit during the current year. Its income statement for the current year is as follows: Sales $11,128,200 Cost of goods sold 3,944,000 Gross profit $7,184,200 Expenses: Selling expenses $1,972,000 Administrative expenses 1,190,000 Total expenses 3,162,000 Income from operations $4,022,200 The division of costs between fixed and variable is as follows: Fixed Variable Cost of goods sold 40% 60%...
Match the term with the correct definition or explanation.    Cost-Volume-Profit (CVP) analysis    Break-even analysis...
Match the term with the correct definition or explanation.    Cost-Volume-Profit (CVP) analysis    Break-even analysis Relevant range Fixed costs Variable costs    Contribution margin    Contribution margin ratio Margin of Safety Absorption costing Variable costing Budgeting    Sales budget Production budget    Direct materials budget Cash budget Fixed budget Flexible budget Standard costs Standard overhead costs a. This method excludes fixed overhead costs from total product costs. b. A budget that is prepared based on several different amounts of...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 165,500 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 165,500 units at a price of $117 per unit during the current year. Its income statement is as follows: Sales $19,363,500 Cost of goods sold 6,864,000 Gross profit $12,499,500 Expenses: Selling expenses $3,432,000 Administrative expenses 2,067,000 Total expenses 5,499,000 Income from operations $7,000,500 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 118,500 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 118,500 units at a price of $45 per unit during the current year. Its income statement is as follows: Sales $5,332,500 Cost of goods sold 1,890,000 Gross profit $3,442,500 Expenses: Selling expenses $945,000 Administrative expenses 570,000 Total expenses 1,515,000 Income from operations $1,927,500 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP analysis shows how revenues, expenses, and profits behave as volume changes, which helps identify problems and create solutions. In CVP analysis, costs are classified according to behavior: variable or fixed, rather than by category: product (which includes both variable and fixed) or period (which includes both variable...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income...
Mastery Problem: CVP Analysis - Constructing a Cost-Volume-Profit Chart CVP Analysis and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP analysis shows how revenues, expenses, and profits behave as volume changes, which helps identify problems and create solutions. In CVP analysis, costs are classified according to behavior: variable or fixed, rather than by category: product (which includes both variable and fixed) or period (which includes both variable...
Break-Even Point Hilton Enterprises sells a product for $115 per unit. The variable cost is $76...
Break-Even Point Hilton Enterprises sells a product for $115 per unit. The variable cost is $76 per unit, while fixed costs are $357,435. Determine (a) the break-even point in sales units and (b) the break-even point if the selling price were increased to $123 per unit. a. Break-even point in sales units units b. Break-even point if the selling price were increased to $123 per unit units Target Profit Trailblazer Company sells a product for $245 per unit. The variable...
Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...
Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 120,150 units at a price of $117 per unit during the current year. Its income statement for the current year is as follows: Sales $14,057,550 Cost of goods sold 6,942,000 Gross profit $7,115,550 Expenses: Selling expenses $3,471,000 Administrative expenses 3,471,000 Total expenses 6,942,000 Income from operations $173,550 The division of costs between fixed and variable...
Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...
Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 86,400 units at a price of $93 per unit during the current year. Its income statement for the current year is as follows: Sales $8,035,200 Cost of goods sold 3,968,000 Gross profit $4,067,200 Expenses: Selling expenses $1,984,000 Administrative expenses 1,984,000 Total expenses 3,968,000 Income from operations $99,200 The division of costs between fixed and variable...