What Each Column of the Table Records

Each row captures the same six facts for one order, so no email is read twice. The order number is the reference used on the picking list and the shipping label. Customer and state identify the destination, while items, quantity and order total describe what goes in the box and what it is worth.

Why the Ship-By Column Is Sometimes Blank

Several emails state a deadline, such as needing delivery by October 20 or shipping by October 18. Others give no date at all, and one simply says there is no rush. A blank ship-by entry does not mean the order is unimportant; it means the buyer expressed no deadline, so the order has no fixed calendar anchor.

The Unit Prices Behind the Totals

The emails state prices directly: Vanilla and Sea Salt candles at $18 each, Lavender tins at $9.50 each, the Cedar Gift Box at $45, and the Holiday Bundle at $72. Each order total is simply the unit price multiplied by the quantity in that email. No discount, tax or shipping charge appears in the messages, so the table shows the merchandise subtotal only.

Checking the Arithmetic on the Largest Line

Order 1043 from Bloom Boutique is twelve Lavender tins at $9.50 each, which comes to $114. That makes it the largest single order total in the batch, ahead of the $90 Cedar Gift Box pair and the two $72 Holiday Bundle orders. The size matters for scheduling because picking twelve units takes longer than picking one.

What the Total Row Shows

Adding the quantity column across all ten orders gives 35 units, and adding the order totals gives $666.00. The total row is a summary of the sample batch, not a revenue projection for the shop. It is useful for knowing how much stock the week's packing will consume.

The Assumption About Which Year the Dates Fall In

The deadlines in the emails give only a month and a day, such as October 18 or October 25. The table treats those dates as falling in 2026, based on the working date of October 14 used when the table was built. If a different year applies, every ship-by date shifts and the priority order would need to be recalculated.

Three Orders Have No Deadline at All

Orders 1042, 1044 and 1049 carry no ship-by date in their emails. Order 1042 from James Carter explicitly says there is no rush. Because these three have no calendar commitment, they can be pushed behind any order that does have one.

The First Order to Ship: 1043, Due October 18

Bloom Boutique's order carries the earliest deadline in the batch, October 18, and is also the largest at twelve Lavender tins worth $114. A wholesale order of that size needs more packing time than a two-unit retail order. Both the deadline and the volume point to starting with this one.

The Second Order to Ship: 1046, Due October 19

Olivia Brown's order is next in line, due October 19, one day after the Bloom Boutique deadline. It contains four Vanilla candles at $18 each, for a total of $72. Four units is more picking and packing than a single-item order, which supports handling it early rather than last.

The Third Order to Ship: 1041, Due October 20

Maria Lopez's order is due October 20, the third earliest date in the table. It is small: two Vanilla candles at $18 each, $36 in total. Because it is quick to fulfil, it fits naturally into the same packing session as the two orders ahead of it.

How the Three Priorities Were Selected

The ranking uses one criterion applied consistently: the ship-by date, earliest first. Where two orders share a date, or where a date is missing, the tie is broken by how much work the order requires. Orders with no deadline are not ranked as priorities because nothing in the email commits them to a date.

Why a Deadline Beats an Order Value

A large order with a later deadline is not automatically more urgent than a small order due sooner. Order 1045, two Cedar Gift Boxes worth $90, is due October 22, two days after order 1041 is due. If value alone drove the schedule, 1045 would jump ahead of 1041 and miss the earlier commitment.

Wholesale Orders Often Need Extra Handling

Bloom Boutique and Green Leaf Spa are labeled as sample wholesale accounts rather than individual buyers. Wholesale orders commonly involve more units per shipment, which is true here: twelve tins and six tins respectively. That does not change the deadline logic, but it does mean the packing bench is occupied longer per order.

Everything Due October 21 or Later

Green Leaf Spa is due October 21, Tom Nguyen October 22, Ethan Wright October 23, and Daniel Kim October 25. None of these compete with the first three shipments. Once the October 18, 19 and 20 orders are out, the remaining dated orders can be worked in date order.

When No Deadline Is Stated, Ask the Customer

A blank ship-by cell can mean the buyer genuinely has no timeline, or it can mean the deadline was left out of the email by accident. Confirming with the customer before assuming there is no hurry avoids a surprise later. Until that confirmation happens, the order stays at the back of the queue.

Recalculating the Table When a Date Changes

If a customer replies with a new deadline, or an order is cancelled, the total row and the priority list both change. The table is a working document rather than a fixed record, so it should be updated whenever a new email arrives. Rebuilding the priority list after each change keeps the earliest deadline at the top.

Separating What the Emails State From What Was Assumed

The prices, quantities, customer names, states and deadlines all come directly from the ten emails. The year attached to the dates and the decision to leave blank ship-by cells for undated orders are assumptions made when building the table. Keeping stated facts apart from assumptions makes it clear what would change if an assumption were wrong.

A Similar Sequence in a Made-to-Order Candle Workflow

A public operations template for made-to-order candles describes an ordered pipeline: new order intake, label proof, batch prep and pour, cure and quality check, label and pack, then shipped and review. It notes cure windows of three to seven days before shipping, which matters because curing time sits between intake and packing. The template is a generic workflow rather than a schedule for this sample shop, but it illustrates why candle orders are not packed the moment they arrive.

What This Table Cannot Tell You

The table shows merchandise totals, but it says nothing about shipping cost, tax, payment status or stock on hand. It also says nothing about carrier transit time, which determines whether a parcel actually arrives by the date the customer named. Those gaps have to be filled from the shop's own records before a ship-by date can be treated as achievable.