1 Reply Latest reply: Dec 31, 2012 8:32 AM by Mahendra RSS

    MRP Planned order calculation required

    880697
      Hi Oracle MRP experts,

      Actually we are in the need of planned order calculation formula.Kindly find the below Planning detail report for your perusal.
      _______________________________________________________________________________________________
      XXXXXX PVT LTD DELHI INDIA Date: 25-DEC-12 12:15:11
      Planning Detail Report Page: 1182
      Plan Date: 25-DEC-12 10:29:26
      MRP Name: SKD_VD_MRP - MRP FOR VDD WITH NWIP ON

      Plan Type: MRP

      Item: 1-D0405A1100 Base Model: UOM: NOS
      Description: VALVE HOUSING
      Organization: SONA KOYO STEERING SYSTEMS LTD, DHARUHER
      Nettable Inventory: 597 Planning Method: MRP planning Processing Time (Days): 0 Fix Lot Mult: 24.0
      Non-nettable Inventory: 0 Make Or Buy: Buy Pre-Lead Time (Days): 0 Fix Order Qty:
      Receiving Inventory: 0 WIP Supply Type: Operation Pull Post-Lead Time (Days): 0 Fix Days Supply: 6
      Standard Cost: 147.98 Buyer: Fixed Lead Time (Days): 0 Min Order Qty:
      Category Set: SONA DEFAUL Planner: Variable Lead Time (Days): 0 Max Order Qty:
      Category: A Class Shrinkage Rate: Cumulative Total Lead Time (Days): 0 Safety Stock: 750%
      Forecast Control: BOM Item Type: Standard Planning Time Fence Date: 26-DEC-12 Round: Yes
      Annual Projected Demand: 127,388 Exception Set: Acceptable Early Days: Revision: -


      --------------- Horizontal Listing

      End Using Parent 24DEC 02JAN 07JAN 14JAN 21JAN 28JAN 04FEB 11FEB 18FEB 25FEB 04MAR 11MAR
      Assembly Usage SBT Assembly Usage 2012 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013
      ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------
      Gross Requirements 0 1484 2460 2460 2460 2530 2670 2670 2670 2670 2670 2670
      Scheduled Receipts 0 0 0 0 0 0 0 0 0 0 0 0
      Planned Orders 0 *3500* 2448 2472 2592 2736 2664 2664 2664 2688 2664 2664
      Projected Available 597 2613 2601 2613 2745 2951 2945 2939 2933 2951 2945 2939
      Current Scheduled Receipts 0 0 0 0 0 0 0 0 0 0 0 0
      Current Projected On Hand 597 -887 -3347 -5807 -8267 -10797 -13467 -16137 -18807 -21477 -24147 -26817
      Safety Stock 3075 3075 3075 3119 3338 3338 3338 3338 3338 3338 3338


      --------------- Daily Vertical Listing

      |---------------Suggested---------------| |---------Current----------|
      Gross Scheduled Planned Projected Scheduled Projected
      Date Requirements Receipts Orders Available Receipts On Hand
      --------- ------------- -------------- ------------- ------------- ------------- -------------
      25-DEC-12 0.0 0.0 0.0 597.0 0.0 597.0
      26-DEC-12 0.0 0.0 0.0 597.0 0.0 597.0
      27-DEC-12 0.0 0.0 0.0 597.0 0.0 597.0
      28-DEC-12 0.0 0.0 0.0 597.0 0.0 597.0
      02-JAN-13 254.0 0.0 *3,500.0* 3,843.0 0.0 343.0
      03-JAN-13 410.0 0.0 0.0 3,433.0 0.0 -67.0
      04-JAN-13 410.0 0.0 0.0 3,023.0 0.0 -477.0
      05-JAN-13 410.0 0.0 0.0 2,613.0 0.0 -887.0
      07-JAN-13 410.0 0.0 0.0 2,203.0 0.0 -1,297.0
      08-JAN-13 410.0 0.0 0.0 1,793.0 0.0 -1,707.0
      09-JAN-13 410.0 0.0 2,448.0 3,831.0 0.0 -2,117.0
      10-JAN-13 410.0 0.0 0.0 3,421.0 0.0 -2,527.0
      11-JAN-13 410.0 0.0 0.0 3,011.0 0.0 -2,937.0
      12-JAN-13 410.0 0.0 0.0 2,601.0 0.0 -3,347.0
      14-JAN-13 410.0 0.0 0.0 2,191.0 0.0 -3,757.0
      15-JAN-13 410.0 0.0 0.0 1,781.0 0.0 -4,167.0
      16-JAN-13 410.0 0.0 2,472.0 3,843.0 0.0 -4,577.0
      17-JAN-13 410.0 0.0 0.0 3,433.0 0.0 -4,987.0

      Kindly suggest how the planned order 3,500 calculated. If any calculation formula available kindly send.