Technology Solutions for the Real World
About IYB Scrap It Our Partners Our Customers Contact Us
 
 

Enterprise Wide Licensing, regardless of the number of scales
No electronic scale too tough to hook up
Turnkey implementation
On-site training...Single source hardware, software and scale integration
Fully integrated state-of-the-art software...Customer quote to financial
statements

Applications:

Master Databases
  • Customers (suppliers of scrap)
  • Consumers (end users of scrap)
  • Products
  • Prices
  • General Ledger Accounts
Customer Quote System w/auto faxing
Scale Ticket System w/ Bar Code Capability
Sales Order System
Bar Coded Bale Tickets
Freight Control System
Brokerage System
Inventory Control System (Scrap)           
Costing
Accounts Payable-Non-Trade

General Ledger & Financial Reporting System
Scrap Purchasing History & Reporting
Cash Office System
Picking & Packing Slip w/ Work Sheet and Bar Code Capability
Invoicing and Accrual System
Sales Reporting System & History
Container Control Dispatch System
Purchase Order System w/ Reporting & History
Accounts Receivable
Accounts Payable-Trade (Scrap Purchases)
Management Information System

Applications and Details of Their Use:

Master Databases
Buying
Operational
Financial

Master Databases

Applications Customers (suppliers of scrap)
Products
General Ledger Accounts
Consumers (end users of scrap)
Prices

Application Details Ability to Add, Modify, Delete, Report and Inquire on the following:
  • Customers (Suppliers of Scrap)
  • Consumers (End Users of Scrap)
  • Products
  • General Ledger Accounts
  • Pricing Files with the following capabilities:
    Standard Price by Product, by Type of Customer
    Customer Contract Prices

back to - menu | top

Buying

Applications Customer Quote System
Scrap Purchasing History and Reporting

Customer Purchase Order System

Application Details

Customer Quote System/Customer Purchase Order System

The System will provide a printed Quote or formal Purchase Order by customer, by product.

Anywhere, in any application, by simply hitting a
specific function key, the Quote or Purchase Order System can be accessed 

The Quote and Purchase Order Systems will have the following features: 

  • View existing Customer Quote or Purchase
    Order by Product 
  • Input new Quote or Purchase Order 
  • Move Quote or Purchase Order to and from the Purchase History System 
  • Review current market product prices (if data
    has been keyed into the master file) 
  • Automatic faxing 
  • Copy Cat

Scrap Purchasing History and Reporting System

The System will provide details by product, by
customer, by date, etc. of all purchases whether
bought against a Quote, Purchase Order or straight across the scale 

The reporting of the information will be either by screen, on an online basis or via reports on an 'as needed' basis 

History of previous Quotes/Purchase Orders by customer, by product, by date will be provided Copy
Cat


back to - menu | top

Operational

Applications

Scale Ticket System
Sales Order System 
Bar Coded Bale Tickets
Invoicing and Accrual System  
Sales Reporting System and History 
Container Control and Dispatch System 

Parts and Supplies

Payment System and Cash Office System 
Shipper (Picking Slip/Packing Slip/Bill of Lading)
Scrap Inventory Control System
Freight Control System
Brokerage System
Purchase Order System

Application Details

Scale Ticket System

The scale would be linked to a server by a computer near the scale 
Based on licence plate number or customer name,
the customer information would be accessed.  New customers could be set up on-line while the product(s) is weighed 

Gross and tare weights by product would be input or
fed automatically from the scale 

Current market price, based on a customer's profile or specific customer quoted prices would be retrieved automatically.  Price overrides would be available 

Once completed, a scale ticket would be printed/faxed/given to the customer if required.  The scale ticket would be bar coded for quick recall in the payment office

Payment System and Cash Office System

Customers would report to the Payment Office from the scale area
The scale ticket(s) would be entered into the
System or recalled by scanning a bar code and the information retrieved automatically

A duplicate receipt would be printed and a check automatically printed and/or cash paid out.  A signed duplicate copy of the receipt in the history file of the server and be printed off only when needed using signature capture technology

At the end of each day, or as required, a Daily
Report of all payments and purchases would be generated Alternatively, customers who are paid by check at the end of a week/month would have checks printed based on customer profile


Sales Order System

Open orders would be input into the System by consumer (end user of scrap), by product

Open Order Inquiry and/or Report would be provided indicating the balance to ship by consumer, by product


Shipper (Picking Slip/Packing Slip/Bill of Lading)

Depending on the specific application any combination
of 'shippers' could be created, indicating total number
of skids, bales, truck load, product description(s), weights, total weight, etc.

A Bill of Lading would be created and signed by the carrier


Bar Coded Bale Tickets

Depending on the specific application bar coded bale tickets would be printed and attached to the product bales, skids, drums, etc.

When product(s) are ready to ship, a memory scanner could be used to collect and create the details for the 'shipper'

Scrap Inventory Control System

The System will provide reporting on screen or in hard copy format.  Reporting will consist of:

  • On Hand in summary
  • On Hand in detail
  • On Shippers (Packing Slips)
  • Available to sell in summary
  • Available to sell in detail

The system will provide 3 methods of Inventory Valuation

  • FIFO/LIFO
  • Latest Landed Cost
  • Average Cost

The system will have the following additional features

  • Multiple Warehouse Capability
  • Ability to Adjust and Transfer Inventory
  • Physical Inventory count sheets/tags
  • Comparison of actual vs. Perpetual counts
  • Ability to enter cycle counts
  • Ability to manually adjust counts

