Chapter 4 Running Case Portfolio
danevia
SpreadsheetChapter4bethell_e04r1NCCTS.xlsxMarch Hours
| Billing Hours and Amounts | ||||||||||
| Calls Closed During March | ||||||||||
| Call ID | Customer ID | Customer Name | Call Type ID | Call Type | Rate | Opened Date | Closed Date | Days Open | Hours Logged | Amount Billed |
| 038 | PC001 | SVC Pharmacy | 10 | Other | $ 40 | 2/19/21 | 3/2/21 | 11 | 3.75 | $ 150.00 |
| 039 | PC035 | Fountains of Odessa | 10 | Other | $ 40 | 2/21/21 | 3/3/21 | 10 | 6.75 | $ 270.00 |
| 040 | PC027 | Wilmington Motor Vehicles | 5 | Training | $ 55 | 2/22/21 | 3/3/21 | 9 | 10.75 | $ 691.25 |
| 041 | PC027 | Wilmington Motor Vehicles | 8 | Software Support | $ 65 | 2/23/21 | 3/6/21 | 11 | 5.00 | $ 325.00 |
| 044 | PC031 | Homer's CyberCafe | 7 | Virus Removal | $ 35 | 2/25/21 | 3/1/21 | 4 | 12.50 | $ 537.50 |
| 045 | PC041 | Betagraphics | 7 | Virus Removal | $ 35 | 2/27/21 | 3/4/21 | 5 | 2.50 | $ 87.50 |
| 046 | PC012 | Grahame Tax Service | 5 | Software Support | $ 55 | 2/28/21 | 3/5/21 | 15 | 10.00 | $ 550.00 |
| 047 | PC048 | Blue Moon Day Spa | 1 | Hardware Support | $ 35 | 3/2/21 | 3/6/21 | 4 | 4.50 | $ 157.50 |
| 048 | PC041 | Betagraphics | 6 | Security Camera Maintenance | $ 35 | 3/3/21 | 3/10/21 | 7 | 1.25 | $ 43.75 |
| 049 | PC041 | Betagraphics | 3 | Other | $ 40 | 3/3/21 | 3/13/21 | 10 | 12.50 | $ 600.00 |
| 050 | PC035 | Fountains of Odessa | 7 | Virus Removal | $ 35 | 3/4/21 | 3/12/21 | 8 | 12.00 | $ 520.00 |
| 051 | PC029 | JobSource | 7 | Virus Removal | $ 35 | 3/4/21 | 3/12/21 | 8 | 8.00 | $ 280.00 |
| 052 | PC001 | SVC Pharmacy | 2 | Software Support | $ 30 | 3/4/21 | 3/9/21 | 5 | 1.25 | $ 37.50 |
| 053 | PC017 | Graber Dentistry | 4 | Network Installation | $ 45 | 3/5/21 | 3/13/21 | 8 | 9.50 | $ 427.50 |
| 054 | PC040 | Fabrics and More | 3 | Network Troubleshooting | $ 40 | 3/5/21 | 3/13/21 | 8 | 10.25 | $ 510.00 |
| 055 | PC038 | Dr. Jennifer Lynn | 5 | Training | $ 55 | 3/6/21 | 3/8/21 | 2 | 9.25 | $ 508.75 |
| 056 | PC028 | Cuddyer & Tejada Law Offices | 3 | Network Troubleshooting | $ 40 | 3/6/21 | 3/13/21 | 7 | 9.75 | $ 390.00 |
| 057 | PC018 | The Trophy Factory | 1 | Hardware Support | $ 35 | 3/7/21 | 3/10/21 | 3 | 2.00 | $ 70.00 |
| 058 | PC004 | Monday's Restaurant | 1 | Hardware Support | $ 35 | 3/8/21 | 3/10/21 | 2 | 1.75 | $ 61.25 |
| 059 | PC018 | The Trophy Factory | 3 | Other | $ 40 | 3/8/21 | 3/17/21 | 9 | 6.25 | $ 250.00 |
| 060 | PC044 | Dr. Lorenzo Reyes | 5 | Training | $ 55 | 3/8/21 | 3/11/21 | 3 | 2.25 | $ 123.75 |
| 061 | PC038 | Dr. Jennifer Lynn | 8 | Disaster Recovery | $ 65 | 3/8/21 | 3/14/21 | 6 | 6.25 | $ 406.25 |
| 062 | PC052 | Zapatos | 7 | Virus Removal | $ 35 | 3/12/21 | 3/14/21 | 2 | 10.75 | $ 476.25 |
| 063 | PC044 | Dr. Lorenzo Reyes | 9 | VoIP Service | $ 50 | 3/12/21 | 3/15/21 | 3 | 1.50 | $ 75.00 |
| 064 | PC041 | Betagraphics | 4 | Network Installation | $ 45 | 3/13/21 | 3/17/21 | 4 | 2.50 | $ 112.50 |
| 065 | PC017 | Graber Dentistry | 2 | Software Support | $ 30 | 3/13/21 | 3/21/21 | 8 | 10.75 | $ 422.50 |
| 066 | PC027 | Wilmington Motor Vehicles | 6 | Security Camera Maintenance | $ 35 | 3/14/21 | 3/24/21 | 10 | 6.00 | $ 210.00 |
| 067 | PC007 | Penny's Arcade | 1 | Hardware Support | $ 35 | 3/17/21 | 3/19/21 | 2 | 7.25 | $ 253.75 |
| 068 | PC044 | Dr. Lorenzo Reyes | 5 | Training | $ 55 | 3/19/21 | 3/21/21 | 2 | 1.50 | $ 82.50 |
| 069 | PC044 | Dr. Lorenzo Reyes | 10 | Software Support | $ 40 | 3/22/21 | 3/31/21 | 9 | 5.25 | $ 210.00 |
| 073 | PC007 | Penny's Arcade | 8 | Disaster Recovery | $ 65 | 3/26/21 | 3/31/21 | 5 | 5.00 | $ 325.00 |
| 077 | PC027 | Wilmington Motor Vehicles | 8 | Disaster Recovery | $ 65 | 3/29/21 | 3/31/21 | 2 | 5.00 | $ 325.00 |
| 078 | PC041 | Betagraphics | 5 | Training | $ 55 | 4/1/21 | 4/3/21 | 2 | 7.50 | $ 412.50 |
| 079 | PC018 | The Trophy Factory | 3 | Network Troubleshooting | $ 40 | 4/4/21 | 4/8/21 | 4 | 32.00 | $ 1,380.00 |
| 080 | PC001 | SVC Pharmacy | 7 | Virus Removal | $ 35 | 4/4/21 | 4/6/21 | 2 | 10.75 | $ 476.25 |
March Filtered
| Billing Hours and Amounts | ||||||||||
| Calls Closed During March | ||||||||||
| Call ID | Customer ID | Customer Name | Call Type ID | Call Type | Rate | Opened Date | Closed Date | Days Open | Hours Logged | Amount Billed |
| 038 | PC001 | SVC Pharmacy | 10 | Other | $ 40 | 2/19/21 | 3/2/21 | 11 | 3.75 | $ 150.00 |
| 039 | PC035 | Fountains of Odessa | 10 | Other | $ 40 | 2/21/21 | 3/3/21 | 10 | 6.75 | $ 270.00 |
| 040 | PC027 | Wilmington Motor Vehicles | 5 | Training | $ 55 | 2/22/21 | 3/3/21 | 9 | 10.75 | $ 691.25 |
| 041 | PC027 | Wilmington Motor Vehicles | 8 | Software Support | $ 65 | 2/23/21 | 3/6/21 | 11 | 5.00 | $ 325.00 |
| 044 | PC031 | Homer's CyberCafe | 7 | Virus Removal | $ 35 | 2/25/21 | 3/1/21 | 4 | 12.50 | $ 537.50 |
| 045 | PC041 | Betagraphics | 7 | Virus Removal | $ 35 | 2/27/21 | 3/4/21 | 5 | 2.50 | $ 87.50 |
| 046 | PC012 | Grahame Tax Service | 5 | Software Support | $ 55 | 2/28/21 | 3/5/21 | 15 | 10.00 | $ 550.00 |
| 047 | PC048 | Blue Moon Day Spa | 1 | Hardware Support | $ 35 | 3/2/21 | 3/6/21 | 4 | 4.50 | $ 157.50 |
| 049 | PC041 | Betagraphics | 3 | Other | $ 40 | 3/3/21 | 3/13/21 | 10 | 12.50 | $ 600.00 |
| 048 | PC041 | Betagraphics | 6 | Security Camera Maintenance | $ 35 | 3/3/21 | 3/10/21 | 7 | 1.25 | $ 43.75 |
| 050 | PC035 | Fountains of Odessa | 7 | Virus Removal | $ 35 | 3/4/21 | 3/12/21 | 8 | 12.00 | $ 520.00 |
| 051 | PC029 | JobSource | 7 | Virus Removal | $ 35 | 3/4/21 | 3/12/21 | 8 | 8.00 | $ 280.00 |
| 052 | PC001 | SVC Pharmacy | 2 | Software Support | $ 30 | 3/4/21 | 3/9/21 | 5 | 1.25 | $ 37.50 |
| 054 | PC040 | Fabrics and More | 3 | Network Troubleshooting | $ 40 | 3/5/21 | 3/13/21 | 8 | 10.25 | $ 510.00 |
| 053 | PC017 | Graber Dentistry | 4 | Network Installation | $ 45 | 3/5/21 | 3/13/21 | 8 | 9.50 | $ 427.50 |
| 056 | PC028 | Cuddyer & Tejada Law Offices | 3 | Network Troubleshooting | $ 40 | 3/6/21 | 3/13/21 | 7 | 9.75 | $ 390.00 |
| 055 | PC038 | Dr. Jennifer Lynn | 5 | Training | $ 55 | 3/6/21 | 3/8/21 | 2 | 9.25 | $ 508.75 |
| 057 | PC018 | The Trophy Factory | 1 | Hardware Support | $ 35 | 3/7/21 | 3/10/21 | 3 | 2.00 | $ 70.00 |
| 061 | PC038 | Dr. Jennifer Lynn | 8 | Disaster Recovery | $ 65 | 3/8/21 | 3/14/21 | 6 | 6.25 | $ 406.25 |
| 060 | PC044 | Dr. Lorenzo Reyes | 5 | Training | $ 55 | 3/8/21 | 3/11/21 | 3 | 2.25 | $ 123.75 |
| 058 | PC004 | Monday's Restaurant | 1 | Hardware Support | $ 35 | 3/8/21 | 3/10/21 | 2 | 1.75 | $ 61.25 |
| 059 | PC018 | The Trophy Factory | 3 | Other | $ 40 | 3/8/21 | 3/17/21 | 9 | 6.25 | $ 250.00 |
| 063 | PC044 | Dr. Lorenzo Reyes | 9 | VoIP Service | $ 50 | 3/12/21 | 3/15/21 | 3 | 1.50 | $ 75.00 |
| 062 | PC052 | Zapatos | 7 | Virus Removal | $ 35 | 3/12/21 | 3/14/21 | 2 | 10.75 | $ 476.25 |
| 064 | PC041 | Betagraphics | 4 | Network Installation | $ 45 | 3/13/21 | 3/17/21 | 4 | 2.50 | $ 112.50 |
| 065 | PC017 | Graber Dentistry | 2 | Software Support | $ 30 | 3/13/21 | 3/21/21 | 8 | 10.75 | $ 422.50 |
| 066 | PC027 | Wilmington Motor Vehicles | 6 | Security Camera Maintenance | $ 35 | 3/14/21 | 3/24/21 | 10 | 6.00 | $ 210.00 |
| 067 | PC007 | Penny's Arcade | 1 | Hardware Support | $ 35 | 3/17/21 | 3/19/21 | 2 | 7.25 | $ 253.75 |
| 068 | PC044 | Dr. Lorenzo Reyes | 5 | Training | $ 55 | 3/19/21 | 3/21/21 | 2 | 1.50 | $ 82.50 |
| 069 | PC044 | Dr. Lorenzo Reyes | 10 | Software Support | $ 40 | 3/22/21 | 3/31/21 | 9 | 5.25 | $ 210.00 |
| 073 | PC007 | Penny's Arcade | 8 | Disaster Recovery | $ 65 | 3/26/21 | 3/31/21 | 5 | 5.00 | $ 325.00 |
| 077 | PC027 | Wilmington Motor Vehicles | 8 | Disaster Recovery | $ 65 | 3/29/21 | 3/31/21 | 2 | 5.00 | $ 325.00 |
| 078 | PC041 | Betagraphics | 5 | Training | $ 55 | 4/1/21 | 4/3/21 | 2 | 7.50 | $ 412.50 |
| 079 | PC018 | The Trophy Factory | 3 | Network Troubleshooting | $ 40 | 4/4/21 | 4/8/21 | 4 | 32.00 | $ 1,380.00 |
| 080 | PC001 | SVC Pharmacy | 7 | Virus Removal | $ 35 | 4/4/21 | 4/6/21 | 2 | 10.75 | $ 476.25 |
Summary Statiscs
| Summary Statistics by Customer | |||
| Customer Name | Total Days Open | Total Hours Logged | Total Amount Billed |
| Betagraphics | 28 | 26.3 | $ 1,256.25 |
| Blue Moon Day Spa | 4 | 4.5 | $ 157.50 |
| Cuddyer & Tejada Law Offices | 7 | 9.8 | $ 390.00 |
| Dr. Jennifer Lynn | 8 | 15.5 | $ 915.00 |
| Dr. Lorenzo Reyes | 17 | 10.5 | $ 491.25 |
| Fabrics and More | 8 | 10.3 | $ 510.00 |
| Fountains of Odessa | 18 | 18.8 | $ 790.00 |
| Graber Dentistry | 16 | 20.3 | $ 850.00 |
| Grahame Tax Service | 15 | 10.0 | $ 550.00 |
| Homer's CyberCafe | 4 | 12.5 | $ 537.50 |
| JobSource | 8 | 8.0 | $ 280.00 |
| Monday's Restaurant | 2 | 1.8 | $ 61.25 |
| Penny's Arcade | 7 | 12.3 | $ 578.75 |
| SVC Pharmacy | 18 | 15.8 | $ 663.75 |
| The Trophy Factory | 16 | 40.3 | $ 1,700.00 |
| Wilmington Motor Vehicles | 32 | 26.8 | $ 1,551.25 |
| Zapatos | 2 | 10.8 | $ 476.25 |
| Summary Statistics by Call Type | |||
| Call Type | Total Days Open | Total Hours Logged | Total Amount Billed |
| Disaster Recovery | 13 | 16.3 | $ 1,056.25 |
| Hardware Support | 11 | 15.5 | $ 542.50 |
| Network Installation | 12 | 12.0 | $ 540.00 |
| Network Troubleshooting | 19 | 52.0 | $ 2,280.00 |
| Other | 40 | 29.3 | $ 1,270.00 |
| Security Camera Maintenance | 17 | 7.3 | $ 253.75 |
| Software Support | 48 | 32.3 | $ 1,545.00 |
| Training | 18 | 31.3 | $ 1,818.75 |
| Virus Removal | 29 | 56.5 | $ 2,377.50 |
| VoIP Service | 3 | 1.5 | $ 75.00 |
| Combined Summary Statistics | |||
| Total Hours Logged | 253.8 | ||
| Total Amount Billed | $ 11,758.75 | ||
| Average Days Open | 20 | ||
| Shortest # of Days Open | 3 | ||
| Longest # of Days Open | 38 |
Summary Charts
Student Name &A &F
Disaster Recovery9%Hardware Support7%Network Installation8%Network Troubleshooting13%Software Support32%Training12%Virus Removal19%Total Days Open by Service Type
$- $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800BetagraphicsBlue Moon Day SpaCuddyer & Tejada Law OfficesDr. Jennifer LynnDr. Lorenzo ReyesFabrics and MoreFountains of OdessaGraber DentistryGrahame Tax ServiceHomer's CyberCafeJobSourceMonday's RestaurantPenny's ArcadeSVC PharmacyThe Trophy FactoryWilmington Motor VehiclesZapatosTotal Amount Billed by Customer
$- $500 $1,000 $1,500 $2,000 $2,5000102030405060Days OpenDays Open vs Amount Billed by Service TypeTotal Days OpenTotal Amount Billed
