Inventory & Cellar Management: Stock Control, Wine Storage & Cost Savings

TAKEAWAYS:

• Inventory management ensures F&B operations never run out of stock or overstock, balancing cost and service quality.
• Cellar management preserves wine, spirits, and non-alcoholic beverages by controlling temperature, humidity, and lighting.
• ABC analysis prioritizes high-value items (A) over low-value (C) to optimize storage and ordering.
• FIFO/LIFO methods determine how stock is issued to prevent spoilage or obsolescence.
• Par stock levels set minimum thresholds to trigger reorders, preventing stockouts.
• Cost control in inventory and cellar directly impacts profit margins (often 20–30% of revenue).

1. Inventory Management in F&B: Definitions and Scope

Inventory management in F&B refers to the systematic tracking, storage, and control of all consumable items—from raw ingredients (rice, meat, vegetables) to finished goods (prepared dishes, sauces) and non-perishables (bottled water, canned goods). Poor inventory management leads to food waste (30–40% of F&B costs), overstocking (tied-up capital), or stockouts (lost sales).

Key Inventory Categories in F&B

mindmap
  root((F&B Inventory))
    Raw Materials
      Perishables: Meat, Fish, Dairy, Produce
      Dry Goods: Rice, Pasta, Spices
    Semi-Finished Goods
      Prepped Ingredients: Chopped veggies, Marinated meats
      Sauces, Stocks, Dough
    Finished Goods
      Ready-to-Serve: Plated dishes, Pastries
      Beverages: Soft drinks, Juices
    Non-Consumables
      Packaging, Utensils, Cleaning Supplies

Why Inventory Management Matters in F&B

• Cost Control: Food costs typically account for 28–35% of total revenue in hotels/restaurants. Efficient inventory reduces waste by 10–20%.
• Service Quality: Running out of key ingredients (e.g., fresh herbs, premium wine) disrupts service.
• Legal Compliance: Nepal’s Food Safety and Quality Act (2019) mandates proper storage and rotation of perishables.
• Revenue Protection: Overstocking ties up 15–20% of working capital in unsold inventory.

2. Inventory Control Techniques

A. ABC Analysis: Prioritizing Stock

ABC analysis classifies inventory into three tiers based on annual consumption value (not quantity). This helps focus resources on high-impact items.

Worked Example: ABC Analysis for a Fine-Dining Restaurant Assume a restaurant’s annual inventory data:

• Truffle oil: 50 bottles × NPR 5,000 = NPR 250,000
• Chicken breast: 500 kg × NPR 300 = NPR 150,000
• Rice: 200 kg × NPR 100 = NPR 20,000

Step 1: Calculate annual value for each item. Step 2: Rank by value (Truffle oil > Chicken > Rice). Step 3: Assign categories:

• A: Truffle oil (highest value, critical for menu)
• B: Chicken breast (moderate value, high turnover)
• C: Rice (low value, bulk purchase)

Action: The restaurant should:

• Order truffle oil in small batches weekly.
• Buy chicken in bulk but monitor daily usage.
• Purchase rice in 3-month quantities.

B. Stock Valuation Methods

Two common methods determine the cost of inventory:

Worked Example: FIFO vs. LIFO for a Hotel Kitchen A hotel buys:

• Week 1: 50 kg flour at NPR 150/kg
• Week 2: 50 kg flour at NPR 160/kg
• Week 3: Uses 80 kg flour.

FIFO Calculation:

• Issue 50 kg (Week 1) × NPR 150 = NPR 7,500
• Issue 30 kg (Week 2) × NPR 160 = NPR 4,800
• Total cost issued: NPR 12,300

LIFO Calculation:

• Issue 50 kg (Week 2) × NPR 160 = NPR 8,000
• Issue 30 kg (Week 1) × NPR 150 = NPR 4,500
• Total cost issued: NPR 12,500

Impact on Profit: FIFO reports a slightly lower cost of goods sold (COGS), increasing net profit marginally.

C. Par Stock Method

The par stock level is the minimum quantity of an item that must be on hand to avoid stockouts. It is calculated as: $$\text{Par Stock}=(\text{Average Daily Usage}\times \text{Lead Time})+\text{Safety Stock}$$

• Lead Time: Time between ordering and receiving stock (e.g., 3 days for local suppliers, 10 days for imported items).
• Safety Stock: Extra buffer (e.g., 10–20%) to account for delays or usage spikes.

Worked Example: Par Stock for a Café

• Item: Coffee beans (1 kg bags)
• Average daily usage: 5 kg
• Lead time: 5 days (supplier delivers in 5 days)
• Safety stock: 20% of usage during lead time

Calculation: $$\text{Par Stock}=(5\text{ kg/day}\times 5\text{ days})+(0.20\times 25\text{ kg})=25\text{ kg}+5\text{ kg}=30\text{ kg}$$ Action: The café should reorder when stock drops to 30 kg to ensure no shortages.

