1. Navigate to “Modifier Stock Report” #

1. Log in to your restaurant management system.
2. In the sidebar, expand the Reports section.
3. Locate and click on Modifier Stock Report (typically under inventory or product reports).
4. The Modifier Stock Report page will open showing:
   • A ▼ Filters section for filtering by business location.
   • Export buttons: Export to CSV, Export to Excel, Print, Column Visibility, and Export to PDF.
   • A comprehensive data table with columns for:
     • Action, SKU, Product, Variation, Location
     • Unit Selling Price, Current Stock, Current Stock Value
     • Potential Profit, Total Unit Sold, Total Unit Transferred, Total Unit Adjusted
   • Search functionality and pagination controls (Show entries, Previous/Next).
   • Status message showing data availability (e.g., “No data available in table”).

2. Understanding Modifier Stock Report #

Modifier Stock Report is a specialized inventory management tool for tracking add-ons, extras, and customization options in your restaurant:

• Modifier Inventory Tracking – Monitor stock levels of add-ons like extra cheese, bacon, sauces, toppings, and side items.
• Profitability Analysis – Calculate potential profit from modifier sales based on current stock and selling prices.
• Stock Valuation – Track the total value of modifier inventory at current purchase prices.
• Movement Tracking – Monitor modifier usage through sales, transfers, and adjustments.
• Multi-Location Management – View modifier stock across different restaurant locations.
• SKU Management – Track modifiers by unique SKU codes for precise inventory control.
• Variation Tracking – Manage different sizes or types of the same modifier (small/medium/large portions).

3. Configure Modifier Stock Filters #

1. Click the ▼ Filters dropdown to expand filtering options.
2. Configure the following filter parameter:
   • Business Location – Select reporting scope:
     • Choose “All locations” to view modifier stock across all restaurant locations.
     • Select specific location to analyze individual restaurant modifier inventory.
     • Useful for:
       • Multi-location chains to compare modifier stock levels.
       • Identifying which locations need modifier restocking.
       • Analyzing location-specific modifier usage patterns.
       • Managing centralized vs. location-specific modifier inventory.
3. Apply the filter to refresh the report data.
4. The table will update to show modifier stock for your selected location(s).

4. Understanding the Modifier Stock Table #

The Modifier Stock Report table provides comprehensive information about each modifier’s inventory status:

5. Analyze Modifier Stock Levels #

1. Current Stock Assessment:
   • Review the Current Stock column to identify:
     • Low stock modifiers that need immediate reordering.
     • Overstocked modifiers that may expire or go to waste.
     • Out-of-stock modifiers affecting menu availability.
   • Set reorder points based on:
     • Daily usage rates from Total Unit Sold.
     • Lead time for supplier deliveries.
     • Safety stock for popular modifiers.
2. Stock Valuation Review:
   • Current Stock Value (at cost) – Shows your investment in modifier inventory.
   • Current Stock Value (at sale price) – Shows potential revenue.
   • Potential Profit – Shows expected profit margin on current stock.
   • Use these metrics to:
     • Optimize inventory investment.
     • Identify high-margin modifiers to promote.
     • Calculate inventory turnover rates.
3. Movement Analysis:
   • Compare Total Unit Sold across modifiers to identify:
     • Best-selling modifiers (high demand).
     • Slow-moving modifiers (consider discontinuing).
     • Seasonal patterns in modifier usage.
   • Review Total Unit Adjusted to identify:
     • High-waste modifiers (spoilage, damage).
     • Frequent counting errors requiring process improvement.
     • Theft or loss issues.

6. Modifier Stock Actions #

1. View Modifier Details:
   • Click the View icon in the Action column.
   • Review complete modifier information:
     • Full product details and specifications.
     • Purchase history and supplier information.
     • Sales history and usage patterns.
     • Stock movement timeline.
2. Edit Modifier Information:
   • Click the Edit icon in the Action column.
   • Update modifier details:
     • Unit selling price adjustments.
     • SKU or product name changes.
     • Variation details.
     • Reorder points and minimum stock levels.
   • Save changes to update the system.
3. Adjust Stock Levels:
   • Click the Adjust Stock icon in the Action column.
   • Perform stock adjustments for:
     • Physical Count Corrections – Update system to match actual count.
     • Waste/Spoilage – Record expired or damaged modifiers.
     • Theft/Loss – Document missing inventory.
     • Receiving – Add newly received modifier stock.
   • Enter adjustment quantity (positive for additions, negative for reductions).
   • Select adjustment reason from dropdown.
   • Add notes explaining the adjustment.
   • Save to update stock levels and create audit trail.

7. Export and Print Modifier Stock Report #

1. Export Options – Use the export buttons above the table:
   • Export to CSV – Export to comma-separated values format:
     • Opens in Excel, Google Sheets, or any spreadsheet application.
     • Ideal for data analysis and manipulation.
     • Lightweight format for large datasets.
   • Export to Excel – Export to Microsoft Excel format:
     • Preserves formatting and column widths.
     • Includes formulas for calculations.
     • Professional format for sharing with management.
   • Export to PDF – Generate PDF document:
     • Professional format for reports and presentations.
     • Maintains consistent formatting across devices.
     • Suitable for archiving and compliance.
   • Print – Print directly from browser:
     • Quick physical copy for inventory counts.
     • Use for warehouse or kitchen reference.
     • Handy for manual stock verification.
