For Supply Chain Managers ·
What you'll accomplish
Every carrier RFP cycle, you rebuild the comparison logic from scratch: five or six bids, a dozen scoring criteria, and an afternoon of copying numbers into a spreadsheet before you can tell which carrier actually wins on total cost, not just headline rate. A Gemini Gem preloaded with your scoring rubric turns each new round of bids into a consistent side-by-side comparison instead of a fresh spreadsheet build.
What you'll need
Carrier bid pricing is competitive and sometimes covered by a mutual NDA between your company and the bidder. Before you build anything, confirm whether your company has an approved AI tool or a Google Workspace account with its own data controls for this kind of work, rather than a personal Gemini account.
What you should see: A clear answer on which account type you're allowed to use for this work. Troubleshooting: If nobody can answer quickly, default to the cautious path and never paste a real, un-redacted bid packet into a personal account.
What you should see: A settings screen confirming your current activity and personalization choices. Troubleshooting: If you can't find this control, search Settings for "Gemini Apps Activity."
What you should see: A Gem editor with a Name field, an Instructions field, and a Knowledge section for optional files. Troubleshooting: If Gems isn't visible in the sidebar, check Settings and help, since first-time access sometimes routes through there.
You evaluate carrier and freight forwarder RFP responses for a mid-market manufacturer or distributor. When I paste in bid details, score each carrier on: base rate, fuel surcharge structure, transit time, historical on-time performance if provided, capacity and equipment availability, insurance and claims history, and any value-adds (tracking, dedicated capacity, and similar). Weight rate and transit time most heavily unless I say otherwise. Always show your scoring math, not just a final ranking, so I can defend the recommendation to my team. Flag anything that looks like an apples-to-oranges comparison, such as one bid quoting all-in and another quoting base plus accessorials. Use generic labels (Carrier A, Carrier B) unless I've already made a carrier's identity non-confidential.
What you should see: The Gem saved and appearing in your Gems list, ready to open as a new chat. Troubleshooting: If Gemini suggests rewriting your instructions into something vaguer, keep your original scoring criteria intact and only accept wording changes that tighten the language.
What you should see: Uploaded files listed under Knowledge with no error message. Troubleshooting: If a file won't upload, check that carrier names and exact pricing are stripped first, both for confidentiality and to keep the example format-focused rather than deal-specific. Gemini's general file limits allow up to 10 files per Gem, so a handful of examples fits comfortably.
What you should see: A structured comparison table or list with per-criterion scores and a final ranking, plus visible reasoning you could walk a colleague through. Troubleshooting: If it collapses everything into a single vague ranking with no visible scoring, restate the instructions inside the chat and ask it to show its work.
Quick two-bid comparison: "Compare these two carrier bids on our standard rubric: [bid 1 details] vs [bid 2 details]. Which wins on total cost, not just rate?"
Missing-data flag: "Carrier [X] didn't provide on-time performance data. How should that affect their score, and what should I ask them for before I finalize this?"
Rubric reweighting: "For this lane, reliability matters more than cost because it's feeding a just-in-time production line. Reweight the scoring to reflect that and rerun the comparison."
Board-ready summary: "Turn this scoring comparison into a three-sentence recommendation I can put in my S&OP deck."
Renewal vs. new bid: "Our incumbent carrier's renewal terms are [details]. Compare them against this new bid: [details]. Is switching worth the transition risk?"