Pc Repair Service Contract - Excel

Document Sample
Pc Repair Service Contract - Excel Powered By Docstoc
					                                                                                                              Asset Management Committee
                                                                                                                  Balance Sheet 2005




                                                                                                    Charles Darwin University
                                                                                           Faculty of Education, Health, & Science
                                                                                                     Asset Management Committee
                                                                                                              Balance Sheet 2005

                                                                                                                                                                                                     AOS
                                                  Jan-05                                        Item                                S/R    Expenditure        Income         Req. No.    PO No.
                                                                                                                                                                                                  Allocation
                                      2005 Balance Loaded                                                                                                     $100,000.00
                                      Encumbrances Carried Forward   2004 Obligations carried forward                                            $3,358.47
                                      2004 Balance Carried Forward   2004 Balance c/fwd                                                                         $7,648.82
                                      Interest Paid                  Interest Paid
                                      Miscellaneous Sales            Miscellaneous Sales                                                                        1,871.75
                                      Hire                           Revenue from Equipment & Facility Hire

                                      B18 CA&ESL                     Dell Optiplex PC's for CAESL                                                  1492.25                     185928    183790
                                      B23 Education                  Dell Optiplex PC GX280 for M Christie                                         2485.35                     185954    183831
                                      B42 Research                   Replacement propeller                                                         2000.00                     185983    183932
                                      Faculty Administration         Recovery of data from failed hard drive- Greg Hill                            2340.00                     186649    184490
                                      B42 Technical Services         NMR power supply units                                       *                1386.00                     186844    184815
                                      Faculty Administration         Leasing of Xerox DC405CP and DC235CFP copiers                                 2394.50                     n/a       157053
                                      Faculty Administration         Leasing of Xerox DC235 copier                                                   682.24                    n/a       167639
                                      Faculty Administration         Leasing of Xerox copier                                                         788.39                    n/a       148782
                                                                                                            Totals for January 05                16,927.20    109,520.57                                0.00
                                                                                       Service / Repair Charges for January 05 *                  1,386.00

                                                                                                               Activities to Date                16,927.20    109,520.57
                                                                                                        Balance Remaining                     $92,593.37

                                                                                                                                                                                                     AOS
                                                  Feb-05                                        Item                                S/R    Expenditure        Income         Req. No.    PO No.
                                                                                                                                                                                                  Allocation
                                      B23 Education                  Dell D505 for Sports                                                         2,608.00                     187011    184880
                                      B42 Technical Services         Repair of RO water system                                       *            2,233.00                     187221    185041
                                      B42 Technical Services         Repairs to dehumidifier                                         *              179.50                     187279    185057
                                      Faculty Administration         Additional payment for data recovery - Greg Hill                               130.00                     187514    185262
                                      B42 Technical Services         Watering Controller - Shadehouse                                *              178.50                     187797    185333
                                      B23 Education                  Dell Optiplex GX280SDT for T Dunbar                                          4,014.48                     187777    185667
                                      Faculty Administration         Dell Lattitude D505 Notebook for EO                                          3,250.82                     187775    185668
                                      B42 Research                   Dell GX280SDT for Karen Gibb                                                 4,465.76                     187748    185666
                                      B42 Technical Services         NMR Power Supply Inspection                                     *              224.40                     188180    186011
                                      Faculty Administration         Dell Optiplex GX280 for staff                                                3,548.89                     188311    186017
                                      Faculty Administration         Dell Optiplex Pc's for staff                                                16,367.12                     188309    186027
                                      B23 Education                  Apple PowerBook (T.Wright)                                                   3,434.00                     188436    186133
                                      B42 Technical Services         Install surge protectors in Shadehouses                                        430.00
                                      Faculty Administration         Leasing payment - 16x Dell PC's                                              3,101.95                     n/a       149176
                                      Funds from Areas of Strength   Funds fro ACIAR Grant                                                                       2297.25
                                      B42 Technical Services         Accomodation @ NFIH for Nick Voromov (Microscope Tech)          *                70.00                 J00631HL
                                      B42 Technical Services         RO Water filters                                                *               944.00                     188602   186437
                                                                                                           Totals for February 05                45,180.42      2,297.25                                0.00
                                                                                        Service / Repair Charges for February 05     *            3,829.40

                                                                                                               Activities to Date                62,107.62    111,817.82

                                                                                                        Balance Remaining                     $49,710.20




