Skip to content
DeutschDERequest Sample

Planning worksheet

Raw Material Reorder Point Calculator

Convert planned beverage output into kilograms of magnesium ingredient per day, then calculate a reorder point from your own lead time, release time and safety stock. Everything is a deterministic plan from the numbers you enter.

Your production plan. The initial values are arithmetic examples.

Exclude magnesium supplied by water or other ingredients.

Use the assay basis approved for planning.

Your documented figure for compounding and filling loss.

Enter the lead time agreed with your supplier. The example is not a supplier commitment.

Time from receipt until the lot is released for use.

A policy choice for your team, not a statistical guarantee.

Used to size the suggested order.

Do not count quarantined or allocated stock.

Confirmed quantities already ordered.

Order quantities are rounded up to whole packs.

Calculated result

Enter the values above to calculate. Results appear here.

Results are a deterministic planning estimate. They do not forecast demand or guarantee supply.

How the reorder point is built

For bulk magnesium glycinate for beverages, the planning chain runs from servings to kilograms. Daily use = servings per week ÷ 7 × elemental mg per serving ÷ (assay % ÷ 100) ÷ (1 − loss %) ÷ 1,000,000. The reorder point covers use during the supplier lead time and the receiving and release time, plus the safety stock you chose: reorder point = daily use × (lead days + release days + safety days).

The stock position is released stock on hand plus confirmed open orders. When the position is at or below the reorder point, the worksheet suggests an order that brings the position back to the reorder point plus the chosen days of cover, rounded up to whole packs. With the initial example, daily use is about 3.06 kg, the reorder point is about 122.4 kg and the suggestion is 9 packs of 25 kg.

What this worksheet does not do

It does not model demand variability, supplier reliability or service levels, and it does not add quarantined, expired or allocated material to available stock. Safety stock here is days of use that your team decides, not a probability. Recalculate whenever the production plan, serving target, assay basis or agreed lead time changes, and check shelf-life or retest dates before ordering more than you can use.

Related technical guides