+ Reply to Thread
Results 1 to 1 of 1

Trying to create a batch by batch and weekly schedule adherence sheet.

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Trying to create a batch by batch and weekly schedule adherence sheet.

    Hi All,

    so my aim is to try and establish how well our machines operate in according to what we scheduled them to do. SO.. how i have approached it is to use the difference in run time, and the absolute difference in start time to work out how much of the time (and therefore production quantity) was made when we wanted it to be made. But i'm not sure i have it quite right yet.

    I want to make sure that when products are scheduled, we make the exact amount at the exact time (100% schedule adherence). But if you make everything scheduled and you either started late, but finished on time or started on time and finished early then this would also mean schedule adherence is 100%.

    Everything else should hit the adherence in it's correct proportions- i have had a first stab at it, but it's not quite there.

    Also if the production run is short.. this should also impact the schedule adherence....

    any help would be greatly appreciated!


    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1