Planning worksheet
Beverage Shelf Life Sampling Calendar
Enter the date the study starts, the time points your protocol uses and a pull window. The worksheet lists the calendar date for each pull, flags weekend dates and counts the pulls across storage conditions. It schedules work; it does not predict shelf life.
Calculated result
Enter the values above to calculate. Results appear here.
A date schedule only. The protocol sets time points, conditions, tests and acceptance criteria.
What the calendar does
Magnesium beverage shelf life testing runs for months, and missed or late pulls are a common reason a study cannot be used. This worksheet adds each time point to the time-zero date, gives the earliest and latest date inside your pull window, marks dates that fall on a weekend and counts the total pulls so the laboratory can plan sample quantities. Months are added by calendar month, so a study started on 31 January has its one-month pull on the last day of February.
Plan the number of containers from the pull count: each pull at each condition needs enough containers for every test in the protocol plus any retained units. The calendar does not choose tests or time points and does not estimate how long the product will last.
What to settle before the start date
Use processed and packaged product from a representative run as time zero, tested on the start date. Write the storage conditions, the tests at each pull, such as appearance, pH, turbidity, sediment, total magnesium and sensory comparison, and the acceptance criteria into the protocol before the first pull. For a conventional beverage the declared magnesium is a Class I nutrient, so the magnesium result at the later pulls is the one that matters for the label.
Related technical guides
- From powder concept to ready to drink magnesium beverage
- Beverage clarity and stability screen
- Packaging, storage and stability evidence
