Chapter 3 Running Case Portfolio

profiledanevia
SpreadsheetChapter3bethell_e03r1NCCTS.xlsx

March Hours

Billing Hours and Amounts Date
Calls Closed During March 10/7/18 19:59
CallID Customer ID Customer Name CallTypeID Call Type Name 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 Stats

Summary Statistics by Customer Summary Statistics by Call Type Combined Summary Statistics
Total Days Open Total Hours Logged Total Amount Billed Total Days Open Total Hours Logged Total Amount Billed
Betagraphics 28 26.3 $ 1,256.25 Disaster Recovery 13 16.3 $ 1,056.25 Total Hours Logged 253.8
Blue Moon Day Spa 4 4.5 $ 157.50 Hardware Support 11 15.5 $ 542.50 Total Amount Billed $ 11,758.75
Cuddyer & Tejada Law Offices 7 9.8 $ 390.00 Network Installation 12 12.0 $ 540.00 Average Days Open 20
Dr. Jennifer Lynn 8 15.5 $ 915.00 Network Troubleshooting 19 52.0 $ 2,280.00 Shortest # of Days Open 3
Dr. Lorenzo Reyes 17 10.5 $ 491.25 Other 40 29.3 $ 1,270.00 Longest # of Days Open 38
Fabrics and More 8 10.3 $ 510.00 Security Camera Maintenance 17 7.3 $ 253.75
Fountains of Odessa 18 18.8 $ 790.00 Software Support 48 32.3 $ 1,545.00
Graber Dentistry 16 20.3 $ 850.00 Training 18 31.3 $ 1,818.75
Grahame Tax Service 5 10.0 $ 550.00 Virus Removal 29 56.5 $ 2,377.50
Homer's CyberCafe 4 12.5 $ 537.50 VoIP Service 3 1.5 $ 75.00
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 Charts