IP1 Inventory Management Portal Hero / App Shell / Navigation

            
            Global Food Solutions — Warehouse Operations
          

Inventory Management Portal

Real-time stock visibility across Edgewood, NY and Hermitage, PA facilities.
Receiving, pick/pack/ship, cycle counts, transfers, lot tracing, temp monitoring, and FIFO enforcement.

Total SKUs

1,247

+18 new this month

Total Inventory Value

$4.2M

+6.3% vs. prior month

Inventory Turns (Annual)

8.4x

Target: 7.5x

Fill Rate

96.8%

+1.2% vs. prior month

All Facilities

Edgewood, NY

Hermitage, PA

Edgewood, NY

131 Heartland Blvd

SKUs

847

Value

$2.8M

Utilization

78%

Hermitage, PA

2500 Freeland Rd

SKUs

400

Value

$1.4M

Utilization

64%

Portal shell uses locked GFS header/sidebar components. Sidebar nav links to all 14 operational modules. Facility data syncs from NetSuite every 15 minutes.

IP2 Inventory Dashboard KPI Cards / Stock by Facility / Category Breakdown

Total SKUs

1,247

+18 new this month

Inventory Value

$4.2M

+6.3% vs. prior month

Turns Ratio (Annual)

8.4x

+0.6 vs. target 7.5x

Fill Rate

96.8%

+1.2% vs. prior month

Stock Levels by Facility

Edgewood, NY — Stock by Zone

Refrig A

Refrig B

Frozen A

Frozen B

Dry 1

Dry 2

Staging

Hermitage, PA — Stock by Zone

Refrig A

Refrig B

Frozen

Dry 1

Dry 2

Staging

Inventory by Category

Category	SKUs	Value	% of Total	Turns
Cheese	312	$1,428,000	34.0%	6.2x
Eggs	189	$892,000	21.2%	14.8x
Dairy	275	$756,000	18.0%	10.2x
Dry Goods	204	$504,000	12.0%	5.4x
Oils	118	$336,000	8.0%	7.1x
Frozen	149	$284,000	6.8%	4.8x

Dashboard auto-refreshes every 15 minutes from NetSuite inventory sync. Turns ratio = COGS / Average Inventory. Fill rate = lines shipped on time / lines ordered.

IP3 Stock Levels — Real-Time Grid Item / Location / Bin / On-Hand / Committed / Available / On-Order / Reorder / Status

All Locations

Edgewood

Hermitage

SKU	Product	Location	Bin	On-Hand	Committed	Available	On-Order	Reorder Pt	Status
GFS-CHD-4010	Bongards Barrel Cheddar 40 lb	Edgewood	RA-04-B	148	36	112	200	50	In Stock
GFS-EGG-2001	Large Grade A Eggs 30 dz	Edgewood	RA-02-A	28	22	6	150	100	Critical
GFS-BUT-1050	Unsalted Butter 36/1 lb	Edgewood	RA-06-C	42	18	24	80	60	Low
GFS-MZZ-2200	Mozzarella Loaf 6/5 lb	Hermitage	RA-01-D	220	85	135	0	80	In Stock
GFS-PAN-1440	Brown Box Pancakes 144 ct	Edgewood	FA-02-C	60	12	48	100	30	In Stock
GFS-FLR-3200	All Purpose Flour 50 lb	Hermitage	D2-08-A	85	30	55	200	120	Low
GFS-OIL-5510	Soybean Oil 35 lb JIB	Edgewood	D1-03-B	18	14	4	60	30	Critical
GFS-CRM-1100	Heavy Cream 12/1 qt	Edgewood	RA-03-A	96	40	56	0	40	In Stock

Showing 1-8 of 1,247 items

«

1

2

3

...

156

»

Available = On-Hand - Committed. Status: Critical (available < 25% of reorder point), Low (available < reorder point), In Stock (available ≥ reorder point).

IP4 Receiving Inbound POs / Receive Entry / Temp Check / Lot & Bin Assignment / QC Hold

Inbound Purchase Orders — Today (May 19, 2026)

PO #	Vendor	Items	ETA	Dock	Status
PO-2026-04821	Bongards Creameries	Barrel Cheddar 40 lb (200 cs)	08:30 AM	Dock 1	Received
PO-2026-04835	Cal-Maine Foods	Large Grade A Eggs (150 cs)	10:15 AM	Dock 2	In Progress
PO-2026-04842	Dairy Farmers of America	Unsalted Butter (80 cs), Heavy Cream (60 cs)	01:30 PM	Dock 1	Scheduled
PO-2026-04848	US Waffle Company	Brown Box Pancakes 144 ct (100 cs)	03:00 PM	Dock 3	Scheduled

