1. Home
  2. Knowledge Base
  3. Parts
  4. Parts: Part Planning Variables Analysis

Parts: Part Planning Variables Analysis

Part Planning Variables Analysis

Part Planning Variables Analysis - Basic and Costs pane

This window is accessible from the MRP Order Options Menu which is on either the MRP Purchase Order Recommendations window or MRP Work Order Recommendations window.

The Basic and Costs pane shows the part and some basic cost and quantity data. You can click on the Update Costs button to recalculate current costs using a single-level cost calculation.

The What-If Planning pane contains an area for planning variables in which you can change values and see the results projected within the What-if block on the right.

The following un-stored values are calculated as shown:

  • Planned Maximum Stock Quantity = Minimum Order Quantity* + Re-Order Level
  • Yearly Usage = computed from the last period usage fields covering at least a year
  • Stock Rotation = Yearly Usage / ((Minimum Level + Planned Maximum) / 2) I.E. an estimate of the number of expected stock cycles per year

If you click on the Save What-if button, any changes you have made to Stock Rotation, Minimum Level, Lot Size, Lead Time, Minimum Order Quantity and Re-Order Level will be saved in the part master record. Clicking on Revert, closes the window without any datafile changes.

Note NOTE: Changes made here will affect the part in future MRP runs. It WILL NOT change recommendations for P/WOs currently held in the MRP results file.

The Purchase History pane of the window contains a list showing Purchase History.

Customisation CUSTOM CAPABILITY: You may wish this window to be available elsewhere in Caliach Vision. If so, you can add it into the Parts ScratchPad menu. You will need to add the following code to oCustom1.$PartsScratchTitleNN and oCustom1.$PartsScratchMenuNN methods in the normal way:

$PartsScratchTitleNN
-------------------
Quit method 'Part Planning Analysis'

$PartsScratchMenuNN
---------------------
Test for window open {wPtmPlan}
If flag false
Do $windows.wPtmPlan.$open('',kWindowCenter)
End If
Do $iwindows.wPtmPlan.$PartSelected(MEMORY.m_PtmList.PTMPTNO)

Window Contents

Field

Description

Part number

Parts Master. Part number unique identifier. {PTMFILE.PTMPTNO char 18}

Description

Parts Master. Part description. {PTMFILE.PTMDESC char 30}

The window has 3 tab panes.

Basic and Costs 
What-If Planning 
Purchase History 

Basic and Costs

Field

Description

Index 1 code

Parts Master. Index 1 code. {PTMFILE.PTMP1CD char 4}

ABC Class

Parts Master. ABC classification. {PTMFILE.PTMABC char 1}

Stock UoM

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char 6}

Index 2 code

Parts Master. Index 2 code. {PTMFILE.PTMP2CD char 4}

Lowest Level Number

Parts Master. Lowest level number within the BoM. {PTMFILE.PTMLLNO number 0dpShortnum}

Sales UoM

Parts Master. Sales unit of measure. {PTMFILE.PTMSAUM char 6}

Physical current value

The value of physical stock based on Current Cost.

Projected current value

The value of projected stock based on Current Cost.

Current Unit Cost

The part’s total Current Cost.

Physical standard value

The value of physical stock based on Standard Cost.

Projected standard value

The value of projected stock based on Standard Cost.

Standard Unit Cost

The part’s total Standard Cost.

Physical quantity

Parts Master. Inventory physical quantity. {PTMFILE.PTMPHYQ number 3dp}

Projected quantity

The projected stock quantity = Physical – Allocated – Due to SOs + Due from P/WOs.

Current Quantities

For details see the Parts Current Quantity subwindow.

Period Usage

For details see the Parts Usage subwindow.

Button

Action

Update Costs

Use this button to update the Current Cost for the part based on a single-level roll-up. Opens the Part Costs Update window.

Back to top

What-If Planning

Part Planning Variables Analysis - What-If Planning pane

Field

Description

Existing and What-If Values

Stock rotation

Parts Master. Stock rotation turns per year. {PTMFILE.PTMROTA number 3dp}

Subject to Engineering Change

Parts Master. Engineering Change in progress flag. {PTMFILE.PTMENGC boolean}

MRP offset time

The current MRP offset days, either purchase or manufacturing.

Minimum level

Parts Master. Minimum stock level. {PTMFILE.PTMMINS number 3dp}

Lot size

Parts Master. Lot size when ordered. {PTMFILE.PTMLOT number 3dp}

Lead time

