|
|
Inventory products are divided into type and group categories for quick product searches.
A primary unit of storage is determined - either gallons or pounds.
Cross conversions are available through the pounds per gallon calculation.
The system divides inventory quantities into these categories:
- On Hand - Total quantity in stock.
- Committed - Quantity committed for use in Sales, Batch or Packaging Orders.
- Available - Quantity available for use. Product not committed to existing orders.
- Back Ordered - Quantities that have open Purchase, Batch or Package Orders.
- Required - Quantities where orders exist and inventory is not available to fill the orders.
Utilize the Minimum - Maximum inventory replenishment system.
A replenishment report provides restocking information.
When minimum quantity levels are met or products fall into a required status,
the report flags those items for easy identification. For example, suppose that a
sales order is received where some of the product required to fill the order is available and
some of the product is not available. The system would mark the product that is available to
committed to fill that sales order. The products on the sales order not available to fill the
order would be marked as required to fill the order. When a package order is generated to
make the product that is not available, the status of the product on the sales order would be
updated to back ordered. If any of the raw materials required to make the package are not available,
the status of the raw materials would change to required to fill the packaging order.
When a batch order for the bulk product is issued, the status of raw materials not available to make the
batch would be changed to required. If raw materials are available to make either a batch or package,
the status of the available product would change to committed. As purchase orders are released for
the required product, the product status changes to back ordered.
As materials are received or production orders are closed the product status is updated to committed.
The system handles these complex allocations quickly and efficiently. Product status can be
quickly checked by reviewing the Associated Orders Screen.
Provide material usage and product sales reports to help in determining efficient
stock levels. Some of our customers have used these tools to reduce inventory levels saving
hundreds of thousands of dollars.
Assign lot numbers and tracks lot history for both both raw materials
and finished goods. Inventory quantities are maintained by location and lot number.
This provides the tools for managing and maintaining an organized warehouse and the
shipment of products by the oldest lot numbers first. It also minimizes lost product in the warehouse.
Utilize a weighted average cost system to accurately reflect inventory costs.
Store the last cost which is the last cost of manufacturing or purchasing materials..
Maintain a future cost for future price changes from vendors.
This is useful in periods of fluctuating costs.
The formula deck can be printed showing the future cost of formula when the price increases take effect.
This helps the marketing department pass on price increases to protect margins in a timely manner.
Tag Count Physical Inventory
Tag sheets are printed and inventories counted by location are entered into the system. Inventory reports
showing counted quantities by location and what the computer shows for the location provide
information to quickly determine where recounts should be performed.
The system provides many reports including:
- Restocking and On hand Inventory Report.
- Detail Report By month or range of months showing beginning balance, detail transactions and ending balance.
- Summary Inventory Report which can be printed for any month at anytime.
- Inventory by location reports.
- Inventory by Lot number and transactions.
- Usage Reports.
- Dead and slow moving product reports.
- And more.
Harvest provides the tools to effectively control and manage one of your company's biggest assets,
it's inventory. It's a tool that will help improve the efficiency of your company and profits.
Inventory Master - Where raw materials and finished goods are entered into the system.
A product code number can either be numeric or alpha-numeric.
The Harvest System Inventory Master Screen shows the key elements of the inventory control system.
- Order entry screens (sales, purchase, batch, package) have the
same look and organization which facilitates learning.
- Layout is logical and not complicated.
Harvest customers quickly learn how to use the system
even if they have never had any windows experience.
Inventory Master - Key Elements
- Product Code Number - Product Code that identifies the product to the system.
- Description - Name of the product.
- Manufacturing Part Number - Optional number that can be the primary vendors stocking number.
- Type - Inventory products are assigned to a type such as RM for raw materials, FG for finished goods.
Useful for isolating specific products for reports.
- Group - Inventory products are assigned to a group such as Cartons, Pallets, Export, Domestic, etc.
Useful for isolating specific products for reports..
- Unit of Measure - B for bulk, DM or DR for drum, PL for pail, T for tote, etc.
G or # - either gallon, # or lb for pound, N for neither.
- Avg Cost - Weighted average cost maintained by the system. Presents a true cost.
- Last Cost - Last purchase or manufacture cost of the product.
- List Price - Used as a 1st level retail price.
- Future Cost - Used when price changes are passed on from vendors.
Another part of the system actual tracks price changes by vendor with a price change date.
- Pack Size - 1 for bulk, 55 for a 55 gallon drum, 5 for a 5 gallon pail, etc.
- Lb or G per Unit - Manufacturing Unit such as 1 for bulk, 55 for drum, etc.
- Sales Pack - 1 for bulk, 55 for drum, etc. Used for marketing reports to determine exact
number of pounds or gallons sold from drums, pails, bulk, etc.
- Sales Unit per package - always 1 and used in marketing reports.
- Generic - If the product is a finished good then the generic code goes in this field.
- Lbs per gallon - The number of pounds per gallon and used to convert gallons to pounds in the system.
- Hazardous Code - Used to classify products by hazardous materials codes for reporting purposes.
- RMS - Raw Material Specifications code.
- Sales Code - Inventory Code - Cost of Sales Code - used to direct accounting entries into the general ledger without manual intervention.
- Minimum Stock - Minimum order quantity.
- Maximum Stock - Maximum order quantity.
- Normally Stocked - Click box for generating reports for reordering.
- Bill In Gallons - used when inventory based in pounds is sold as gallons with a gallon price.
- Track Lots - Click box when marked turns on lot tracking for the product.
- Sales Territory - Used in some systems for reporting of sales by product territory.
- Stock - Number of Units in Stock.
- Not Committed - Number of units available for sale.
- Committed - Number of units for which orders exist whether blend, packaging or sales orders.
- Required - Number of Units needed to fill orders whether purchase, blend, pack or sales orders.
- Appropriated - Number of units appropriated to fill orders.
- Not Appropriated - Number of units not appropriated to fill orders.
Inventory is tracked by lot and by location.
Maintaining inventory in this manner organizes the warehouse and makes it easier to find products.
It is easy for users to track lots and locations. When product moves out or in, the
system displays a screen showing all the products on the order with the existing lot numbers
and locations. The quantity is already marked for the default location, so if tracking is not
required, the user presses Enter.
Normal system flow:
Sales orders are taken during the day.
If the quantity ordered is not in stock or if there is not enough product to fill the orders
then the balance goes to required. That night or the next morning, inventory reports are
generated to determine which goods need to be ordered to fill the existing reports.
If finished goods are required then package orders are generated to fill orders which in
turn flags raw materials to determine if sufficient stock remains to make the existing orders.
Purchase orders can be entered either manually or automatically by the system.
Auxiliary View and Information Screens:
- Transactions
- Usage
- Customer Purchases
- Vendor History
- DOT Screen
- Lot Masters and Lot History
Inventory Control Auxiliary Task Screens:
- Physical Adjustments Screen
- Cost Adjustments
- Verify Files - Used to verify all allocations.
- Print & Post Adjustments - Physical adjustments are posted to the general ledger via this program.
- Delete Products - Used to delete products from the inventory master.
- Copy Product Warehouse - In some systems used to copy existing product codes to a new warehouse.
- Copy Product Regular - Similar products can be quickly entered into the system by copying. The product to copy is entered with a new product number and product name.
- Matrix / Customer Prices - Prices can be set on a customer by product basis with quantity matrix.
- Matrix Pricing - Pricing breaks can be set by quantity purchased.
- Physical Inventory Tag Report System - Each item in the warehouse and counted with a tag.
Tags are sequentially numbered and stored in the computer.
Inventory count balances between the computer and the tag counts are printed and recounts issued.
Physical adjustments can be entered manually or the computer will automatically adjust the balances.
Inventory Reports:
On hand inventory report
Month end inventory summary report
Transaction history by month or other time period
Physical adjustment report
Inventory by location report
Raw Material Requirements report
Finished Goods Requirements
|