Receive Entry Form

GFS Inventory — Receiving Module

Receive Shipment

PO# PO-2026-04835
Cal-Maine Foods

PO Number

Received By

Date / Time

Dock

Line	Item	Ordered	Received	Temp (F)	Lot #	Bin	QC Hold	Status
1	Large Grade A Eggs 30 dz	150 cs						OK

Temperature Verification

Recorded: 38.2 F — Acceptable range: 33-41 F — PASS

Quantity Check

Ordered: 150 cs — Received: 148 cs — Shortage: 2 cs (1.3%)

Temp above 41 F for refrigerated or above 0 F for frozen triggers automatic QC hold. Lot numbers auto-generated from vendor code + date. Short shipments flag purchasing for vendor follow-up.

IP5 Put-Away Items to Shelve / Suggested Bin / Confirm / Bin Label Print

Put-Away Queue — Edgewood Warehouse

Receipt #	Item	Qty	Lot	Zone/Temp	Suggested Bin	Assigned To	Status
RCV-7841	Bongards Barrel Cheddar 40 lb	200 cs	BG-2026-0519A	Refrigerated (36-38 F)	RA-04-B	James Rodriguez	Pending
RCV-7842	Large Grade A Eggs 30 dz	148 cs	CM-2026-0519A	Refrigerated (33-40 F)	RA-02-A	Maria Santos	In Progress
RCV-7838	All Purpose Flour 50 lb	200 bg	AB-2026-0518D	Dry (Ambient)	D2-08-A	Robert Chen	Complete

Confirm Put-Away

Item

Suggested Bin

Override Bin (if different)

Quantity Placed

Bin suggestions based on: (1) zone/temp match, (2) existing product in bin (co-locate same SKU), (3) proximity to pick face, (4) available capacity. Bin labels print 4x6" thermal.

IP6 Pick / Pack / Ship Pick Queue / Pick List / Pack Station / Ship Confirm

1

2

3

      Pick
      Pack
      Ship
    

Pick Queue — Sorted by Priority

Order #	Customer	Lines	Priority	Ship By	Picker	Status
SO-2026-18204	Good Eats Deli Corp	8	RUSH	Today 2:00 PM	James Rodriguez	Picking
SO-2026-18207	Metro Foodservice Inc	5	High	Today 5:00 PM	Maria Santos	Queued
SO-2026-18210	Sunrise Bakery Co	3	Normal	Tomorrow	Unassigned	Queued
SO-2026-18212	Brooklyn Catering Group	12	Normal	Tomorrow	Unassigned	Queued

Pick List — SO-2026-18204 (Good Eats Deli Corp)

        BIN WALK ORDER — Optimized Route
        Picker: James Rodriguez — Started: 10:48 AM
      

Seq	Bin	Item	Lot	Pick Qty	Picked
1	RA-01-A	Bongards Barrel Cheddar 40 lb	BG-2026-0517A	12 cs	12
2	RA-02-A	Large Grade A Eggs 30 dz	CM-2026-0516B	6 cs	6
3	RA-03-A	Heavy Cream 12/1 qt	DF-2026-0514C	4 cs	--
4	RA-06-C	Unsalted Butter 36/1 lb	DF-2026-0512A	8 cs	--

Pack Station — Verify, Label, Weight

Verify Items

Scan each item barcode to verify against pick list. System flags mismatches with audible alert. All 8 lines must verify green before packing.

2/4 lines verified

Print Shipping Label

Auto-generates BOL and shipping label. Carrier: GFS Fleet (Truck T-108). Route: Edgewood to Good Eats warehouse, Brooklyn, NY.

Weight Check

Scale reading: 1,247 lbs. Expected: 1,240-1,260 lbs. Tolerance: +/- 2%.

WEIGHT OK — Within tolerance

Pick lists optimized for shortest bin walk path. FIFO enforced: oldest lot picked first. Ship confirm triggers NetSuite item fulfillment and invoice generation.

IP7 Cycle Counting Schedule / Counters / Entry Form / Variance / Approval / Health Score

Inventory Accuracy

98.4%

Target: 98.0%

Counts This Month

142

of 180 scheduled

Variances Found

8

3 pending approval

Dollar Variance

