Please help.

profileKingin757
assets.xlsx
Home>Computer Science homework help>Please help.

Assets

Asset ID Customer ID Item Model Serial Number Category In Service Date Purchase Date Cost
1955 108 Desktop PC System z99145A System ZA9932716482 Computers 01/10/2011 01/09/2011 $ 1,200.00
1956 110 Espresso Machine LH3000 2267155789A Appliances 02/11/2011 01/27/2011 $ 100.00
1957 107 Microwave Microwave Oven 1100 77W2245ZA23 Appliances 04/20/2011 03/17/2011 $ 150.00
1958 105 Desk Chair ErgoChair 100 5574986320H Office Furniture 05/18/2011 03/26/2011 $ 50.00
1959 104 VOIP Telephone Clear Call 2000 778640061K Telephones 05/23/2011 04/18/2011 $ 75.00
1960 109 Desk Chair ErgoChair 100 5575372783E Office Furniture 06/14/2011 04/23/2011 $ 50.00
1961 107 Digital Camera IX US 801S 1X2U5G64AC Cameras 05/20/2011 05/01/2011 $ 300.00
1962 110 Desk Chair ErgoChair 100 5582939281G Office Furniture 07/13/2011 06/07/2011 $ 50.00
1963 110 Digital Camera IX US 801S 1X2U9H28JS Cameras 07/22/2011 07/08/2011 $ 300.00
1964 111 VOIP Telephone Clear Call 2000 778682762G Telephones 08/28/2011 07/15/2011 $ 75.00
1965 112 Microwave Microwave Oven 1100 77W3738HT81 Appliances 01/10/2012 11/24/2011 $ 150.00
1966 103 VOIP Telephone Clear Call 2000 779182737S Telephones 03/09/2012 01/12/2012 $ 75.00
1967 109 Desktop PC System z99145A System ZA9962536488 Computers 06/09/2012 04/18/2012 $ 1,200.00
1968 108 VOIP Telephone Clear Call 2000 782736489Q Telephones 05/21/2012 05/16/2012 $ 75.00
1969 107 Desk Chair ErgoChair 100 5589282663E Office Furniture 08/15/2012 08/13/2012 $ 50.00
1970 103 15" Notebook Business Notebook 15 BN299765G Computers 10/25/2012 10/22/2012 $ 1,000.00
1971 108 Desk Chair ErgoChair 100 5591097523B Office Furniture 12/05/2012 10/29/2012 $ 50.00
1972 107 15" Notebook Business Notebook 15 BN374839P Computers 12/30/2012 12/15/2012 $ 1,000.00
1973 109 VOIP Telephone Clear Call 2000 786728399S Telephones 02/03/2013 12/25/2012 $ 75.00
1974 112 VOIP Telephone Clear Call 2000 789283647W Telephones 07/16/2013 06/26/2013 $ 75.00
1975 109 Espresso Machine LH3000 2268367485A Appliances 08/25/2013 07/03/2013 $ 100.00
1976 104 Espresso Machine LH3000 2268276159A Appliances 10/04/2013 08/31/2013 $ 100.00
1977 112 Digital Camera IX US 801S 1X2V1I29OW Cameras 10/12/2013 09/04/2013 $ 300.00
1978 105 VOIP Telephone Clear Call 2000 791264784E Telephones 10/13/2013 09/16/2013 $ 75.00
1979 106 15" Notebook Business Notebook 15 BU172638N Computers 10/27/2013 10/09/2013 $ 1,000.00
1980 110 Desktop PC System z99145A System ZA9982938829 Computers 11/17/2013 11/06/2013 $ 1,200.00
1981 106 Desk Chair ErgoChair 100 5593546573G Office Furniture 11/29/2013 11/08/2013 $ 50.00
1982 104 Digital Camera IX US 801S 1X2V5O28NC Cameras 12/01/2013 11/15/2013 $ 300.00
1983 104 Desktop PC System z99145A System ZA9988273654 Computers 12/03/2013 11/30/2013 $ 1,200.00