Add Lots Required with airSlate SignNow

Add lots required

okay so I had some questions on how to solve problem six in Chapter 12 let me go ahead and read the question to you says we're given the company that makes a table also ship 100 units at the beginning of day for 150 units at the beginning of day 5 and 200 units at the beginning of day 7 receipts of a hundred would sections are scheduled at the beginning a day to the odd hand balances are braces equal 60 and legs equal 120 lead times in days are for all items are shown in the table below and the product structure is shown also so each table they make takes two wood sections three braces and four legs okay and depending on the quantity any one of these that we're going to get order lead time the lead time is going to be yeah is going to be dependent on how many we order okay so we want to find we want to find a material requirements plan for a lot to law degree for alignment items so I want to hit and pre-made this master schedule and we can go ahead and put some this information like you can look at the master schedule I made it has a day and the quantity needed for each day okay and it says here that any they need 100 at the beginning of day four so I can go here and put a hundred and then at the beginning of day five they need 150 and the may need a seven they need 200 okay so so the gross requirements are going to be the same here this equals this right and I could copy that across okay video ending on hand is a zero okay so basically way this formula works what you would do is I'm going to say this equals zero or this equals this so basically the next on hand predicted on hand is going to be equal to the previous on hand okay plus up grant planned order receipts - the gross requirements and then plus what we scheduled to receive on that day has also their clinic copy that all the way across and so what are my net requirements here my projected on hand is zero my and I need 100 so my net requirements are going to be equal to this - my projected on hand so I so that would give me my requirements each one of these days okay and my plan order receipts well I knew I've been basically in you'd order 100 right and here I need order 50 and here I'm gonna need 200 okay I can go ahead and clear this off yeah so let me go ahead and put a little formula here so you can read what I'm putting in here hold on one second I do I'm gonna add a little formula oops I add a little formula here so you can read what I put okay so so now each one of these they need a hundred of these on day four what's the lead team lead time for quantity 100 is the one daily time so I'd have to order them right here okay and here also for how you quantity of 150 plus between 0 and 200 so my lead time would be equal to OOP one day so I need to order these right here and 200 review time is also my one day to day time so I need to order these right here so that's okay so that's my table all right so now for the wood sections we need to wood sections okay so if I'm ordering a hundred tables I need to wood sections for each table so my gross requirements are going to be equal to this times two okay I can copy that across I remember I did it on this lead time not on here because after order this I need this table here so in order to build this table I have to have these okay so it's right below that I'm going clear this good this arrow just be confusing and the wood sections says it says up it says here that the wood sections we're going to have a hundred scheduled for the beginning day - so the wood sections a two is going to be 100 coming in all right and there's no beginning inventory all right okay and then all of those let's copy this format down copy paste copy hey okay and we'll copy this across okay so so we started always there all we got a hundred so how are projected on the end of a hundred on day two now date three what are my net requirements okay my net requirements are going to be my gross requirements - my projected on hand one hundred rate so I'm going to need this many on this day so I copy this formula across and I go ahead and make these zeros okay so now that's that's for my wood sections let me copy these again okay so a hundred we know 100 I need a one day time for 300 how many days I need I need two days so really I need this 100 plus I need this 300 so I need 400 right there now for 400 if you go up here the lead time for 400 two days so I would need these right here okay and that would mean my wood sections okay so now let's look at the braces we need three braces we also want to check and see what it said about braces since we have sixty braces on hand so I'm going to put beginning inventory 60 okay so now this is going to be day one we're going to have sixty I'm gonna go ahead and copy this formula again and copy it across and so let's see we need three three braces for each table and so I would say this now I would say this is equal to how many tables I need times three okay and I'll copy that across again I'm going to clear these two because zero doesn't really mean much here so these are my gross requirements on legs and remember I need those on the day I release the order so I couldn't get the order going it is because I have a one daily time for the table itself okay now so what are my net requirements here it's going to be equal to 300 minus 60 is 240 so I'm gonna have to release an order of 240 I can drag these across yeah and I'm going to clear a hotel control and highlight all this the right click and go clear compounds those never leave me much here and so now I need 240 on day 3 240 is a 2 day 18 time so I say that's equal to their need order those 450 is also a 2 daily time so I say this equals this and 600 is a three-day time so I go 1 2 3 and this equals that so this is the one I'm going to have to release the orders update 248 to 450 and 300 600 on day 3 so if you're the production planner you have to already release an order today all right in order to get it - in order to get my my orders get enough parts in order to produce the table starting day 3 in order to ship a day for ok alright so let's go ahead seems complicated you kind of get the hang as we call so let me go ahead and copy these formulas again alright so so now on on day or on the legs we need 4 legs so again so it's going to so this requirement the growth requirement is going to be equal to 100 I need a hundred tables and for laid won't each table copy that across I'm going to clear these two because it don't you the zero there this all right there's also projected on hand for that it says there's 120 legs on hand so I'm a beginning inventory 120 this equals this copy this formula down and I can drag that formula cross again and so now my neighbor Karma's here they're going to be equal to 400 minus 120 so my planned ordered receipts going to be equal to that there I guess across I can clear this okay so two hundred and eighty my leave time for 280 is two days so I'd have to order that today 600 elite time is three days so I have to all sort of those today so I'm going to have to go Plus this and then 800 is three days so that I would say this is right here because this is take for one to three days to get there okay and now to be my answer right there and let me copy this worry and that's answer so these are basically we're trying to get at when do I need to release orders after all much so I'm going to highlight these yellow so these are what we're doing all that work for because these we need your disorders for legs for 888 legs on day 1 for 800 legs on day 3 in order to get to get these to get these made in time okay so it just gives us what orders need to be recently and that's all