Shed Inventory

Bruny Island Cheese Co.

Area access code

Loading inventory...
Supabase not configured. Replace YOUR_SUPABASE_URL and YOUR_SUPABASE_ANON_KEY in this file.
Shed Inventory
Bruny Island Cheese Co.

Current Shed Stock

View weekly summary →
Status
Category

Search Products

Weekly Withdrawal Sheet

Record what left the warehouse each day of the week.

Physical Stock Count

Enter physical quantities counted. Only rows you edit will be updated. WH resets base_stock to today. FOH inserts a new count record.

Reports & Analysis

FOH Weekly Consumption

Actual FOH consumption per week: Opening FOH + WH withdrawals − Closing FOH = Consumed. Based on your Sunday counts.

Write-off & Waste Analysis

Product Audit Log

▼ Show

All Products

Reorder Point Calculator — PP & Safety Stock

How it works Enter the demand parameters for each product. The system calculates:
Safety Stock (SS) = Z × σd × √Lead Time  |  Reorder Point (PP) = (Avg demand/day × Lead Time) + SS
Use "Apply PP → Min Stock" to save the calculated value to the database.
▶ SQL migration — ejecutar una sola vez en Supabase (ya ejecutado ✓)
ALTER TABLE products
  ADD COLUMN IF NOT EXISTS d_avg NUMERIC DEFAULT 0,
  ADD COLUMN IF NOT EXISTS d_std NUMERIC DEFAULT 0,
  ADD COLUMN IF NOT EXISTS lead_time_days INT DEFAULT 7,
  ADD COLUMN IF NOT EXISTS service_level INT DEFAULT 95;
CodeProduct Avg Demand
(units/day)		 σ Demand
(std dev)		 Lead Time
(days)		 Service
Level		 Safety Stock
(SS)		 Reorder Point
(PP)		 Current
Min Stock		 Action

Auto-Optimizer — Min Stock desde Planillas

How it works The system analyses the accumulated planilla data, calculates the average weekly consumption per product and suggests a new min_stock using the formula:
Suggested Min = ⌈ Weekly avg × (Lead Time weeks + 0.5 safety buffer) ⌉
Select the period, run the analysis and apply changes with one click. Phase-out products (min = 0) are never touched.

Profitability — Last 12 Months

Revenue and gross margin per product based on retail sales. Hard cheese revenue = portions × 0.145 kg × price/kg. Use this to identify which cheeses are driving the most profit.

Monthly retail revenue trend — last 12 months

Shows total revenue across all cheese products per month. Use this to identify seasonal patterns and year-on-year growth.

Selected Month vs Same Month Last Year

Compares retail revenue week by week for the current month against the same month last year. If the blue line is above the green line, we are performing better than last year.

Revenue Projection — Next 6 Months

Estimated revenue for the next 6 months based on same-month performance from last year (seasonality-adjusted). Use this for production planning and purchasing decisions.

Monthly Sales History — Soft & Hard Cheeses

Weekly Sales Entry

Enter the Monday of the week. Retail sales only.

Product Qty Sold Unit

Kitchen Extras — This Week

Baked cheeses sold outside the standard platter (winter only). Saved per month.

Platters — This Week

Number of platters sold this week.

Data Log — All Entered Records

Cheese Sales (weekly)

Week Product Qty Unit

Platters (weekly)

Week Product Qty

Kitchen Extras (monthly)

Month Extra Otto Extra Baked Saint