Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Data Analysis Setup | Setting up and Configuration of Excel | |||
Break Even Analysis | Excel Worksheet Functions | |||
break-even analysis | Excel Discussion (Misc queries) | |||
Break Even Analysis | Excel Worksheet Functions |