|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
|
| |
|
|
|
AutoSoft
Systems |
2 Round Hill Court |
|
| |
|
|
|
East Greenwich, RI
02818 |
|
| |
|
|
|
401.885.3631 |
|
| |
|
|
|
401.884.5653 Fax |
|
| |
|
|
|
|
|
|
|
|
|
|
|
401.996.3631 Cell |
|
| AMDG |
|
|
|
Decision Ready
Information! |
autosoft@aol.com |
|
| Commercial & custom multi-user computer software for a
variety of applications including performance metrics, statistical analysis,
data extraction and merger from multiple large databases, computer simulation
and management information systems.
Founded in 1982. |
|
| We know Excel! Whenever possible, Excel
is the user interface, VBA is the programming language, ODBC connects to the
database of your choice. |
|
| Home |
About Us |
Literature |
Wire
& Cable |
Pharmaceutical
& Biotech |
Construction
Management |
Commercial
Products |
Custom Solutions |
|
| Contact Us |
Events |
Downloads |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| MaximoŽ is a
trademark of IBM |
|
| AutoSoft is
not affiliated with IBM. |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Planners and Buyers are tasked with assuring that all necessary
spare parts are stocked in the warehouse when required BUT do not overstock
items. This report provides the
Planners and Buyers with the "Decision Ready Information" to
optimize inventory levels. |
|
| This report can be automatically updated using AutoSoft's CART
system at any desired frequency.
Additionally, the user can manually update it as desired. The Main screen provides the user with the
status of the report, providing a quick color indication as to the
"freshness" of the data: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The "Reserved" worksheet lists the following
attributes of every work order in Maximo that has an upcoming part
requirement. There are 33 columns of
information, too many to display a screen shot here, but the 33 column
headers are displayed in in 3 rows: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
WO Num |
Planner |
WO Location |
Labor Group |
WO
Description |
Safety Crit |
Classifi-
cation |
Work Type |
Cate-gory |
WO Status |
InvReserve
Request Date |
WO Targ Start
Date |
WO Targ Comp
Date |
XX Number |
Parts Status |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Z Number Description |
Manufacturer |
Model Number |
Catalog Code |
Vendor |
Assigned
To |
Min Level |
Max Level |
Reserved
Qty |
Current RI
Balance |
RI Balance
After Demand |
1st PO Number |
Arrival
Date |
On Order |
XX Balance
After Orders |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
WO NOTES |
WO Targ Comp.
- 45 |
Arrival Date
- (Comp. - 45) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The "Orders" worksheet lists the following attributes
of each Purchase Order in the system. There are 18 columns of information: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Item Num |
Item Number
Description |
PO Num |
PO Line |
PO Description |
Purchase Agent |
Order Date |
Required Date |
PO Status |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Vendor |
Ven Delivery Date |
Model Num |
Catalog Code |
Order Qty |
Requested By |
Manufacturer |
Order
Comments |
Order Status |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The "Parts" worksheet lists 29 attributes of each part
on order and/or required for scheduled work orders. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Z # |
Unit |
Part
Description |
Catalog Code |
Model Number |
Manufacturer |
Vendor |
Status |
ABC |
Bin # |
Last Issued |
CCF |
Category |
RI Balance |
Current Order
Qty |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Reserved |
Delivery Time |
Issue 1 Yr
Ago |
Issued YTD |
Max |
Min |
Part Order
Quantity |
RMS Flag |
Avg. Cost |
Stand. Cost |
Assigned To |
PCS |
Commodity Group |
Repairable |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Click here to download a crippled
and redacted copy of this report. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| AutoSoft Systems | 2 Round Hill Court, East
Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 |
Mobile: 401.996.3631 |
|
| This web page was last updated at 01/09/2024 04:51 PM and is
written in EXCEL! |
|
| AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach
- AutoSoft Systems is not affiliated with Consona nor Zumbach |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|