| Restaurant Resource Group has developed
a series of
customized Microsoft Excel spreadsheets
designed specifically for foodservice applications! They are configured to organize critical
financial information generated by your restaurant on a daily, weekly
and/or monthly basis; to forecast trends and help with budgeting; and even to
assist you in performing many types of "what if" analysis. But that's not
all...many are also designed to make manual entries into your accounting system more
streamlined.
The information generated by these
spreadsheets will not only allow you produce accurate monthly financial
reports, but also support your efforts to proactively manage your
restaurant on a daily basis.
These nine "workbooks"
cover every facet of your restaurant and include spreadsheets to organize your
daily sales and deposits data, your labor expenses and food & beverage purchases
and inventory. They will assist you in optimally scheduling your labor, maintain
up to date recipe costs, and evaluate the overall profitability of your menu.
They will also assist you in forecasting your weekly cash flows, as well as your
daily and weekly sales revenues.
Don't let all the critical
financial information generated by your restaurant slip through your fingers!
Use these spreadsheets to turn your restaurant into a great business, and begin
to take charge of the critical areas where you have an opportunity to make a
real difference to deliver bottom line profits.
|
|
Special offer - Order all 9 spreadsheets in this series (see below) for only
$99.
A savings of $193! |
Regular price: $292.00 |
|
Sale Price:
$99.00 |
|
|
Note:
YOU MUST HAVE MICROSOFT EXCEL (version 2000 or later) INSTALLED ON YOUR COMPUTER TO UTILIZE THESE
SPREADSHEETS! They do come with detailed instructions, and while pre-configured, they can easily be
customized by any reasonably experienced Excel user.
Simply use the included password to unprotect the worksheets, make your changes
and then re-protect the worksheet again!
|
Daily
Sales & Deposits plus Labor Summary ($39)
click on image for full view in Adobe pdf format |
 |
Adds labor
expenses, by Department, to the daily sales report so you can monitor your
daily and week-to date labor costs as a percentage of sales. Designed to
allocate your labor costs by Department (e.g. Kitchen, Front of House,
Managers) utilizing the labor report information from your POS report as well
as fixed
salaried employees. The report also accounts for estimated Employer tax
expenses. Monitor your daily and weekly labor expenses as compared to labor
targets that you choose. A very powerful tool!
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Weekly Prime Cost Workbook ($49)
click on image for full view in Adobe pdf format |
 |
In addition to
recording the current week's sales information and payroll expenses, this spreadsheet
takes the "series" to its logical conclusion by also accounting for your weekly
food and beverage purchases as well as beginning and ending food and beverage
inventories. The result is a
weekly COST OF GOODS SOLD (COGS) SUMMARY and a PRIME COST report which indicate your restaurant's total F&B usage plus Gross
Labor in both total dollars and as a percentage of the current week's sales. Use this report to
manage both your labor and your purchases and to keep expenses in line with sales
budgets.
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Weekly Food & Beverage
Purchase Log ($29)
click on image for full view in Adobe pdf format |
 |
Summarize your daily food and beverage purchases on a single weekly
log sheet. Includes Vendor Name, Invoice Number, Date, and Breakout by Food &
Beverage Category. Use the summarized totals to 1) make direct entries
into QuickBooks or other accounting software, 2) have a one page, easy to
read summary of weekly purchase totals to compare with your budget (based on
reordering to specified par levels).
Click here to order
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Restaurant Schedule & Labor Cost Master ($39)
click on image for full view in Adobe pdf format |
 |
This is a very
powerful tool that every restaurant operator should be using! Designed to help
you schedule every labor hour of the day to provide you with instant feedback of the costs associated with your scheduling decisions.
Compare the labor expense of each scenario with your actual or projected sales to
determine optimum employee scheduling for each day of the week. Then use the plan to create your actual
weekly schedule, and track the actual labor costs against your plan and actual
sales for feedback. There is no better way to effectively keep labor costs in
line with your budgeted and actual sales!
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Food & Beverage Inventory Master ($39)
click on image for full view in Adobe pdf format |
 |
Counting and
calculating your end of month food and beverage inventory is effortless with this
spreadsheet. You will need to invest a few hours of upfront time to enter your
restaurant's specific product list and unit prices (from your Vendor invoices).
Thereafter, the form will do all the extensions for you (e.g. it will multiply the number of
each item counted by the unit price) and it will then total each inventory category
automatically. Designed so that each month’s count sheets can then saved for future reference.
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Menu Engineering
& Profitability Workbook
($49)
click on image for full view in Adobe pdf
|
 |
A powerful and fully automated tool to assess the profitability of your menu items based on their food cost, selling price and popularity. Includes five worksheets to assess all your menu categories from appetizers to desserts. A simple set of instructions tells you where to input your information, and even helps you to take action based on the results!
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Weekly Sales Projection
Spreadsheet ($29) click on image for full view in Adobe pdf format |
 |
An easy to use tool to help project daily and weekly
sales by day-part. Simply input your estimates of the customer (cover) counts
and check average for each meal period and the worksheet will auto calculate the
sales totals as well as provide the daily percentage contribution. Use this tool
in reverse to determine how many covers and/or check averages are required to
generate specific total sales.
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
|
Payroll Accrual Spreadsheet ($39) click on image for full view in Adobe pdf format |
 |
Accruing payroll at the end of each month is
unquestionably the most important task that 99% of independent restaurant
operators ignore. (For more information refer to the following article:
www.rrgconsulting.com/restaurant_payroll_accrual.htm)
More importantly, it results in accurate payroll totals in your all important Profit and Loss
Statement! This workbook makes the accrual easy with detailed instructions to
guide every step. It also automatically creates the
necessary journal entry's (both the accrual and the reversal) to make into your
accounting software.
Click here to order only this spreadsheet
Click here for a
full view (PDF) |
|
or consider these special offers:
Special Offer #1:
Save an additional $49 when combine our Operations & Management spreadsheet
package and the
Restaurant
Operators Complete Guide to QuickBooks, 2nd Edition
Click
here for more info or to order Now...
Special Offer #2:
Save an additional $68 when you order our
Restaurant
Spreadsheet Library Special
Click here
for more info or to order Now...
Special Offer #3:
Save an additional $39 when you combine our Operations &
Management spreadsheet package and the
Restaurant Startup and Feasiblity Spreadsheets
Click here
for more info or to order Now... |
