mjacquot82
New Member
- Joined
- Jan 2, 2018
- Messages
- 34
As i am sure it is said in many posts, i have looked and tried but still can't figure it out.
I am trying to automate the following.
Product #1 to make = 32 300 pcs
Product # 2 to make = 35 160 pcs
Product # 3 to make = 21 873 pcs
It takes 8500 pcs to fill one truck, how many trucks will it require and what will the end time be for all the product #'s ( So # of trucks needed, and what time will production move from #1 to #2 ).
This is over 2 production shifts, one starting at @ 4:15 with a 30 minute break @ 8:50am and shift ending @ 12:45pm. Second shift starts @ 1:30 pm with 30 minute break @ 5:45pm with shift ending @ 9:45 pm.
I know how to calculate the basic, like how many hours are needed for each product and i know how do it all manually. But trying to enter it all in excel is beyond me !
Any help would be greatly appreciated. I am just trying to be more efficient and save time.
A bonus would be being able to figure out what time would the supplies need to leave the warehouse if they are needed 30 minutes before production starts at the production plant. So example would be if they are 3 hours away ( this would vary ) and needed for 4:15 they would need to leave warehouse @ 12:45 am.
Thank you !
I am trying to automate the following.
Product #1 to make = 32 300 pcs
Product # 2 to make = 35 160 pcs
Product # 3 to make = 21 873 pcs
It takes 8500 pcs to fill one truck, how many trucks will it require and what will the end time be for all the product #'s ( So # of trucks needed, and what time will production move from #1 to #2 ).
This is over 2 production shifts, one starting at @ 4:15 with a 30 minute break @ 8:50am and shift ending @ 12:45pm. Second shift starts @ 1:30 pm with 30 minute break @ 5:45pm with shift ending @ 9:45 pm.
I know how to calculate the basic, like how many hours are needed for each product and i know how do it all manually. But trying to enter it all in excel is beyond me !
Any help would be greatly appreciated. I am just trying to be more efficient and save time.
A bonus would be being able to figure out what time would the supplies need to leave the warehouse if they are needed 30 minutes before production starts at the production plant. So example would be if they are 3 hours away ( this would vary ) and needed for 4:15 they would need to leave warehouse @ 12:45 am.
Thank you !