F.A.C.E Global Freight: How to Build the Excel Cost Spreadsheet Assignment
A section-by-section guide to the F.A.C.E Global Freight workbook — how to structure your sheets, what goes in the 20-item shipment log, how to set up warehouse cost, container, truck, tax, and fees sections with correct formulas, and how to link everything to a summary dashboard without formula errors.
The F.A.C.E Global Freight Excel spreadsheet assignment requires you to build a working cost management workbook — not just a table with some numbers typed in. There is a clear list of six required cost categories, a 20-row item log, and an implied expectation that totals calculate automatically and update when inputs change. Knowing what to put where, how to write the formulas correctly, how to structure your sheets so they connect, and how to avoid the formula errors that lose marks — that is what this guide covers.
A completed, verified workbook is available for download at the bottom of this guide. The sections below explain every design decision in it — so you understand what you are submitting and why each element is built the way it is, whether you use the provided file or build your own from scratch.
What This Guide Covers
Understanding the Assignment Requirements
The assignment asks for a single Excel workbook for F.A.C.E Global Freight containing six specific cost categories: warehouse monthly cost, 20 spaces for items to ship with a total price for each, shipping container cost, truck transport cost, taxes, and other fees. Every one of these is a required element — a workbook missing any category is incomplete regardless of how polished everything else looks.
Two things distinguish a strong spreadsheet submission from a weak one at this level. First, totals must be calculated by formula, not typed in manually. A total typed as a number does not update when inputs change — which defeats the purpose of a spreadsheet. Second, the 20-item section must be a proper table — 20 rows that each calculate their own row total automatically, with a grand total at the bottom that sums all rows. A row with just a label and a hardcoded number is not a functional item row.
Yes — a single-sheet workbook that contains all six sections is acceptable. However, splitting the workbook into multiple sheets produces a significantly more professional result and makes the assignment much easier to read and navigate. The cost breakdown sections (warehouse, container, truck, taxes, fees) have multiple line items each, and the 20-item log is a substantial table on its own. On one sheet, the workbook becomes very long and hard to use. The recommended approach is four sheets: Overview/Dashboard, Shipment Log, Cost Breakdown, and Invoice/Summary. This is how professional freight cost workbooks are structured.
Recommended Sheet Structure
Before building anything, map out your sheet structure. Trying to add sheets after the fact — especially once formulas reference specific cell addresses — creates errors that are time-consuming to fix. The four-sheet structure below is what the provided workbook uses, and it reflects how cost tracking tools are built in freight and logistics operations.
Sheet 2: Building the 20-Item Shipment Log
The assignment specifies “20 spaces/column for items to ship and total price for each item listed.” This means the sheet must have exactly 20 rows available for item entry, and each row must display a total price. The total price for each row is always Unit Price × Quantity — this must be a formula, not a typed value.
Column Structure for the Item Log
A minimal version of the item log needs three columns: Item Description, Unit Price, and Total Price. A professional version adds Quantity (so the row total formula works) and optional fields like Category, Origin Country, and Weight. The column setup below is what makes the log usable for a real freight operation — and what makes the assignment look like it was built by someone who understands logistics, not just how to type in a spreadsheet.
| Column | Label | Type | Notes |
|---|---|---|---|
| A | # | Static (1–20) | Row number — hardcoded, not a formula. Helps identify specific items quickly. |
| B | Item / Description | Text input | The name of the goods being shipped. Required for each row. |
| C | Category / HS Code | Text input | HS (Harmonized System) code is used in international freight for customs classification. Optional but professional. |
| D | Origin Country | Text input | Where the item ships from — relevant for import duty calculations in the taxes section. |
| E | Unit Price ($) | Currency input | Price per single unit. Must be formatted as currency ($#,##0.00). This is a blue-text input cell. |
| F | Quantity | Number input | Number of units. Must be a number, not text. Combined with Unit Price to calculate the row total. |
| G | Weight (kg) | Number input | Total weight of this item line. Used when truck cost is weight-based. |
| H | Total Price ($) | Formula | = Unit Price × Quantity. Must be a formula, not a typed number. Format as currency. |
The Row Total Formula
For row 6 (the first item row), the total price formula is: =E6*F6. Copy this formula down to all 20 rows (rows 6 through 25). Do not type the calculated value — if someone changes the unit price or quantity, the total must update automatically.
=IF(AND(E6<>””,F6<>””),E6*F6,””)
This version shows a blank instead of zero when the row has no data yet — which keeps the sheet clean when only some of the 20 rows are filled. The basic =E6*F6 version also works; it will just show $0.00 in empty rows.
The Grand Total Row
Below all 20 item rows, add a clearly labelled totals row. The grand total for the shipment uses =SUM(H6:H25) in the Total Price column. This is the figure that feeds the Overview dashboard and the Invoice Summary sheet — do not rename the “Shipment Log” sheet tab after linking it, or those cross-sheet references will break.
Writing the row total formula for row 6 and then typing the totals for rows 7–25 is one of the most common errors in this assignment. It means 19 of your 20 rows are not functional — they will not update when inputs change. Write the formula in the first row, then select that cell and drag the fill handle down to copy it to all 20 rows. Verify each row has its own formula (not the same cell reference) by clicking a few rows and checking the formula bar.
Sheet 3: The Cost Breakdown — Six Sections, One Sheet
Sheet 3 contains five of the six required cost categories (the sixth — the item values — lives on the Shipment Log). Each section has its own header, multiple line items with individual amounts, and a subtotal formula. The subtotals from each section feed the Overview dashboard using cross-sheet references.
The key structural decision is whether to give each cost category its own block (header → line items → subtotal → gap → next block) or to list all costs in a single flat table. Distinct blocks are strongly recommended: they make the sheet readable, make it easier to add or remove line items in one section without disrupting others, and produce a more professional result.
Warehouse Monthly Cost Section
The warehouse section covers all costs associated with storing freight before and after transit. This is a monthly recurring cost for F.A.C.E Global Freight and should be structured as a list of individual cost components that add to a monthly subtotal.
Line Items to Include Under Warehouse Monthly Cost
- Base Monthly Rent — the lease or storage fee for the physical warehouse space. This is the largest single line item in this section for most freight operations.
- Utilities — electricity, water, climate control. For a freight warehouse these can be substantial, particularly if temperature-controlled storage is involved.
- Security / CCTV — access control systems, CCTV monitoring contracts, and on-site security personnel if applicable.
- Insurance — goods-in-storage insurance. This is separate from cargo insurance in transit (which appears in Other Fees).
- Handling / Labour — loading, unloading, palletizing, and moving goods within the warehouse. Often calculated per pallet or per tonne.
The section subtotal formula sums all line item amounts: =SUM(C[first_row]:C[last_row]) where the C column holds the dollar amounts for this section.
Shipping Container Cost Section
The shipping container section covers all costs directly associated with the physical container used to move freight. In international freight, container costs include hire of the unit itself, any specialist container type required (refrigerated, open-top, flat-rack), and the charges the port applies to handle it.
Container Hire Line Items
- 20ft Container Hire — standard dry container, the most common unit in international freight. Approximately 33 cubic metres of capacity.
- 40ft Container Hire — larger standard dry container; roughly double the capacity of a 20ft.
- Refrigerated (Reefer) Container — temperature-controlled; significantly more expensive than a dry container. Only include if the goods require it.
- Container Sealing / Locking — security seals required by customs in many jurisdictions.
Port & Handling Line Items
- Terminal Handling Charge (THC) — the fee charged by the port for moving the container between the vessel and the yard. Charged at both origin and destination ports.
- Fumigation / Inspection — some destination countries require fumigation or biosecurity inspection of containers. If applicable, this is a fixed fee per container.
- Container Damage Waiver — optional protection against charges for minor container damage during transit.
The Freightos Baltic Index (FBX), published weekly at fbx.freightos.com, tracks global container shipping rates by route. If your assignment requires realistic cost figures rather than placeholders, this is a verified, regularly updated source for container price benchmarks across major trade lanes. Using realistic figures — even as examples — makes your workbook more credible and demonstrates you understand the real cost drivers in this industry.
Truck / Transport Cost Section
The truck transport section covers ground movement of freight — both the first mile (collecting goods from suppliers or manufacturers) and the last mile (delivering from the destination port to the final warehouse or customer). In a freight operation like F.A.C.E Global Freight, trucking costs can vary significantly by route, load type, and distance.
| Line Item | What It Covers | How It Is Typically Charged |
|---|---|---|
| Local Pickup / First Mile | Collection of goods from supplier or manufacturing facility to origin port or warehouse | Per trip, per km, or per tonne depending on carrier agreement |
| Long-Haul Trucking | Transport from destination port to final warehouse or delivery address | Per km, per load, or flat rate per lane |
| Fuel Surcharge | Variable addition based on diesel price index — applied on top of base rate | Percentage of base transport cost; updated periodically by carriers |
| Toll / Road Fees | Highway tolls, bridge fees, or congestion charges on the route | Fixed per route; varies significantly by country and road type |
| Driver Overnight / Detention | Additional charge if the truck is held waiting beyond agreed loading/unloading time, or requires overnight stops | Per hour for detention; flat rate per night for overnight |
Taxes Section
The taxes section is one of the most important in a freight cost workbook because taxes are often the largest single variable cost in an import shipment. The exact taxes applicable depend on the goods being shipped, their HS code, the destination country, and the trade agreement (if any) between origin and destination countries. Your workbook should list each tax type separately so the total is transparent and auditable.
Import Duty
Charged on the CIF value (Cost + Insurance + Freight) of imported goods. Rate depends on the HS code and destination country tariff schedule. This is typically the largest tax line item.
VAT / GST on Import
Value Added Tax or Goods and Services Tax applied at the border. In most countries this is calculated on the CIF value plus duty. Rates vary — check the destination country’s customs authority.
Customs Processing Fee
A flat or percentage fee charged by the customs authority for processing the import declaration. In the US this is the Merchandise Processing Fee (MPF); in other countries it varies.
Excise Tax
Applies to specific categories of goods — alcohol, tobacco, fuel, certain electronics. Not applicable to all shipments. Only include this line item if your goods are in an excisable category.
State / Local Tax
Some jurisdictions apply state or local sales tax to imported goods on delivery. In the US, this varies by state. Include if relevant to the destination location.
Harbor Maintenance Fee
Charged in the US on goods imported via ocean freight. A small percentage of the cargo value, collected by CBP at the time of import entry filing.
Other Fees Section
The “Other Fees” section is the catch-all for costs that do not fit neatly into the four preceding categories. In practice this section often contains costs that are equal in magnitude to some of the earlier categories — freight forwarding fees and cargo insurance, in particular, can be substantial. Include every line item separately so the total is auditable.
Line Items for the Other Fees Section
- Freight Forwarding Fee — the commission or flat fee charged by the freight forwarder (agent) who coordinates the shipment on behalf of F.A.C.E Global Freight. Often 1–3% of shipment value or a flat rate per container.
- Documentation Fee / Bill of Lading — the charge for issuing the Bill of Lading (B/L), Certificate of Origin, commercial invoice, and packing list. Each document may have a separate fee.
- Customs Broker Fee — fee charged by the licensed customs broker who files the import entry with the customs authority. Separate from the customs processing fee charged by the government.
- Cargo Insurance Premium — covers loss or damage to goods in transit. Typically all-risk or named-perils coverage. Premium is usually 0.2–1% of the insured value depending on commodity and route.
- Port Demurrage — charged when a container remains at the port beyond the free-time window (usually 3–5 days). This can escalate rapidly and is a major cost risk in freight operations.
- Currency Conversion / Bank Fee — where payment is made in a different currency from the invoice, the FX spread and wire transfer charges are a real cost that belongs in the workbook.
- Miscellaneous / Contingency — a buffer of 5–10% of total freight cost is standard practice in freight cost planning to cover unforeseen charges, delays, or surcharges not captured in the base quotation.
Overview Dashboard and Linking Sheets with Cross-Sheet Formulas
The Overview sheet pulls totals from the Shipment Log and Cost Breakdown sheets using cross-sheet formula references. This is what makes the workbook functional as a dashboard — change any input on any sheet, and the Overview updates automatically. Getting this right is the most technically demanding part of the workbook.
Cross-Sheet Formula Syntax
To reference a cell from another sheet, use the format: ='Sheet Name'!CellAddress. The sheet name must be in single quotes if it contains a space. Examples:
Total Items Value: =’Shipment Log’!H27 ← total row in the shipment log
Warehouse Cost: =’Cost Breakdown’!C12 ← subtotal cell for warehouse section
Container Cost: =’Cost Breakdown’!C21 ← subtotal cell for container section
Truck Cost: =’Cost Breakdown’!C29 ← subtotal cell for truck section
Taxes: =’Cost Breakdown’!C37 ← subtotal cell for taxes section
Other Fees: =’Cost Breakdown’!C47 ← subtotal cell for fees section
The exact row numbers depend on how many line items are in each section of your Cost Breakdown sheet. Identify the correct subtotal row in your sheet before writing these references.
Wrapping Cross-Sheet References in IFERROR
When a referenced cell contains an empty or zero value, some cross-sheet formulas return an error — particularly when the referenced cell itself contains a formula rather than a plain number. Wrapping the reference in IFERROR prevents this from showing as an error on the Overview sheet:
=IFERROR(‘Cost Breakdown’!C12, 0)
If the referenced cell produces an error (e.g. because it contains a SUM of empty cells that returns a text result), IFERROR returns 0 instead — keeping the Overview dashboard clean and preventing cascading errors in the Grand Total row.
Formatting, Colour Coding, and Professional Presentation
A correctly functioning workbook with poor formatting scores lower than a well-formatted one of equal technical quality. Formatting in Excel assignment submissions is assessed on: consistent use of currency number formats, clear visual distinction between input cells and formula cells, readable headers, and consistent font and colour usage throughout. The industry-standard colour convention for financial and cost models is worth following exactly — it is widely used in professional practice and markers in business programs often expect it.
Where Most Spreadsheets Lose Marks
Hardcoded Totals
“Total: $4,500” typed directly into a cell. If any line item changes, the total is now wrong but shows no error — making the workbook misleading. Every total in the workbook must be a SUM or multiplication formula.
Instead
Every total row uses a formula. For section subtotals: =SUM(C[first]:C[last]). For row totals in the item log: =E[row]*F[row]. For the grand total: =SUM of all section subtotals, or a sum of the individual summary cells on the Overview sheet.
Only Some of the 20 Rows Have Formulas
Writing a row total formula in row 6, then typing values in rows 7–25. The assignment requires 20 functional item rows — each row must have its own formula in the Total Price column.
Instead
Write the formula in the first item row, click the cell, hover over the bottom-right corner until you see a + cursor, then drag down to row 25. All 20 rows will have their own formula with the correct relative row reference.
Warehouse Cost Is a Single Cell with One Number
Writing “Warehouse Monthly Cost: $2,000” in a single merged cell. This satisfies the label requirement but misses the point — a professional cost workbook itemises what makes up the warehouse cost so it can be updated when individual components change.
Instead
Build a proper section block: header row, then individual line items (Rent, Utilities, Security, Insurance, Labour), each with its own amount cell, ending with a Subtotal formula that sums all the line items. This is what “warehouse monthly cost” means in a real freight operation.
Formula Errors Left in the Workbook
Submitting with #REF!, #VALUE!, or #DIV/0! errors visible. These indicate broken cell references or invalid operations. Each visible error loses marks and suggests the workbook was not tested before submission.
Instead
Before submitting, open the Formulas tab → Error Checking → Error Checking. Fix every flagged cell. Wrap cross-sheet references in IFERROR where referenced cells may be empty. Never submit a workbook with visible errors.
The “Taxes” Section Contains Only One Line
“Taxes: $350” in a single row. In international freight, multiple different tax types apply — import duty, VAT, customs fees, excise. A single-line taxes section suggests the workbook was built without understanding what the taxes section needs to cover.
Instead
Build the Taxes section with at minimum 4–5 line items covering the distinct tax types relevant to freight imports. Each has its own labelled row and its own amount cell. The subtotal sums all tax line items.
All Costs on a Single Unformatted Sheet
Dumping all six cost categories in a single column with no visual separation, no headers, no formatting, and no clear indication of which rows are inputs vs. totals. The workbook is functional in principle but unreadable in practice.
Instead
Use section headers with coloured backgrounds to separate each cost category. Apply alternating row colours to long tables. Format all dollar cells as currency. Bold totals rows. Freeze the header row so it stays visible when scrolling.
Frequently Asked Questions
How the Workbook Fits Together
A well-built F.A.C.E Global Freight workbook is not six separate cost cells — it is a connected system. The 20-item log calculates row totals automatically and produces a shipment total that flows to the Overview. The Cost Breakdown calculates a subtotal for each of the five fixed cost categories, and those subtotals also flow to the Overview. The Overview adds everything together and shows F.A.C.E Global Freight the full cost of a shipment at a glance. The Invoice Summary formats that information for external use.
The key to getting this right is building in order: Shipment Log first, Cost Breakdown second, Overview last. Write the cross-sheet references on the Overview only after the source cells exist on the other sheets — not before. Test by entering sample values on the Shipment Log and Cost Breakdown sheets and confirming the Overview totals update correctly. Run Excel’s Error Checking before submitting.
For direct support with this assignment — whether you need the completed workbook reviewed, help with a specific formula, or the full build — our data and spreadsheet writing team works specifically with Excel business models, logistics cost trackers, and freight workbooks at the undergraduate and vocational level.
Continue with: supply chain management help · business finance help · data science assignment help · professional coursework writers · proofread my paper.