Assignment
encdannekga
ITCO107_U3_IP_v1.xlsxSheet1
| Desktop & Laptop Systems Inventory & Depreciation | |||||||||
| System Owner | Department | System Type | Puchase Date | Initial Cost | Depreciated Value After 1 Yr. | Depreciated Value After 2 Yrs. | Depreciated Value After 3 Yr. | Depreciated Value After 4 Yrs. | Depreciated Value After 5 Yr. |
| Avery | CEO | Laptop | 42339 | 2105 | |||||
| Laurie | Marketing | Desktop | 41640 | 1689 | |||||
| Sid | Marketing | Desktop | 41640 | 1899 | |||||
| Terry | Sales | Desktop | 41640 | 1565 | |||||
| Toby | HR | Laptop | 41365 | 2224 | |||||
| Vic | Development | Laptop | 41518 | 2224 | |||||
| Chris | Sales | Laptop | 41609 | 1972 | |||||
| John | Development | Laptop | 41365 | 1972 | |||||
| Joel | Development | Desktop | 42430 | 1565 | |||||
| Keri | Sales | Laptop | 41153 | 1299 | |||||
| Nelson | Sales | Desktop | 42036 | 1689 | |||||
| Neil | Marketing | Laptop | 41518 | 1299 | |||||
| Amy | Development | Laptop | 41609 | 1606 | |||||
| Bob | Sales | Laptop | 41365 | 1710 | |||||
| Sonia | Marketing | Laptop | 42339 | 1299 | |||||
| Elena | HR | Laptop | 41518 | 2224 | |||||
| Karen | Development | Laptop | 41365 | 1658 | |||||
| David | Development | Desktop | 42036 | 1899 | |||||
| Mary | Sales | Desktop | 42430 | 1689 | |||||
| Frank | Sales | Laptop | 42339 | 1299 | |||||
| Larry | Marketing | Desktop | 41579 | 2701 | |||||
| Gabe | Sales | Desktop | 42430 | 2224 | |||||
| Heidi | Sales | Desktop | 42430 | 1899 | |||||
| Ian | Development | Laptop | 41579 | 1972 | |||||
| Owen | Sales | Desktop | 41640 | 1367 | |||||
| Paul | HR | Laptop | 41518 | 1167 | |||||
| Rich | Development | Desktop | 42036 | 1975 | |||||
| Stan | Sales | Laptop | 41579 | 1972 | |||||
| Beth | Sales | Laptop | 41609 | 2065 | |||||
| Walt | Sales | Laptop | 42036 | 1167 | |||||
| Tracy | Development | Desktop | 41579 | 1565 | |||||
| Noel | Development | Laptop | 41609 | 2105 | |||||
| Jim | Development | Laptop | 42339 | 1432 | |||||
| Roger | Sales | Laptop | 41609 | 2224 | |||||
| Kate | Sales | Laptop | 41153 | 1972 | |||||
| Sara | Sales | Desktop | 42036 | 1899 | |||||
| Sandy | Development | Desktop | 41640 | 1899 | |||||
| Eddie | Marketing | Desktop | 41579 | 1565 | |||||
| Cindy | Marketing | Desktop | 42430 | 1565 | |||||
| Kathy | Sales | Laptop | 41365 | 2224 | |||||
| Wendy | Development | Desktop | 42036 | 1689 | |||||
| Molly | Development | Desktop | 42430 | 1689 | |||||
| George | Marketing | Laptop | 41153 | 1972 | |||||
| Sean | Sales | Laptop | 42339 | 2105 | |||||
| Lewis | Development | Desktop | 41640 | 1565 | |||||
| Average Cost | |||||||||
Orange cells require formulas or functions.
Sales Data
| Sale Data | ||||||||||||
| Employee | January | February | ||||||||||
| Keri | $ 7,885 | $ 3,790 | $ 15,680 | $ 5,680 | $ 5,462 | $ 26,453 | $ 14,819 | $ 22,238 | $ 14,446 | $ 13,429 | $ 38,272 | $ 45,355 |
| Kate | $ 7,439 | $ 7,273 | $ 16,514 | $ 17,848 | $ 4,945 | $ 16,843 | $ 15,976 | $ 14,847 | $ 2,205 | $ 24,166 | $ 52,314 | $ 60,763 |
| Bob | $ 8,758 | $ 4,196 | $ 13,022 | $ 19,580 | $ 19,247 | $ 5,222 | $ 5,365 | $ 4,203 | $ 4,593 | $ 26,763 | $ 54,973 | $ 41,094 |
| Kathy | $ 8,871 | $ 4,999 | $ 15,002 | $ 7,773 | $ 23,584 | $ 19,257 | $ 20,378 | $ 9,625 | $ 11,132 | $ 11,118 | $ 24,037 | $ 37,861 |
| Stan | $ 9,473 | $ 7,951 | $ 16,721 | $ 3,290 | $ 6,729 | $ 26,494 | $ 28,556 | $ 5,661 | $ 19,627 | $ 11,023 | $ 10,275 | $ 69,328 |
| Chris | $ 8,309 | $ 10,626 | $ 8,423 | $ 9,108 | $ 13,288 | $ 16,666 | $ 20,389 | $ 28,197 | $ 18,388 | $ 16,191 | $ 21,484 | $ 54,817 |
| Beth | $ 4,332 | $ 3,413 | $ 15,842 | $ 17,097 | $ 5,884 | $ 3,905 | $ 3,817 | $ 8,721 | $ 15,078 | $ 10,716 | $ 34,048 | $ 52,736 |
| Roger | $ 7,532 | $ 10,674 | $ 12,111 | $ 18,058 | $ 19,379 | $ 2,822 | $ 14,269 | $ 2,063 | $ 24,354 | $ 10,451 | $ 71,470 | $ 55,190 |
| Walt | $ 5,854 | $ 2,151 | $ 3,787 | $ 20,557 | $ 9,502 | $ 19,549 | $ 2,417 | $ 12,009 | $ 6,891 | $ 14,427 | $ 25,129 | $ 39,241 |
| Frank | $ 6,557 | $ 2,568 | $ 5,428 | $ 6,359 | $ 4,220 | $ 13,108 | $ 13,529 | $ 28,321 | $ 20,204 | $ 16,325 | $ 44,706 | $ 45,548 |
| Sean | $ 6,869 | $ 5,232 | $ 12,145 | $ 13,318 | $ 2,825 | $ 27,096 | $ 11,517 | $ 5,003 | $ 7,312 | $ 21,275 | $ 69,026 | $ 28,443 |
| Terry | $ 6,954 | $ 4,870 | $ 16,589 | $ 19,106 | $ 5,662 | $ 27,811 | $ 16,765 | $ 16,084 | $ 25,193 | $ 14,972 | $ 21,659 | $ 21,922 |
| Owen | $ 8,528 | $ 2,578 | $ 11,305 | $ 9,967 | $ 16,256 | $ 10,918 | $ 7,643 | $ 5,847 | $ 16,358 | $ 16,300 | $ 67,887 | $ 36,325 |
| Nelson | $ 6,913 | $ 9,319 | $ 9,270 | $ 16,196 | $ 1,639 | $ 7,367 | $ 22,320 | $ 9,377 | $ 27,892 | $ 16,632 | $ 74,505 | $ 50,837 |
| Sara | $ 6,581 | $ 2,497 | $ 13,465 | $ 13,235 | $ 12,008 | $ 19,145 | $ 23,208 | $ 22,887 | $ 16,128 | $ 12,295 | $ 47,702 | $ 48,051 |
| Mary | $ 2,303 | $ 3,084 | $ 2,759 | $ 20,634 | $ 25,599 | $ 9,227 | $ 12,774 | $ 21,182 | $ 6,847 | $ 18,842 | $ 13,009 | $ 66,403 |
| Gabe | $ 9,602 | $ 9,385 | $ 5,682 | $ 14,224 | $ 29,490 | $ 28,523 | $ 11,149 | $ 15,630 | $ 20,554 | $ 29,804 | $ 21,392 | $ 20,505 |
| Heidi | $ 4,244 | $ 9,691 | $ 16,943 | $ 5,518 | $ 20,454 | $ 13,876 | $ 29,966 | $ 19,302 | $ 7,971 | $ 18,294 | $ 43,492 | $ 70,106 |
