RWS Information Systems
Blog
Who uses IMS? (May 1, 2018)
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
Inventory Magic Reports (May 14, 2018)
#1 Inventory Report
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
#2 The Order 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
#3 The Project / Job Cost 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
#4 The Item History 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
#5 The Physical Inventory Count Sheet
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
Lifetime Free Support (May 21, 2018)
Inventory Magic Spreadsheet comes with
lifetime, free, unlimited, support - Because
we get our best ideas from our users!
How to create Intelligent Item "Numbers" (June 1, 2018)
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.
5 Major Benefits of Inventory Control (July 5, 2018)
It has been my experience (‘IHBME’, below)
that inventory control provides benefits far beyond
simply having individual item control. Let’s take a look.
1 - Inventory Control Saves Money
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.
2 - Inventory Control Saves Time
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.
3 - Inventory Control Reduces Labor Cost
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.
4 - Inventory Control Enhances Customer Service
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.
5 - Inventory Control Reduces Waste
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.
Free copy of IMS Pro - August 1, 2018
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)
OR
#2 Provide a backlink from your website to
our website. It's that simple!
Contact Us
o : 949.276.7060
f : 949.334.1599
c : 310.489.5557
s: InventoryMagic