Over the years, the one thing that is common about IMS users
is the need to keep track of parts and supplies.
Clients come in all sizes ... from mail rooms (brochures and office supplies)
to helicoptor maintenance and tours (brochures and repair parts).
Here's a partial list of clients that use Inventory Magic:
School Cafeterias
Janitorial Supplies
Doctors and Dentists
Break Room Items
Insurance Companies
Jewelry Shops
Restaurants and Bars
Facilities Essentials
Fire Departments
Ambulances
Emergency Supplies
Automobile Repair
Mail Order
Construction Companies
Country Clubs
Computer Maintenance
Visitors Information Centers
Vintage and Collectable Art Objects
The Inventory Report provides the detail of your items,
On Hand Quantity, Cost, Extended Cost, etc. When you
run the Inventory Report, you will see the following:
Inventory Report options include:
All items, regardless of On Hand Quantity
Only items with On Hand Quantity
Only items for a Specific Vendor
Subtotal by a specific Category or Vendor
Review on Screen (Default)
Save as File
Click Here to view the Inventory Report
The Order Report provides a list of items you need to order.
This is based on the current On Hand Quantity and the Maximum Stock.
Items appear in this report when the On Hand Quantity is below
the Reorder Quantity. When you
run the Order Report, you will see the following:
Options include:
Only show items you need to Order
All items, whether you need to Order or not
Only items for a Specific Vendor or All Vendors
Review on Sreen
Save as File
Click Here to view the Order Report
The Project / Job Cost Report provides the detail of inventory used for a
specific customer, project or job
This report is based on the data in the Inventory Out sheet.
When you
run the PJC Report, you will see the following:
Options include:
Select Date Range
Select customer, project or job
Review on Screen
Save as File
Click Here to view the Project Job Cost Report
The Item History Report provides the detail of inventory movement
When you run the Item History Report, you will see the following:
Options include:
Search by Keyword (Description)
Select Date Range
Subtotal by
View on Screen
Save as File
Click Here to view the Item History Report
The Physical Inventory Count Sheet assists in the taking of physical inventory
When you run the Physical Inventory Count Sheet you will see the following:
Options include:
Select Vendor, Category, or Item
Include ON HAND QUANTITY
Review on Sreen
Printer
Click Here to view the Physical Inventory Count Sheet
We also have a 2 minute video which displays
the 5 reports of Inventory Magic
Inventory Magic Spreadsheet comes with
lifetime, free, unlimited, support - Because
we get our best ideas from our users!
Instead of using "regular numbers" (think UPC codes)
"Intelligent Item Numbers" will make life easier
for everyone in your group.
This is especially true if you need to
retag or resticker items. We have a pdf document
that discusses this topic. Just 3 pages short, it's a 5 minute read.
It has been my experience (‘IHBME’, below)
that inventory control provides benefits far beyond
simply having individual item control. Let’s take a look.
IHBME: Inventory is an Asset…until it isn’t.
And the more you have on-hand,
the higher your potential waste will be.
Why: When a ‘new, improved’ item becomes available,
you are stuck using up your excess older items.
And if an item becomes obsolete, it can result in a total loss.
That’s why—as a general rule—the less
inventory you have, the better off you are.
I have seen situations where a stockroom was so overstocked
and disorganized that no-one could find what they needed.
So every time they went to find something—or to order
something—it took 10X longer than it should have taken.
IHBME that the labor cost involved
in carrying too much inventory results in
2-3X the cost of having everything at the right level
and in it’s proper place. This observation is based on
working in a warehouse for a big box retailer.
That loss of time can never be recovered.
And the resulting level of frustration is hard to overestimate.
Whether you have ‘real’ customers
(in a retail or hospitality environment),
or whether your ‘customers’ are members
of your group or team, not being able to
take care of that person’s needs can
have devastating effects on your business.
If you have too little inventory to meet your needs,
or have too much inventory that is aging,
it can result in disappointing a ‘real’ customer,
or prevent a co-worker from being able to do
their job properly. IHBME that either way
it will result in a loss to your business.
IHBME that having improper inventory control
means that you won’t have the funds needed
to buy inventory that you really do need…
your assets will be tied up with your stagnant inventory.
By having the right inventory levels—
and the right inventory mix—
then your money is working for you,
not being wasted.
You can earn a free copy of IMS Pro
in either one of two ways.
#1 Allow us to document your experience with IMS Pro
and publish it to our blog (Yes, you can remain anonymous)
#2 Provide a backlink from your website to
our website. It's that simple!
o : 949.276.7060
f : 949.334.1599
c : 310.489.5557
s: InventoryMagic