Excel Midterm
Raymonds1996
Lastname_Firstname--REDOMIDTERM.xlsxInstructions
| Instructions |
| This file is for Exam 1 ("Midterm"), ISM 3011, Spring 2018 |
| * Make sure you have not opened this file on Blackboard. You must download it to your hard drive or flash drive before you open it. |
| * Change the filename to your own, legal, lastname and firstname. If you do not do this, you will lose 3 points on the exam. |
| In the blue cells, |
| Type your: |
| Legal Name: |
| Panther ID: |
| Today's Date: |
| Exam Start Time: |
| The problems you are to implement are on the following worksheets. |
| 5123412 |
Multiple Choice
| Question | Response |
| #2 | |
| #3 | |
| #6 | |
| #7 | |
| #12 | |
Problem Sheet A
| Total Charges for All Service Calls (without tax): | Lookup Table | ||||||||
| Total Charges for All Service Calls (with tax): | Code | Status | |||||||
| 1 | Non-Government | ||||||||
| 2 | Government | ||||||||
| Customer | Last Service Date | Base Fee | Service Hours | Hourly Rate | Total Cost (w/o tax) | Gov't Code | Gov't Contract? | Tax Rate | Total Cost (with tax) |
| Aase, Jason | 8/22/12 | $ 43.20 | 11.2 | $ 16.55 | 1 | 7% | |||
| Adams, Aaron | 8/20/12 | $ 21.33 | 8.4 | $ 28.41 | 1 | ||||
| Alderks, David | 8/19/12 | $ 41.55 | 5.5 | $ 29.06 | 1 | ||||
| Alexander, Velinda | 8/7/12 | $ 31.67 | 10.8 | $ 25.30 | 1 | ||||
| Anderson, Alvin | 8/23/12 | $ 44.10 | 7.6 | $ 14.73 | 1 | ||||
| Anderson, Katherine | 8/17/12 | $ 26.02 | 7.9 | $ 28.87 | 1 | ||||
| Baker, Jean | 8/20/12 | $ 33.85 | 7.8 | $ 11.63 | 1 | ||||
| Barr, Deborah | 8/31/12 | $ 36.86 | 10.9 | $ 11.76 | 1 | ||||
| Bartlett, Emily | 8/15/12 | $ 31.60 | 11.9 | $ 17.41 | 1 | ||||
| Baxter, Nichelle | 8/20/12 | $ 28.96 | 3.6 | $ 28.05 | 1 | ||||
| Beier, Deborah | 8/12/12 | $ 37.97 | 7.9 | $ 16.70 | 1 | ||||
| Bexfield, Christopher | 8/11/12 | $ 29.82 | 10.3 | $ 15.53 | 1 | ||||
| Bills, Tamara | 8/3/12 | $ 27.46 | 10.5 | $ 30.91 | 1 | ||||
| Black, Brian | 8/20/12 | $ 34.49 | 9 | $ 29.37 | 1 | ||||
| Blatter, Therron | 8/29/12 | $ 42.96 | 3.3 | $ 30.35 | 1 | ||||
| Blaylock, Glenn | 8/21/12 | $ 37.80 | 11.5 | $ 23.02 | 1 | ||||
| Bradfield, Todd | 8/5/12 | $ 21.25 | 1.7 | $ 25.70 | 1 | ||||
| Bray, E. Lee | 8/5/12 | $ 27.34 | 4.2 | $ 25.62 | 1 | ||||
| Briggs, Kristen | 8/29/12 | $ 29.29 | 4.8 | $ 27.48 | 1 | ||||
| Brinkerhoff, Alonzo | 8/31/12 | $ 26.99 | 4.1 | $ 19.46 | 1 | ||||
| Bushman, Michelle | 8/22/12 | $ 21.90 | 7.5 | $ 13.64 | 1 | ||||
| Call, Lisa | 8/29/12 | $ 43.23 | 8.3 | $ 16.92 | 1 | ||||
| Carling, Gregory | 8/10/12 | $ 23.13 | 2.1 | $ 12.90 | 1 | ||||
| Chandler, Matthew | 8/17/12 | $ 29.74 | 1.5 | $ 26.14 | 1 | ||||
| Christiansen, David | 8/23/12 | $ 27.10 | 9.4 | $ 27.11 | 1 | ||||
| Curtice, Brian | 8/18/12 | $ 23.14 | 6.4 | $ 27.79 | 1 | ||||
| Dangerfield, Anne | 8/6/12 | $ 42.94 | 3 | $ 13.33 | 1 | ||||
| Dewey, John | 8/29/12 | $ 35.85 | 6.6 | $ 28.10 | 1 | ||||
| Diazconti, Concepcion | 8/5/12 | $ 37.03 | 7 | $ 12.02 | 1 | ||||
| Durrant, Camille | 8/12/12 | $ 43.10 | 10.4 | $ 20.09 | 1 | ||||
| Dutson, Sarah | 8/29/12 | $ 32.34 | 11.8 | $ 27.49 | 1 | ||||
| Eddleman, James | 8/25/12 | $ 34.66 | 8.1 | $ 25.00 | 1 | ||||
| Flamm, Douglas Scott | 8/19/12 | $ 21.06 | 2 | $ 25.33 | 1 | ||||
| Floyd, Andrew | 8/25/12 | $ 41.68 | 4.2 | $ 16.73 | 1 | ||||
| Garner, Ann | 8/24/12 | $ 30.07 | 8 | $ 20.93 | 1 | ||||
| Gibbs, Todd | 8/28/12 | $ 35.61 | 6.3 | $ 24.55 | 1 | ||||
| Gillespie, Jeremy | 8/28/12 | $ 27.88 | 6 | $ 17.74 | 1 | ||||
| Greenhalgh, Brent | 8/5/12 | $ 37.08 | 8.7 | $ 11.01 | 1 | ||||
| Haddox, David | 8/16/12 | $ 39.11 | 9.6 | $ 28.08 | 1 | ||||
| HaeHae, P. Kevin | 8/28/12 | $ 21.57 | 6.6 | $ 13.06 | 1 | ||||
| Hamaker, Sandra | 8/2/12 | $ 43.38 | 2.2 | $ 19.73 | 1 | ||||
| Hansen, Ashley | 8/27/12 | $ 25.80 | 11.8 | $ 13.91 | 1 | ||||
| Harper, Matthew | 8/21/12 | $ 26.04 | 2.8 | $ 25.03 | 1 | ||||
| Harris, William B. | 8/12/12 | $ 40.19 | 4.5 | $ 28.26 | 1 | ||||
| Hart, Garrett | 8/19/12 | $ 21.97 | 2.9 | $ 27.25 | 1 | ||||
| Hash, Stephan | 8/13/12 | $ 20.77 | 6.5 | $ 16.04 | 1 | ||||
| Hebertson, Gregory | 8/8/12 | $ 36.02 | 2.3 | $ 19.73 | 1 | ||||
| Henderson, Rachel | 8/23/12 | $ 40.96 | 8.4 | $ 22.05 | 1 | ||||
| Herron, David | 8/18/12 | $ 28.91 | 2.3 | $ 12.05 | 1 | ||||
| Holdaway, Bradley | 8/7/12 | $ 32.59 | 3.9 | $ 10.96 | 1 | ||||
| Holman, Laura S | 8/12/12 | $ 34.07 | 8.3 | $ 15.75 | 1 | ||||
| Howland, Shiloh M. James | 8/10/12 | $ 39.57 | 11.9 | $ 25.93 | 1 | ||||
| Hu, Nan | 8/27/12 | $ 30.84 | 3.4 | $ 30.49 | 1 | ||||
| Jacobson, Cecil | 8/28/12 | $ 34.66 | 11.8 | $ 29.33 | 1 | ||||
| Jefferies, Vincent | 8/19/12 | $ 33.44 | 11.9 | $ 15.01 | 1 | ||||
| Jensen, Paul | 8/13/12 | $ 38.29 | 4 | $ 25.81 | 1 | ||||
| Jordan, Benjamin | 8/27/12 | $ 44.96 | 8 | $ 14.12 | 1 | ||||
| Kass, Michael | 8/6/12 | $ 21.19 | 11.1 | $ 23.16 | 1 | ||||
| Kelson, Chris | 8/9/12 | $ 37.65 | 2.1 | $ 24.35 | 1 | ||||
| Ladle, Garth | 8/7/12 | $ 37.59 | 5 | $ 20.21 | 1 | ||||
| Larsen, Norbert | 8/23/12 | $ 31.20 | 7.5 | $ 10.60 | 1 | ||||
| Larson, Susan | 8/28/12 | $ 30.55 | 2.2 | $ 29.38 | 1 | ||||
| Leavitt, Aaron | 8/14/12 | $ 24.92 | 3.2 | $ 22.21 | 1 | ||||
| Li, Yaping | 8/1/12 | $ 26.66 | 3.6 | $ 27.93 | 1 | ||||
| Long, Michael | 8/4/12 | $ 26.53 | 7.9 | $ 30.12 | 1 | ||||
| Loucks, Mark D. | 8/1/12 | $ 24.92 | 6.8 | $ 18.45 | 1 | ||||
| Lusk, Mary | 8/3/12 | $ 20.11 | 9.6 | $ 27.18 | 1 | ||||
| Luthi, Allen | 8/10/12 | $ 21.16 | 8.3 | $ 22.98 | 1 | ||||
| Lyman, Jared | 8/28/12 | $ 40.68 | 5.1 | $ 30.52 | 1 | ||||
| Lyman, Jeanette | 8/15/12 | $ 30.36 | 5 | $ 17.08 | 1 | ||||
| Manning, Vicky | 8/3/12 | $ 31.37 | 6.5 | $ 20.72 | 1 | ||||
| Marino, Jorge | 8/24/12 | $ 42.08 | 6.6 | $ 30.31 | 2 | ||||
| Martin, Daniel | 8/16/12 | $ 20.27 | 9.1 | $ 24.53 | 2 | ||||
| Maughan, Larissa | 8/27/12 | $ 40.91 | 2.5 | $ 29.29 | 1 | ||||
| Maughan, Terry | 8/29/12 | $ 43.61 | 7 | $ 23.49 | 1 | ||||
| McLeod, Robert | 8/24/12 | $ 43.16 | 6.4 | $ 13.15 | 1 | ||||
| Mercer, Lonnie | 8/17/12 | $ 40.13 | 2.8 | $ 23.78 | 1 | ||||
| Miller, James | 8/13/12 | $ 34.11 | 8.1 | $ 12.00 | 1 | ||||
| Miner, Reed Evan | 8/10/12 | $ 36.37 | 2.7 | $ 28.03 | 1 | ||||
| Mitchell, Scott | 8/14/12 | $ 23.60 | 11.7 | $ 27.32 | 1 | ||||
| Monn, Will | 8/9/12 | $ 34.90 | 11.4 | $ 25.42 | 1 | ||||
| Moore, Daniel | 8/22/12 | $ 37.44 | 4.3 | $ 24.49 | 1 | ||||
| Mustoe, Nathan | 8/25/12 | $ 21.53 | 3.9 | $ 25.10 | 1 | ||||
| Nelson, Wendy | 8/3/12 | $ 43.57 | 8.7 | $ 23.44 | 2 | ||||
| Nicholls, Mark | 8/21/12 | $ 34.88 | 4 | $ 30.32 | 1 | ||||
| Nielson, Dru R. | 8/24/12 | $ 26.62 | 7.1 | $ 28.66 | 1 | ||||
| Nix, Tamara | 8/13/12 | $ 29.18 | 5.3 | $ 12.58 | 1 | ||||
| Nugroho, Hendro | 8/19/12 | $ 30.99 | 3.5 | $ 15.19 | 1 | ||||
| Okure, Maxwell | 8/5/12 | $ 21.10 | 8.8 | $ 23.16 | 1 | ||||
| O'Neal, Ryan | 8/5/12 | $ 39.49 | 8.1 | $ 23.30 | 1 | ||||
| Onohuome Okojie-Ayoro, Anita | 8/21/12 | $ 36.72 | 11.2 | $ 21.10 | 1 | ||||
| Osborn, Caleb | 8/28/12 | $ 41.63 | 6.7 | $ 15.84 | 1 | ||||
| Outdoor Hunter, Elizabeth Adele | 8/15/12 | $ 27.81 | 2.5 | $ 13.59 | 1 | ||||
| Payne, Kelly | 8/13/12 | $ 37.16 | 9.9 | $ 17.73 | 1 | ||||
| Peltier, Stephen | 8/24/12 | $ 21.94 | 6.1 | $ 21.46 | 1 | ||||
| Petersen, Erik | 8/1/12 | $ 29.20 | 6.4 | $ 15.52 | 1 | ||||
| Petersen, Mark | 8/15/12 | $ 43.90 | 2.6 | $ 22.59 | 1 | ||||
| Pett, Teresa | 8/22/12 | $ 36.29 | 3.7 | $ 22.71 | 1 | ||||
| Pulsipher, Tamalyn | 8/7/12 | $ 29.06 | 4.8 | $ 17.83 | 1 | ||||
| Puvvada, George | 8/4/12 | $ 28.95 | 4.7 | $ 23.41 | 1 | ||||
| Radebaugh, Jani | 8/19/12 | $ 37.91 | 6.6 | $ 27.00 | 1 | ||||
| Radke, Lisa | 8/17/12 | $ 33.54 | 10.2 | $ 26.92 | 1 | ||||
| Radke, Lyle | 8/22/12 | $ 22.90 | 11.3 | $ 27.99 | 2 | ||||
| Richardson, Paul | 8/13/12 | $ 42.02 | 12 | $ 13.94 | 1 | ||||
| Richmond, Dean | 8/8/12 | $ 31.96 | 10.1 | $ 16.78 | 1 | ||||
| Robeck, Eric | 8/28/12 | $ 41.41 | 11.4 | $ 22.37 | 1 | ||||
| Robinson Ty | 8/20/12 | $ 43.82 | 10 | $ 18.65 | 1 | ||||
| Roosmawati, Nova | 8/6/12 | $ 26.30 | 11.2 | $ 22.18 | 1 | ||||
| Rufolo, Scott | 8/25/12 | $ 42.06 | 6 | $ 11.10 | 1 | ||||
| Ryskamp, Elizabeth | 8/23/12 | $ 21.61 | 3.9 | $ 21.95 | 1 | ||||
| Sandau, Stephen | 8/4/12 | $ 24.88 | 2.2 | $ 14.16 | 1 | ||||
| Shaw, Allen | 8/20/12 | $ 24.18 | 6.1 | $ 16.65 | 1 | ||||
| Shoore, David J | 8/12/12 | $ 27.94 | 5.5 | $ 27.96 | 1 | ||||
| Shrum, Daniel | 8/8/12 | $ 41.77 | 10.9 | $ 27.90 | 1 | ||||
| Skinner, Randal | 8/2/12 | $ 22.52 | 11 | $ 24.32 | 1 | ||||
| Smouse, Deforrest | 8/29/12 | $ 30.69 | 10.8 | $ 20.98 | 1 | ||||
| Sorber, Samuel | 8/19/12 | $ 29.74 | 3.7 | $ 16.19 | 1 | ||||
| South, John | 8/21/12 | $ 41.28 | 2.5 | $ 30.23 | 1 | ||||
| Stavast, William | 8/28/12 | $ 38.19 | 6.8 | $ 11.50 | 1 | ||||
| Stubben, Melissa | 8/7/12 | $ 42.11 | 6.8 | $ 22.83 | 1 | ||||
| Tarbet, Melissa Eileen Schlegel | 8/19/12 | $ 33.15 | 7.9 | $ 20.17 | 1 | ||||
| Thomas, Briana | 8/15/12 | $ 35.04 | 3.6 | $ 27.79 | 1 | ||||
| Thompson, Timothy | 8/28/12 | $ 44.41 | 11.7 | $ 12.06 | 1 | ||||
| Tingey, Brady | 8/23/12 | $ 39.19 | 6.1 | $ 27.08 | 1 | ||||
| Titus, Thomas | 8/14/12 | $ 27.78 | 3.9 | $ 23.33 | 1 | ||||
| Tomlinson, David | 8/29/12 | $ 37.12 | 9.5 | $ 26.52 | 1 | ||||
| Vorkink, Michael | 8/31/12 | $ 36.61 | 10.2 | $ 23.80 | 1 | ||||
| Waite, Kimberly | 8/29/12 | $ 37.70 | 5.4 | $ 12.72 | 1 | ||||
| Wald, Laura | 8/29/12 | $ 35.51 | 2.4 | $ 12.54 | 1 | ||||
| Ward, Stephen | 8/29/12 | $ 40.31 | 11.1 | $ 17.74 | 1 | ||||
| Webber, William | 8/2/12 | $ 21.39 | 3.7 | $ 12.23 | 1 | ||||
| Wegner, Marybeth | 8/16/12 | $ 24.40 | 1.7 | $ 26.69 | 1 | ||||
| Wilhite, Ray | 8/10/12 | $ 41.14 | 5.6 | $ 21.05 | 1 | ||||
| Wood, M. Jay | 8/12/12 | $ 38.16 | 4.1 | $ 28.70 | 1 | ||||
| Wu, Jie | 8/17/12 | $ 32.68 | 5.6 | $ 25.58 | 1 | ||||
| Xiaofen, Ren | 8/22/12 | $ 25.80 | 6.6 | $ 22.35 | 1 | ||||
| Young, George | 8/14/12 | $ 27.17 | 7.3 | $ 20.94 | 1 | ||||
| Zentner, Matthew | 8/4/12 | $ 28.66 | 11.5 | $ 15.01 | 1 | ||||
| Zhang, Chengning | 8/14/12 | $ 29.84 | 5.3 | $ 23.32 | 1 | ||||
Problem Sheet B
| Year | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 |
| Tuxedos | $ 6,012.00 | $ 6,645.00 | $ 6,945.00 | $ 7,012.00 | $ 7,559.00 | $ 8,264.00 |
| Men's Suits | $ 6,377.00 | $ 7,518.00 | $ 7,520.00 | $ 6,824.00 | $ 6,942.00 | $ 7,301.00 |
| Sportswear | $ 6,884.00 | $ 5,035.00 | $ 5,739.00 | $ 5,292.00 | $ 5,494.00 | $ 5,717.00 |
| Shoes | $ 5,264.00 | $ 3,585.00 | $ 3,363.00 | $ 5,597.00 | $ 3,296.00 | $ 5,447.00 |
| Outerwear | $ 11,841.00 | $ 12,048.00 | $ 12,438.00 | $ 14,210.00 | $ 14,323.00 | $ 14,244.00 |
