Inquiry on Planning Detail Display

[Luz Cornejo]

Dear Experts,

It's me again. I have a question on the planning display detail for one item, kindly see some info. below:

[TABLE="width: 468"]
[TR]
[TD]Sample Item A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Item Details:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]No existing forecast[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Safety stock[/TD]
[TD="align: right"]30,250[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]order min[/TD]
[TD="align: right"]1,000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]order multiple[/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]After running MRP generation, the planning detail display shows the[/TD]
[/TR]
[TR]
[TD]following result:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]projected on hand[/TD]
[TD]o/s req[/TD]
[TD]o/s receipt[/TD]
[/TR]
[TR]
[TD]beg bal[/TD]
[TD="align: right"]39,375[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11/29-12/1 forecast[/TD]
[TD="align: right"]37,870[/TD]
[TD="align: right"]1,505[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/12 PO[/TD]
[TD="align: right"]108,970[/TD]
[TD] [/TD]
[TD="align: right"]71,100 [/TD]
[/TR]
[TR]
[TD]12/12 total CO[/TD]
[TD="align: right"]12,250[/TD]
[TD="align: right"]96,720[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/31 forecast[/TD]
[TD="align: right"]11,250[/TD]
[TD="align: right"]1,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/6/2012-PO[/TD]
[TD="align: right"]31,250[/TD]
[TD][/TD]
[TD="align: right"]20,000[/TD]
[/TR]
[TR]
[TD]1/14/2012-forecast[/TD]
[TD="align: right"]30,250[/TD]
[TD="align: right"]1,000[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]
Note: The 71,100 is the result of the order action report. But based on my observation the suggested qty of 71,100 is not sufficient to cater all the CO totalling 96,720, because the item should have a safety stock of 30,250. Kindly correct me if I'm wrong.

Thanks and best regards,
Luz[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[/TABLE]

 

[darrenk]

There should be a "PLN" amount at approx. 12/12 of 30,250 (Safety Stk) - 12,250 (Projected O/H) (in multiples of 100) to fulfill the minimum Safety Stock level.
Again, this is not necessarily a Progress-based problem but a system and business process issue. Suggest, again, that you get a consultant to look at your entire system and its processes. Quick question - what are the Production / Planning people at the company saying about this?

Darren