| DBA Services Home Page
|
|
PLANNING
Long Range Master
Planning Report
Ever wonder how much poor planning and interruptions are costing your
manufacturing operation? This powerful tool employs some of the most advanced
manufacturing concepts available today. Designed by M. Larry Smith, CPIM, of
Innovative Technologies, Inc., this is actually a system that will allow you to
input and store Actual and Planned Beginning Backlog and Workcenter Capacity by
week. Run the Long Range Master Planning report each week using input data and DBA
labor, production, and scheduling data to calculate and store Forecast Hours, Planned
Order Hours, Interrupt Hours, Actual Hours, Net Deviation, Cumulative Deviation, Percent
Interrupt, and Planned and Actual Beginning and Cumulative Backlog. For details
regarding how Long Range Master Planning can work for your company, contact Larry Smith at
(864) 288-5687, www.itbcorp.com, e-mail - mls1@piedmont.net. Contact us to purchase the
Long Range Master Planning Report.
Price - $129.00
 Inputs
Outputs
Percentages
Screen Shot
Back to top
ACCOUNTS RECEIVABLE
Cash Receipts Projection
Set up for each customer expected
number of days to pay in a table format in Access. Access report computes for each
customer invoice amount and invoice date (from the A/R aging) and projects the days that
the invoice will be paid from the criteria established and as of the date the report is
requested. Access report list each invoice into one of 7 columns based upon the
projected payment date as follows: 7 days, 8-14 days, 15-21 days, 22- 28 days, 29-35 days,
36-42days, and >42 days. Populate customer table with a Days To Pay variable
that is present in DBA (it is a running analysis of average number of days a customer has
paid and cannot be updated by the user- it is updated by the AR-C program each time a
receipt is entered). You can have a report instantly after updating the table!
Price - $79.00
Cash
Projection
Screen Shot
Back to top
ACCOUNTS PAYABLE
Accounts Payable Out of Balance
Research Report
Ever had your accounts payable detail not agree to your
general ledger? Use this report to isolate and resolve differences. Will
analyze your DBA system for any range of dates (e.g. 1/1/99 through 12/31/99, 12/1/99
through 12/31/99, etc.), calculate Beginning AP, Net Change, and Ending AP by vendor from
your Accounts Payable files, Net Change by vendor for your accounts payable account and
from your general ledger files, and Difference between Net Change from your accounts
payable versus general ledger files. Then goes on to display your beginning and
ending general ledger balances, all accounts payable general ledger entries that were
posted as a general journal entry and, for all vendors with a difference between Net
Change from your accounts payable versus general ledger files, complete accounts payable
and general ledger detail.
Price - $79.00.
AP Analysis
Back to top
WORK ORDERS
Job Cost History
This powerful report pulls together components from your
inventory, customer and work order bills of material, labor, work center, finished
production, and labor files to provide you with an up to the moment snapshot of work order
status. Provides important summary, details and analysis including Total Hours,
Total $ Material and Subcontract, Total $ Hours, Price Per Hours, Hours Each, Cost Each,
Material and Subcontract Each., Operations by Employee including Production Hours, # of
Pieces, Time per Cycle, and $ per Operation, and details of all Material and Subcontract
issues.
Price - $79.00.
Job Cost
History
Back to top
Work Order Pick List
Shows items that still need to be issued to the work orders specified.
The list shows how many of each item for each work order in the range by work order
number. This will allow you to look at one sheet and see what is needed to complete
the work order material requirement.
Price - $79.00
Work
Order Pick List
Back to top
Work Order BOM Pick List
A report similar to an
inventory inquiry for WIP that shows how many items are required, how many are issued, and
the balance to be issued for each part by work order. The Bill of Material
quantities is for a work order, reflects the information mentioned above, and can be
filtered for zero balances to be issued.
Price - $79.00
Work
Order Bill of Material Pick List
Back to top
SALES ORDERS
Open Sales Orders by
Customer
Combines the dollar information from the open sales order report with
the shipping schedule information on the shipping report. Can be printed for a range
or all sales orders with ship or back order quantities. Includes Customer Code,
Customer Name, Customer Order #, Order Description, SO No., Order Date, Invoice Subtotal,
Part Number, Part Description, Quantity Shipped, Ship Quantity, BO Qty, Total to Ship,
Price, Discount %, Extension, RTS, and Est Ship Date.
Price - $79.00.
SO by
Customer
Back to top
Open Sales Orders
by Estimated Ship Date
Print open sales orders sorted by ship date and subtotal the dollars
with user definable subtotals by day, week, month, or quarter. Provides valuable
information including Sales Order Number and Parts, Total to Ship, Extension, and
Estimated Ship Date.
Price - $79.00.
SO by Date
Back to top
Sales Order
Estimated Vs. Actual Ship Date
Prepares a report that compares the estimated ship date from the sales
order to the actual ship date from the invoice, calculates number of days early or late,
and subtotals Invoice Amount by Sales Order and Invoice.
Price - $79.00.
SO
Estimated vs. Actual Ship Date
Back to top
Sales Order
Rolling Aged Order Backlog
Two reports and one DBA program customization are provided.
Creates a rolling aged order backlog report which summarizes total
dollar value of shipments (sales order quantity to ship times unit price) by product
group (stored in a Microsoft Access table), product class, and classified by
estimated ship date.
Provides supporting details to the rolling aged backlog report
including rolled ESD date, customer, order date, ESD, number of days late or early,
product description, unit price, extension, and staged quantities.
Includes a slight modification to the SO-A screen (version 2000.1) to
classify each sales order line item as to whether the customer is willing to accept the
order early or will only accept on or after the estimated ship date.
Price - $199.00 (two reports and SO-A modification)
SO Rolling
Aged Order Backlog (1 of 2)
SO Rolling
Aged Order Backlog (2 of 2)
Back to top
PURCHASE ORDERS
Purchase
Order Estimated Vs. Actual Receipt Date
Prepares a report that compares
the estimated receipt date from the purchase order to the actual receipt date from the
invoice, calculates number of days early or late, and subtotals Invoice Amount by Purchase
Order and Invoice.
Price - $79.00
PO Estimated vs. Actual Receipt Date
Back
to top
COMMISSIONS
Commissions Earned Report
Print a report of all commissions earned by Sales Person, Customer No.,
Part Number, and Invoice Date subtotaled by Sales and Commission Amount.
Price - $79.00.
Commissions
Earned
Back to top
Commissions Payable
If you pay your commissions at time of customer payment, then this
report is for you (also see Accrued Commissions). Prints a report of commissions
payable by Sales Person, Customer No., Part Number, Invoice Date, and Payable Date
subtotalled by Sales and Commission Amount.
Price - $79.00.
Commissions
Payable
Back to top
Accrued Commissions
If you pay commissions at the time of customer payment, then this
report is a must to determine the amount of unpaid commissions which would be due if all
accounts receivable were paid as of any date (also see Commissions Payable). Use
this report to determine the amount of commissions that will become payable in the future
and to make general ledger accounting entries. Print a report of accrued commissions
by Sales Person, Customer No., Part Number, and Invoice Date subtotaled by Sales and
Commission Amount.
Price - $79.00.
Accrued
Commissions
Back to top
CUSTOM REPORT REQUEST |
