logo

Trail Mix Quick Solve Guide

Experience the power of Decision Optimization firsthand! This interactive guide will walk you through real optimization scenarios using the Workbench interface at app.optimalanswers.com. Watch as the system instantly finds optimal solutions to complex formulation challenges.

Get Ready for Immediate Results! In just minutes, you'll see how Optimal automatically adjusts recipes based on cost changes, ingredient availability, and formula constraints—delivering the mathematically best solution every time.
🛠️

Setup & Baseline Optimal Solve

⚠️ CRITICAL STEP: Disable your pop-up blocker for app.optimalanswers.com. This allows the system to automatically generate and display Recipe Detail reports.

Application Verification

  • Database Check: Verify your database is set to: [Your Name]_Guided_Optimal_Introduction_IMP_FPD_Trailmix.
Tip: This guide includes *Show Me click-on features to help you navigate the platform.
Tip: Switch between this tab and the Optimal App tab to enhance your progress.

Perform the First Solve

  • Step 1: In the Opt-It! menu, open the Workbench.
  • Step 2: Ensure the Formula is set to Nut Mix and the Lot Set is set to Snacks-Trail Mix.
    *Show Me Temp Settings
  • Step 3: Click the Opt it! button.
Result: Upon SUCCESS, a Recipe Detail with All Items report will automatically open in a new tab. This represents the baseline optimal recipe for Trail Mix (take note of your unit cost).
*Show Me Unit Cost location Temp Unit Cost
*Show Me items selected by least cost Temp Least Cost
Tip: Keep your original report tab open to compare your subsequent exercise results. After review, you may close the latest report for the next exercise.
📈

Scenario 1: Cost Increase

See how Optimal reacts when a key ingredient suddenly becomes more expensive. The system automatically adjusts the formula to minimize cost impact while maintaining all quality standards.

Action (Input Change) Expected Impact (Output Change) Learning Point
Step 1: Return to the Workbench tab. Set the table Page to Lots.
*Show Me Temp Page Lots
Increased Unit Cost: The total cost of the formula will go up, and the final recipe will use less or none of the now more expensive ingredient. The system prioritizes cost minimization and demonstrates how quickly you can model supply chain cost risk.

In this case, Optimal selected Cashew Nuts, Dry Rstd, wo/Salt because it is now the least expensive.
Step 2: Locate Cashew Nuts, Dry Rstd, w/Salt (12585) and increase the cost from $2.40 to $2.51.
Tip: For easy location, click the Item Name column to sort ascending.
*Show Me Temp Col Sort
Step 3: Click Opt it! and review the new Unit Cost. Compare it to your original report.
📉

Scenario 2: Cost Decrease

Discover how Optimal incorporates a lower-cost ingredient to reduce the final Unit Cost. This demonstrates the system's ability to capitalize on sourcing opportunities.

Action (Input Change) Expected Impact (Output Change) Learning Point
Step 1: Return to the Workbench. Click the Load button to reset the formula.
*Show Me Temp Load
Lower Unit Cost: The Unit Cost will decrease because the higher-end almond vendor now lowered its cost. The system automatically determines the optimal amount of the cheaper item to achieve the lowest total cost while meeting all recipe requirements.
Step 2: Locate Almonds, Dry Roasted, wo/Salt (12063) and decrease the cost from $1.70 to $1.59.
Step 3: Click Opt it! and review the new, lower Unit Cost.
🚫

Scenario 3: Ingredient Unavailability

Observe how Optimal compensates when an ingredient becomes unavailable. The system finds the next-best solution, often at a higher cost, while still meeting all requirements.

Action (Input Change) Expected Impact (Output Change) Learning Point
Step 1: Return to the Workbench. Click the Load button to reset the formula. Set the table Page to Formula Items.
*Show Me Temp Items
Increased Unit Cost: Optimal adjusts other ingredients to meet recipe rules, resulting in a higher but still optimal cost. The system prioritizes meeting all required recipe rules (constraints) over cost, demonstrating how it handles supply chain disruptions.
Step 2: Locate Peanuts, All Types, Dry Rstd, w/Salt (16090) and Disable it.
*Show Me Temp Disable
Step 3: Click Opt it! and review the new Unit Cost.
⚖️

Scenario 4: Constraint Flexibility

This demonstrates the powerful concept of relaxing a constraint. However, this exercise limits a constraint to see the direct trade-off between relaxed formula rules and strict company requirements.

Action (Input Change) Expected Impact (Output Change) Learning Point
Step 1: Return to the Workbench. Click the Load button to reset the formula. Set the table Page to Formula Constraints.
*Show Me Temp Constraints
Increased Unit Cost: The Unit Cost will increase because Optimal will need to select a higher cost ingredient due to the strict sodium limit. Greater flexibility expands the search space, allowing Optimal to find lower-cost solutions that still meet quality standards.
Step 2: Locate the Sodium row and enter a maximum/upper limit of 240.
*Show Me Temp Max Limit
Step 3: Click Opt it! and review the new, higher Unit Cost.
Congratulations! You've just experienced the power of Decision Optimization! You've seen how Optimal instantly adapts to cost changes, supply disruptions, and formula adjustments—delivering mathematically optimal solutions every time.