Excel filling in the MRP for you .xlsx

Exams
Uploaded by Tommy Croese 1743 at 2020-05-30
Description:

Make sure to add all the required numbers (green on the graph) and to reed the instructions carefully or it won't work. (FYI: You don't have to put any number in the cell of the order quantity it is just to put L4L or FOQ) Good luck!!

 +11
306
6
Download
No area was marked for this question
Hey man, there's an issue with th enet requiremtns row as you didnt lock the safety stock cell reference. now it just shifts to the right.
Yeah I have realised it, normally it should be fixed on the excel I uploaded with all the chapters!
No area was marked for this question
What if there are more weeks/days tho ?
what does DB mean?
Dame blanche in this case It’s just the number of parts you need to make the thing above
How to we change the lead time manually? I do not understand
The planned order releases do not influence the rest of your table, so you can just adjust them yourself. I.e. if you have a lead time of 1 week the POreleases of week 1 are the POReceipts of week 2. If you have a 2 week lead time, the POreleases is week 1 are the POReceipts of week 3
No area was marked for this question
can you make it longer cause its usually 8 weeks/days thanks
No area was marked for this question
I realised 4 cells turned to 0. The formulas that should be in them are the following: D43: =(C43 + D45 - D41 + D42) D44: =(D41 + B35 - C43 - D42) E43: =(D43 + E45 - E41 + E42) E44: = (E41 + B35 - D43 - E42)