Welcome to Capital Asset Management

1
Welcome to Capital Asset Management

2
CAMS Mission

• The mission of the University Capital Asset
  Management department is to provide the highest
  quality service and guidance in asset management
  to university organizations, while fulfilling the
  financial recording and reporting requirements of
  the university.

3
Roles and Responsibilities

• Compliance Services
• Consulting Services
• System Support and Training Services

4
Asset Categories

• Capital Movable
• Equipment
• Fabrications
• Lease Purchases
• Capital Non-movable
• Art and Museum
• Bonds
• Buildings Building Improvements
• Infrastructure
• Land
• Leasehold Improvements
• Library books
• Non Capital

5
Major Components of CAMS

• Capital Asset Builder
• Pre-Asset Tagging
• Non-Movable Additions
• Documents and Maintenance Screens
• Inventory Process
• Depreciation
• Reconciliation Reports

6
CAB Menu
7
Invoice Line Item Screen
8
Allocate Additional Charges
9
Insert from Pending
10
Add line 8 to line 1
11
Create View Asset Screen
12
General Ledger Transactions
13
Modify an Asset
14
Enter Pending Asset Information
15
Create View Asset Screen
16
Pre-asset Tagging
17
Pre-asset Tagging (tagging) screen
18
Documents Route for Approval

• Add Asset
• Asset Retirement
• Asset Transfer
• Equipment Loan/Return
• Fabrication Request

19
Maintenance Screens Security

• Maintenance Screens do have restrictions
• University Capital Asset Office
• Campus Capital Asset Offices
• Organizations

20
Accuracy of Data

• Additions (CAB/Add Asset Document)
• Transfers
• Retirements
• Inventory Updates

21
Add Asset Document
22
Asset Retirement
23
Asset Transfer
24
Equipment Loan/Return
25
Fabrication
26
CAMS Maintenance Screens

• Capital Asset Maintenance
• Location Maintenance
• Tag an Asset
• Merge an Asset
• Separate an Asset
• System Manager Maintenance

27
Capital Asset Lookup
28
Capital Asset Maintenance
29
Location Maintenance
30
Physical Inventory

• Intermec Antares Trakkers scan equipment.
• Filecopy utility is used to extract file and copy
  to PC.
• File Uploaded to FIS
• Bar-code Error Document
• Inventory Reconciliation Report

31
Depreciation

• Depreciation expense is calculated from a stored
  procedure that updates the asset database on a
  monthly basis. The Straight Line method is the
  basis for the calculation, along with a method
  for Salvage Value. Federally owned payments are
  excluded from the depreciation calculation. In
  addition, no Deprecation will be taken on Art and
  Museum Objects, Land, or Leasehold Equities.
  Each asset is depreciated from the asset create
  date, and the assets useful life assigned to the
  asset type code. Non-Movable assets use a ½ year
  convention for assigning the create date. The
  Deprecation entries Debit Object Code 51XX,
  Depreciation Expense, and Credit the appropriate
  Accumulated Depreciation Object Code based on the
  Object Code Sub Types in the Asset Object Code
  Table.

32
Asset Object Code Table
33
Reconciliation

• Additions
• Retirements
• Transfers
• Depreciation Expense
• Ending Balances

34
Pre-Defined Queries

• Capital Asset Management has made available the
  following reporting categories to assist
  organizations in asset management.
• Inventory Control Reports Nbr of rpt 9
• Depreciation Reports Nbr of rpt 4
• Edit Reports Nbr of rpt 10
• Summary Reports Nbr of rpt 4
• Internal Reports Nbr of rpt 15
• Screening Reports Nbr of rpt 1
• Capital Lease Reports Nbr of rpt 2

35
Movable Equipment Activity

• For Year Ending June 30, 2004
• Total net capital assets 1,707,160,245.18
• Capital Asset Management Staff
• Plant Fund Accountant
• Asset Creator
• Inventory/Tagging Manager
• Data Manager