Parts Master. Lead time in active (buy or make) days. {PTMFILE.PTMLEAD number 0dpShortnum}

Yearly Usage

The part’s yearly usage based on the last available usage figures.

Minimum order quantity

Parts Master. Re-order quantity. {PTMFILE.PTMREQT number 3dp}

Re-order level

Parts Master. Re-Order level. {PTMFILE.PTMROLE number 3dp}

Total current MRP demand

The total direct and dependant demand quantity in the current MRP results file.

Total MRP recommendations

The total recommended new orders in the current MRP results file.

Total procurement listed

The total listed new orders in the order recommendations listing window.

Planned Max. stock quantity

Planned maximum stock quantity = Re-order Level + Minimum Level adjusted for Lot Size.

Planned Max. stock cost (cc)

Current cost value of Planned Maximum stock quantity.

Planned Max. stock cost (sc)

Standard cost value of Planned Maximum stock quantity.

Planned Min. stock cost (cc)

Current cost value of Minimum Level of stock.

Planned Min. stock cost (sc)

Standard cost value of Minimum Level of stock.

Suggested Values Based on What-If and Period Usage

Yearly Usage (what if)

A value for Yearly Usage based on the ‘What-If’ figures you have entered.

Yearly Usage (period 1)

The value for Yearly Usage based on the Period 1 history.

Yearly Usage (period 2)

The value for Yearly Usage based on the Period 2 history.

Yearly Usage (period 3)

The value for Yearly Usage based on the Period 3 history.

Minimum order qty (what if)

Recommended Minimum Order Quantity based on ‘What-If’ values and Yearly Usage.

Minimum order qty (period 1)

Recommended Minimum Order Quantity based on Period 1 Usage.

Minimum order qty (period 2)

Recommended Minimum Order Quantity based on Period 2 Usage.

Minimum order qty (period 3)

Recommended Minimum Order Quantity based on Period 3 Usage.

Re-order level (what-if)

Recommended Re-Order Level based on ‘What-If’ values and Yearly Usage.

Re-order level (period 1)

Recommended Re-Order Level based on Period 1 Usage.

Re-order level (period 2)

Recommended Re-Order Level based on Period 2 Usage.

Re-order level (period 2)

Recommended Re-Order Level based on Period 3 Usage.

Planned Max. stock quantity (what-if)

Resultant Planned maximum stock quantity based on your ‘What-If’ entries.

Planned Max. stock quantity (period 1)

Resultant Planned maximum stock quantity based on Period 1 Usage.

Planned Max. stock quantity (period 2)

Resultant Planned maximum stock quantity based on Period 2 Usage.

Planned Max. stock quantity (period 3)

Resultant Planned maximum stock quantity based on Period 3 Usage.

Planned Max. stock cost (cc) (what-if)

Current cost value of ‘What-If’ Planned Maximum stock quantity.

Planned Max. stock cost (cc) (period 1)

Current cost value of the resultant Planned Maximum stock quantity for Period 1 Usage.

Planned Max. stock cost (cc) (period 2)

Current cost value of the resultant Planned Maximum stock quantity for Period 2 Usage.

Planned Max. stock cost (cc) (period 3)

Current cost value of the resultant Planned Maximum stock quantity for Period 3 Usage.

Planned Max. stock cost (sc) (what-if)

Standard cost value of ‘What-If’ Planned Maximum stock quantity.

Planned Max. stock cost (sc) (period 1)

Standard cost value of the resultant Planned Maximum stock quantity for Period 1 Usage.

Planned Max. stock cost (sc) (period 2)

Standard cost value of the resultant Planned Maximum stock quantity for Period 2 Usage.

Planned Max. stock cost (sc) (period 4)

Standard cost value of the resultant Planned Maximum stock quantity for Period 3 Usage.

Button

Action

Revert

Aborts the process currently in session. The keyboard equivalent is the Esc key for Windows computers and Command-.(full stop or period) for the Mac.

Save What-If

The OK button updates the data you have entered, or confirms the selection and/or processes the function you have called.

Back to top

Purchase History

Part Planning Variables Analysis - Purchase History pane

See Purchase History List subwindow for details.

Back to top

See also: –

Compiled in Program Version 5.10. Help data last modified 4 Jun 2012 04:48:00.00. Class wPtmPlan last modified 10 Oct 2017 11:48:34.

Was this article helpful?

Related Articles

Get started.

Try our state-of-the-art ERP Manufacturing Software today.