Warehouse Operations Spreadsheet Bundle for Excel, Freight Costs, Inventory Counts and Production Capacity

Bring freight costs, inventory count review and labor capacity planning into three focused Excel workbooks.

INCLUDED WORKBOOKS
Freight Profit Analyzer
Compare completed-order revenue, matched product costs, shipping income and billed freight in one editable workbook. Split-shipment costs aggregate by Order ID. Open orders stay out of completed-order profitability until you mark them Complete.
Limits: 250 orders and 500 freight charges per file. Contribution excludes overhead, taxes, payment fees and other unentered costs; it is not net profit. Use one currency throughout. All freight invoices must be entered manually.

Inventory Cycle Count Tracker
Record inventory count events by SKU and location, compare the final count with system quantity, and review the value of differences. An optional recount overrides the first count, including a valid zero recount.
Limits: 250 count events per file. Exact-match accuracy is the share of completed count events with zero unit variance, not a weighted quantity measure. Each event counts separately. This workbook does not update your inventory system.

Production Capacity Planner
Compare available productive labor hours with scheduled job requirements. Enter people, shift hours, breaks and efficiency for each center/day, then add jobs with quantities, standard labor minutes per unit and setup labor hours.
Limits: 100 work-center/day capacity records and 250 jobs per file. This is labor capacity planning, not machine scheduling. Sequence, due dates, materials and job priorities remain manual. Spare capacity at one center may not offset overload elsewhere.

The bundle contains the same three workbooks sold individually in this shop. Buy the bundle or the individual products you need; buying both duplicates files. The workbooks are separate and do not sync data between them.

FORMAT & SOFTWARE
Digital download only. No physical item. You receive a ZIP containing three editable XLSX workbooks, Quick Start text file and one-business internal-use license. Microsoft Excel desktop 2019 or later / Microsoft 365 is required. Excel software is not included. Other spreadsheet apps, including Google Sheets and Numbers, have not been verified.

HOW IT WORKS
1. Download your ZIP through Etsy in a web browser after payment is confirmed.
2. Extract the ZIP and save a working copy of the XLSX.
3. Read Start Here. Replace the clearly labeled DEMO records in blue input cells.
4. Keep gray formula cells intact and resolve check flags before using the dashboard.

No macros, live carrier feeds, accounting sync, inventory integrations or automatic imports are included. Data entry and business decisions remain yours.

LICENSE & SUPPORT
One purchasing business may use and modify the file internally, including across its employees. Resale, redistribution, public sharing, sublicensing and inclusion in other template products are prohibited. For file questions, contact the shop through Etsy Messages with a redacted example.

CREATION DISCLOSURE
Created with AI assistance for the OpsFlow Templates collection. The workbook’s calculations and worked examples were checked. Screenshots show included sample data. Microsoft and Excel are trademarks of their respective owner; this product is independent and not endorsed by Microsoft.