D:\Docstoc\Working\pdf\68db918e-89d6-4195-a108-e51899ecd000.xls                                                            1                                                                                   3/16/2011
                                                                                                              Asset Management Committee
                                                                                                                  Balance Sheet 2005




                                                                                                                                                                                                         AOS
                                                  Mar-05                                         Item                                S/R         Expenditure        Income       Req. No.    PO No.
                                                                                                                                                                                                      Allocation
                                      B23 Health Science             Replacement Battery for Health Sciences laptop                  *                    103.00                   189049    186764
                                      B42 Technical Services         Repairs to stirring hot plates                                  *                    770.00                   188997    186787
                                      B42 Technical Services         Replacement UV lamp for RO water system                         *                    278.00                   189116    186880
                                      B23 Administration             Port Replicator for David Parry                                                      277.40                   189151    186938
                                      B23 Health Science             Dell D505 notebook PC's for Lithgow and Fox                                        4,900.02                   189353    187074
                                      B42 Technical Services         Repairs to large Labec Incubator                                *                  3,600.00                   189395    187113
                                      B42 Technical Services         Repairs to Balance A113762                                      *                    300.00                   189910    187637
                                      B42 Research                   Replacement rotary pump for ICPMS                               *                  1,500.00                   190050    187795
                                      NTRC                           Mechanical Cow for NTRC                                                            3,480.00
                                      B23 Administration             Transfer of funds into account                                                                  50,000.00
                                      Funds from Areas of Strength   Funds received from Dept. Environment & Heritage                                                   718.80 T121782

                                                                                                            Totals for March 05                        15,208.42     50,718.80                              0.00
                                                                                         Service / Repair Charges for March 05           *              6,551.00

                                                                                                               Activities to Date                      77,316.04    162,536.62

                                                                                                         Balance Remaining                   $       85,220.58

                                                                                                                                                                                                         AOS
                                                  Apr-05                                         Item                                S/R         Expenditure        Income       Req. No.    PO No.
                                                                                                                                                                                                      Allocation
                                      B42 Technical Services         B42 Varian Annual preventative maintenance visit                *                  8,000.00                    187651   186019
                                      B42 Technical Services         Membrane filters for RO water system                            *                     5262                     190600   188627
                                      B42 Technical Services         Installation of 3x NMR power supply units                       *                      342                     190700   188441
                                      B42 Technical Services         Repairs to Qualtex drying oven                                  *                      515                     190970   188758
                                      B23 IT Support                 Purchase of Dell Server (to be refunded by Central)                                  13432                     191249   188942
                                      B42 Technical Services         Additional parts for RO system                                  *                        65                    191413   186880
                                      Funds from Areas of Strength   Funds received from Power & Water                                                                   434.75 T122174
                                      Funds from Areas of Strength   Funds received from Miwatj Health Aboriginal Corporation                                              719 T122194
                                      Faculty Administration         Leasing of Xerox copier                                                               788.39                   n/a      148782
                                      Faculty Administration         Leasing of Xerox DC235 copier                                                         682.24                   n/a      167639
                                                                                                               Totals for April 05                     29,086.63      1,153.75                              0.00
                                                                                           Service / Repair Charges for April 05         *             14,184.00

                                                                                                               Activities to Date                     106,402.67    163,690.37

                                                                                                         Balance Remaining                          $57,287.70




