Problem Solving Manual (7): Analyze

The Architecture of Objective Analysis

The analysis stage is the bedrock of objectivity in problem solving. Its primary purpose is to determine the exact scale or magnitude (how influential a variable is) and the direction (increasing or decreasing) of the problem's core levers. By substituting vague opinions with hard data, analysis either confirms or disconfirms the hypotheses generated during disaggregation.

In our Gia Pizza baseline case, establishing the magnitude and direction of key levers prevents the team from executing wrong solutions:

Customer Traffic: –30% (Largest negative lever—Primary Core Problem)
Food Ingredient Costs: +18% (Medium negative lever—Secondary Friction)
Average Transaction Bill: –8% (Small negative lever—Minor Symptom)
Promotion Potential: +25% to +40% possible volume uplift (Biggest positive recovery lever)

Heuristics: Stripping Away Complexity

Before deploying heavy statistical machinery, expert problem solvers apply mental shortcuts, or heuristics, to evaluate data quickly and ground their reality.

Core Heuristic	Analytical Purpose	Operational Application
Occam's Razor	Slices away overly complicated, unproven theories in favor of the simplest, most direct explanation backed by facts.	Saves weeks of chasing corporate or psychological ghosts.
Marginal Analysis	Compares the incremental cost versus the incremental benefit of a specific additional action.	Optimizes resource allocation under strict capital constraints.
Order of Magnitude	Estimates values to the nearest power of 10 to instantly assess if a problem or solution scale makes logical sense.	Acts as an immediate sanity check on raw data inputs.
Expected Value & Bayesian Thinking	Calculates probability-weighted outcomes and dynamically updates the probability of a hypothesis as new facts arrive.	Prevents rigid, black-and-white strategic conclusions.

Heuristic Example 1: Applying Occam’s Razor

Before analyzing the operational metrics, Gia Pizza’s family members held several highly complex, emotionally charged theories for the 25% profit drop:

Theory A: A permanent shift in local neighborhood demographics means families no longer want casual dining here.
Theory B: The kitchen staff has suddenly become highly inefficient, leading to massive internal food waste that is bleeding money.
Theory C: The macro-economy is entering a deep recession, causing everyone to stop eating out entirely.

Slicing Through the Theories with Bare Facts: When the team looks at the data gathered during the two-week workplan, Occam’s Razor cuts down these complex arguments:

Demographics & Economy: Pedestrian traffic logs show street foot traffic is actually up, and the two new competing pizza restaurants down the block are packed to capacity every night. (Slices away Theory A and Theory C).
Internal Waste: Kitchen ingredient tracking and waste logs show portioning and spoilage metrics have remained stable compared to last year. (Slices away Theory B).

The Simplest Explanation: The data confirms two highly visible events occurred simultaneously six months ago: two modern competitors opened nearby, and Gia Pizza's customer count instantly fell by 30%. Applying Occam's Razor, the simplest explanation is true: customers did not stop wanting pizza; they simply chose to walk into newer, shinier spaces because Gia Pizza's menu and marketing have remained completely stagnant for two years.

Heuristic Example 2: Applying Marginal Analysis

With limited cash (capped at 20 million IDR) and an urgent timeline, the owner evaluates three competing recovery paths by assessing incremental costs against incremental benefits:

Path 1: Complete Restaurant Interior Renovation.
Analysis: Marginal costs are extremely high (exceeding 50 million IDR and requiring a multi-day closure), while the marginal benefit is highly uncertain and slow to realize.
Path 2: Launching 5 Modern, High-Margin Menu Items.
Analysis: Marginal costs are exceptionally low (limited to simple kitchen testing and printing costs), while the marginal benefit directly addresses the core customer complaint.
Path 3: Running Geo-Targeted Instagram Promotions.
Analysis: Marginal costs are flexible and cheap, while the marginal benefit offers massive immediate reach to local customers walking the neighborhood.

Conclusion: Marginal analysis dictates that the highest return per rupiah spent comes from the combination of menu updates and digital marketing, completely bypassing expensive, high-risk physical renovations.

Root Cause Analysis: The 5Ws + 1H and 5 Whys

To ensure our analysis targets root causes rather than superficial symptoms, we combine the descriptive clarity of the 5W1H framework with the diagnostic depth of the 5 Whys methodology.

The 5W1H Diagnostic Blueprint

What: A severe 25% drop in monthly net operational profits.

When: Initiated exactly 6 months ago and sustained through the current month.

Where: Isolated to main dining room cover counts during historic peak weekend dinner hours.

Who: Lapsed regular local customers and neighborhood families migrating away.

Why: The sudden arrival of aggressive, modern competitors paired with an outdated internal menu.

How: Manifesting through a steady 30% reduction in daily customer ticket counts.

The 5 Whys Deep Dive

