Introduce Bundle Manifest Report

Problem Statement

The client uses a Truck Manifest every print day to determine the number and size of newspaper bundles required for distribution.

The required bundle size varies by print day. Their standard bundle sizes are 30 copies on Sundays and 50 copies on Wednesdays, with the ability to change the size when the publication is heavier due to large or heavy inserts.

Currently, there is currently no report that converts these quantities into the number of bundles and remaining copies required for distribution. The legacy manifest performs this calculation using total draw and standard bundle size.

User Story

As a Distribution Manager,

I want to generate a Bundle Manifest for a selected print day,

so that I can see how many bundles and remaining copies need to be prepared for each route.

Definition of Done

• A new Bundle Manifest Report is available under Reports.

• The user can select a fulfillment creation/delivery date.

• The report is grouped by Vendor/Carrier → Route.

• Delivery points within each route are ordered by their existing Delivery Sequence.

• For each delivery point, the report displays:

• Delivery Sequence

• Subscriber / Account Name

• Delivery Address

• Phone Number

• Total Draw / Copies

• Bundle Size

• Number of Full Bundles

• Remaining Copies

• A default Bundle Size can be configured by delivery day:

• Sunday: 30 copies

• Wednesday: 50 copies

• Users can override the bundle size for a specific print/delivery date when needed for heavy or large inserts.

• Bundle quantities are automatically calculated based on the Total Draw:

• Full Bundles = Total Draw ÷ Bundle Size

• Remaining Copies = Total Draw % Bundle Size

• Existing Pelcro data is reused for Vendor/Carrier, Route, Delivery Sequence, Subscriber, Address, Phone Number, and Total Draw.

• The report displays totals per Route and Vendor/Carrier.

• The report can be exported/downloaded.

• Insert mix, returns, ad zones, and other legacy manifest fields are out of scope for V1.