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

    Workshop Loading & Productivity (A2000 SR1)

    Just wondered, does any one have any examples of Workshop Loading possibly with Staff productivity to give me some idea's on how to approach this project.

    Tips or Demo's are welcome

    Dave

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

    Re: Workshop Loading & Productivity (A2000 SR1)

    I'm unfamiliar with "workshop loading". Could you explain further?
    Charlotte

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

    Re: Workshop Loading & Productivity (A2000 SR1)

    Workshop loading is a calculation of how many hours are available within the workshop to sell:-

    e.g.

    Pete Smith has been a painter for 20yrs, he is fully experienced and earns an experienced salary.
    Lets say the experienced salary is
    Attached Files Attached Files

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

    Re: Workshop Loading & Productivity (A2000 SR1)

    I think the question should be, how can I query the forth coming weeks.
    Do i have to create some kind of date range.

    The calculation part is not difficult.
    Any Idea's or help will be appreciated.

    Dave

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Workshop Loading & Productivity (A2000 SR1)

    Dave,

    I work for a medium size engineering firm where we have departments (turning milling slotting etc). I have attempted to load up the workshop in this way.

    Sales gives the workshop manager jobcards with hours allocated to each deptoperation. On a form, he enters the job number, selects a dept, selects an employee and enters the hours. Each record in the table is a job/dept/employee combination. Another form shows a list box with all employees and the total hours allocated to them as a bar graph. Clicking on an employee opens another box showing the jobs allocated to them in date order.

    The above informaton is kept current with timecard info being entered daily into a seperate table and then the worked hours for each job/dept/employee combination being subtracted from the relevant record in the first table.

    As in your above example, you could multipy the hours for each employee by the efficiency rating to get an accurate bar graph.

    Hope this makes sense to you
    "Heading for the deep end"

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

    Re: Workshop Loading & Productivity (A2000 SR1)

    Hello Allan.
    Thanks for the reply.
    This seems very similar to what I need. We also have the various departments,(Paint,Body,Fit) and yes I had realised to calculate by productivity.
    Is their any possible chance i could have,Maybe a cut down version of your DB to give me some idea's for a starting point.
    Regards
    Dave

  7. #7
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    330
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Workshop Loading & Productivity (A2000 SR1)

    Dave,

    I am in the process of cutting down and documenting for you. I hope to be able to upload it monday or tuesday for you.
    "Heading for the deep end"

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

    Re: Workshop Loading & Productivity (A2000 SR1)

    Thanks for that, it is appreciated.

    Regards
    Dave

Posting Permissions

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