Why did monthly net profits drop by 25%? Because our active customer volume fell by 30% while wholesale ingredient purchase costs simultaneously spiked.
Why did active customer volume fall by 30%? Because regular neighborhood lunch and dinner diners are choosing to eat at the new modern restaurants down the street instead.
Why are they choosing to eat at the new competitors? Because those competitors offer highly appealing "Value Combo Bundles" and modern, Instagram-friendly menu options that fit current consumer tastes.
Why doesn't Gia Pizza offer modern options or value combo bundles? Because the baseline menu has not been updated, refreshed, or systematically reviewed in over two years.
Why hasn't the menu been reviewed or updated in two years? Root Cause: The owner, Dian, lacks a formal, scheduled operational process for tracking menu item profitability performance and reviewing supplier wholesale invoice pricing against open-market shifts.

Assumption Validation & Sensitivity Analysis

To ensure our final recommendations are robust, we must make all analytical assumptions explicit, cross-check them for internal consistency, and run a sensitivity analysis to see if our conclusions hold up if our assumptions turn out to be completely wrong.

Explicit Core Assumptions

Assumption 1: Competitor positioning and menu staleness are the primary drivers of customer attrition, not an underlying decline in Gia Pizza's actual cooking quality.
Assumption 2: Lapsed neighborhood customers still maintain local brand affinity and will respond positively to a modern menu refresh.

Sensitivity Analysis Matrix

The matrix below tests the resilience of our core turnaround strategy against assumption failures:

Working Assumption	If Wrong (The Failure State)	Strategic Impact	Does the Core Conclusion Change?
1. Competitor traffic draw: Lapsed traffic is driven by competitor novelty.	The real cause is an unnoticed, severe slide in our internal food quality or staff behavior.	A simple marketing promotion will fail immediately upon customer trial.	Partially Changes: We must pivot immediate resources into intensive kitchen staff retraining and strict recipe quality audits before spending any money on marketing.
2. Product sensitivity: Customers want trendy, high-margin gourmet pizza options.	The neighborhood has become highly price-sensitive and only wants rock-bottom cheap meals.	Premium new menu additions will sit unsold on the menu.	Major Change: The menu refresh must immediately pivot away from premium entries and shift entirely toward low-cost value pricing models and high-volume combo structures.
3. Supplier negotiation: We can slash ingredient costs by 8% to 10% through vendor negotiation.	Suppliers refuse to budge on prices due to locked-in macroeconomic inflation.	The projected profit recovery timeline will slow down.	Minor Change: The core menu and promotional recommendations remain intact, but we must lower the short-term profit target and search for alternative non-food operational cost reductions.
4. Marketing responsiveness: Targeted local promotions will drive a 25% to 30% volume bounce.	The promotion only yields a weak 10% traffic increase.	The restaurant will fail to fully recover its lost margins within the 90-day window.	Timeline Change: We must extend the promotional tracking period and layer on local digital social media ad spending to boost visibility.

Sensitivity Conclusion

The core strategic recommendation (menu refresh + targeted local promotion) is exceptionally resilient and holds its structural validity across most assumption failures. The primary risk factor is Assumption 2 (Price Sensitivity). If local diners prove to be hyper-focused on price rather than novelty, we must quickly shift our execution toward value-for-money combo deals. We will build a standby "Plan B" focused on aggressive value-bundling, and closely monitor customer ordering data during the first 14 days of the menu launch.

Numerical Sanity Checks & Statistical Traps

Data can lie just as easily as opinions. When executing quantitative analysis, you must explicitly guard against analytical errors:

Sanity Checks: Constantly step back to ask if your calculated numbers pass basic operational logic. If your cost-cutting spreadsheet claims you can save money by reducing cheese usage to zero, your math works but your business will collapse.
Spurious Correlations & Confounding Variables: Do not mistake coincidence for causation. For instance, if you notice that ice cream sales across the street rose exactly when Gia Pizza's profits dropped, a naive analysis might claim ice cream is stealing your pizza sales. In reality, the confounding variable is summer heat: the rising temperature drove ice cream sales up and made hot pizza dining less appealing during lunch hours.

The Analytical Loop & Advanced Toolkit

As emphasized throughout this guide, problem solving is a non-linear, iterative cycle. The analysis stage serves as the ultimate sorting mechanism. If your data disproves your hypothesis, you must move back to Step 2 (Disaggregate), rebuild branches of your logic tree, form updated claims, and return to run a fresh analysis.

Once your analysis cleanly isolates the critical path, respects all operational constraints, and provides a clear foundation for decision-making, the iteration loop for Step 5 closes, and you move forward to synthesis.

Deploying Advanced Quantitative Machinery

While simple heuristics solve 80% of everyday challenges, complex or highly volatile problem spaces require advanced analytical tools:

Systems Thinking & System Dynamics: Mapping feedback loops, delays, and non-linear interactions within a complex organization to see how a change in one department ripples through the entire ecosystem.
Causal Inference Techniques: Deploying statistical models to isolate true cause-and-effect relationships from messy, observational historical data.
Stochastic Modeling (Monte Carlo Simulations): Running high-volume data simulations to project future outcomes under deep uncertainty.

Advanced Execution Example: If Gia Pizza operated across twenty regional locations with highly volatile supply chains, we could write a Python or Excel script to run a Monte Carlo Simulation. By simulating next quarter's net profits across 10,000 distinct scenarios—randomly fluctuating raw flour/cheese ingredient costs alongside unpredictable customer return rates—we can mathematically map our exact probability of hitting our success criteria under any economic condition.

nugistic