production planning

Hi, I'm trying to calculate the finish date and time of a production run but excluding hours the factory doesn't work. I have the start date + time and the production hours needed, please help!!!!!

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...

Hello! I'm trying to brainstorm ways to create a way/formula on excel to trigger when I need to start moving production up going into the busy months. Something to break production down by week (like "you need to make this much of item 11111 this week"). I've watched a few videos on how to...

I'm trying to create a production schedule that is 24/7 that will show an overview of what is currently running and when it'll be done. I was able to make macros (which i've never done before) so the code is horrible, I'm sure, but it works for the most part. Essentially, on the Open Orders...

I am currently using a calculation from an older post to calculate end date time using a start date time and a duration. This formula excludes weekends and accounts for a 18hr production day...

Hello, I have a worksheet for demand planning and forecasting that basically shows: <tbody> Stock Monday Demand Tuesday Demand Wed Demand Thurs Demand 10 4 5 4 3 </tbody> I need to write a formula that will tell me how many days my stock will last (ie: how many days, after fulfilling that...

I'm not sure what to call the function I'm looking for, not even positive multiplying by a matrix is the correct name for what I want to do, but I'll describe below. I have a table similar to this: <tbody> (Cell: A1) Components> CompA CompB CompC Products Demand Prod1 500 1 2 Prod2...

Hi, I work for a manufacturing plant where we manufacture one product which is then sold under different names. The product is made from the same material. I am looking for a way to match up production to the orders and then subtract the produced quantity from the orders. Tab 1 - Orders...