-$2,140

Net shrinkage MTD

Count Schedule — Week of May 19, 2026

Day	Zone	Bins	Assigned Counter	Status
Mon 5/19	Refrigerated A (Edgewood)	RA-01 through RA-06	Maria Santos	In Progress
Tue 5/20	Frozen A (Edgewood)	FA-01 through FA-04	James Rodriguez	Scheduled
Wed 5/21	Dry 1 (Edgewood)	D1-01 through D1-10	Robert Chen	Scheduled
Thu 5/22	Refrigerated A (Hermitage)	RA-01 through RA-08	Sarah Kim	Scheduled
Fri 5/23	Dry 1-2 (Hermitage)	D1-01 through D2-06	Tony Morales	Scheduled

Variance Report — Pending Approval

Bin	SKU	Product	System	Physical	Variance	$ Impact
RA-01-B	GFS-MZZ-2200	Mozzarella Loaf 6/5 lb	36	34	-2	-$148
RA-04-A	GFS-CHD-4010	Barrel Cheddar 40 lb	48	50	+2	+$312
D1-03-B	GFS-OIL-5510	Soybean Oil 35 lb JIB	20	18	-2	-$86

Perpetual Inventory Health Score: 98.4% — Accuracy = (Matched bins / Total bins counted) x 100. Target: ≥ 98%. Score above 99% earns quarterly bonus. Below 97% triggers root-cause investigation.

ABC classification drives count frequency: A-items (top 20% value) counted monthly, B-items quarterly, C-items annually. Variances > $500 require supervisor approval.

IP8 Transfer Orders Facility-to-Facility / Create TO / In-Transit / Receive / Reefer Temp Log

Active Transfer Orders

TO #	From	To	Items	Ship Date	ETA	Reefer	Status
TO-2026-0391	Edgewood, NY	Hermitage, PA	Barrel Cheddar (80 cs), Mozzarella (40 cs)	05/19/2026	05/19/2026 6:00 PM	37.1 F	In Transit
TO-2026-0388	Hermitage, PA	Edgewood, NY	AP Flour (120 bg), Brown Box Pancakes (50 cs)	05/18/2026	05/18/2026 4:30 PM	N/A (Dry)	Received
TO-2026-0395	Edgewood, NY	Hermitage, PA	Large Grade A Eggs (60 cs)	05/20/2026	05/20/2026 5:00 PM	Pending	Scheduled

Create Transfer Order

From Facility

To Facility

Ship Date

Carrier

Item

Quantity

Reefer Temperature Log (TO-2026-0391)

Depart
36.8 F
8:15 AM
+1hr
37.0 F
9:15 AM
+2hr
37.1 F
10:15 AM
+3hr
37.2 F
11:15 AM
+4hr
37.1 F
12:15 PM
Current
37.1 F
LIVE

Edgewood-Hermitage route: ~370 miles, 6.5 hours. Reefer temp logged every 30 min via IoT sensor. Temp excursion triggers automatic alert to dispatch and QC hold on receipt.

IP9 Bin Management Warehouse Map / Bin Lookup / Transfer / Capacity

Edgewood Warehouse Map — Zone Layout

Bin Lookup

Search Bin

BIN RA-04-B — Refrigerated A, Row 4, Level B

Zone: Refrigerated A
Temp: 36-38 F
Capacity: 40 pallets
Current: 34 pallets
Available: 6 pallets
Util: 85%

Contents: Bongards Barrel Cheddar 40 lb (148 cs, Lot BG-2026-0519A) + Bongards Barrel Cheddar 40 lb (24 cs, Lot BG-2026-0517A)

Capacity Utilization by Zone

Refrig A

36-40 F

85%

Refrig B

36-40 F

72%

Frozen A

-10 to 0 F

58%

Frozen B

-10 to 0 F

40%

Dry 1

Ambient

65%

Dry 2

Ambient

50%

Staging

Mixed

30%

Bin opacity on map reflects utilization level. Click any zone for drill-down detail. Bin capacity measured in pallet positions. Transfer between bins via scan-confirm workflow.

IP10 Lot & Expiry Tracking Lots by Item / FIFO Queue / Expiring Soon / Lot Holds / Traceability

Lots by Item — Bongards Barrel Cheddar 40 lb (GFS-CHD-4010)

