Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Labour Advice (A2k)

    I've been pondering for some time now on Labour Times etc.
    Basically one of the most important parts of my database.

    "" How to handle Productivity, Efficiency, Activity ""

    My problem is how to accomplish this task, whether through several tables, one table or whatever.
    I'm not interested at the moment in the calculations, but the actual input.

    Has any other member dealt with this subject in one of their databases and lend some valuable advice for my direction.

    I was given a demo from Hans the other week, which dealt with Start Date & Times.
    I also account for Hrs worked on Jobs, ie Labour booking.
    Holidays are accounted for.

    At this point I'm unsure on which direction because all these above subjects are in separate tables.

    Any advice would be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Labour Advice (A2k)

    Are you talking about tracking user labor times as an element of your application? Productivity, Efficiency and Activity are a little general and I don't see how they would be tracked in separate tables.
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Labour Advice (A2k)

    Charlotte.
    This is the exact issue.

    Before I start this part of the project ( I've been here before ) I want to make sure I am following the correct route.

    Activity = Cost Hrs / Available Hrs * 100
    Efficiency = Sales Hrs / Cost Hrs * 100
    Productivety = Sales Hrs / Available Hrs * 100

    So three elements need to be addressed, Cost Hrs, Available Hrs, Sales Hrs.
    With my Sales hrs, this is covered by the initial Estimate and Authorised Status
    Cost Hrs are covered with time taken per job.

    The problem lies in Available Hrs, this can be complicated.
    I have to take into account, Holidays, Bank Holidays, Weekends etc. Although again, these are covered,when I look at my database, I'm getting the feeling I will run into problems later on.
    Available hrs ought to be automatically generated,so no data entry is required, ie Hrs avail per month less holidays and pre-booked holidays and then take into consideration, productivity rating, ie Qualified Employee = 100%, None Qualified Employee = From 25% up to 100%.

    See what I mean ??
    hense the post.
    I want to be sure in my mind on the correct direction to follow.


    Thanks for you input here, I may have answered my own post !!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Labour Advice (A2k)

    I see. I think.. I couldn't tell whether tracking user time was part of the application requirement or you were talking about developer time. Which is it? In any case, you shouldn't really need 3 tables, since you can flag each type of hours in the record.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •