Program Description
This program can be found on the Purchase Order Data Entry menu (PO-1-2). The purpose of the PO Worksheet is to provide the purchasing agent with the necessary information to create a purchase order. The current inventory status is analyzed and compared with the parameters of the Item (ITEM) file and Vendor Item (VITEM.DT) file for maintaining the desired inventory stock amount. The quantities that need to be ordered are provided on the report. Further explanation of this program can be found in the separate Purchase Order manual.
Rev 15 Changes
Internal changes were made to set a new OEM Indicator field correctly in the PO Header File (POHDRD). This is for the OEM Interface module.
Rev 14 Changes
When the PO Worksheet was run, it would only look at the amount on-hand, on-order, allocated, back-ordered and available for the individual warehouses. Some dealers receive inventory into one warehouse, but then transfer the products out to other warehouses. The program really needed to have the ability to order for an individual warehouse, but look at the inventory levels in all (or range) of warehouses. This option has been added. Three new questions have been added. If the operator enters a range of warehouse that is one specific warehouse (the beginning and ending warehouse is the same number), these questions will be asked. If the range of warehouse is more than one warehouse, or all warehouse, the new questions will be skipped. The first new question is Base Avail. On A Range Of WH (Y/N). If Y is entered, the program will ask for Beginning Warehouse All and Ending Warehouse. These questions will work in conjunction with the Print Current Inventory Status (Y/N) question. If Y is entered at both the Print Current Inventory Status (Y/N) and Base Avail. On A Range Of WH (Y/N) questions, the report will print the inventory status detail line for each warehouse in the warehouse range entered at both prompts. There will be a total line showing the total for all the warehouses being checked. If the Print Current Inventory Status warehouse range is 1 to 10, and the Base Avail. On A Range Of WH warehouse range is 1 to 50, warehouses 1 to 50 is used in the calculations, but only the inventory status for warehouses 1 to 10 will be printed on the report. If the Print Current Inventory Status question is answered N, the Base Avail. On A Range question can still be answered Y. The inventory status detail lines just will not print on the report, however, all of the warehouses will be used to calculate quantity available. It is recommended that if Y is entered at both questions, that the warehouse ranges for both of these questions be the same.
Example:
Results:
Rev 13 Changes
Program logic was added to convert American currency to Trinidad currency for Trinidad customers.
If the new global field 41 in Purchase Order Control File Maintenance (BI-3-1-18-14) is setup to not allow ordering of Dead Stock items, an item with Non-Stock (Y/N/D) set to D will not be skipped by the PO Worksheet. The program will look at the Non-Stock indicator in the Item File (ITEM) if the warehouse it is working on is warehouse 1. It will look at the Non-Stock indicator in the Item Warehouse File (ITEMWHD) if the warehouse it is working on is not warehouse 1.
The new field Overrided Description in the PO Worksheet file (TPOLD#) will blanked out.
The temporary file created by the program will be created larger.
If the item being entered on the purchase order has a discount % stored in the Vendor Item File (VITEM.DT) for the vendor and item number, then the discount % will be taken. If the Vendor Item File (VITEM.DT) does not have a discount for that vendor and item number, the discount % will be 0. The undiscounted cost will be stored in a new field (Original Quoted Cost) in the PO Worksheet File (TPOLD#) and the Quoted Cost field will become the discounted cost. The costs that display on the PO Worksheet are the costs with all applicable discounts.
Internal program changes were made to prevent the Error In Index File Or Index Parameters Stop on Unix platform systems.
Rev 12 Documentation
The purpose of the PO Worksheet is to provide the purchasing agent with the necessary information to create a purchase order. The current inventory status is analyzed and compared with the Item Files and Vendor Item Files parameters for maintaining the desired inventory stock amount. The quantities that need to be ordered are provided on the report.
Use of Create PO Worksheet will result in the following functions.
.
A minimum inventory amount can be defined in the Item and Item Warehouse File of all items in the LMS system. The primary vendor is assigned in the Item File. An item will appear on the worksheet when the worksheet is run for it's designated primary vendor and the item has reached a current inventory quantity at least one below the defined minimum quantity or has reached the minimum inventory quantity. Whether the item appears, based on its quantity reaching the minimum or below the minimum, is an option when running the program.
An item will also appear on the worksheet when the current inventory status is at a negative quantity. This will occur even with a minimum of zero.
A maximum inventory amount can be defined in the Item and Item Warehouse Files of items in the LMS system. The worksheet will provide the quantity that needs to be ordered to reach the defined maximum quantity.
If an item is at a negative inventory status and there is no defined maximum amount the worksheet will want to order a quantity to bring the item to an inventory status of zero thus negating the negative status.
Any differences between the Vendor and Item Files pack multiple and unit of measure will be reflected in the quantity to be ordered.
The worksheet will print the current inventory status, the minimum, the maximum and the economical order amount for all items and warehouses that have reached the reorder point.
Introduction (Contd)
The worksheet will provide cost, pack multiple and unit of measure information of each item that needs to be ordered from the primary vendor. If the primary vendor has a Vendor Item File a lead time per item will be provided.
When running the worksheet to stock more than one warehouse, the option is available to receive the items into one warehouse or into the individual warehouses.
Any alternate vendors, that are defined in the Vendor Item File, will print on the worksheet. The desired order amount, cost, lead time, unit of measure, and pack multiple will be provided for the alternate vendors.
The vendor item numbers will be printed for the primary and secondary vendors.
A total cost will be provided for the primary and secondary vendors per item. For each primary vendor a grand total will be calculated.
The PO Worksheet may be run as many times as desired. A temporary Purchase Order called a Batch Purchase Order will be created which can be edited in the program Generate PO From Worksheet. Once the batch purchase order is ready to become an actual purchase order, the batch purchase order is changed to an actual purchase order in the program Generate PO From Worksheet. No actual updating occurs in Create PO Worksheet.
Prior to running the PO Worksheet the minimum and maximum inventory levels must be defined in the Item File for warehouse 1 and the Item Warehouse File for all other warehouses. These can be entered in Item File Maintenance for warehouse 1 and the Warehouse/Item File Maintenance for all other warehouses. You may also run a Min and Max Report, which is found in the Inventory module. The Min and Max Report automatically sets the minimum and maximum amounts per warehouse based on item usage.
Enter Data
Beginning Vendor Number Or A'll
7/11/95 Create PO Worksheet 10:30
Beginning Vendor Number Or A'll ########
Ending Vendor Number
Beginning Product Class Or A'll
Ending Product Class
Beginning Warehouse Number Or A'll
Ending Warehouse Number
Enter One Warehouse The Items Will Be Received Into Or I'ndiv. Warehouses
S'tock, N'on-Stock, Or A'll Items
Spare P'arts, S'erialized, R'est Of Inventory Or A'll Items
Include Items With A Quantity Needed Equal To MIN? (Y/N)
Print Current Inventory Status (Y/N)
Beginning Warehouse - A'll
Ending Warehouse
Prepare Final Purchase Order Worksheet (Y/N)
Comment Press 'ESC' To Interrupt And Return To Menu
Notes: ^ = Go Back 1 Space / = Cancel
Input a specific Vendor number or a beginning range or an A for all. When inputting the Vendor number keep in mind that the items that will be included must have that Vendor number as their primary vendor. Primary vendor is defined in the Item File. If the worksheet is run for more than one vendor a separate worksheet will print for each vendor. (8 Numeric or A)
Ending Vendor Number
Whatever was input as the beginning vendor appears as the default ending vendor. A carriage return accepts the default. This can be overridden, if desired. Input the ending Vendor number. If an ending vendor number is input that is less than the beginning, the prompt Beginning Vendor Number Is Greater Than Ending appears. The cursor returns for re-input. (8 Numeric)
Enter Data (Contd)
Beginning Product Class Or A'll
Input a specific product class or a beginning range or an A for all. Every item in the system is assigned to a product class. The ability to specify product classes will allow the worksheet to be more item specific. (4 Numeric or A)
Ending Product Class
Whatever was input as the beginning product class appears as the default ending product class. A carriage return accepts the default. This can be overridden if desired. Input the ending product class number. If an ending product class number is input that is less than the beginning, the prompt Beginning Product Class Is Greater Than Ending appears. The cursor returns for re-input. (4 Numeric)
Beginning Warehouse Number Or A'll
Ending Warehouse Number
Whatever was input as the beginning warehouse appears as the default ending warehouse. A carriage return accepts the default. Input the ending warehouse number. If an ending warehouse number is input that is less than the beginning, the prompt Beginning Warehouse Is Greater Than Ending appears. The cursor returns for re-input. (1-9999)
Enter Data (Contd)
Enter One Warehouse The Items Will Be Received Into Or Indiv. Warehouses
When the PO Worksheet is generated into an actual Purchase Order the on order amount will be updated for each item that needs to be ordered. The warehouse that is input at this prompt will determine which warehouse will be updated with the on order amounts. This will then flow through to when the items are received into stock. When the worksheet is run to stock only one warehouse, the cursor will not stop at the above prompt. The receiving warehouse will automatically be the warehouse that is being stocked and updated with the on order amounts.
The above prompt offers two options, when ordering for more than one warehouse. This occurs when all warehouses or a range is input. If you want to receive all items into one warehouse and then transfer the items into the individual warehouses, enter the desired receiving warehouse number. When the purchase order is generated the inputted warehouse will have the on order amounts updated. The most common response will be warehouse 1 as all items are stocked in warehouse 1. The items are then received into warehouse 1 and inventory transfers are made into the other warehouses. One worksheet is created for each included vendor. Note, if an item is not stocked in the inputted receiving warehouse, when the batch PO is generated, an Item Warehouse File, will be automatically created.
If you want to directly receive the items into the individual warehouses, without having to do transfers, enter an I for individual warehouses. The program will then produce an individual worksheet for each individual warehouse that is in the designated range and needs items restocked. When the purchase order is generated, the on order will be updated in the individual warehouses. One worksheet is created for each included vendor and warehouse. Thus this creates more worksheets and purchase orders. Each worksheet will be generated into a separate purchase order. Even with only one vendor there will be a separate worksheet for each included individual warehouse for the vendor. As an example, vendor 45 is being stocked in warehouse 1 and 10. Thus there will be a worksheet for vendor 45, warehouse 1, and another for vendor 45, warehouse 10. The print and process time will be greater when using the individual option. However, there will be no need to do inventory transfers once the items are received. You also wont have to run the program multiple times, once for each different receiving warehouse. (1-9999 or I)
Enter Data (Contd)
Also note, that the branch number that is stored in the selected receiving warehouse is written to the batch PO File and is used to determine which General Ledger account number is stored in the Batch File and than written to the PO Line Item File when the purchase order is generated. The G/L account is used to clear the A/P invoice.
S'tock, N'on-Stock, Or A'll Items
Input a S to print only items that are designated in the Item and Item Warehouse File as a stock item. Input N to print only items that have been designated a non-stock item in the Item and Item Warehouse File. Input an A to print both stock and non-stock items. The item must reach its reorder point or have a negative on hand in all cases. Note, if the item warehouse file is blank for the non-stock indicator, the program will assume a no for non-stock. Items marked as dead stock are never included. (1 Alphanumeric)
Spare P'arts, S'erialized, R'est Of Inventory Or A'll Items
To only include parts on the worksheet input a P. The worksheet will search the Item File and look for a Y for yes in field 41, Spare Part. To only print serialized items input a S. The Worksheet will search the Item File and look for a Y for yes in field 37, Serial No. The Item File can be viewed in Item File Maintenance. Input a R to include all other items that do not have a Yes in the above fields. This would normally be supplies. This will allow a separate worksheet for different product types. If all item types are desired on one worksheet input an A for all. (1 Alphanumeric)
Include Items With A Quantity Needed Equal To MIN? (Y/N)
If you want items to appear on the worksheet, when their available amounts are equal to the defined minimum for the warehouse, enter a Y for yes. This means an item needs to be restocked when the quantity available is equal to the defined minimum. If you want items to appear on the worksheet, when their available amounts are less than the defined minimum for the warehouse, enter an N for no. This means an item needs to be restocked when the available amount is one less than the defined minimum. Items with a negative available amount will print regardless to the response to the above prompt. The available amount is determined by (On hand + On Order) - (Amount Allocated + Amount Back Ordered). This is determined per included warehouse. The amount allocated and back ordered are amounts updated through the Customer Order Entry module.
Enter Data (Contd)
Print Current Inventory Status (Y/N)
Input a Y for yes to include on the worksheet the current inventory status of all of the items that need to be ordered. All of the quantities relate to the Item Files UM and PM. Input an N for no to not print inventory status on the worksheet. With a Y for yes the following additional information will print on the worksheet.
OH This is the current on hand amount. Any broken packs (Units) will not be included.
OO This is the current on order amount.
AL This is the current amount allocated. This is the amount on any open orders to customers through the Order Entry package.
BO This is the amount that is on back order to customers. These are the orders entered through the Order Entry package.
AV This is the quantity available of the item. This is the result of the allocated, on hand, and back order quantities.
MIN This is the minimum amount that is desired to keep in stock. For warehouse 1 this is stored in the Item File. For any other warehouse this is stored in the Item Warehouse File.
MAX This is the maximum amount that is desired in stock. For warehouse 1 this is stored in the Item File. For any other warehouse this is stored in the Item Warehouse File.
EOQ This is the economical order amount that can be stored per item. This is not used in any calculation but can be used as an informational tool. This is field 30 in Item File Maintenance for warehouse 1. This is field 4 in the Warehouse Item File for other warehouses. If a special amount has to be ordered store it here as a reminder.
Enter Data (Contd)
Beginning Warehouse - A'll
If a Y for yes is input at the prompt Print Current Inventory Status the cursor will stop at warehouse. This will allow the user to input which warehouse to print the inventory status of items. Note, only items in warehouses that are included on the report to be restocked will have the inventory status included. As an example, if you are stocking warehouse 10 to 14 and you input warehouse 1 to the above prompt, no inventory status will be printed. An A for all will include the inventory status of items for all warehouses that are included on the report and need items reordered. (1-9999 Or A)
Ending Warehouse
Whatever was input as the beginning warehouse appears as the default ending. A carriage return accepts the default. This can be overridden if desired. Input an ending warehouse number. If an ending warehouse number is input that is less than the beginning, the prompt Beginning Warehouse Is Greater Than Ending appears. The cursor returns for re-input. (1-9999)
Prepare Final Purchase Order Worksheet (Y/N)
The PO Worksheet can be run numerous times. Just keep entering a N for no and no batch is created. Once the purchasing agent has decided it is time to create a purchase order from the worksheet the first step must be performed. This is to input a Y for yes at the above prompt. When a Y for yes is input a temporary file called a Batch File is created. A batch purchase order number is assigned. The date, time, the user's initials, and the port number of the task the batch PO was created on, are stored in this file. The system will allow only one group of batch POs per port. Thus there could be other batch PO's on the system but they are assigned to another port. The purpose of the batch system is to allow more than one PO Worksheet at a time but to use up as little internal space as possible on the system. This will also prevent someone from creating worksheets and never generating them allowing them to eat up disk space. Note, that using flip screen or multiple tasks on windows creates 1 port or task per flip screen. Thus if you have three flip screens and created a final worksheet on each flip screen, three batch purchase orders, one for each port, is created. So if you only want one batch purchase order at a time, try to always use the same task and port when running the worksheet.
Enter Data (Contd)
The final PO Worksheet prints with the batch PO number assigned. The batch PO is now ready to edit. Any additions, changes or deletions could now be performed. This is done in the program Generate PO From Worksheet. Be sure and keep the hard copy of the final Batch Worksheet, as a reference to use when accessing the batch POs in Generate PO From Worksheet.
The final worksheet does not update any files until it is generated from a batch purchase order to a regular purchase order. This occurs in the program Generate PO From Worksheet.
Comment
When a Y for yes is input, at the Prepare Final Worksheet prompt, an input for a comment will appear. This will help you identify which batch PO this is when the PO is generated. You may want to write a descriptive account such as Parts Order and the vendor number. (25 Alphanumeric)
Every time the PO Worksheet is run and a Y for yes is input at final worksheet, the existing batch for that task is deleted and replaced by the new one. Thus if one was created on your task and you did not want it, the next time the final worksheet is run the previous one would be deleted. Note, when a batch purchase order is generated that also deletes the batch purchase order
The following prompt appears when a Y for yes is entered to create a final worksheet and a batch purchase order already exists for that task.
Enter Data (Contd)
Batch For This Terminal Already Exists - Do You Wish To Delete It? (Y/N)
7/17/95 Create PO Worksheet 15:26
Beginning Vendor Number Or A'll 21
Ending Vendor Number 21
Beginning Product Class Or A'll A
Ending Product Class
Beginning Warehouse Number Or A'll A
Ending Warehouse Number
Enter One Warehouse The Items Will Be Received Into Or I'ndiv. Warehouses 1
S'tock, N'on-Stock, Or A'll Items A
Spare P'arts, S'erialized, R'est Of Inventory Or A'll Items A
Include Items With A Quantity Needed Equal To MIN? (Y/N) N
Print Current Inventory Status (Y/N) Y
Beginning Warehouse - A'll A
Ending Warehouse
Prepare Final Purchase Order Worksheet (Y/N) Y
Batch For This Terminal Already Exists - Do You Wish To Delete It? (Y/N) .
Run On 7/17/95 By Comment: VEN 21 ALL ITEMS
The previous batch date, initials and comment will be displayed on the screen. If a N for no is input the previous batch remains and the program is exited. A new one is not created. If a Y for yes is input the previous batch that is assigned to that port is deleted and a new one created. The previous batch is deleted even if it has not been generated into a purchase order. It will be replaced by the new batch Purchase Order Worksheet.
The system date and time the final worksheet was run will print on each page. The port number and comment entered will also print on each page. The PO Worksheet will print the following information for each vendor selected. When stocking more than one warehouse and using the individual receiving warehouse option, the information is repeated per vendor, per warehouse.
Vendor Name, Number, Address, Contact Name and Phone Number
The above information will be pulled from the Vendor File and will print at the top of each page.
Item Number
The item that needs to be ordered. This is from the Item File.
Item Description
The full item description from the Item File.
Vendor Item Number
If there is a Vendor Item File the Vendor Item Number will print. If there is no Vendor Item File the item number will print.
Lead Time
Lead time will only print if there is a Vendor Item File. This is updated in PO Receipts.
WH
This is the number of the warehouse that needs the item restocked.
UM
This is the unit of measure. If there is a Vendor Item File that will be used first. If there is no Vendor Item File field 24 in the Item File will be used. If that is blank, field 4 in the Item File will be used. This can be viewed in Item File Maintenance.
Report Results (Contd)
PM
This is the pack multiple which defines the quantity in one unit of measure. If there is a Vendor Item File that will be used first. If there is no Vendor Item File field 25 in the Item File will be used. If that is blank, field 7 will be used. This can be viewed in Item File Maintenance.
QTY
This is the quantity that needs to be ordered to stock up to the maximum or to zero out a negative quantity. This will coincide with the UM and PM that printed on the same line.
Cost
This is the cost of 1 Unit of Measure. If there is a Vendor Item File the cost stored in the Vendor Item File prints. If there is no Vendor Item File the last cost from the Item File is used. The four decimal cost is printed.
Alternate Ext. Cost
This is the calculated extended cost of the last cost that is stored in the Vendor Item File for the included alternate vendors.
Ext. Cost
This is the extended cost for the items that are to be ordered from the primary vendor. This is QTY times Cost. This is always rounded to two decimals.
Total
A total QTY ordered and Ext. Cost for each item in each included warehouse.
Totals For Vendor
The vendor number is printed followed by the total Ext. Cost of all items for each primary vendor. If the individual warehouse option is used, the warehouse number is printed.
Report Results (Contd)
If there are any alternate vendors, defined in the Vendor Item File for an item, they are all listed. The following information is included per item per alternate vendor.
Vendor:
The vendor number.
Vendor Item Number
The Vendor Item Number found in the Vendor Item File.
Lead Time
The lead time stored in the Vendor Item File. This is updated in PO Receipts.
UM
This is the unit of measure defined in the Vendor Item File.
PM
This is the pack multiple defined in the Vendor Item File.
QTY
This is the quantity that needs to be ordered to stock up to the maximum or to zero out a negative quantity. This coincides with the UM and PM that printed on the same line. Note, if more than one warehouse needs to be restocked the quantity ordered is the combined quantity for all of the warehouses.
Cost
This is the cost of 1 Unit of Measure defined in the Vendor Item File. The four decimal cost is printed.
Alternate Ext. Cost
This is the calculated extended cost of the last cost that is stored in the Vendor Item File. This is Cost times Qty. This is always rounded to two decimals.
Additional Notes
To recap the procedure:
1. Run Create PO Worksheet inputting a N for no at prepare final worksheet. No batch is created. The printout of the worksheet allows you to review it to be sure that the correct parameters were input.
2. When ready to create a Batch PO Worksheet rerun it and input a Y for yes to prepare a final worksheet. Batch PO numbers will be assigned. A batch PO is created for each included vendor. When using the individual warehouse option a batch PO is created for each included vendor and warehouse. Only one group of batch POs will be allowed per task or port. No updating of quantities or Purchase Order Files occur.
3. Go into the program Generate PO From Worksheet to edit the batch and eventually generate an actual purchase order. See Section II, page 111 for details on the Generate PO From Worksheet program.
Items print and are assigned, in the Batch File and on the report, to their assigned primary vendor. The primary vendor is defined in the Item File, field 23 in Item File Maintenance. Alternate vendors will only print if there is a Vendor Item File assigned to the item and the item has an included vendor as the primary vendor. Alternate vendors print with an ***. Any alternate vendor will not be assigned a batch purchase order. The alternate vendors information is included on the report but is not reflected in the batch purchase order that is created. After studying the report, if you decide to order the item from an alternate vendor, you would need to delete the item from the Batch Purchase Order for the primary vendor. This would be done in the program Generate POs From Worksheet. You could than create a purchase order, in the program Enter Direct POs, for the alternate vendor. Or if a batch purchase order exists for the alternate vendor you could add the item to that batch purchase order.
,
The program will want to stock an item when the On Order plus On Hand, minus the Allocated minus the Back Ordered amounts, are equal to or are one less than the defined minimum amount. The equal to or less than minimum is an option when running the program. If an item has no defined minimum and the combined On Order, On Hand, Allocated, and Back Ordered amounts equal a quantity less than 0, the item will also be restocked.
When calculating the quantity to be ordered the worksheet will check the item's pack multiple and unit of measure. If there is a Vendor Item File that will be used first. If there is no Vendor Item File fields 24 and 25 in the Item File will be used. If these fields are blank fields 4 and 7 in the Item File will be used. The fields can be viewed in Item File Maintenance. The program will want to stock the item up to the defined maximum amount defined for the warehouse that is being stocked. Any negative quantity will also be added into the amount needed to be ordered. An item that has reached a negative quantity and does not have a defined maximum will have an order quantity necessary to equal 0, negating the negative amount.
There should not be any items that do not have pack multiples in the Item File or Vendor Item File, but if there is an item that is not assigned a pack multiple and the item needs to be restocked, the program will assume the pack multiple is 1.
Report Results (Contd)
The information that is written into the Batch Purchase Order Header can be changed in the program Generate PO From Worksheet. The information written into the header are the defaults used in Enter Direct PO The order type is set at order type 1. The ship via is set at ship via 1. The delivery instructions are set at 1, Dock Delivery. Prepaid purchase order is set at no. The bill-to address, contact name and phone number is the data stored in the Purchase Order Control File. The ship-to address, contact name, and phone number is the data stored in the Purchase Order Control File, unless the warehouse the items are to be received into has a ship-to address defined in the Warehouse File. If a ship-to address is defined in the Warehouse File, that is the data that will be the ship-to address on the batch purchase order. The branch number, assigned in the Warehouse File, to the receiving warehouse is the branch assigned to the Batch PO header. See Section IV, page 1320 for details on the set up of the Warehouse File. The order, ship and due date will be the transaction date that was input at the menu prompt when the Batch POs were created.
The same codes, dates and branch number that are written to the PO header are also written to the PO line items if applicable.
Report Results (Contd)
Following is the formula that is used in the calculation of the amount to be ordered. For the primary vendors each included warehouse is calculated separately.
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
Max This is the defined maximum amount stored in the Item or Item Warehouse Files.
On Hand This is the current on hand amount for the item stored in the Item or Item Warehouse Files.
On Order This is the current on order amount for the item stored in the Item Or Item Warehouse File.
BO This is the current amount backordered for the item stored in the Item Or Item Warehouse File. This is the amount backordered through the Customer Order Entry module.
Alloc This is the current amount allocated for the item stored in the Item Or Item Warehouse File. This is the amount allocated through the Customer Order Entry module.
Note, the amounts in the calculation for On Order, On Hand, Alloc and BO do not include broken pack quantities. As an example, the Item Files pack multiple is 4. The item has an on hand quantity of 4 full packs and 1 unit. The 4 full packs is the quantity that will be used for the current on hand quantity.
Report Results (Contd)
See page 87 for an example of a PO Worksheet and the items that need to be ordered. This is an example of the worksheet before the Final PO Worksheet or Batch File is created. Thus there are no assigned batch numbers. The worksheet was run for two vendors, all items, all product classes, and all warehouses. The option to order items that have reached the defined minimum was selected. The inventory status is printed for all of the included warehouses. All items will be received into one warehouse which is warehouse 1. Note, that there is one worksheet for each vendor.
The calculation made for the quantity to be ordered for each included item is as follows. The first items are assigned to primary vendor 105. Note, if the ending calculation is greater than 0 but less than 1 the program will always round up to 1.
ITEM-G The Item Files PM is 2. The Vendor Item Files PM is 1. The cost is from the Vendor Item File.
Warehouse 1
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
ITEM-G SUPPLY 45-P567 1 EA 1 14 7.5000 105.00
BIN= OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 5 MAX= 7 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[7 - (0)] = 7, 7 X 2 = 14/1 = 14
Warehouse 96
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
ITEM-G SUPPLY 45-P567 96 EA 1 14 7.5000 105.00
BIN=BIN 96 OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 5 MAX= 7 EOQ= 0
[7 - (0)] = 7, 7 X 2 = 14/1 = 14
Report Results (Contd)
ITEM65A The Item Files PM is 4. The Vendor Item Files PM is 10.
Warehouse 1
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
ITEM65A SUPPLY ITEM65A 10 1 CS 10 25 14.5000 362.50
BIN=ROW34 OH= 2 OO= 5 AL= 19 BO= 0 AV= -17 MIN= 30 MAX= 50 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[50 - (-12)] = 62, 62 X 4 = 248/10 = 24.8 = 25
Warehouse 2
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
ITEM65A SUPPLY ITEM65A 10 2 CS 10 20 14.5000 290.00
BIN=BIN47 OH= 1 OO= 0 AL= 0 BO= 0 AV= 1 MIN= 30 MAX= 50 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[50 - (1)] = 49, 49 X 4 = 196/10 = 19.6 = 20.
Alternate Vendor 45 The alternate vendors order quantity will be combined for all of the included warehouses. The alternates PM is 1.
ALTERNATE COST
LEAD TIME UM PM QTY EXT.COST
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 444 1.5500 688.20
VENDOR NAME: LANIER WORLDWIDE
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[100 - (-11)] = 111, 111 X 4 = 444/1 = 444 .
Report Results (Contd)
TONER The Item Files PM is 4. The Vendor Item Files PM is 4.
Warehouse 1
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
TONER BLACK TONER 45-235-6543 3 1 CT 4 57 36.0000 2052.00
BIN=A46B12 OH= 24 OO= 2 AL= 8 BO= 25 AV= -9 MIN= 30 MAX= 50 EOQ= 30
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[50 - (-7)] = 57, 57 X 4 = 228/4 = 57 .
Warehouse 62
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
TONER BLACK TONER 45-235-6543 3 62 CT 4 5 36.0000 180.00
BIN= OH= 0 OO= 0 AL= 1 BO= 0 AV= -1 MIN= 3 MAX= 4 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[4 - (-1)] = 5, 5 X 4 = 20/4 = 5 .
Alternate Vendor 1 The alternate vendors order quantity will be combined for all of the included warehouses. The alternates PM is 1.
ALTERNATE COST
LEAD TIME UM PM QTY EXT.COST
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 248 10.0000 2480.00
VENDOR NAME: OFFICE PRODUCTS INC
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[54 - (-8)] = 62, 62 X 4 = 248/1 = 248.
Report Results (Contd)
TONER
Alternate Vendor 10 The alternate vendors order quantity will be combined for all of the included warehouses. The alternates PM is 6.
ALTERNATE COST
LEAD TIME UM PM QTY EXT.COST
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 42 60.0000 2520.00
VENDOR NAME: MINOLTA
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[54 - (-8)] = 62 - 62 X 4 = 248/6 = 41.33 = 42 .
Alternate Vendor 100 The alternate vendors order quantity will be combined for all of the included warehouses. The alternates PM is 4.
ALTERNATE COST
LEAD TIME UM PM QTY EXT.COST
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 62 26.7500 1658.50
VENDOR NAME: OTTO CORP.
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[54 - (-8)] = 62 - 62 X 4 = 248/4 = 62.
Note, on the sample report the different costs for the two vendors with the same PM, thus the different extended costs.
Report Results (Contd)
The next group of items are assigned to primary vendor 106.
111-222-3333 The Item Files PM is 1. There is no Vendor Item File. This is an example of an item that has no defined min or max but has a negative amount.
Warehouse 2
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
111-222-3333 PART 111-222-3333 2 EA 1 2 25.0000 50.00
BIN= OH= -2 OO= 0 AL= 0 BO= 0 AV= -2 MIN= 0 MAX= 0 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[0 - (-2)] = 2, 2 X 1 = 2/1 = 2.
45-111-34-2222 The Item Files PM is 1. There is no Vendor Item File. Note that this items available amount equals the defined minimum. This is an example of an item that would not be included on the report if the option to only include items that have a quantity that is less than the defined minimum was selected.
Warehouse 1
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
45-111-34-2222 PART 45-111-34-2222 4 1 EA 1 4 12.0000 48.00
BIN= OH= 3 OO= 0 AL= 0 BO= 0 AV= 3 MIN= 3 MAX= 7 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[7 - (3)] = 4, 4 X 1 = 4/1 = 4.
Report Results (Contd)
946-181 The Item Files PM is 1. The Vendor Item Files PM is 4. Note, that in this example only 99 are needed. But the vendor sells them in packs of 4 thus you will actually receive 100. The program will order more rather than less. If only 24 were ordered, the amount received would be 96 which is less than the needed 99.
Warehouse 1
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
946-181 TONER D4598-34 5 1 CS 4 25 6.4800 162.00
BIN=8400 OH= 29 OO= 4 AL= 84 BO= 18 AV= -73 MIN= 15 MAX= 30 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[30 - (-69)] = 99, 99 X 1 = 99/4 = 24.75 = 25.
Warehouse 2
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
946-181 TONER D4598-34 5 2 CS 4 4 6.4800 25.92
BIN= OH= 0 OO= 0 AL= 6 BO= 0 AV= -6 MIN= 4 MAX= 10 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[10 - (-6)] = 16, 16 X 1 = 16/4 = 4.
Alternate Vendor 10 The alternate vendors order quantity will be combined for all of the included warehouses. The alternates PM is 4.
ALTERNATE COST
LEAD TIME UM PM QTY EXT.COST
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 29 8.0000 232.00
VENDOR NAME: MINOLTA
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[40 - (-75)] = 115, 115 X 1 = 115/4 = 28.75 = 29.
Report Results (Contd)
ITEM-M The Item Files PM is 1. The Vendor Item Files PM is 100.
Warehouse 1
VENDOR ITEM LEAD COST
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST
ITEM-M ITEM WENT THRU ITEM MERGE 34-E2-456 1 CS 100 1 630.0000 630.00
BIN=WH 1 OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 1 MAX= 1 EOQ= 0
[(Max - (On Hand + On Order - BO - Alloc)] X Item Files PM/Vendor PM
[1 - (0)] = 1, 1 X 1 = 1/100 = .01 = 1. Note, anything greater than 0 will round up to 1.
Report Results (Contd)
Following is the sample report that corresponds with the preceding calculations.
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 1
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN:Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO WAREHOUSE 1
RUN ON 8/02/95 BY AT 11:06 ON PORT NUMBER 28 - COMMENT:
BATCH PO NUMBER: VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM-G SUPPLY 45-P567 1 EA 1 14 7.5000 105.00
BIN= OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 5 MAX= 7 EOQ= 0
ITEM-G SUPPLY 45-P567 96 EA 1 14 7.5000 105.00
BIN=BIN 96 OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 5 MAX= 7 EOQ= 0
------ ------------
* TOTAL * 28 210.00
---------------------------------------------------------------------------------------------------------------------------------
ITEM65A SUPPLY ITEM65A 10 1 CS 10 25 14.5000 362.50
BIN=ROW34 OH= 2 OO= 5 AL= 19 BO= 0 AV= -17 MIN= 30 MAX= 50 EOQ= 0
ITEM65A SUPPLY ITEM65A 10 2 CS 10 20 14.5000 290.00
BIN=BIN47 OH= 1 OO= 0 AL= 0 BO= 0 AV= 1 MIN= 30 MAX= 50 EOQ= 0
------ ------------
* TOTAL * 45 652.50
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 444 1.5500 688.20
VENDOR NAME: LANIER WORLDWIDE
------------------------------------------------------------------------------------------------------------ ----------------
TONER BLACK TONER 45-235-6543 3 1 CT 4 57 36.0000 2052.00
BIN=A46B12 OH= 24 OO= 2 AL= 8 BO= 25 AV= -9 MIN= 30 MAX= 50 EOQ= 30
TONER BLACK TONER 45-235-6543 3 62 CT 4 5 36.0000 180.00
BIN= OH= 0 OO= 0 AL= 1 BO= 0 AV= -1 MIN= 3 MAX= 4 EOQ= 0
------ ------------
* TOTAL * 62 2232.00
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 248 10.0000 2480.00
VENDOR NAME: OFFICE PRODUCTS INC
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 42 60.0000 2520.00
VENDOR NAME: MINOLTA
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 62 26.7500 1658.50
VENDOR NAME: OTTO CORP.
---------------------------------------------------------------------------------------------------------------- --------
TOTALS FOR VENDOR: 105 3094.50
Report Results (Contd)
Sample Report (Contd)
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 2
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO WAREHOUSE 1
RUN ON 8/02/95 BY AT 11:06 ON PORT NUMBER 28 - COMMENT:
BATCH PO NUMBER: VENDOR: 106 90056 NORTH LANE CONTACT: MARK TANNER
OFFICE PRODUCTS WORLDWIDE PO BOX 87543 612-978-3333
MINNEAPOLIS MN 54377111
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
111-222-3333 PART 111-222-3333 2 EA 1 2 25.0000 50.00
BIN= OH= -2 OO= 0 AL= 0 BO= 0 AV= -2 MIN= 0 MAX= 0 EOQ= 0
------ --- ---------
* TOTAL * 2 50.00
--------------------------------------------------------------------------------------------------------------- -------------
45-111-34-2222 PART 45-111-34-2222 4 1 EA 1 4 12.0000 48.00
BIN= OH= 3 OO= 0 AL= 0 BO= 0 AV= 3 MIN= 3 MAX= 7 EOQ= 0
------ ---- --------
* TOTAL * 4 48.00
----------------------------------------------------------------------------------------------------------------- -----------
946-181 TONER D4598-34 5 1 CS 4 25 6.4800 162.00
BIN=8400 OH= 29 OO= 4 AL= 84 BO= 18 AV= -73 MIN= 15 MAX= 30 EOQ= 0
946-181 TONER D4598-34 5 2 CS 4 4 6.4800 25.92
BIN= OH= 0 OO= 0 AL= 6 BO= 0 AV= -6 MIN= 4 MAX= 10 EOQ= 0
------ ------------
* TOTAL * 29 187.92
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 29 8.0000 232.00
VENDOR NAME: MINOLTA
--------------------------------------------------------------------------------------------------------------- -------------
ITEM-M ITEM WENT THRU ITEM MERGE 34-E2-456 1 CS 100 1 630.0000 630.00
BIN=WH 1 OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 1 MAX= 1 EOQ= 0
------ ------------
* TOTAL * 1 630.00
------------------------------------------------------------------------------------------------------------- ---------------
TOTALS FOR VENDOR: 106 915.92
********** END OF REPORT **********
Report Results (Contd)
On page 90 is another report sample. This sample is run with the option to receive the items into the individual warehouses that are being stocked. In the first report sample on page 87, even though the ordered quantities are calculated for various individual warehouses, when the batch purchases orders are generated the on order amounts will all be updated into warehouse 1. When the items are received into stock, warehouse overrides or inventory transfers from warehouse 1 will have to be made. However, on the items on the second sample worksheet, run for the individual warehouses, when the item is received into stock the default warehouse will be the warehouse that needs to be restocked. When the batch purchase orders are generated each individual warehouse that is included to be restocked will have the on order updated.
All of the other program options are the same on both sample reports. Thus the calculations for the amounts to be ordered are the same. By comparing the two sample reports you will see that the individual warehouse sample has more individual batch purchase orders. There is one for each vendor, each different warehouse.
Report Results (Contd)
Following is the report sample using the individual warehouse option.
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 1
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:15 ON PORT NUMBER 46 - COMMENT:
BATCH PO NUMBER: VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM-G SUPPLY 45-P567 1 EA 1 14 7.5000 105.00
BIN= OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 5 MAX= 7 EOQ= 0
--------------------------------------------------------------------------------------------------------------------- -------
ITEM65A SUPPLY ITEM65A 10 1 CS 10 25 14.5000 362.50
BIN=ROW34 OH= 2 OO= 5 AL= 19 BO= 0 AV= -17 MIN= 30 MAX= 50 EOQ= 0
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 248 1.5500 384.40
VENDOR NAME: LANIER WORLDWIDE
---------------------------------------------------------------------------------------------------------------------------------
TONER BLACK TONER 45-235-6543 3 1 CT 4 57 36.0000 2052.00
BIN=A46B12 OH= 24 OO= 2 AL= 8 BO= 25 AV= -9 MIN= 30 MAX= 50 EOQ= 30
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 228 10.0000 2280.00
VENDOR NAME: OFFICE PRODUCTS INC
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 38 60.0000 2280.00
VENDOR NAME: MINOLTA
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 57 26.7500 1524.75
VENDOR NAME: OTTO CORP.
----------------------------------------------------------------------------------------------------------------------------
TOTALS FOR VENDOR: 105 2519.50
WAREHOUSE NUMBER: 1
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 2
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:15 ON PORT NUMBER 46 - COMMENT:
BATCH PO NUMBER: VENDOR: 106 90056 NORTH LANE CONTACT: MARK TANNER
OFFICE PRODUCTS WORLDWIDE PO BOX 87543 612-978-3333
MINNEAPOLIS MN 54377111
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
45-111-34-2222 PART 45-111-34-2222 4 1 EA 1 4 12.0000 48.00
BIN= OH= 3 OO= 0 AL= 0 BO= 0 AV= 3 MIN= 3 MAX= 7 EOQ= 0
----------------------------------------------------------------------------------------------------------------- -----------
946-181 TONER D4598-34 5 1 CS 4 25 6.4800 162.00
BIN=8400 OH= 29 OO= 4 AL= 84 BO= 18 AV= -73 MIN= 15 MAX= 30 EOQ= 0
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 25 8.0000 200.00
VENDOR NAME: MINOLTA
-------------------------------------------------------------------------------------------------------------- --------------
ITEM-M ITEM WENT THRU ITEM MERGE 34-E2-456 1 CS 100 1 630.0000 630.00
BIN=WH 1 OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 1 MAX= 1 EOQ= 0
----------------------------------------------------------------------------------------------------------------- -----------
TOTALS FOR VENDOR: 106 840.00
WAREHOUSE NUMBER: 1
Report Results (Contd)
Sample Report (Contd)
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 3
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:15 ON PORT NUMBER 46 - COMMENT:
BATCH PO NUMBER: VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM65A SUPPLY ITEM65A 10 2 CS 10 20 14.5000 290.00
BIN=BIN47 OH= 1 OO= 0 AL= 0 BO= 0 AV= 1 MIN= 30 MAX= 50 EOQ= 0
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 196 1.5500 303.80
VENDOR NAME: LANIER WORLDWIDE
-------------------------------------------------------------------------------------------------------------- --------------
TOTALS FOR VENDOR: 105 290.00
WAREHOUSE NUMBER: 2
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 4
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:15 ON PORT NUMBER 46 - COMMENT:
BATCH PO NUMBER: VENDOR: 106 90056 NORTH LANE CONTACT: MARK TANNER
OFFICE PRODUCTS WORLDWIDE PO BOX 87543 612-978-3333
MINNEAPOLIS MN 54377111
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
111-222-3333 PART 111-222-3333 2 EA 1 2 25.0000 50.00
BIN= OH= -2 OO= 0 AL= 0 BO= 0 AV= -2 MIN= 0 MAX= 0 EOQ= 0
-------------------------------------------------------------------------------------------------------------- --------------
946-181 TONER D4598-34 5 2 CS 4 4 6.4800 25.92
BIN= OH= 0 OO= 0 AL= 6 BO= 0 AV= -6 MIN= 4 MAX= 10 EOQ= 0
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 4 8.0000 32.00
VENDOR NAME: MINOLTA
---------------------------------------------------------------------------------------------------------------- ------------
TOTALS FOR VENDOR: 106 75.92
WAREHOUSE NUMBER: 2
Report Results (Contd)
Sample Report (Contd)
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 5
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:15 ON PORT NUMBER 46 - COMMENT:
BATCH PO NUMBER: VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
TONER BLACK TONER 45-235-6543 3 62 CT 4 5 36.0000 180.00
BIN= OH= 0 OO= 0 AL= 1 BO= 0 AV= -1 MIN= 3 MAX= 4 EOQ= 0
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 20 10.0000 200.00
VENDOR NAME: OFFICE PRODUCTS INC
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 4 60.0000 240.00
VENDOR NAME: MINOLTA
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 5 26.7500 133.75
VENDOR NAME: OTTO CORP.
-------------------------------------------------------------------------------------------------------- --------------------
TOTALS FOR VENDOR: 105 180.00
WAREHOUSE NUMBER: 62
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 6
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN:Y
ALL ITEMS ALL ITEMS WILL NOT PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:15 ON PORT NUMBER 46 - COMMENT:
BATCH PO NUMBER: VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM-G SUPPLY 45-P567 96 EA 1 14 7.5000 105.00
BIN=BIN 96 OH= 0 OO= 0 AL= 0 BO= 0 AV= 0 MIN= 5 MAX= 7 EOQ= 0
------------------------------------------------------------------------------------------------------------------ ----------
TOTALS FOR VENDOR: 105 105.00
WAREHOUSE NUMBER: 96
********** END OF REPORT **********
Report Results (Contd)
The following sample report was run for the same options as the first included sample report. The difference is this is the final worksheet. Note the assigned batch numbers. A Batch Purchase Order was created for each vendor. Also note, that the inventory status was not included on the printout.
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 1
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO WAREHOUSE 1
RUN ON 8/02/95 BY AT 11:20 ON PORT NUMBER 28 - COMMENT: VEN 105/106 ALL ITEMS
BATCH PO NUMBER: 4041 VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM-G SUPPLY 45-P567 1 EA 1 14 7.5000 105.00
ITEM-G SUPPLY 45-P567 96 EA 1 14 7.5000 105.00
------ ------------
* TOTAL * 28 210.00
-------------------------------------------------------------------------------------------------------------- ------------
ITEM65A SUPPLY ITEM65A 10 1 CS 10 25 14.5000 362.50
ITEM65A SUPPLY ITEM65A 10 2 CS 10 20 14.5000 290.00
------ - -----------
* TOTAL * 45 652.50
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 444 1.5500 688.20
VENDOR NAME: LANIER WORLDWIDE
---------------------------------------------------------------------------------------------------------- -----------------
TONER BLACK TONER 45-235-6543 3 1 CT 4 57 36.0000 2052.00
TONER BLACK TONER 45-235-6543 3 62 CT 4 5 36.0000 180.00
------ -- ----------
* TOTAL * 62 2232.00
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 248 10.0000 2480.00
VENDOR NAME: OFFICE PRODUCTS INC
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 42 60.0000 2520.00
VENDOR NAME: MINOLTA
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 62 26.7500 1658.50
VENDOR NAME: OTTO CORP.
------------------------------------------------------------------------------------------------------------------------
TOTALS FOR VENDOR: 105 3094.50
Report Results (Contd)
Sample Report (Contd)
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 2
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO WAREHOUSE 1
RUN ON 8/02/95 BY AT 11:20 ON PORT NUMBER 28 - COMMENT: VEN 105/106 ALL ITEMS
BATCH PO NUMBER: 4042 VENDOR: 106 90056 NORTH LANE CONTACT: MARK TANNER
OFFICE PRODUCTS WORLDWIDE PO BOX 87543 612-978-3333
MINNEAPOLIS MN 54377111
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
111-222-3333 PART 111-222-3333 2 EA 1 2 25.0000 50.00
------ ------------
* TOTAL * 2 50.00
----------------------------------------------------------------------------------------------------------------------------------
45-111-34-2222 PART 45-111-34-2222 4 1 EA 1 4 12.0000 48.00
------ - -----------
* TOTAL * 4 48.00
---------------------------------------------------------------------------------------------------------------- ----------
946-181 TONER D4598-34 5 1 CS 4 25 6.4800 162.00
946-181 TONER D4598-34 5 2 CS 4 4 6.4800 25.92
------ --- ---------
* TOTAL * 29 187.92
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 29 8.0000 232.00
VENDOR NAME: MINOLTA
--------------------------------------------------------------------------------------------------------------- -----------
ITEM-M ITEM WENT THRU ITEM MERGE 34-E2-456 1 CS 100 1 630.0000 630.00
------ -- ----------
* TOTAL * 1 630.00
----------------------------------------------------------------------------------------------------------- ---------------
TOTALS FOR VENDOR: 106 915.92
********** END OF REPORT **********
Report Results (Contd)
The following sample report was run for the same options as the second included sample report. The difference is this is the final worksheet. Note, the assigned batch numbers. A Batch Purchase Order was created for each vendor and each individual warehouse that needs to be restocked. Also note, that the inventory status was not included on the printout.
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 1
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:22 ON PORT NUMBER 46 - COMMENT: VEN 105/106 ALL ITEMS IND
BATCH PO NUMBER: 4043 VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM-G SUPPLY 45-P567 1 EA 1 14 7.5000 105.00
---------------------------------------------------------------------------------------------------------------------------------
ITEM65A SUPPLY ITEM65A 10 1 CS 10 25 14.5000 362.50
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 248 1.5500 384.40
VENDOR NAME: LANIER WORLDWIDE
-------------------------------------------------------------------------------------------------------------- ------------
TONER BLACK TONER 45-235-6543 3 1 CT 4 57 36.0000 2052.00
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 228 10.0000 2280.00
VENDOR NAME: OFFICE PRODUCTS INC
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 38 60.0000 2280.00
VENDOR NAME: MINOLTA
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 57 26.7500 1524.75
VENDOR NAME: OTTO CORP.
---------------------------------------------------------------------------------------------------------------- -------------
TOTALS FOR VENDOR: 105 2519.50
WAREHOUSE NUMBER: 1
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 2
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:22 ON PORT NUMBER 46 - COMMENT: VEN 105/106 ALL ITEMS IND
BATCH PO NUMBER: 4044 VENDOR: 106 90056 NORTH LANE CONTACT: MARK TANNER
OFFICE PRODUCTS WORLDWIDE PO BOX 87543 612-978-3333
MINNEAPOLIS MN 54377111
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
45-111-34-2222 PART 45-111-34-2222 4 1 EA 1 4 12.0000 48.00
------------------------------------------------------------------------------------------------------------- -------------
946-181 TONER D4598-34 5 1 CS 4 25 6.4800 162.00
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 25 8.0000 200.00
VENDOR NAME: MINOLTA
--------------------------------------------------------------------------------------------------------- -----------------
ITEM-M ITEM WENT THRU ITEM MERGE 34-E2-456 1 CS 100 1 630.0000 630.00
---------------------------------------------------------------------------------------------------------------- ----------
TOTALS FOR VENDOR: 106 840.00
WAREHOUSE NUMBER: 1
Report Results (Contd)
Sample Report (Contd)
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 3
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:22 ON PORT NUMBER 46 - COMMENT: VEN 105/106 ALL ITEMS IND
BATCH PO NUMBER: 4045 VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM65A SUPPLY ITEM65A 10 2 CS 10 20 14.5000 290.00
*** VENDOR: 45 VENDOR ITEM NO.: ITEM65A 0 EA 1 196 1.5500 303.80
VENDOR NAME: LANIER WORLDWIDE
---------------------------------------------------------------------------------------------------------------------------------
TOTALS FOR VENDOR: 105 290.00
WAREHOUSE NUMBER: 2
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 4
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:22 ON PORT NUMBER 46 - COMMENT: VEN 105/106 ALL ITEMS IND
BATCH PO NUMBER: 4046 VENDOR: 106 90056 NORTH LANE CONTACT: MARK TANNER
OFFICE PRODUCTS WORLDWIDE PO BOX 87543 612-978-3333
MINNEAPOLIS MN 54377111
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
111-222-3333 PART 111-222-3333 2 EA 1 2 25.0000 50.00
---------------------------------------------------------------------------------------------------------------------------------
946-181 TONER D4598-34 5 2 CS 4 4 6.4800 25.92
*** VENDOR: 10 VENDOR ITEM NO.: H45923 0 CS 4 4 8.0000 32.00
VENDOR NAME: MINOLTA
----------------------------------------------------------------------------------------------------------------- ------------
TOTALS FOR VENDOR: 106 75.92
WAREHOUSE NUMBER: 2
Report Results (Contd)
Sample Report (Contd)
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 5
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:22 ON PORT NUMBER 46 - COMMENT: VEN 105/106 ALL ITEMS IND
BATCH PO NUMBER: 4047 VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
TONER BLACK TONER 45-235-6543 3 62 CT 4 5 36.0000 180.00
*** VENDOR: 1 VENDOR ITEM NO.: KTONER 1 EA 1 20 10.0000 200.00
VENDOR NAME: OFFICE PRODUCTS INC
*** VENDOR: 10 VENDOR ITEM NO.: JERI11 5 CT 6 4 60.0000 240.00
VENDOR NAME: MINOLTA
*** VENDOR: 100 VENDOR ITEM NO.: T123678 2 CT 4 5 26.7500 133.75
VENDOR NAME: OTTO CORP.
--------------------------------------------------------------------------------------------------------------- ----------
TOTALS FOR VENDOR: 105 180.00
WAREHOUSE NUMBER: 62
LA CROSSE MANAGEMENT SYSTEMS - TESTING PO WORKSHEET AS OF 8/02/95 PAGE 6
PRODUCT CLASSES 1 TO 9999 VENDORS 105 TO 106 WAREHOUSES 1 TO 255 INC. ITEMS = MIN: Y
ALL ITEMS ALL ITEMS WILL PREPARE PO'S RECEIVE INTO INDIV.WAREHOUSES
RUN ON 8/02/95 BY AT 11:22 ON PORT NUMBER 46 - COMMENT: VEN 105/106 ALL ITEMS IND
BATCH PO NUMBER: 4048 VENDOR: 105 900 VALLEY ST CONTACT: JOHN MAC KENZIE
OTTO SUPPLY COMPANY PO BOX 9987 708-355-5678
CHICAGO IL 555552222
VENDOR ITEM LEAD COST ALTERNATE
ITEM NUMBER ITEM DESCRIPTION NUMBER TIME WH UM PM QTY EXT.COST EXT.COST
ITEM-G SUPPLY 45-P567 96 EA 1 14 7.5000 105.00
--------------------------------------------------------------------------------------------------------------- -------------
TOTALS FOR VENDOR: 105 105.00
WAREHOUSE NUMBER: 96
********** END OF REPORT **********