Lot #	Received	Expiry	Days Left	Location	Bin	Qty (cs)	FIFO Position	Status
BG-2026-0410A	04/10/2026	07/10/2026	52	Edgewood	RA-04-A	24	PICK FIRST	Active
BG-2026-0517A	05/15/2026	08/15/2026	88	Edgewood	RA-04-B	24	2nd	Active
BG-2026-0519A	05/19/2026	08/19/2026	92	Edgewood	RA-04-B	148	3rd	Active

Expiring Soon — All Items

Within 30 Days

6

$4,820 at risk

Within 60 Days

18

$14,200 at risk

Within 90 Days

42

$31,600 at risk

Active Lot Holds

Lot #	Item	Hold Reason	Hold Date	Held By	Qty	Action
CM-2026-0512C	Large Grade A Eggs 30 dz	Temp Excursion	05/17/2026	QC Dept	30 cs

Traceability Chain — Lot BG-2026-0517A

Vendor
Bongards Creameries
PO-2026-04821

Received
Edgewood Dock 1
05/15/2026 08:42

Put-Away
Bin RA-04-B
05/15/2026 09:18

Partial Pick
SO-2026-18204
05/19/2026 10:48

Remaining
12 cs in RA-04-B
Exp: 08/15/2026

FIFO position auto-calculated from receipt date. Lots within 30 days of expiry trigger daily email alerts. Held lots excluded from available inventory and pick lists.

IP11 Temperature Monitoring Zone Dashboard / Current Readings / Excursion Alerts / 24-hr Trend / Compliance

Current Temperature Readings — All Zones

Refrig A

37.2 F

Normal

Range: 36-40 F

Refrig B

38.1 F

Normal

Range: 36-40 F

Refrig C

43.8 F

EXCURSION

Range: 36-40 F

Frozen A

-4.2 F

Normal

Range: -10 to 0 F

Frozen B

-6.1 F

Normal

Range: -10 to 0 F

Dock Area

52.4 F

Ambient

No limit set

!

TEMPERATURE EXCURSION — Refrigerated C
Current reading: 43.8 F (limit: 40 F). Excursion started at 9:42 AM (duration: 38 min). Maintenance notified. QC reviewing affected inventory (18 SKUs, estimated value $6,200).

24-Hour Temperature Trend — Refrigerated Zones

Refrigerated A — 24hr (Target: 36-40 F)

12a

4a

8a

12p

4p

8p

Refrigerated C — 24hr (EXCURSION at 9:42 AM)

12a

4a

8a

10a

Now

Temperature Compliance Log — May 2026

Date	Zone	Reading	Limit	Duration	Action Taken	Status
05/19 09:42	Refrigerated C	43.8 F	40 F max	38 min (ongoing)	Maintenance dispatched, QC notified	Open
05/14 14:20	Frozen A	2.1 F	0 F max	12 min	Compressor cycled, restored to -4 F	Resolved
05/08 06:15	Refrigerated B	41.2 F	40 F max	8 min	Door left open, closed, temp recovered	Resolved

IoT sensors report every 60 seconds. Excursion = reading outside range for > 5 continuous minutes. Excursions automatically logged, emailed to QC + ops manager, and flagged in HACCP record.

IP12 Dead Stock & Slow Movers 60/90/120+ Day No Movement / Value at Risk / Markdown / Dispose

60+ Days No Movement

23

$18,400 at risk

90+ Days No Movement

11

$9,200 at risk

120+ Days No Movement

4

$3,100 at risk

Total Value at Risk

$30,700

0.73% of total inventory

Items with No Movement

SKU	Product	Location	Last Movement	Days Idle	Qty	Value	Recommendation
GFS-SPE-7720	Specialty Gouda Wheel 10 lb	Edgewood	01/15/2026	124	8 whl	$960	Markdown 40%
GFS-SAU-3310	Truffle Hot Sauce 12/12 oz	Edgewood	01/28/2026	111	24 cs	$864	Markdown 50%
GFS-NUT-4450	Pine Nuts Bulk 25 lb	Hermitage	03/02/2026	78	6 bg	$1,440	Push to Sales
GFS-GRN-6680	Organic Matcha Powder 5 lb	Edgewood	03/18/2026	62	12 bg	$2,160	Push to Sales

Dead Stock Policy:
60 days: Sales team notified for push campaigns. | 90 days: Manager reviews for markdown (up to 30% authority). | 120+ days: VP approval for markdown > 30% or disposal. | Disposed items require write-off JE in NetSuite with supervisor sign-off.