2. Column Visibility:
   • Click the Column Visibility button to customize displayed columns.
   • Show or hide specific columns based on your needs:
     • Hide columns not relevant to current analysis.
     • Focus on key metrics (stock levels, profitability).
     • Simplify report for specific audiences.
   • Export will include only visible columns.
3. Scheduled Exports (if available):
   • Set up automatic daily or weekly modifier stock reports.
   • Email reports to inventory managers automatically.
   • Maintain consistent reporting schedule.

8. Search and Pagination #

1. Search Functionality:
   • Use the Search box on the right side above the table.
   • Search by:
     • Modifier name (e.g., “cheese”, “bacon”, “sauce”).
     • SKU code for precise lookup.
     • Variation name (e.g., “large”, “spicy”).
     • Location name.
   • Search is real-time and filters results as you type.
   • Clear search to return to full list.
2. Pagination Controls:
   • Show entries – Select number of rows per page:
     • 25 entries (default) – Good for quick overview.
     • 50 or 100 entries – Better for comprehensive review.
     • Adjust based on screen size and preference.
   • Previous/Next – Navigate between pages using buttons at bottom.
   • View total count: “Showing 0 to 0 of 0 entries” (updates based on data).
3. Column Sorting:
   • Click column headers to sort data.
   • Useful sorting options:
     • Sort by Current Stock to identify low stock items.
     • Sort by Total Unit Sold to find best sellers.
     • Sort by Potential Profit to prioritize high-margin items.
     • Sort by Total Unit Adjusted to identify problem items.
   • Toggle between ascending and descending order.

9. Modifier Profitability Analysis #

• Profit Margin Calculation:
  • Profit Margin % = (Unit Selling Price – Unit Cost) ÷ Unit Selling Price × 100
  • Identify high-margin modifiers to promote:
    • Train staff to upsell profitable modifiers.
    • Feature high-margin modifiers on menu boards.
    • Create combo deals highlighting profitable add-ons.
  • Review low-margin modifiers:
    • Consider price increases if market allows.
    • Negotiate better supplier pricing.
    • Discontinue if not strategically important.
• Revenue Contribution Analysis:
  • Calculate total modifier revenue: Total Unit Sold × Unit Selling Price
  • Determine modifier revenue as percentage of total sales.
  • Set targets for modifier attachment rates (% of orders with modifiers).
  • Track modifier revenue trends over time.
• Cost Management:
  • Monitor Current Stock Value to control inventory investment.
  • Optimize order quantities to balance:
    • Bulk purchase discounts.
    • Storage capacity and shelf life.
    • Cash flow considerations.
  • Reduce waste by:
    • Implementing FIFO (First In, First Out) rotation.
    • Proper storage and handling procedures.
    • Accurate demand forecasting.

10. Modifier Stock Management Best Practices #

• Regular Stock Counts – Conduct physical counts weekly or monthly to verify system accuracy.
• Set Par Levels – Establish minimum and maximum stock levels for each modifier based on usage patterns.
• Monitor Expiration Dates – Track shelf life for perishable modifiers (sauces, dairy, produce).
• Optimize Storage – Store modifiers properly to maintain quality and prevent spoilage.
• Track Waste – Document all waste and adjustments to identify improvement opportunities.
• Supplier Management – Maintain relationships with multiple suppliers for critical modifiers.
• Seasonal Adjustments – Adjust stock levels based on seasonal demand patterns.
• Staff Training – Train staff on proper portioning to control modifier costs.
• Menu Engineering – Use modifier data to optimize menu design and pricing.
• Technology Integration – Ensure POS system accurately tracks modifier usage in real-time.

11. Modifier Types and Categories #

12. Integration with Other Systems #

• POS Integration:
  • Modifier stock automatically decreases when sold through POS.
  • Real-time inventory updates prevent overselling.
  • POS can alert staff when modifiers are low or out of stock.
  • Ensure proper modifier mapping in POS system.
• Recipe Management:
  • Link modifiers to recipes for accurate cost calculation.
  • Track modifier usage in combo meals and special items.
  • Calculate true cost of menu items including modifiers.
• Purchasing System:
  • Generate purchase orders automatically when stock reaches reorder point.
  • Track supplier pricing and lead times.
  • Compare actual usage vs. purchased quantities.
• Financial Reporting:
  • Modifier stock value appears on balance sheet as inventory asset.
  • Modifier sales contribute to revenue on income statement.
  • Waste and adjustments impact cost of goods sold.

13. Troubleshooting Common Issues #

14. Advanced Modifier Stock Strategies #

• ABC Analysis:
  • A Items – High-value, high-volume modifiers (20% of items, 80% of value):
    • Monitor daily with tight controls.
    • Maintain optimal stock levels to prevent stockouts.
    • Negotiate best pricing with suppliers.
  • B Items – Moderate value and volume (30% of items, 15% of value):
    • Monitor weekly with standard controls.
    • Balance stock levels with storage capacity.
  • C Items – Low-value, low-volume modifiers (50% of items, 5% of value):
    • Monitor monthly with minimal controls.
    • Consider discontinuing slow movers.
• Just-In-Time (JIT) Inventory:
  • Order modifiers to arrive just before needed.
  • Reduces storage costs and waste.
  • Requires reliable suppliers and accurate forecasting.
• Cross-Location Optimization:
  • Transfer excess modifiers from overstocked locations to understocked ones.
  • Centralize slow-moving modifiers at high-volume locations.
  • Share supplier orders across locations for better pricing.

15. Done! 🎉 #

You can now effectively manage modifier inventory, track add-on profitability, optimize stock levels, reduce waste, and maximize revenue from customization options across your restaurant operations!