| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
I am trying to determine recommended headcount for a store.
Each store needs to achieve 75% store a has 6 people and is 50% efficient store b has 4 people and is 75% efficien I know my recommended headcount for store A should be reduced by 2, but how do I create a formula to do that since I have over 100 locations to analyze? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
How do you calculate 'efficiency'?
"Liz" wrote: I am trying to determine recommended headcount for a store. Each store needs to achieve 75% store a has 6 people and is 50% efficient store b has 4 people and is 75% efficien I know my recommended headcount for store A should be reduced by 2, but how do I create a formula to do that since I have over 100 locations to analyze? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
headcount for store A =6*50%/75%
-- Jacob "Liz" wrote: I am trying to determine recommended headcount for a store. Each store needs to achieve 75% store a has 6 people and is 50% efficient store b has 4 people and is 75% efficien I know my recommended headcount for store A should be reduced by 2, but how do I create a formula to do that since I have over 100 locations to analyze? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
