Hi,
A little bit of background, I am a Production Planner and my planning is based on a worksheet which reads values for all inventories available. Most of my planning is to build KITS (which is a Finished Good SKU composed of many child SKUs)
If I want to build a kit TK-101 I want to be able that on my working tab I can see if I am able to produce such KIT based on the child SKUs for that KIT.
An example of my working tab looks:
FINISHED GOOD PLAN YES/NO TK-101 1000 NO
An example of my tab reading inventories:
FINISHED GOOD COMPONENT DESCRIPTION WH10 WH13 WH16 TK-101 BOX-151 POST TREATMENT TRIAL KIT BOX 405 0 0 TK-101 CHILD1 COMPONENT1 1000 200 10000 TK-101 CHILD2 COMPONENT2 0 200 10 TK-101 CHILD3 COMPONENT3 20000 10000 50000 TK-101 CHILD4 COMPONENT4 35000 55000 100 TK-101 CHILD5 COMPONENT5 2000 0 0 TK-101 CHILD6 COMPONENT6 13000 15000 5000 TK-101 CHILD7 COMPONENT7 13000 12000 10000
As you can see above, I would want to have visibility on my first tab (SHEET1) where I am planning my production. As of now, I have to go back from tab to tab to see if I have all inventories available on child SKUs.
What I am looking for is that SHEET1 can write YES or NO if it reads on SHEET2 that one of other components is under a value. If <100 write NO; if >100 write YES
Let me know if I am clear enough and if I need to upload a sample worksheet.
Thanks for your time in reading this thread.
Bookmarks