D:\Docstoc\Working\pdf\68db918e-89d6-4195-a108-e51899ecd000.xls                                                             2                                                                                      3/16/2011
                                                                                                             Asset Management Committee
                                                                                                                 Balance Sheet 2005




                                                                                                                                                                                                      AOS
                                                  May-05                                        Item                                S/R       Expenditure        Income       Req. No.    PO No.
                                                                                                                                                                                                   Allocation
                                      B42 Technical Services         Repairs to air dryer for FTIR                                   *                  546.59                  192535    190208
                                      B42 Technical Services         Repairs to incubator in culture room                            *                  720.00                  192946    190562
                                      B42 Research                   Maintenance to Licor portable gas exchange system (Hutley)      *                  665.00
                                      B18 GIS/RS Teaching Lab        Purchase of replacement HP4250TN printer 18.2.40                                 2,461.46                  193270    190917
                                      B42 Technical Services         Replacement pressure gauge for RO water system                  *                  131.00                  193345    191078
                                      Faculty Administration         Leasing of Xerox DC405CP and DC235CFP copiers                                      2394.5                  n/a       157053
                                      Faculty Administration         Leasing payment - 16x Dell PC's                                                  3,101.95                  n/a       149176
                                      B42 Research                   Polaragraph - Metrohm Analysis System                                           20,989.00                  192028    189655
                                                                                                                Totals for May 05                   31,009.50          0.00                              0.00
                                                                                             Service / Repair Charges for May 05    *                2,062.59

                                                                                                              Activities to Date                   137,412.17    163,690.37

                                                                                                        Balance Remaining                        $26,278.20

                                                                                                                                                                                                      AOS
                                                  Jun-05                                        Item                                S/R       Expenditure        Income       Req. No.    PO No.
                                                                                                                                                                                                   Allocation
                                      B42 Technical Services         Filters for RO water system                                     *               1,064.00                   193863    191513
                                      B42 Technical Services         Repairs to incubator                                            *                 335.50                   193942    191626      335.50
                                      B42 Administration             Replacement HP4250dtn printers (Techs + L2 staff printer)                       5,735.26                   194047    191704
                                      B42 Research                   Freight charge for ICPMS pump                                                     614.54                   194065    191833      614.54
                                      Alice Springs - Science & PI   Replacement field laptop for Wayne Tregea                                       2,313.76                   194182    191821
                                      B42 Technical Services         Poly bowl mixer for potting mixes                                                 493.75                   192155    192758
                                      B42 Research                   Credit from AOS to support equipment                                                          9,500.00
                                      NTRC                           Irrigator and hose pump for NTRC                                               12,995.00                    192486   190146
                                      B42 Research                   Replacement HP Notebook for Lindsay Hutley                                      2,477.40                    195467   193170
                                      B40 Primary Industries         Notebook for Bryan Harty                                                        2,477.40                    195467   193170
                                      B46 Shade House                Repairs to shadehouses - torn fabric                            *                 600.00                    195538   193807
                                      Faculty Administration         Lease payment - 16x Dell PC's                                                   3,101.95                    n/a
                                      B42 Technical Services         Accomodation NFIH for service technician                        *                  70.00                  J00631HL
                                      Funds from Areas of Strength   Infrastructure funds from NLC Beeetalook Research Station                                     2,579.50   J00658MT
                                                                                                               Totals for June 05                   32,278.56     12,079.50                           950.04
                                                                                            Service / Repair Charges for June 05    *                2,069.50

                                                                                                              Activities to Date                   169,690.73    175,769.87

                                                                                                        Balance Remaining                 $        6,079.14




