The workbook contains three primary sheets:

• Summary Income Statement: The main dashboard providing a consolidated view of revenues, costs, and profits across logistics functions.
• Revenue Breakdown: A detailed table showing income generated from different logistics services (e.g., freight forwarding, last-mile delivery, warehousing).
• Cost Center Analysis: A granular view of expenses categorized by logistics cost centers such as fuel, labor, equipment depreciation, facility costs, and subcontractor fees.

Note: All values are formatted as currency ($, €, etc.) and aligned to two decimal places. The column headers (e.g., "Revenue", "Costs") are in bold and use a distinct background color for visual hierarchy.

• Total Revenue: =SUM(B2:B4) — Automatically aggregates all revenue sources.
• Total Operating Costs: =SUM(B7:B10) — Sums up core logistics expenses.
• Net Logistics Profit (Loss): =B5 - B11 — Calculates final profitability metric.
• Profit Margin %: =(B12 / B5)*100 — Shows percentage of revenue retained as profit.
• Conditional formatting formulas: Used to flag negative values and highlight performance trends (explained below).

To enhance data visualization and quick decision-making, the following conditional formatting rules are applied:

• Negative Net Profit: Red fill with white text — alerts users to operational losses.
• Profit Margin > 10%: Green background — indicates strong financial health.
• Profit Margin between 0–10%: Yellow background — signals caution and need for cost optimization.
• Cost Increases >5% MoM: Highlighted dynamically using a helper column (e.g., "MoM Change") and conditional logic.

These rules are applied to key metric cells such as B12 (Net Profit) and the Profit Margin % cell, ensuring that performance status is instantly visible.

1. Input Data: Enter monthly or quarterly revenue and cost figures in the "Revenue Breakdown" and "Cost Center Analysis" sheets.
2. Update Summary Sheet: The Summary Income Statement updates automatically using linked formulas from other sheets.
3. Add New Categories: Insert new rows under Revenue or Cost categories as needed; update totals with expanded SUM formulas.
4. Use Data Validation: Apply dropdowns to standardize cost center naming (e.g., "Fuel", "Labor").
5. Analyze Trends: Compare data across multiple periods by duplicating rows and using the built-in chart tools.

Interpretation: The logistics operation generated a net profit of $164,700 on $1.45M in revenue—yielding a healthy 11.36% profit margin.

• Stacked Bar Chart: Visualize revenue vs. cost breakdown by category (e.g., "Freight", "Warehousing") to compare profitability per segment.
• Trend Line Graph: Plot Net Profit and Revenue over time (monthly/quarterly) to identify seasonal patterns or performance changes.
• Gauge Chart: Display profit margin percentage with thresholds (e.g., Green >10%, Yellow 5–10%, Red <5%).
• Pie Chart: Show proportion of total revenue from each logistics service—useful for strategic planning and resource allocation.

These visualizations can be embedded directly into the Summary sheet using Excel’s built-in chart tools. Users are encouraged to update them monthly to track performance trends.