|
We
offer a set of 7 MS Excel spreadsheets, RETAIL MEAT MANUAL and RETAIL ROBBERY TRAINING plus various primers for
Retail Meat Operations.
The Spreadsheets are in Microsoft Excel format:
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 following primers are in
Adobe Acrobat pdf format, viewable on PCs and MACs.
You need Adobe Acrobat
Reader, already on most computers .
Get it at NO COST at www.adobe.com
BUYING A SUPERMARKET
MEAT MARKETING TO THE MEXICAN
CUSTOMER
A DAY IN THE LIFE OF A REAIL
MEAT DEPARTMENT
RETAIL MEAT CLERK TRAINING GUIDELINES
==============================================================
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.
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 after payment
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 after payment .
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
after payment
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
after payment
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 after payment
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 Acrobat PDF format.
Immediate download
24/7 after payment
Top of Page
RETAIL MEAT CLERK TRAINING GUIDELINES
How to
train a retail meat clerk covers customer service, sanitation, safety
issues, cross contamination, equipment and tool usage and more.
A handy reference guide, also has tips for topics to be included in a
typical company policy handbook.
BUY
this REPORT, in Acrobat pdf format for $5.99 thru "Paypal"
Immediate
download 24/7 after payment
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 for $5.99
thru "Paypal"
Immediate
download 24/7 after payment
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
after payment
Top of Page
A
Day In The
Life Of a Retail Meat Department.
Covers a meat managers duties
from opening to closing on a typical day.
Essential things to do during the course of a day to ensure a well run,
profitable meat department.
This primer is a handy, inexpensive reference guide.
Buy this primer for
$2.99
Immediate Download 24/7 after payment
|
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
MeatnPlace
About Us |
E-Mail |Sitemap | * || Retail Meat Manual | Meat Spreadsheets |
STORE
Privacy Policy Meatnplace Disclaimer
Terms Of Use
|
