RAS Pantry Resource

Templates & Tools

Stop building spreadsheets from scratch. Calculators, trackers, and worksheets Singapore F&B operators use every week. Working files, not theory.

10
min read
Members only
Tool Library

Quick start

  1. Download one template.
  2. Use it this week.
  3. Iterate next week.

Need help implementing?

Start here (3 minutes)

๐Ÿงฎ
Objective: stop building spreadsheets from scratch. The Templates & Tools library is the working set of calculators, trackers, and worksheets Singapore F&B operators use every week.

Every operational decision in F&B comes back to a calculation. What is my real prime cost this week? Can I afford this lease? What does this delivery promo actually do to margin? Is this menu item earning its place? The Templates & Tools library answers each of those with a working spreadsheet that takes 10 minutes to fill in.

These are not theoretical. They are the working files RAS members use to run the weekly Monday review, the monthly P&L drill, and the once-a-quarter strategic call. Use them once and you stop guessing.

โœ”

What you will get from this library

  • Calculators for break-even, prime cost, rent affordability, delivery margin, promo profitability
  • Trackers for waste, weekly benchmarks, labour scheduling
  • Worksheets for menu engineering, action planning, scoreboards
  • Pre-filled examples so you can see how a good submission looks
  • Direct cross-links to the playbook each tool supports

How to use this library

Use this library like a toolbox, not a textbook. The workflow:

  1. Pick the right tool for the question. Use the What's Inside section below to match your decision to a tool.
  2. Download or duplicate it. Most tools are designed to be saved as a copy and used as a working file.
  3. Block 10 to 20 minutes. Each tool has a defined fill-in time. If it is taking longer, you are overcomplicating.
  4. Use the same tool every week or month. The value compounds with consistency. One use is a snapshot. Twelve uses is a trend.
  5. Pair with the matching playbook. Each tool has a playbook that tells you what to do once the tool surfaces the answer.
โšก

The discipline that matters: use one tool consistently before adding a second. Operators who try to run six trackers at once end up running zero.

What's inside the library

The library is organised by what they do. Open the section that matches the question you are trying to answer.

Calculators ("Should I do this?")

Trackers ("What is happening?")

Worksheets ("What should I do?")

๐Ÿ“ˆ

The library grows. Tools are added as RAS members ask for them. Most-requested becomes built. Write to info@ras.org.sg with what you wish existed.

When to use which tool

The decision you are making points you to the right tool.

The question The tool
Can I afford this unit at this rent?Rent Affordability Calculator
What revenue do I actually need to break even?Break-Even Calculator
Is this delivery channel profitable after fees?Delivery Margin Calculator
Should I run this 20% off promo?Promo Profitability Calculator
Is my prime cost moving in the right direction?Prime Cost Dashboard
How am I doing week on week across all key metrics?Weekly Benchmark Scoreboard
Where is food cost actually leaking?Waste Tracker + Root Cause Fixes
Am I scheduling staff against actual demand?Labour Scheduler + SPLH Tracker
Which menu items are pulling their weight?Menu Engineering Worksheet
The outlet is in trouble. What is the plan?90-Day Turnaround Action Planner
Have I let a licence expire by accident?Licence & Renewal Tracker

Member benefits and tool requests (premium)

What RAS members get from this library

Every tool here has been pulled apart, tested in live Singapore F&B operations, and stripped down so the input takes under 20 minutes. No required software. No subscriptions. Just working spreadsheets.

๐Ÿ”’

Members get the full Templates & Tools library including: every calculator, tracker, and worksheet listed above with formulas built in and worked examples filled in, the weekly Monday morning scoreboard template, the labour cost build-up template with CPF and Work Permit levy calculations included, the menu engineering matrix with quadrant-based decision rules, and the integrated 90-day action planner that wires together prime cost, labour, menu, and waste actions.

๐Ÿ“ฉ

Request a tool: if you wish a working tool existed for a problem you keep solving from scratch, write to info@ras.org.sg with the subject line "Tool request" and describe what you want it to calculate. The most-requested tools get built.

Not yet a member? RAS membership unlocks the full Templates & Tools library alongside the rest of the Members Vault. Learn more about RAS membership.

Suggested usage cadence

Tools work when you use them on a schedule. The cadence that produces results:

Frequency Tools to run
DailyWaste Tracker (live entries)
Weekly (Monday morning, 30 minutes)Weekly Benchmark Scoreboard, Prime Cost Dashboard, Waste Tracker review, Labour SPLH review
MonthlyMenu Engineering Worksheet, Delivery Margin Calculator (across all platforms)
QuarterlyBreak-Even Calculator (re-run as cost base changes), Rent Affordability (if renewal is approaching)
Ad-hocPromo Profitability Calculator (before launching any promo), 90-Day Turnaround Planner (when trouble is identified)
๐Ÿ’ก

The compounding effect: three months of consistent weekly use beats six months of irregular use. Pick the weekly cadence and protect it.

Common tool mistakes

The most common ways operators waste tool effort:

Templates & Tools are the working files. The companion content that turns them into action:

The playbooks that call on these tools

The framework the tools sit inside

Wider context

๐Ÿ“ˆ

Pattern to notice: tools measure. Playbooks act. Benchmarks set the target. The three are designed to be used together.

Quick Navigation