Achieve precise, data-driven financial control by mastering a few powerful formulas.
The Challenge of Manual Tracking
For importers and supply chain managers, tracking costs manually is error-prone and time-consuming. Item prices, fluctuating freight charges, and various service fees live in separate places, making it hard to see your true landed cost. This is where the FishGoo Methodology
Building Your Automated FishGoo Cost Tracker
The core principle is to create a single source of truth. Structure your spreadsheet with these key columns:
| Column | Purpose |
|---|---|
Item |
Product name or SKU. |
Unit Cost |
Price per unit from supplier. |
Quantity |
Number of units ordered. |
Item Total |
Formula: Unit Cost * Quantity |
Freight Allocation |
Share of total freight per line item. |
Service Fees |
Customs, brokerage, or other fixed fees. | Line Total Cost |
The Goal: Formula sum of Item Total, Freight, and Fees. |
The Power of Automation: Essential Formulas
Automation turns a static table into a dynamic financial model. Here are the core formulas for the FishGoo system:
1. Summing Item Totals: SUMPRODUCT
Instead of a simple SUM, use SUMPRODUCT for flexibility in multiplying unit costs by quantities before summing.
=SUMPRODUCT(B2:B100, C2:C100) // Where B is Unit Cost, C is Quantity2. Allocating Freight Proportionally: PRO-RATA
Distribute total freight costs based on an item's share of total value or volume.
=(Item Total / SUM of All Item Totals) * Total Freight CostExample: If an item's total is $500 and all items sum to $5000, it bears 10% of the total freight.
3. The Grand Total: SUM
Calculate the final landed cost for each line item by summing all cost components.
=D2 + E2 + F2 // Where D=Item Total, E=Freight Allocation, F=Service Fees
Then, use =SUM(G2:G100)
Calculate the final landed cost for each line item by summing all cost components.
=D2 + E2 + F2 // Where D=Item Total, E=Freight Allocation, F=Service FeesThen, use =SUM(G2:G100)
Benefits of the FishGoo Automated System
- Real-Time Accuracy:
- Data-Driven Decisions:
- Scenario Planning:
- Transparency & Reporting:
- Data-Driven Decisions: