View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Hourly labor formula

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!