B
baldguy27
I am trying to solve the following problem: I am using this database to
monitor the efficiency and scheduling for jobs on a production line.
Individuals will input the number of parts they complete in a day, and the
number of people who worked on the job. The report / form will show them how
many parts they should get in a day versus how many parts they actually
completed. It will also show them how many parts they must complete each day
for the remainder of that jobs schedule (for instance job rscheduled from 1/1
through 1/10. If they are behind schedule on 1/6 it will tell them how many
parts they must make per day, for the remainder of the schedule, in order to
hit the due date).
I established a calendar in access. The calendar
identifies our work days and hours to work on those days (ex Monday 9.5,
Tuesday 9.5,etc) excluding Friday, Saturday, Sunday, and Holidays (as those
are not scheduled work days).
Right now I have a table that includes product information with job number,
bid time, quantity, etc. I have another date table that includes the date,
day of week, and number of work hours on that day.
I am having problems because I need to evaluate how many parts they need to
get done for the remainder of the job for work days only. However, since
everyone knows overtime is a reality, it is possible for us to work on Friday
and Saturday. I don't want those days figured into the initial calculation
for parts needed for the remainder of the job schedule. But if we do work a
Friday or Saturday I would like those parts totals and time worked added
into the equation.
The database will also show current efficiency based on total hours worked
on the job, versus bid time.
If you can help I would really appreciate it.
monitor the efficiency and scheduling for jobs on a production line.
Individuals will input the number of parts they complete in a day, and the
number of people who worked on the job. The report / form will show them how
many parts they should get in a day versus how many parts they actually
completed. It will also show them how many parts they must complete each day
for the remainder of that jobs schedule (for instance job rscheduled from 1/1
through 1/10. If they are behind schedule on 1/6 it will tell them how many
parts they must make per day, for the remainder of the schedule, in order to
hit the due date).
I established a calendar in access. The calendar
identifies our work days and hours to work on those days (ex Monday 9.5,
Tuesday 9.5,etc) excluding Friday, Saturday, Sunday, and Holidays (as those
are not scheduled work days).
Right now I have a table that includes product information with job number,
bid time, quantity, etc. I have another date table that includes the date,
day of week, and number of work hours on that day.
I am having problems because I need to evaluate how many parts they need to
get done for the remainder of the job for work days only. However, since
everyone knows overtime is a reality, it is possible for us to work on Friday
and Saturday. I don't want those days figured into the initial calculation
for parts needed for the remainder of the job schedule. But if we do work a
Friday or Saturday I would like those parts totals and time worked added
into the equation.
The database will also show current efficiency based on total hours worked
on the job, versus bid time.
If you can help I would really appreciate it.