3. Inventory Control Systems

A. Manual vs. Automated Systems

Example in Nepal:

• Small Café (Manual): Uses a notebook to track rice, dal, and oil. Reorders when stock is visibly low.
• Hotel (Automated): Uses Toast POS to scan barcodes on rice bags and automatically alerts the manager when par levels are breached.

B. Just-in-Time (JIT) Inventory

JIT minimizes inventory by receiving goods only as needed for production/service. Used in:

• Fast-food chains (e.g., KFC, Burger King) for fries, buns.
• Fine-dining restaurants for high-value ingredients (e.g., truffles, foie gras).

Pros:

• Reduces waste (e.g., fresh herbs used within 24 hours).
• Lowers storage costs.

Cons:

• Requires reliable suppliers (e.g., daily deliveries from local farms).
• Risk of stockouts if deliveries are delayed.

Case Study: Himalayan Java (Nepal) Himalayan Java uses JIT for its specialty coffee beans:

• Orders beans weekly from local roasters.
• Stores only 3–5 days’ supply to ensure freshness.
• Result: 15% reduction in coffee waste and 10% cost savings.

4. Cellar Management: Storage of Beverages

Cellar management ensures wine, spirits, beer, and non-alcoholic beverages are stored properly to maintain quality, flavor, and value. Poor cellar management can:

• Cause oxidation (wine turns to vinegar).
• Lead to temperature damage (beer loses carbonation).
• Result in humidity issues (labels peel off bottles).

Key Cellar Requirements

mindmap
  root((Ideal Cellar Conditions))
    Temperature
      Wine: 8–14°C (50–57°F)
      Beer: 0–4°C (32–39°F)
      Spirits: 10–15°C (50–59°F)
    Humidity
      60–80% (prevents cork drying)
    Light
      Dark or UV-filtered (prevents degradation)
    Ventilation
      Controlled airflow (prevents mold)
    Vibration
      Minimal (avoids sediment disturbance in wine)

A. Wine Storage Guidelines

Worked Example: Storing a Bottle of Nepali Wine (e.g., Chaudhary Group’s "Nepal Wine")

• Storage Location: Dedicated wine fridge at 12°C.
• Position: Lay horizontally for the first 5 years (to keep cork moist).
• Humidity: Use a hygrometer to maintain 75% humidity (add a tray of water if needed).
• Light: Store in a dark cabinet or use UV-protective glass.

Result: The wine retains its berry and spice notes for 10+ years.

B. Beer and Spirits Storage

• Beer: Store at 0–4°C (refrigerator or beer fridge). Avoid temperature fluctuations.
• Spirits (Whiskey, Rum, Vodka): Store at 10–15°C in a dark, cool place. Oak barrels for aging (e.g., Nepali whiskey brands like Yeti 1890).
• Champagne/Sparkling Wine: Always store vertical to preserve bubbles.

Case Study: Ncell’s "Beer Cellar" for Corporate Events Ncell’s corporate catering team uses temperature-controlled beer dispensers for events:

• Temperature: 2–4°C for lagers, 7–9°C for ales.
• Glassware: Chilled to 5°C before serving.
• Result: No flat beer, consistent quality for 500+ attendees.

C. Non-Alcoholic Beverages

• Soft Drinks: Store at 5–10°C (avoid direct sunlight).
• Juices: Refrigerate after opening; use FIFO to prevent spoilage.
• Tea/Coffee: Keep in airtight containers away from moisture/light.

5. Cost Control in Inventory and Cellar

A. Food Cost Percentage (FCP)

$$\text{FCP}=\left(\frac{\text{Total Food Cost}}{\text{Total Food Sales}}\right)\times 100$$ Target FCP for Nepalese Restaurants:

• Fine-dining: 28–32%
• Casual dining: 30–35%
• Fast food: 35–40%

Worked Example: Calculating FCP for a Café

• Sales: NPR 500,000 (1 month)
• Opening Inventory: NPR 80,000
• Purchases: NPR 150,000
• Closing Inventory: NPR 60,000
• Food Waste: NPR 20,000

Calculation: $$\text{Total Food Cost}=\text{Opening Inventory}+\text{Purchases}-\text{Closing Inventory}+\text{Waste}$$ $$=80,000+150,000-60,000+20,000=\text{NPR 190,000}$$ $$\text{FCP}=\left(\frac{190,000}{500,000}\right)\times 100=38\%$$ Analysis: The café’s FCP is too high (target: 30–35%). Actions:

1. Reduce waste (e.g., better portion control).
2. Negotiate with suppliers (e.g., buy rice in bulk).
3. Adjust menu prices or remove low-margin items.

B. Beverage Cost Control

