Having problems with dates and calculations

[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 isntance job runs 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 in order to hit the due date).

I need to establish a calendar in access (completed). The calendar will
identify 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 values 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.

 

[Olduke]

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 isntance job runs 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 in order to hit the due date).

I need to establish a calendar in access (completed). The calendar will
identify 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 values 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.

From your table which holds the data, create a query.
You will need a calculated field in the query which we will call Quota.
Quota is the number of items required divided by the number of days you have
to do the job. (Example, 100 items divided by 10 working days equals 10
items per day).
Quota[ItemsOrdered])/([NumberDays])
Create a second calculated field in the query we'll call PlusMinus. This
field is the number of items created minus the Quota.
PlusMinus:Sum([ItemsCreated])-Sum([Quota])
You will have to set both Quota and PlusMinus to Expressions or you will get
an error message.