Chapter 2 Running Case Portfolio
danevia
SpreadsheetChapter2bethell_e02r1NCCTS.xlsxMarch Hours
| Billing Hours and Amounts | Date | |||||||||||||
| Calls Closed During March | ||||||||||||||
| CallID | Customer ID | Customer Name | CallTypeID | Call Type Name | Rate | Opened Date | Closed Date | Days Open | Hours Logged | Amount Billed | Summary Statistics | |||
| 049 | PC041 | 3 | Network Troubleshooting | 3/3/21 | 3/13/21 | 10 | 12.50 | Total Hours Logged | ||||||
| 064 | PC041 | 4 | Network Installation | 3/13/21 | 3/17/21 | 4 | 2.50 | Total Amount Billed | ||||||
| 048 | PC041 | 6 | Security Camera Maintenance | 3/3/21 | 3/10/21 | 7 | 1.25 | Average Days Open | ||||||
| 045 | PC041 | 7 | Virus Removal | 2/27/21 | 3/4/21 | 5 | 2.50 | Shortest # of Days Open | ||||||
| 047 | PC048 | 1 | Hardware Support | 3/2/21 | 3/6/21 | 4 | 4.50 | Longest # Days Open | ||||||
| 056 | PC028 | 3 | Network Troubleshooting | 3/6/21 | 3/13/21 | 7 | 9.75 | |||||||
| 055 | PC038 | 5 | Training | 3/6/21 | 3/8/21 | 2 | 9.25 | Parameters | ||||||
| 061 | PC038 | 8 | Disaster Recovery | 3/8/21 | 3/14/21 | 6 | 6.25 | Hours Threshold | 10.00 | |||||
| 060 | PC044 | 5 | Training | 3/8/21 | 3/11/21 | 3 | 2.25 | Premium Billing | $ 100.00 | |||||
| 068 | PC044 | 5 | Training | 3/19/21 | 3/21/21 | 2 | 1.50 | |||||||
| 063 | PC044 | 9 | VoIP Service | 3/12/21 | 3/15/21 | 3 | 1.50 | |||||||
| 069 | PC044 | 10 | Other | 3/22/21 | 3/31/21 | 9 | 5.25 | |||||||
| 054 | PC040 | 3 | Network Troubleshooting | 3/5/21 | 3/13/21 | 8 | 10.25 | |||||||
| 050 | PC035 | 7 | Virus Removal | 3/4/21 | 3/12/21 | 8 | 12.00 | |||||||
| 039 | PC035 | 10 | Other | 2/21/21 | 3/3/21 | 10 | 6.75 | |||||||
| 065 | PC017 | 2 | Software Support | 3/13/21 | 3/21/21 | 8 | 10.75 | |||||||
| 053 | PC017 | 4 | Network Installation | 3/5/21 | 3/13/21 | 8 | 9.50 | |||||||
| 046 | PC012 | 5 | Training | 2/28/21 | 3/5/21 | 5 | 10.00 | |||||||
| 044 | PC031 | 7 | Virus Removal | 2/25/21 | 3/1/21 | 4 | 12.50 | |||||||
| 051 | PC029 | 7 | Virus Removal | 3/4/21 | 3/12/21 | 8 | 8.00 | |||||||
| 058 | PC004 | 1 | Hardware Support | 3/8/21 | 3/10/21 | 2 | 1.75 | |||||||
| 067 | PC007 | 1 | Hardware Support | 3/17/21 | 3/19/21 | 2 | 7.25 | |||||||
| 073 | PC007 | 8 | Disaster Recovery | 3/26/21 | 3/31/21 | 5 | 5.00 | |||||||
| 052 | PC001 | 2 | Software Support | 3/4/21 | 3/9/21 | 5 | 1.25 | |||||||
| 038 | PC001 | 10 | Other | 2/19/21 | 3/2/21 | 11 | 3.75 | |||||||
| 057 | PC018 | 1 | Hardware Support | 3/7/21 | 3/10/21 | 3 | 2.00 | |||||||
| 059 | PC018 | 3 | Network Troubleshooting | 3/8/21 | 3/17/21 | 9 | 6.25 | |||||||
| 040 | PC027 | 5 | Training | 2/22/21 | 3/3/21 | 9 | 10.75 | |||||||
| 066 | PC027 | 6 | Security Camera Maintenance | 3/14/21 | 3/24/21 | 10 | 6.00 | |||||||
| 041 | PC027 | 8 | Disaster Recovery | 2/23/21 | 3/6/21 | 11 | 5.00 | |||||||
| 077 | PC027 | 8 | Disaster Recovery | 3/29/21 | 3/31/21 | 2 | 5.00 | |||||||
| 062 | PC052 | 7 | Virus Removal | 3/12/21 | 3/14/21 | 2 | 10.75 |
Customers
| CustomerID | Company Name | Address | City | State | Zip | Phone |
| PC001 | SVC Pharmacy | 163 Bannister Drive | Newark | DE | 19718 | 351-490-9677 |
| PC004 | Monday's Restaurant | 268 Mendocino Circle | Newark | DE | 19711 | 857-610-2424 |
| PC007 | Penny's Arcade | 63 Mc Rae Road | Wilmington | DE | 19802 | 327-729-5558 |
| PC009 | The Home Store | 367 Meadow Road | Wilmington | DE | 19802 | 711-826-1561 |
| PC012 | Grahame Tax Service | 848 Brookridge Circle | Newark | DE | 19702 | 950-660-7078 |
| PC016 | Supermercado | 110 Robin Drive | Wilmington | DE | 19801 | 300-272-8352 |
| PC017 | Graber Dentistry | 466 Cedrus Circle | Wilmington | DE | 19894 | 959-373-6764 |
| PC018 | The Trophy Factory | 256 Gorsuch Street | Wilmington | DE | 19802 | 300-255-8297 |
| PC020 | Wild Bill's Office Superstore | 101 Jacque Circle | Wilmington | DE | 19802 | 958-759-8665 |
| PC023 | City Movie Superplex | 109 Icefall Drive | Delaware City | DE | 19706 | 998-368-2385 |
| PC027 | Wilmington Motor Vehicles | 564 Pilgrim Drive | Wilmington | DE | 19802 | 959-730-6633 |
| PC028 | Cuddyer & Tejada Law Offices | 897 Ronny Place | New Castle | DE | 19721 | 833-310-1435 |
| PC029 | JobSource | 360 Icefall Drive | Newark | DE | 19718 | 976-517-8180 |
| PC031 | Homer's CyberCafe | 1068 South Tug Road | Newark | DE | 19712 | 327-292-6210 |
| PC035 | Fountains of Odessa | 259 Roger Graves Road | Odessa | DE | 19730 | 959-781-4850 |
| PC038 | Dr. Jennifer Lynn | 986 Colusa Circle | Wilmington | DE | 19802 | 327-580-9607 |
| PC040 | Fabrics and More | 218 Snug Harbor Circle | Wilmington | DE | 19802 | 833-330-8520 |
| PC041 | Betagraphics | 990 Geese Circle | Newark | DE | 19714 | 830-526-3278 |
| PC044 | Dr. Lorenzo Reyes | 549 Main Street | Wilmington | DE | 19802 | 600-723-7818 |
| PC045 | Yelbir Credit Union | 319 Koine Circle | Wilmington | DE | 19802 | 424-334-1571 |
| PC048 | Blue Moon Day Spa | 141 Snowshoe Lane | Wilmington | DE | 19802 | 857-338-6470 |
| PC052 | Zapatos | 1128 Gum Street | Wilmington | DE | 19802 | 833-932-2594 |
Rates
| CallTypeID | Description | Hourly Rate |
| 1 | Hardware Support | $ 35 |
| 2 | Software Support | $ 30 |
| 3 | Network Troubleshooting | $ 40 |
| 4 | Network Installation | $ 45 |
| 5 | Training | $ 55 |
| 6 | Security Camera Maintenance | $ 35 |
| 7 | Virus Removal | $ 35 |
| 8 | Disaster Recovery | $ 65 |
| 9 | VoIP Service | $ 50 |
| 10 | Other | $ 40 |