D:\Docstoc\Working\pdf\68db918e-89d6-4195-a108-e51899ecd000.xls                                                            3                                                                                    3/16/2011
                                                                                                           Asset Management Committee
                                                                                                               Balance Sheet 2005




                                                                                                                                                                                                       AOS
                                                  Jul-05                                      Item                                S/R       Expenditure        Income        Req. No.      PO No.
                                                                                                                                                                                                    Allocation
                                      Faculty Administration      Funds transfer into account                                                                  100,000.00
                                      B42 Research                Service of Research Microscopes (LMG Scientific Service)         *               1,000.00
                                      B42 Research                Service of Precision Balances                                    *               1,690.00                     195738     193408
                                      B42 Research                Replacement theta probe (Lindsay Hutley)                         *                 600.00                     195772     193406      600.00
                                      B42 Technical Services      Construction of benches for Shadehouses                                          4,079.15                     196078     193969
                                      B42 Technical Services      Repairs to B42 L2 Ice Maker                                      *                 253.33                     196468     194238
                                      B23 Health Sciences         Replacement laptop for lost item. For HeartStart Manequin                        2,259.22                     196502     194237
                                      B42 Technical Services      Service contract for Electron microscopes                        *              20,903.85                     197018     194802
                                      B42 Technical Services      Repairs to Incubator in 42.2.74                                  *               1,220.00                     197020     194803
                                      B42 Technical Services      Parts for Electron Microscope                                    *                 450.80                     197026     194804
                                      B42 Technical Services      Repairs to Incubator in teaching areas                           *               1,018.55                     197030     194660
                                      NTRC                        Purchase of HP Notebook PC for Rural College                                     2,220.71                     197402     195108
                                      B42 Research                HP 8240 Notebook for M.Douglas - for full recovery of funds                      3,333.70                     195715     193334
                                      Faculty Administration      Lease payment for Xerox copier                                                      788.00                B00092057      147872
                                      Faculty Administration      Lease payment for Xerox DC235 copier                                               682.24                        84008   167639
                                      Faculty Administration      Chairs for lab 23.1.40 - funds to be recovered                                   3,492.00                     196584     194297
                                      B23 Health Sciences         Manikins, simulators and parts for Nursing Lab                                   8,898.00                     195635     194744
                                                                                                             Totals for July 05                   52,889.55    100,000.00                             1,550.04
                                                                                         Service / Repair Charges for July 05     *               27,136.53

                                                                                                            Activities to Date                   222,580.28    275,769.87

                                                                                                      Balance Remaining                 $       53,189.59

                                                                                                                                                                                                       AOS
                                                  Aug-05                                      Item                                S/R       Expenditure        Income        Req. No.      PO No.
                                                                                                                                                                                                    Allocation
                                      B42 Technical Services      2x HP 17" LCD panels for Technical Services                                        869.06                     197533     195330
                                      B42 Technical Services      Service Contract and repairs to Moran X-Ray system               *               5,980.50                     197540     195368
                                      B40 Aquaculture             Repairs to Air Blower in Aquaculture                             *                 100.00
                                      B42 Technical Services      Service and repairs to oxygen sensors in B42                     *               1,154.00                     198490     196123
                                      B42 Technical Services      Repairs to high speed centrifuge motor                           *                 700.00                     199070     196744
                                      Faculty Administration      HP Desktop PC's x3 + HP Notebooks x2                                            10,623.24                     198543     196291
                                      Faculty Administration      Leasing payment - 16x Dell PC's                                                   3,101.95                    n/a        149176

                                                                                                        Totals for August 05                      22,528.75          0.00                             1,550.04
                                                                                     Service / Repair Charges for August 05        *               7,934.50

                                                                                                            Activities to Date                   245,109.03    275,769.87

                                                                                                      Balance Remaining                        $30,660.84