$$\text{Beverage Cost Percentage}=\left(\frac{\text{Cost of Beverages Sold}}{\text{Beverage Sales Revenue}}\right)\times 100$$ Target for Nepalese Hotels:

• Alcoholic: 18–25%
• Non-alcoholic: 10–15%

Worked Example: Costing a Cocktail at a Bar

• Recipe: Vodka Martini
  • 60 ml vodka (NPR 200/litre) = NPR 12
  • 15 ml dry vermouth (NPR 150/litre) = NPR 2.25
  • Olive/garnish = NPR 1
  • Total cost: NPR 15.25
• Selling Price: NPR 400
• Beverage Cost %: $\frac{15.25}{400}\times 100=3.8\%$

Issue: The cost % is too low (should be 18–25%). Possible reasons:

• Overpouring: Bartender uses 80 ml vodka instead of 60 ml.
• Cheap ingredients: Using NPR 150/litre vodka instead of NPR 300/litre premium brand.
• Theft: Employees stealing liquor.

Solution: Train staff on standard pours and audit inventory weekly.

6. Inventory Management Software in Nepal

## In the Real World

1. eSewa & Khalti (Digital Inventory Tracking)

   • How it uses inventory ideas: Both apps use just-in-time stock replenishment for their server farms and data centers.
   • Example: eSewa’s servers in Kathmandu are stocked with backup power supplies (UPS batteries) using par stock levels. When usage drops to 30% of capacity, an alert triggers an automatic reorder from suppliers like Caterpillar or HBL Power.
   • Impact: Ensures zero downtime during load-shedding, saving NPR 500,000+ annually in potential revenue loss.

2. Daraz (E-Commerce Fulfillment Centers)

   • How it uses inventory ideas: Daraz’s warehouses in Nepal use ABC analysis to prioritize high-demand items (e.g., smartphones, groceries) over slow-moving products (e.g., specialty tools).
   • Example: During Dashain/Tihar, Daraz’s Kathmandu warehouse stocks A-items (diya sets, dry fruits) with daily inventory checks and FIFO rotation to prevent spoilage. Slow-moving items (e.g., winter jackets) are stored in remote warehouses with longer lead times.
   • Impact: Reduces out-of-stock errors by 40% and cuts waste by 15%.

3. Nabil Bank’s ATM Network (Cash Inventory)

   • How it uses inventory ideas: Nabil Bank manages ATM cash inventory using dynamic par levels based on transaction data.
   • Example: ATMs in Thapathali (high footfall) are restocked twice daily with NPR 500,000–1,000,000 in cash, while rural ATMs are serviced weekly with NPR 200,000.
   • Cost Control: Uses LIFO for cash counts (new notes issued first to detect counterfeit bills) and real-time alerts when cash drops below par.
   • Result: Saves NPR 20 million/year in interest on excess cash and reduces customer dissatisfaction from empty ATMs.

## Exam Tip

How This Unit is Examined (TU Pattern)

1. Short Questions (2–5 marks):

   • Define cellar management, par stock, or FIFO.
   • Example: "Why is humidity control critical in wine storage?" → Answer: Prevents cork drying and oxidation.

2. Worked Problems (5–10 marks):

   • Calculate FCP, par stock, or beverage cost %.
   • Example: Given sales and inventory data, compute FCP and suggest improvements.

3. Case Studies (10–15 marks):

   • Analyze a hotel’s inventory issue (e.g., high waste) and propose solutions.
   • Example: "A restaurant’s FCP is 40%. How would you reduce it?" → Use ABC analysis, JIT ordering, and staff training.

4. Diagrams (5 marks):

   • Draw a cellar layout or inventory control flowchart.
   • Example: Sketch a wine storage rack with labels for temperature/humidity zones.

Top 5 Exam Strategies

1. Memorize Formulas:
   • FCP, Beverage Cost %, Par Stock.
2. Practice Calculations:
   • Do 3–5 worked examples of FCP and beverage costing.
3. Link Theory to Nepal:
   • Relate Nepali examples (e.g., Daraz, Ncell, Chaudhary Group) to concepts like ABC analysis or JIT.
4. Draw Diagrams:
   • Practice cellar conditions, inventory flowcharts, and ABC classification tables.
5. Case Study Ready:
   • Know how to diagnose issues (e.g., high waste, stockouts) and prescribe fixes.

## Quick Revision Checklist

Before the exam, verify you can: ✅ Define inventory management and cellar management. ✅ Explain FIFO vs. LIFO with a numerical example. ✅ Calculate par stock and FCP. ✅ Sketch a wine cellar layout with ideal conditions. ✅ List 3 inventory control systems (manual, automated, JIT). ✅ Name 2 Nepali companies using these techniques (e.g., Daraz, Ncell). ✅ Describe how humidity affects wine storage.