Dead stock analysis runs daily at 6:00 AM. Excluded: seasonal items with planned reorder, USDA commodity products with government drawdown schedules, items with pending POs.

IP13 Inventory Valuation Value by Category / FIFO Cost Layers / Landed Cost / Monthly Movement

Total Value by Category

Inventory Value Distribution

Cheese
$1.43M

Eggs
$892K

Dairy
$756K

Dry
$504K

Oils
$336K

Frozen
$284K

Monthly Inventory Movement (May 2026)

Inbound
$1.8M

Outbound
$1.7M

Transfers
$245K

Shrinkage
$12K

FIFO Cost Layers — Bongards Barrel Cheddar 40 lb

Layer	Receipt Date	Lot	Qty (cs)	Unit Cost	Extended	CME Basis	FIFO Order
1	04/10/2026	BG-2026-0410A	24	$152.40	$3,657.60	$1.8240/lb + 35% moisture	Deplete First
2	05/15/2026	BG-2026-0517A	24	$156.80	$3,763.20	$1.8780/lb + 35% moisture	2nd
3	05/19/2026	BG-2026-0519A	148	$158.20	$23,413.60	$1.8920/lb + 35% moisture	3rd
Total			196	$157.32 avg	$30,834.40

Landed Cost Breakdown — Lot BG-2026-0519A

Product Cost

$155.60

98.4%

Freight

$1.85

1.2%

Handling

$0.45

0.3%

Insurance

$0.30

0.2%

Landed Total

$158.20

100%

NetSuite costing method: FIFO. CME trailing-week price applied to Bongards barrel cheddar per vendor agreement. Landed cost includes freight (FOB destination), handling, and cargo insurance.

IP14 FIFO Enforcement — USDA Bracket Drawdown Bracket Status / Depletion Forecast / Next Bracket Preview / Bongards Drawdown

FIFO Bracket Enforcement — USDA Commodity Products

Bongards barrel cheddar pricing is tied to CME trailing-week average plus a 35% moisture premium bracket. When a cost layer (bracket) is partially depleted, split journal entries ensure accurate COGS at bracket boundaries. This module enforces strict FIFO depletion order.

Current Bracket Status — Bongards Barrel Cheddar 40 lb

          BRACKET 1 — ACTIVE (Depleting)
          Lot BG-2026-0410A — $1.8240/lb + 35% = $152.40/cs
        

            24 cs remaining of 200 (88% depleted)
            Est. depletion: May 23, 2026
          

          BRACKET 2 — NEXT
          Lot BG-2026-0517A — $1.8780/lb + 35% = $156.80/cs
        

            24 cs — Full (0% depleted)
            Available after Bracket 1 exhausted
          

          BRACKET 3 — QUEUED
          Lot BG-2026-0519A — $1.8920/lb + 35% = $158.20/cs
        

            148 cs — Full (0% depleted)
            Available after Brackets 1-2 exhausted
          

Depletion Forecast

Bracket	Lot	Unit Cost	Remaining	Avg Daily Usage	Est. Depletion	Days Left	COGS Impact
B1	BG-2026-0410A	$152.40/cs	24 cs	6 cs/day	May 23, 2026	4 days	$3,657.60
B2	BG-2026-0517A	$156.80/cs	24 cs	6 cs/day	May 27, 2026	8 days	$3,763.20
B3	BG-2026-0519A	$158.20/cs	148 cs	6 cs/day	Jul 20, 2026	62 days	$23,413.60

Split Journal Entry Preview — Bracket Boundary

        SPLIT JE PREVIEW — When order crosses B1 to B2 boundary
        Scenario: 30 cs order depletes B1 (24 cs) and pulls 6 cs from B2
      

JE Line	Description	Bracket	Qty	Unit Cost	Debit (COGS)	Credit (Inventory)
1	B1 depletion (last 24 cs)	B1	24	$152.40	$3,657.60	$3,657.60
2	B2 partial draw (first 6 cs)	B2	6	$156.80	$940.80	$940.80
Total			30	$153.28 blended	$4,598.40	$4,598.40

Next Bracket Preview — CME Watch

Current CME Barrel

$1.8920/lb

Trailing week avg as of 05/19

With 35% Moisture Premium

$2.5542/lb

$158.20 per 40 lb case

CME 5-Day Trend

Trending up +$0.032 over 5 days

FIFO enforcement is mandatory for USDA commodity products. Split JEs auto-generate in NetSuite when a fulfillment crosses bracket boundaries. CME prices update daily from market data feed.