D:\Docstoc\Working\pdf\68db918e-89d6-4195-a108-e51899ecd000.xls                                                          4                                                                                       3/16/2011
                                                                                                          Asset Management Committee
                                                                                                              Balance Sheet 2005




                                                                                                                                                                                                   AOS
                                                  Sep-05                                      Item                                S/R   Expenditure        Income        Req. No.      PO No.
                                                                                                                                                                                                Allocation
                                      B42 Research                Service of Beckman Centrifuges (High Speed & Ultra)              *            2346.22                     197775     195370
                                      Faculty Administration      Leasing of Xerox DC405CP and DC235CFP copiers                                 2394.50                     n/a        157053
                                      B42 Technical Services      Filters for RO water system                                      *            1064.00                     199242     196979
                                      B18 Science                 Maintenance kit for HP4100 printer in GIS/RS                     *             466.08                     199431     197013
                                      B42 Research                Replacement Powerboard for Licor 6200 (L.Hutley)                 *            1698.00                     199633     197171     1,698.00
                                      B23 IT Support              Replacement power supplies for Dell computers                    *             188.00                     199643     197212
                                      Alice Springs (Education)   2x HP Desktop PC's (Des Thornton, Judith McKinlay)                            3158.62                     200368     197923
                                      Faculty Administration      3x HP Desktop PC's for staff (replacement PC's)                               4506.93                     200419     197959


                                                                                                    Totals for September 05                   15,822.35          0.00                             3,248.04
                                                                                 Service / Repair Charges for September 05         *           5,762.30

                                                                                                            Activities to Date               260,931.38    275,769.87

                                                                                                     Balance Remaining                     $14,838.49

                                                                                                                                                                                                   AOS
                                                   Oct-05                                     Item                                S/R   Expenditure        Income        Req. No.      PO No.
                                                                                                                                                                                                Allocation
                                      B23 Administration          PDA and parts for Dean                                                       1,937.00                     201187     198722
                                      B23 Administration          HP 17" Standard LCD monitor for admin staff                                    434.53                     201850     199306
                                      B42 Technical Services      Testing of Biohazard and laminar flow cabinets                   *             770.00                     201140     199334
                                      B42 Technical Services      Courier and inspection of television asset #121520 in 42.1.24    *              99.00                     202379     199972




                                      Faculty Administration      Lease payment for Xerox copier                                                  788.00                B00092057      147872
                                      Faculty Administration      Lease payment for Xerox DC235 copier                                           682.24                        84008   167639
                                                                                                     Totals for October 05                     2,773.77          0.00                             3,248.04
                                                                                  Service / Repair Charges for October 05                         99.00

                                                                                                            Activities to Date               263,705.15    275,769.87

                                                                                                     Balance Remaining                     $12,064.72




D:\Docstoc\Working\pdf\68db918e-89d6-4195-a108-e51899ecd000.xls                                                          5                                                                                   3/16/2011
                                                                                                        Asset Management Committee
                                                                                                            Balance Sheet 2005




                                                                                                                                                                                               AOS
                                                  Nov-05                                    Item                              S/R    Expenditure           Income       Req. No.   PO No.
                                                                                                                                                                                            Allocation




                                      Faculty Administration      Leasing payment - 16x Dell PC's                                           3,101.95                      n/a      149176

                                                                                                    Totals for November 05                  3,101.95             0.00
                                                                                 Service / Repair Charges for November 05      *               0.00

                                                                                                         Activities to Date               266,807.10       275,769.87
                                                                                                    Balance Remaining                     $8,962.77

                                                                                                                                                                                               AOS
                                                  Dec-05                                    Item                              S/R    Expenditure           Income       Req. No.   PO No.
                                                                                                                                                                                            Allocation




                                                                                                    Totals for December 05                          0.00         0.00
                                                                                 Service / Repair Charges for December 05      *                   0.00

                                                                                                         Activities to Date               266,807.10       275,769.87

                                                                                    Total Service / Repair Charges for 2005    *           71,014.82


                                                                                                    Balance Remaining                     $8,962.77


                                                                                                 School of Science Totals                   5,241.30
                                                                                                   School of Health Totals                  5,003.02
                                                                                               School of Education Totals                  15,700.45
                                                                                       School of Primary Industries Totals                 21,773.11
                                                                                          Centre for Access & ESL Totals                    1,492.25
                                                                                                          Research Totals                  44,765.62
                                                                                                Technical Services Totals                  65,602.48
                                                                                            Faculty Administration Totals                  94,650.18




