Production scheduling

[jheald12]

Hello All,


First I think this forum is amazing and all the people that offer there support, I need some help. I'm assisting a member of staff at work who is struggling with doing production scheduling.

The process is that we pick the material for an Item, then that item is ready 48 hours later currently.

Example

Material Picked . Production completed (48 Hours )
03/12/2017 (Sunday). 05/12/2017
04/12/2017 (Monday AM) . 05/12/2017
04/12/2017 (Monday PM) . 06/12/2017
05/12/2017 (Tuesday AM) . 06/12/2017
05/12/2017 (Tuesday PM . 07/12/2017

We are looking at away to use Excel to help us do this automatically so we can easily see when changing the forecast so for example going from picking material 4 days a week to picking a total of 9 times so 2 picks a days except for Friday then ETA of finished production but excluding weekend for the production date.

I hope some of this makes sense on what we are trying to achieve. Currently it takes him along time and as production is changing he has to re work all the dates again

If any one can help would really appreciate. And also would be willing to donate some money for this

[leelnich]

Hi, welcome to Excel Forum! A small sample workbook (NOT a picture) would really help us to solve your problem quickly and accurately.
Please remove any sensitive or extraneous info.
Try to preserve the original layout so our solutions fit your workbook.
Provide “realistic” data. Include any variations the code or formula must address.
IMPORTANT: Simulate some results to demonstrate what you want.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!

[jheald12]

Hello
Thank you for the quick reply, I have included a draft copy which is only showing 4 day's
Thank you again for your help in advance

[JeteMc]

Looking at the differential in dates it appears that if the materials are picked in the 'AM' the production is completed the following day, otherwise the production is completed two days later. I have attached a file based on this understanding of the question. If my understanding is incorrect please follow leelnich's instructions (the paperclip icon doesn't work) to upload a sample file that shows your set up and expected results.
The formula used to compute when production will be complete is:

Please Login or Register  to view this content.

Let us know if you have any questions.

[jheald12]

That is fantastic, thank-you ever so much he will be thrilled.

Is there anything I can do to say thank-you

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.