If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you setup a Break Even Analysis Worksheet
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 |
#2
|
|||
|
|||
How do you setup a Break Even Analysis Worksheet
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. -- http://www.ExcelHelp.us 888-MY-ETHER ext. 01781474 "Alvina Burch" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|