How do you setup a Break Even Analysis Worksheet


A

Alvina Burch

YOU CAN CALCULATE THE NUMBER OF UNITS YOU MUST SELL TO BREAK EVEN POINT IF
YOU KNOW THE FIXED EXPENSES, THE PRICE PER UNIT AND THE EXPENSE (COST) PER
UNIT.YOU HAVE BEEN HIRED BY FAIRVIEW CLOTHING TO CREATE A DATA TABLE THAT
ANALYZES THE BREAK EVEN POINT FOR PRICES BETWEEN 8.00 AND 14.25 IN INCREMENTS
OF 0.25 tHE FOLLOWING FORMULA DETERMINES THE BREAK EVEN POINT

BREAK-EVEN POINT= FIXED EXPENSES/(PRICE PER UNIT-EXPENSES PER UNIT) NOW I
NEED TO MAKE THIS INTO A WORK SHEET HOW DO I GO BY DOING IT
 
Ad

Advertisements

G

galimi

Alvina,

Enter all of the data you mentioned. Where you specify the formula, just
enter the equal sign and replace the names you wrote with the cell references
that correspond.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top