Invoicing and Accrual System

The System will control outbound shipments by
tracking the open, non-invoiced shippers
(packing slips) and recording their raw value as
accrued shipped revenue

At month end and/or upon receipt of settlement
weights and/or payments the accrual would be converted to an invoice and the accrual reduced

Accruals can be set up to reflect actual shipment values or reduced in order to account for grading changes and weight adjustments

Freight Control System

As a contract carrier is called to pick up a load, a numbered open load ticket is filled out on the System detailing:

  • Pickup location
  • Drop off location
  • Estimated load size and weight
  • Expected pickup date and time
  • Expected drop off date and time
  • Quoted price
  • Freight 'bill to'

Once the carrier has crossed the scale the open load ticket will be attached to a scale ticket on the System.  The System will not allow duplicate or non-valid load tickets to be entered

Reports and Inquiries would be available by load ticket, by carrier, by overdue loads, etc.

Similar systems and controls would be in effect on outbound shipments

Depending on the specific application the System is capable of tracking freight without a load ticket by simply entering the carrier's name, bill number and freight amount against an inbound scale ticket or an outbound shipper

The System will not allow duplicate payments against a scale ticket or shipper nor will it allow a carrier to present a bill more than once for payment.



Sales Reporting System and History

The System will provide the following reports and inquires:

  • Sales by dollars, by weight, by product, by units in summary and in detail
  • Analysis by consumer (end user of scrap), consumer/product
  • This year vs. last year comparisons

Brokerage System

The System will allow a buy or a sell of any product
Buys will be tracked independently from sells and vice versa
A buy can be linked to a sell or a customer at any time
A sell can be linked to a buy or a consumer/customer
at any time
The System will keep track of unfilled quantities and dollars of both buys and sells

On demand, a brokerage position report can be generated indicating the open buys and sells by product, by consumer, by customer in dollars and
weight

Container Control and Dispatch System

A master file of containers will be created indicating:

  • Container number
  • Size
  • Initial service date
  • Type and manufacturer of container
  • Status

As containers are sent out and returned, the
information as to who what and where is recorded in the System via the Scale Ticket System and the
Shipper System

On demand, container status reports and inquiries
will be produced by container and/or by customer or consumer

On demand, container history and movement reports could be generated A dispatch slip would be created for each truck movement

Parts and Supplies Purchase Order System

The System will create suggested purchase orders for parts and supplies

Following approval, purchase orders will be generated by the System
Copycat feature will be available

Purchase Orders can be printed and/or automatically faxed to a supplier
As goods are received, purchase order files and inventory records will be updated reflecting the quantities received including supplier reference
number, picking slip number, packing slip number, etc.

Open Purchase Order reporting on screen or hard copy will be available on demand by supplier, product, date

back to - menu | top

Financial

Applications Costing System
Accounts Payable System - Non-Trade
General Ledger and Financial Reporting System
Accounts Receivable System Accounts Payable System - Scrap Purchases/Trade
Management Information System

Application Details

Costing System

The System will provide the ability to enter and report on the calculation of landed costs

These costs would be determined by dates and customers

Various cost components would consist of:

  • First cost  
  • Transportation
  • Crushing, shredding, baling
  • Review current market product prices (if data
    has been keyed into the master file) 
  • Others to be determined

Accounts Receivable System

The System will be an open item type with automated 'Cash Posting' and adjustment processing

Reporting information will include:
  • Details of paid and unpaid items  
  • Summary and detailed aging lists
  • 45 and 60 day aged reports

The System features simple function screen key to obtain

  • Invoice summary and details  
  • Invoice History
  • Sales History

Accounts Payable System - Non-Trade

The System will be an open item type with simple screen input and automated default fields for simplified entry.  On line history will be available for a minimum of two years with drill down summary to detail invoice through to general ledger posting

The System features:
  • On line inquiries during input  
  • Ability to have periods open at a time including over year ends
  • Multiple currency including foreign exchange calculation
  • Dial up access to bank for TT Automation,
    balance verification, etc.
  • Ability to produce single checks as well as multiple checks on a group run
  • Ability to input and produce future dated checks for any period

Accounts Payable System - Trade (Scrap Purchases)

The System will be an open item type with simple screen input and automated default fields for simplified entry.  On line history will be available for a minimum of two years with drill down from summary to detail
invoice through to general ledger posting

The System features:
  • All features in Non-Trade Payable System  
  • Open scale ticket summary reporting
  • Advances and reconciliation routines

General Ledger and Financial Reporting

The System will provide automatic entries from all subsystems
The System will use non-fixed length ledger codes
The Financial Statement Routines will be user defined and controlled

Reporting will be as follows:

  • Trial Balance  
  • Detail Register
  • This year vs. last year comparisons
  • Financial Statements - multiple flavours

Management Information System

The system will provide on line inquiry and reporting detailing:

  • Quantity and dollars purchased across scale by product or by summary  
  • Quantity and dollars shipped by product or by summary
  • Brokered position
  • Total A/R aged
  • Bank Balance
  • Monthly Purchases Summary Report by day
  • Monthly Paid out Report by day


 
   
  Career Opportunities   Contact
 

I.Y.B. is always striving to move forward, and that
includes bringing in new people that are excited about
contributing to a dynamic organization.

Read more...

Address:
105-11 Allstate Pky
Markham, ON.
L3R 9T8

Tel: 905.480.9388
Fax: 905.480.9342
E-mail: lcohen@iyb.ca

   
      Ravenshoe Group      
iyb consultants inc.