You're welcome. If you need anything else, let us know.

Regards,
Fred.

"Merc" wrote in message
...
If your sales are not high enough then people must go home so that you
will
not eat into your profit. You would take the hourly wage of each person
and
multiply it the number of people working then divide it by your hourly
sales.
That percentage is what determines if you are high or low for labor. I
have a
schedule with formulas in it already. I would like to just add this to it
so
that all of the information is in one file. Thanks.

"Shane Devenshire" wrote:

Hi,

Need more info. For example are you sending them home because they've
meet
their quota or because of poor performance. What are the values that
trigger
this behavior, are there any other considerations, like they were out
sick,
not being counted? Are you basing this on 1 day's performance, a week, a
month, a quarter, a year? Does it matter what department they are in.
Is
this based on sales dollars, or sales volume? Are all sales equal - I
sell 1
Lear Jet, but John sells 50,000 roles of toilet paper.

Cheers,
Shane Devenshire

"Merc" wrote:

I have a schedule that exists prior to starting with this company. I
would
like to incorporate a formula into this schedule so that managers will
know
when to send people home based on sales. I would appreciate any help!