• Preview of Negotiation Preparation Worksheet (BATNA, ZOPA and Concessions)Excel workbook preview

Negotiation, Cost Analysis and Savings

Negotiation Preparation Worksheet (BATNA, ZOPA and Concessions)

$17.99 Free XLSX
Excel workbook · 17 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A buyer preparing for a supplier negotiation who must show the approver where the limits are and why the walk-away price is below the best alternative.

What is inside

  • 10 sample issues with opening, target and walk-away for both sides
  • ZOPA exists, ZOPA range and target-inside-ZOPA calculate for lower-is-better and higher-is-better issues
  • Walk-away turns red when opening, target and walk-away are out of order
  • BATNA sheet values 4 alternatives and picks the cheapest one that meets the need
  • Checks that your walk-away unit price sits below the BATNA cost per unit
  • Concessions plan of 8 trades with value to cost ratios; ratios below 1 turn red

How to use it: Replace the laptop example with your own issues, alternatives and concessions, then copy the agreed limits into the negotiation mandate form.

Files & formats
  • XLSXnegotiation-preparation-worksheet.xlsx17 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.