|
RETAIL
MEAT SPREADSHEETS
Your retail meat operation
control center spreadsheets
Designed
for a single store or multiple units
No More
Wondering If You
Can Attain Your Budgeted Gross
Project
Your Sales and Profits
Educate
Your Meat Managers
No
More Guesswork
Running your retail meat
operation, large or small, will never get easier than this!
Retail is a numbers game...control them and you are on your game!
Knowing your gross profit numbers, to a great degree of accuracy,
before the fact is half the battle.
Historical data is essential in retail meats... you will now get
accurate numbers weekly.
Experience can not be bought
or studied.
Getting
the experience from expert in the field is critical, especially in
perishables.
Years of
meat buying in major chain and ownership of independent markets helped
in designing these 7 essential spreadsheets.
While
each spreadsheet
can be purchased individually we recommend buying the "Set of 7" for
total control of your retail meat business.
With
knowledge of Microsoft Excel these spreadsheets can adapted for any
number of stores.
We also offer a RETAIL MEAT
OPERATIONS MANUAL
and RETAIL ROBBERY
TRAINING MANUAL plus various
primers for
Retail Meat Operations.
The
Spreadsheets:
When
bought as a set
(see here)
give
you excellent control of the
entire retail meat operation.
To
purchase individual
sheets click on the following links.
AD LOSS REPORT |
MEAT CUTTING
TESTS | MEAT
TONNAGE
MEAT PRICE BOOK
| MULTI-DECK CASE
SCHEMATIC |
INVENTORY TRACK |RECEIVING/INVENTORY FORM
The
Primers:
BUYING
A SUPERMARKET |MEAT
CLERK TRAINING
MEAT MARKETING TO
THE MEXICAN
CUSTOMER |
AD
LOSS REPORT
This
spreadsheet, in MS Excel format, is an accurate way to predict what the
Gross Profit is going to be for store(s) during any AD period.
The
report is user friendly, enter data and it computes the
results
in 6 easy steps
Results
of the report can be given to Meat Managers, by store, BEFORE the Ad
week starts so they know what their individual gross profit should be.
As you save worksheets for reference this tool
helps
make projections accurate.
Input
the following 6 variables:
***
Input Selected items To Advertise
*** Input Projected Tonnage per item
*** Input Cost per lb/unit
*** Input Retail per lb/unit
*** Input Projected Total Sales
*** Input Gross % on OFF Ad Sales
Gross Profit $$$ and %%% is computed.
Change the cost and/or retails to achieve required results.
Save worksheet for future reference.
Buy This Spreadsheet for $15
Immediate download
- 24/7 - after payment at PayPal
Top
of Page
MEAT CUTTING
TESTS
***
Tests were taken under normal working conditions
*** USDA Select Beef and Fresh Pork
*** Costs---Retails---Cuts can be changed as needed.
*** Average costs per lb computed
Buy This Spreadsheet for
$25.
Immediate download - 24/7 -
following payment at PayPal
Top of Page
MEAT
PRICE BOOK
This
is an actual Meat
Department Price Book.
It contains the following:
*** UPC
Codes
*** Tares for Self Service
*** Tares for Service
*** Retail Price computed by gross profit requirement.
*** This can be hidden before printing.
*** Retail price automatically rounded to the nearest .09.
The
Price book is THE
most important part of any retail operation, especially a perishable
department like meat.
Prices
change frequently
and PROMPT execution of price changes can mean extra gross dollars.
This
report is MS Excel
format can be modified to suit any operation.
Top
of Page
Buy
This Spreadsheet for $20
Immediate download - 24/7 -
following payment at PayPal
MEAT
TONNAGE
***
Input weights from invoices
*** Items are categorized
*** Computes tonnage by species and primal
*** Helps identify items contribution to gross profit
*** Helps pinpoint slow movers
Buy
This Spreadsheet for $15
Immediate
download - 24/7 - following payment at PayPal.
Top
of Page
MULTI DECK
SCHEMATIC
This is a
complete triple Deck setup.
***
Color and Number coded for easy setup.
*** Can be modified for more or less decks
*** Includes Beef--Pork--Lamb--Chicken--
*** Variety Meats--Ground Meats--Smoked Meats
Buy
This
Spreadsheet for $15
Immediate
download - 24/7 - following payment at PayPal
Top of
Page
MEAT CLERK TRAINING
The
Meat Clerk has become a very important part of Retail Meat Operations,
especially those markets with Service Cases.
This E-Book will cover essential guidelines for use in Clerk training.
This E-Book is printable.
Buy this E-Book
(Not viewable on MACs) for $5.99.
Immediate download - 24/7
- following payment at PayPal
Top of Page
RECEIVING/INVENTORY
COMPUTATION COMBO
Great
new spreadsheet has the DAILY RECEIVING LOG hooked
into the INVENTORY
FORM which SPEEDS UP the INVENTORY
taking process
and it's ACCURACY.
Meat Manager enter WEIGHTS, BEGINNING INVENTORY and
SALES
and all calculations on RECEIVING LOGS and INVENTORY FORMS
are
calculated automatically.
Reduce computation errors
Can be modified for ANY Inventory
period.
INVENTORY FORM
has 16 pages covering:
* Walk-In Cooler
* Walk-In Freezer
* Service Case
*Self Service Case
* Formula for cost on calc page.
* Calc Page, all info calculated to produce gross profit result.
Buy
this spreadsheet for $20.
Immediate download
- 24/7 - following payment at PayPal
Top
of Page
BUYING a
SUPERMARKET?
This
report will cover VERY IMPORTANT points, learned
by
experience, which can make the process from start to finish go a lot
smoother.
Things that would not be obvious to a first time buyer, from site
selection to sealing the deal.
Buy this primer for only $7.99
It is in e-book and Acrobat PDF format, download both for the price of
one
You need Adobe Acrobat Reader to view PDF files.
Get it at NO COST HERE
Immediate
download
- 24/7 -after payment at PayPal.
Top of Page
MEAT MARKETING TO
THE MEXICAN CUSTOMER.
Mexican
shoppers are big, repeat, meat buyers when their needs are met.
After 30 years of marketing in Mexican communities I found these are
the keys for success.
BUY this REPORT,
in Acrobat pdf format and/or E-Book
format, for $5.99 thru "Paypal"
Immediate download
- 24/7 -following payment at PayPal.
INVENTORY TRACK
(Silent Audit)
*** This
spreadsheet
acts as a silent audit
***
Especially useful
if there are more than one store
***
Tracks $$ changes
in:
1) Self-service meat case
2) Service meat case
3) Freezer Case
4) Freezer box
5) Cooler
Change
amounts can be
set to "ALERT" abnormal amounts.
Buy
This Spreadsheet for $15
Immediate download - 24/7 - following payment at PayPal
Top
of Page
|
MS EXCEL SPREADSHEETS
SET Of 7
FOR
RUNNING A PROFITABLE RETAIL MEAT BUSINESS
More info about each individual spreadsheet
below.
**NEW**
Online Video Tutorial For Each Spreadsheet in SET
"SET" of 7 MS Excel Spreadsheets
includes:
-
Cutting
Tests
-
Ad
Loss Report
-
Receiving/Inventory
Form
(Linked)
-
Inventory
Tracking (Silent
Audit)
-
Price
Book
-
Tonnage
Report
-
Case
Schematic (Multi Deck
Self Service)
Control is
the key to any business operation, especially in perishables.
Accurate projections, product movement, historical data, cutting tests
and price books are essential to a successful operation.
The 7 spreadsheets are:
MEAT
CUTTING TESTS
Cover the most used primal cuts in Beef, Pork and Lamb.
Includes a Ad Projection Sheet for
advertised
items, which can be used with the Ad Loss Sheet, to
project
gross profit for advertised items on a weekly basis.
This is useful for predicting gross profits for Meat Managers
BEFORE
the fact!
Has an optional function, not necessary for gross profit calculation,
whereby labor and supply costs can be entered to get a ball park NET
profit result.
AD
LOSS SHEET
This records the ACTUAL product movement, AFTER
the
fact, for advertised specials, data is taken from weekly
invoices
to use with starting and ending inventory.
This can also be filed by Meat Managers to use as historical data for
future ads.
When used with the Ad Projection Sheet it greatly
improves Ad
writing and Gross Profit projection skills and provides historical data
on file for easy reference.
TONNAGE
SHEET
This records, from invoices tonnage for EVERY item
in a meat
department, very important for product mix, to identify slow movers and
determine an item's contribution to GROSS PROFIT.
MEAT PRICE
BOOK
Has
an extensive
list of items found in an average meat department, including codes.
Computes the the retail, based on user gross profit number, to the
nearest .09.
Includes tares for self service and service meat cases.
INVENTORY
COMPUTING /
RECEIVING LOG
This
combo sheet
computes inventory results, from operator input, in a timely fashion.
It is linked to the receiving
log which
is designed for a 1-5 week inventory period, it
links data from INVOICES in RECEIVING
sheet to
the
INVENTORY sheet, this makes for accurate purchase numbers, it
saves
time because you do not have to enter the purchase data again in the INVENTORY
sheet, this will speed inventory results
INVENTORY
TRACKING
This
operates as a
silent audit, useful for multiple stores.
Data entry person enters inventory numbers for walk-in coolers, walk-in
freezers, service and self service cases after every inventory, it
computes the difference in inventory numbers from inventory to
inventory.
Owner/operator criteria can be set for each area, for example, when an
increase in FREEZER inventory over $1500 (arbitrary
number) is
seen by the office data entry person she must alert management so
increase can be verified and checked for accuracy.
When Managers know this system is in operation they take care to take
accurate inventories.
MULTI DECK
CASE SCHEMATIC (Self Service Case)
This
is a color
coded schematic for an 80' triple deck case.
It covers beef, pork, lamb, chicken, fish,
smoked
and variety meats
Video
Tutorials Included For Each Spreadsheet
All these spreadsheets are easily modified for any size operation.
Microsoft Excel software needed to use these spreadsheets.
The
FREE
Window Media Player needed to view and hear video tutorials
|
| |
Top of Page
We
Offer a Free Meat Newsletter
Keep up to date on new meat topics.
Consumer tips and recipes.
MeatnPlace News is published monthly
Subscribe
About Us
| E-Mail |Sitemap
| Retailers
Join Now || Retail
Meat Manual | Meat
Spreadsheets | STORE
Privacy Policy
Meatnplace
Disclaimer Terms Of Use
|