可爱老虎erp 术语函数（ERP term function）
This batch method will determine the order quantity of a planned order as a quantity or multiple that is previously determined by experience.
党建工作个人总结
POQ Periodic Order Quantity (periodic batch method):
The lot rule is derived from PRS, which is the net demand for veral periods, but the number of periods is determined by EOQ. In other words, this is a period of order is determined by the EOQ regular asssment method.
LFL Lot For Lot (batch batch method):
This plan orders batch produced and each net demand is equal. In the logic of MRP, if the LFL lot rule is ud, the amount of planned orders will be equal to the net demand.
USC万岁崖
CC
OH On-Hand Inventory (in stock):
The time or the implementation of MRP query inventory, inventory is in the warehou.
AL Allocated Inventory (rerve):
The rervation amount is ud to indicate the quantity that has been designated for a given order, outsourcing order or
transfer order, and the actual quantity that has not been taken out from the warehou. When the production planner issued system order and requisition, MRP will be the number of components of the system order, the scheduled completion period, into the component in transit volume (SR), at the same time, each of the component is ud as the retained amount of record number of parts". When the parts are petty, will also reduce the amount in the bank and retention. Rervation is not available inventory, can not be ud for other purpos.
GR Gross Requirement (demand):
In MRP, the sum of independent demand and material dependent demand is called the total demand.
SR (OO) Scheduled Receipts, On-Order Inventory (in transit volume):
The quantity that will be obtained at a certain time in the future, also known as an already opened order or an already paid amount, is a future inventory, which is deemed to be available during the period of delivery.
POH Projected On-Hand (expected in stock)
In a period (period), if there is no planned order collection (PORC), the expected amount at the end of the warehou is called the expected amount in the library. MRP u POH to determine the net demand in certain period (NR).属猪和属羊
PAB Projected Available Balance (expected amount):
When the expected amount is available, the end inventory of each period of the planned order collection (PORC) is considered, that is, the expected quantity in the warehou (POH) plus the planned order quantity (PORC) is equal to the expected amount (PAB).
NR Net Requirement (net demand):
The total demand period (GR) docked in the library volume (OH), in transit volume (SR) and safety stock (SS), they have
Net demand (NR). More precily, in MRP logic, if the expected amount of pool (POH) is less than SS, the difference is NR.
PORC Planned Order Receipts (planned order receipt):
Planned order delivery (PORC) refers to the amount of material expected to be received in the future periods (periods). This quantity is planned before the order is nt out (PORC); after the order is issued, the quantity is in transit (SR). Net demand (NR) is adjusted by lot size and safety time (ST), and then it becomes planned order collection (PORC).
POR Planned Order Releas (program order):
The planned order delivery (PORC) goes forward one time before the scheduled order is issued (POR). The parent's planned order delivery (POR) will be expanded by the material table, and the total demand of all its components (GR) will be calculated. When the planned order is issued, the planned order delivery (PORC)
becomes SR, the planned order issuing (POR) no longer exists, and the aggregate demand (GR) is no longer needed for the subsystem.
CO Customer Order (customer orders):
量块
From customer orders, inform the demand for certain products and time. According to the actual needs of customer orders and is different from the forecast demand.
the fsc forecast sales (销售预测).
对未来需求的估计.预测可以根据经验主观估计, 也可以用数学方法由历史资料求出, 或两种方法并用.
dtf demand time fence (需求时栅).
天赋英文需求时栅 (dtf) 是在mps计划期间中的一个时间点 (tfp), 设定于目前日期与计划时栅之间.在目前日期到dtf之间, 包含确认了的客户定单.在此期间内, 除了经过仔细分析和上级核准修改外, mps 时不能改变的.
planning time fence (ttf 计划时栅).
计划时栅介于dtf和计划期间的最后日期之间.在dtf和ptf间包含了实际以及预测的定货, 而在ptf之后则只有预测之客户定单.在
dtf与ptf之间, 实际客户定单逐渐取代预测数量.
atp available to promi (可应答量).
可应答量 (atp) 是公司的库存及计划生产量中未被承诺的部分.atp
通常显示在mps报表中, 以支持业务员让他们能合理地向客户承诺定单交期.可应答量在mps报表中出现在第一期以及所有有mps的期间.在第一期中, atp等于在库量加上mps (如果是正数的) 减已到期和已逾期之客户定单量.在第一期之后的任何有mps数量的期间, atp 等于mps减该期到下一个有mps计划数量期间之前一期的所有客户定单总和.某期间算出的atp若为负数, 则业务员已超量承诺定单, 此时, 应从前一个atp减去不足之数而使该期的atp调为0.罗宝文
相关函数学习
if
执行真假值判断, 根据逻辑测试的真假值, 返回不同的结果.
if 对数值和公式进行条件检测可以使用函数.
语法 1
心跳过快是怎么回事if (logical _ test value _ if _ true value _ if _ fal)
logical _ 或的任何数值或表达式计算结果为 true fal test.
the value _ _ true logical _ test 为 true 时函数的返回值.如果 logical _ test 为 true 并且省略 value _ if _ 则返回, true, true.
the value _ _ true 可以为某一个公式.
the value _ _ fal logical _ test 为 fal 时函数的返回值.如果 logical _ test 为 fal 并且省略 value _ if _ fal, fal if _ 则返回 fal.value _ 可以为某一个公式.
