Home / Tools
Free operations tools and templates
Free operations tools PILTA’s team uses with product companies: a landed cost calculator and three Excel templates, an RFP (request for proposal) scorecard for choosing a 3PL (third-party logistics provider), an OGSM (objectives, goals, strategies and measures) one-page plan and a 13-week cash flow forecast. Each template comes with a guide that explains how to use it.
Calculator
Landed cost calculator.
The landed cost calculator adds product cost, freight, insurance, duties and tariffs, customs fees, brokerage and inland freight for one order and shows the landed cost per unit. An Excel workbook that runs the same math for many SKUs (stock keeping units) comes with the guide How to calculate landed cost after tariffs.
Download the landed cost workbook (Excel). Free, no sign-up.
Template
3PL RFP scorecard (Excel).
A weighted scorecard for comparing 3PL finalists on the same criteria, such as product and order fit, channel compliance, location and transit time, and systems and integrations. It comes with the guide How to choose a 3PL, which walks through the order data to gather and the RFP steps.
Download the 3PL RFP scorecard (Excel). Free, no sign-up.
Template
OGSM one-page plan (Excel).
A one-page plan in the OGSM format for setting next year’s priorities and tracking them through the year. The guide OGSM: next year’s plan on one page explains each part and how the plan becomes the operating plan and budget.
Download the OGSM one-page plan (Excel). Free, no sign-up.
Template
13-week cash flow template (Excel).
A week-by-week cash forecast that shows the cash balance at the end of every week for the next quarter. The guide The 13-week cash flow forecast explains how to build it, keep it accurate and act on what it shows.
Download the 13-week cash flow template (Excel). Free, no sign-up.
Behind the tools
Help putting the numbers to work.
PILTA’s team builds these models with companies as part of its Supply Chain & Fulfillment, Business Excellence & Profitability, Finance & Accounting and Org Structure, Hiring & Coaching work, then runs the decisions they point to with the company’s team.
Straight answers
Questions about the free tools.
What are some tips to find a good 3PL logistics company?
Start with the order data: SKUs, monthly orders, units per order, storage needs and the channels each order comes from. Send every candidate the same RFP so the prices compare, score the finalists on fit, compliance, location and systems, and visit each warehouse before signing. Ask for references at a similar size and for measured accuracy and shrink figures. PILTA’s free 3PL RFP scorecard sets up the comparison.
How are you actually tracking true COGS and landed costs on Amazon?
True COGS (cost of goods sold) starts with landed cost by SKU and purchase order: supplier price, freight, duties, customs fees and inbound costs, divided by the units received. Then add Amazon referral fees, FBA (Fulfillment by Amazon) fees, storage and returns by SKU, and subtract the total from the selling price to see the profit per unit on Amazon. Update the landed cost with each new order and every duty or freight change. PILTA’s free landed cost calculator handles the first half.
How to forecast cash flow in Excel?
Set up 13 weekly columns. Start with today’s cash balance, list expected receipts by customer in the week each payment should land, then list payroll, rent, supplier payments, inventory buys, loan payments and taxes in the week each one leaves the account. Each week’s ending balance becomes the next week’s starting balance. Compare the forecast with actual results every week. PILTA’s free 13-week cash flow template has the layout built in.
How to measure OKRs?
Measure each key result as a number with a starting value, a target and a date, then score progress at a set rhythm, such as weekly for team goals and monthly for company goals. Keep the list of key results short so each one gets reviewed. OKRs (objectives and key results) and OGSM share this idea, and OGSM puts it in its measures column. PILTA’s free OGSM one-page plan tracks every measure on one page.
Free assessment
See if PILTA can help.
Get on a call with the PILTA Founder and CEO Ryan or one of our expert executives and strategists. No cost, no obligation, just 15 minutes of your time.