D:\Docstoc\Working\pdf\68db918e-89d6-4195-a108-e51899ecd000.xls                                                       6                                                                                  3/16/2011
                                                 Faculty of Education, Health & Science

                                         2005 Planned Equipment Maintenance Schedules
                  B42
                  Equipment                           Company                          Period         Period Cost    Annual Cost
                  Autoclaves                          AirDucter                       bi-annual           $250.00        $125.00
                  Balances                            Precision Services               annual           $1,230.00      $1,230.00
                  Electron Microscopes                JEOL                             annual          $21,150.00     $21,150.00
                  EDAX System                         Moran                           bi-annual         $6,000.00      $3,000.00
                  Microscopes - undergratuate         In-house                                                             $0.00
                  Microscopes - postgraduate          Micro-Optics Solutions           annual            $1,000.00     $1,000.00
                  Ice Flakers                         CTM Refridgeration              6 monthly           $630.00      $1,260.00
                  Spectrometers                       Varian                           annual            $8,000.00     $8,000.00
                  Oxygen sensors                      Air & Gas Systems               6 monthly           $250.00        $500.00
                  RO Water system                     Medical & Laboratory Supplies    annual            $2,768.00     $2,768.00
                  Centrifuges                         Beckman Instruments              annual            $3,000.00     $3,000.00
                  Laminar Flow / Biohazard Cabinets   AES Environmental SA             annual             $700.00        $700.00
                  Electrical Equipment Cord Tagging   APG Electrical                   annual          $10,000.00     $10,000.00
                  -80°C Freezer Maintenance           Quantum Scientific               annual             $600.00        $600.00
                                                                                                  Building Total:     $53,333.00

                  B40
                  Equipment                           Company                          Period         Period Cost    Annual Cost
                  Water Pumps and Reticulation        In-house                         annual                          $4,000.00
                                                                                                  Building Total:      $4,000.00

                  Faculty General
                  Equipment                           Company                          Period         Period Cost    Annual Cost
                  Vehicles                            BASD                             annual          $30,000.00     $30,000.00
                                                                                                  Building Total:     $30,000.00




68db918e-89d6-4195-a108-e51899ecd000.xls                                   7                                                       3/16/2011
                  TOTAL ANNUAL COST            $87,333.00




68db918e-89d6-4195-a108-e51899ecd000.xls   8                3/16/2011
                                                  Charles Darwin University
                                             Faculty of Education, Health, & Science

                                Dispersal of Computer Purchases Amongst Schools / Departments

 Requisition   PO Number   Date Education    Health       Science   Prim Indust       Administration
185928         183790      Jan-05
185954         183831      Jan-05       1
187011         184880      Feb-05       1
187777         185667      Feb-05       1
187775         185668      Feb-05                                                                  1
187748         185666      Feb-05
188311         186017      Feb-05
188309         186027      Feb-05       3             2         2                 1
188436         186133      Feb-05       1
#REF!             #REF!




          Area Totals               7          2             2           1                  1
                                 Education   Health       Science   Prim Indust       Administration
University
ealth, & Science

ongst Schools / Departments

                   Tech Services       Research   CAESL       TOTAL
                                                          7           7
                                                                      1
                                                                      1
                                                                      1
                                                                      1
                                              1                       1
                                   1                                  1
                                                                      8
                                                                      1
                                                                      0
                                                                      0
                                                                      0
                                                                      0
                                                                      0
                                                                      0
                                                                      0
                                                                      0
                                                                      0
                                                                      0



                         1                1         7
                   Tech Services       Research   CAESL

				
DOCUMENT INFO
Description: Pc Repair Service Contract document sample