Batch Calculation

Loading saved values…

Raw Materials

Edit base quantities

Shared raw material requirements calculated from Sheet1 per-batch quantities, aligned by ingredient name across products
Material Name	Current stock									Stock balance (g)
Batch need to produce	—									—
Purified Water	g	70,780.00g	168,840.00g	50,000.00g	168,840.00g	36,984.00g	159,690.00g	130,000.00g	82,260.00g	—
Glycerin	g	76,000.00g	160,800.00g	80,000.00g	160,800.00g	152,760.00g	—	53,740.00g	94,000.00g	—
Tartaric acid	g	800.00g	804.00g	600.00g	804.00g	160,558.80g	1,210.00g	400.00g	400.00g	—
Partially Neutralized Polyacrylate (Aronvis 106X)	g	—	16,080.00g	10,000.00g	16,080.00g	16,080.00g	16,080.00g	—	10,000.00g	—
Propylene glycol	g	10,000.00g	16,080.00g	6,000.00g	16,080.00g	—	20,100.00g	—	—	—
Lidocaine base	g	—	16,080.00g	8,000.00g	16,080.00g	—	—	—	—	—
CMC-Na(Sunhere/900 CPS)	g	—	15,276.00g	—	15,276.00g	—	—	—	—	—
Polyacrylic acid (Juyrymer AC-10LHPK)	g	—	4,020.00g	—	4,020.00g	281.40g	14,070.00g	2,000.00g	5,000.00g	—
Disodium Edetate	g	80.00g	281.40g	140.00g	281.40g	14,070.00g	321.60g	120.00g	140.00g	—
Urea	g	2,000.00g	—	—	—	—	—	—	2,000.00g	—
1,2-Hexanediol	g	—	—	—	—	1,206.00g	1,210.00g	800.00g	600.00g	—
L-Menthol	g	—	—	2,000.00g	—	—	804.00g	—	—	—
Dihydroxyaluminum aminoacetate	g	380.00g	723.60g	340.00g	723.60g	361.80g	—	—	200.00g	—
Titanium dioxide	g	—	804.00g	—	804.00g	—	804.00g	—	—	—
Polysorbate 80	g	260.00g	—	—	—	—	2,010.00g	—	—	—
Sodium polyacrylate(MX)	g	—	402.00g	—	402.00g	—	—	1,400.00g	—	—
TiO2	g	600.00g	—	400.00g	—	—	—	400.00g	—	—
Methyl paraben	g	200.00g	402.00g	200.00g	402.00g	—	—	—	—	—
Propyl paraben	g	100.00g	201.00g	100.00g	201.00g	—	—	—	—	—
Materials subtotal	—	161,200.00g	400,794.00g	157,780.00g	400,794.00g	382,302.00g	216,299.60g	188,860.00g	194,600.00g	—

Material Codes

Loading saved values…

Raw Materials

Edit materials

Search materials

60 codes · 66 entries

Editable Raw Materials codes
Material code	Material Type	Material Name	Manufacturer	Actions
	RM		HERBAMED AG
	RM
	RM		Formosa
	RM		Indo German
	RM		Henan Dongtai
	RM		Hubei Biocause
	RM		Delta Synthetic
	RM		MOEHS
	RM		Mahendra
	RM		htba
	RM		Fleming Laboratories
	RM		Hebei Jingye
	RM		POLPHARMA
	RM		Fermenta Biotech
	RM		Kyowa
	RM		Shin Won
	RM		Shanghai Nuocheng Pharmaceutical
	RM		Shanghai Nuocheng Pharmaceutical
	RM		Zhejiang Jiande Zhengfa
	RM		CRODA
	RM		Hunan Jiudian
	RM		Merck
	RM		MUSIM MAS
	RM		ICOF Eroup Gmbh
	RM		DJC CO.LTD
	RM		DOW
	RM		DUPONT
	RM		ASHLAND
	RM		Takehara Kagaku Kogyo Co., Ltd.
	RM		Corbion
	RM		Bhagat aromatics Ltd.
	RM		DOW
	RM		San Fu Chemical co,Ltd
	RM		Wuhu Huahai
	RM		HEALTH TECH BIO ACTIVES SLV
	RM		Toagosei co.ltd
	RM		DOW
	RM		Shangdong Mimei Biotechnology Co., Ltd.
	RM		Toagosei co.ltd
	RM		Toagosei co.ltd
	RM		Jiangxi Alpha
	RM		Jiangxi Alpha
	RM		Toagosei co.ltd
	RM		Toagosei co.ltd
	RM		Ashland
	RM		ASHLAND
	RM		Prachin Pharmachem
	RM		Wuhu Huahai
	RM		CRODA
	RM		HUBEI
	RM		Hunan Jiudian
	RM		CRODA
	RM		Anhui Sunhere
	RM		Toagosei co.ltd
	RM		Paik Kwang Industrial Co. Ltd
	RM		Baekwang
	RM		Merck
	RM		Toagosei co.ltd
	RM		BASF
	RM		Shangdong Kanbo
	RM		Caviro Distillerie
	RM		VENATOR
	RM		Merck
	RM		Roquette
	RM		HISHINE
	RM		ECP

Packaging Materials

Edit materials

Search materials

23 codes · 23 entries

Editable Packaging Materials codes
Material code	Material Type	Material Name	Manufacturer	Actions
	PM		MIRAE POLYCHEM
	PM		MIRAE POLYCHEM
	PM		JAPAN VILENE CO. LTD.
	PM		SHENG HUNG
	PM		KOREA VILENE CO. LTD
	PM		MIRAE POLYCHEM
	PM		MIRAE POLYCHEM
	PM		MIRAE POLYCHEM
	PM		CHANGSU BAILIFU NON-WOVEN PRODUCTS CO.LTD.
	PM		MIRAE POLYCHEM
	PM		WOO GYEONG
	PM		SEWHA PACKAGE CO.
	PM		BAOLI PACKAGING
	PM		SEWHA PACKAGE CO.
	PM		BAOLI PACKAGING
	PM		BAOLI PACKAGING
	PM		TAEYANG ZIPPER CO. LTD.
	PM		ZIPPIAN CO. LTD
	PM		NOVIAL D.O.O.
	PM		NOVIAL D.O.O.
	PM
	PM		Intercommerce SI
	PM		NOVIAL D.O.O.

Editable Finished Products codes
Material code	Material Type	Material Name	Manufacturer	Actions
No materials yet.

Material Entry

Raw Materials

Search materials

Material CodeWL Lot Number

Material arrival entries
Material Code	Material Type	Material Name	Arrival Date	Material Receipt Report Number	WL Lot Number	Manufacture LOT Number	Manufacturing Date	Expiry Date	Retest Date	Quantity	Prices (EUR)	Material Status
No saved arrivals.

Material Test

Raw Materials

Search materials

Material CodeWL Lot Number

Material tests by arrival
Material Receipt Report Number	WL Lot Number	Material/Product Evaluation Number	Test Request Form Number	Sample number	Material Code	Material Type	Material Name	Arrival Date	Quantity	Test items	Test Status
Loading tests…

Stock Control

Raw Materials

Search materials

Material CodeWL Lot Number

Raw Materials — Material Code, Material Type, Material Name, WL Lot Number, Product Name, Batch Number, Batch Volume, Released Quantity, Spends Quantity, Pending Quantity
Material Code	Material Type	Material Name	WL Lot Number	Product Name	Batch Number	Batch Volume	Released Quantity	Spends Quantity	Pending Quantity
Loading stock…

Raw Materials

Raw Materials

Packaging Materials

Finished Products

Raw Materials

Raw Materials

Raw Materials

October