Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download the spreadsheet Store Sales 2012.xlsx below. Use the data in this spreadsheet for the remainder of the assignment. StoreSales2012.xlsx The formula in cell H2

Download the spreadsheet "Store Sales 2012.xlsx" below. Use the data in this spreadsheet for the remainder of the assignment. StoreSales2012.xlsx The formula in cell H2 contains a referencing error that must be fixed before copying the formula down the column. If the formula were to be copied down the column without making any corrections, which of the following would be true? The formula would always return \"Small\" The formula would always return \"Medium\" The formula would always return \"Large\" The formula would only return \"Large\" or \"Small\" 1 point 2. Assuming you want the formula in H2 to always reference the cell directly to its left, correct the formula. Once the formula is fixed, copy the formula down the column. What is the \"Order Type\" of Order ID 11428, placed on 1/21/2012? Small Medium Large Extra Large 1 point 3. The boss decides that using only 3 levelssmall, medium, and largedoes not give the shipping department enough information. She wants to use the 10 levels shown in Lookup Table 1 (A3:B12). Write a formula in the \"Expanded Order Type\" column to assign the correct type to each order by \"Order Quantity.\" Copy the formula down to all the rows. Based on the layout of Lookup Table 1, should you use a VLOOKUP function or an HLOOKUP function? VLOOKUP HLOOKUP 1 point 4. Using your newly created \"Expanded Order Type\" column, calculate the total \"Sales\" for all orders of \"Medium\" type (rounded to 2 decimal places). Hint: The SUMIF() function is useful here. 5. 1 point The company gives a 1% discount on any Extra Large or larger orders. In the \"Discount\" column, create a formula that returns 0.01 if the \"Expanded Order Type\" is Extra Large, XX Large, or XXX Large, and returns 0 otherwise. You can accomplish this by using a (select all that apply): VLOOKUP formula HLOOKUP formula Nested IF formula IF formula 1 point 6. Create the formula from the previous question and copy the formula down to all the rows. How many orders will have a discount applied? Hint: The COUNTIF() function is useful here. 7. 1 point The \"Sales with Discount\" can be calculated by applying the discount to the original \"Sales\" entry: Sales with Discount = Sales - (Sales * Discount) or Sales with Discount = Sales * (1 - Discount) Create a formula in the \"Sales with Discount\" column and copy it down to all the rows. What is the impact of the discount on total sales in 2012? In other words, what is the difference between the sum of the \"Sales\" and the sum of the \"Sales with Discount\" (rounded to 2 decimal places)? 1 point 8. Currently, customers are responsible for paying the shipping costs. The sales team suggests that customers really dislike paying shipping costs, and that offering \"free shipping\" instead of the 1% discount would likely increase sales. Create a formula for the \"Sales with Free Shipping\" column that subtracts the \"Shipping Cost\" from the \"Sales\" only if the \"Expanded Order Type\" is Extra Large, XX Large, or XXX Large. Copy the formula down to all the rows. What would total 2012 sales have been if the company had offered free shipping instead of the 1% discount (rounded to 2 decimal places)? 9. 1 point How much money would the company have saved in 2012 if it had offered free shipping instead of the 1% discount on Extra Large, XX Large, or XXX Large orders (rounded to 2 decimal places)? 1 point 10. What would 2012 total \"Sales\" have been if the company had offered free shipping on anyorder shipped by Delivery Truck, and no additional discounts (rounded to 2 decimal places)? Lookup Table 1 Order Quantity Type 1 Mini 6 Extra Small 11 Small 16 Small-Medium 21 Medium 26 Medium-Large 31 Large 36 Extra Large 41 XX Large 46 XXX Large Order ID Order Date 51648 1/1/2012 51648 1/1/2012 29030 1/2/2012 54214 1/2/2012 47591 1/2/2012 43494 1/3/2012 10945 1/3/2012 35811 1/3/2012 16164 1/3/2012 16164 1/3/2012 50471 1/3/2012 35811 1/3/2012 16164 1/3/2012 31555 1/4/2012 55011 1/4/2012 7107 1/4/2012 44646 1/4/2012 7107 1/4/2012 31555 1/4/2012 39619 1/4/2012 55011 1/4/2012 7107 1/4/2012 4800 1/5/2012 52516 1/5/2012 10432 1/5/2012 16036 1/5/2012 52516 1/5/2012 16036 1/5/2012 16036 1/5/2012 25442 1/5/2012 4800 1/5/2012 5601 1/5/2012 25442 1/5/2012 13444 1/5/2012 4800 1/5/2012 16036 1/5/2012 56645 1/6/2012 56645 1/6/2012 57698 1/6/2012 57698 1/6/2012 54115 1/7/2012 54115 1/7/2012 45284 1/7/2012 5409 1/8/2012 26818 1/8/2012 54307 1/8/2012 Order Priority Order Quantity Order Type Low 45 Large Low 50 Medium 10 Medium 38 Critical 27 Medium 2 Medium 14 Critical 6 Low 26 Low 26 Low 25 Critical 49 Low 22 Critical 5 Critical 48 Not Specified 3 Low 47 Not Specified 3 Critical 38 Low 15 Critical 18 Not Specified 32 Low 7 High 19 Low 13 Medium 28 High 50 Medium 10 Medium 33 High 32 Low 4 High 10 High 40 High 33 Low 17 Medium 28 Low 46 Low 42 Critical 13 Critical 10 Low 24 Low 39 High 7 Low 11 Not Specified 23 High 41 26818 7042 54307 14726 54307 42886 59456 26818 48704 51424 14820 51424 10053 44033 34662 18275 10053 59969 54786 47879 22663 22663 59969 44036 51970 7783 292 21382 5382 51269 51269 28485 21382 21382 52068 52068 22914 52068 6501 52068 6501 36357 16807 16807 13027 23268 23268 1/8/2012 1/8/2012 1/8/2012 1/8/2012 1/8/2012 1/8/2012 1/8/2012 1/8/2012 1/9/2012 1/9/2012 1/9/2012 1/9/2012 1/10/2012 1/10/2012 1/10/2012 1/10/2012 1/10/2012 1/11/2012 1/11/2012 1/11/2012 1/11/2012 1/11/2012 1/11/2012 1/11/2012 1/11/2012 1/12/2012 1/12/2012 1/12/2012 1/12/2012 1/12/2012 1/12/2012 1/12/2012 1/12/2012 1/12/2012 1/13/2012 1/13/2012 1/13/2012 1/13/2012 1/13/2012 1/13/2012 1/13/2012 1/14/2012 1/15/2012 1/15/2012 1/15/2012 1/16/2012 1/16/2012 Not Specified Medium High Low High Medium Low Not Specified High Not Specified High Not Specified High Critical Critical Low High High Not Specified Critical Low Low High High Not Specified Medium High Critical Low High Critical High Critical Critical Not Specified Not Specified Critical Not Specified High Not Specified High Not Specified Medium Medium Critical High High 5 4 14 15 15 42 30 36 11 5 39 48 44 45 35 25 31 42 30 19 15 35 16 40 1 3 43 27 30 2 20 12 11 21 21 17 30 31 35 47 46 38 48 30 42 14 5 29090 3685 29573 9632 29090 42753 52837 15491 51044 51044 51044 11969 8034 11969 8034 11969 8034 6886 33285 50433 33956 38690 29223 19617 19617 6016 11428 40706 55618 9761 44549 9761 28582 28582 2688 2688 2688 41441 6373 46243 46243 44647 44647 46243 26053 26759 54177 1/16/2012 1/16/2012 1/16/2012 1/16/2012 1/16/2012 1/18/2012 1/18/2012 1/18/2012 1/18/2012 1/18/2012 1/18/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/19/2012 1/20/2012 1/20/2012 1/20/2012 1/20/2012 1/20/2012 1/21/2012 1/21/2012 1/21/2012 1/22/2012 1/22/2012 1/22/2012 1/22/2012 1/22/2012 1/23/2012 1/23/2012 1/23/2012 1/23/2012 1/23/2012 1/24/2012 1/24/2012 1/24/2012 1/24/2012 1/24/2012 1/24/2012 1/25/2012 1/25/2012 Medium Medium Critical Low Medium Medium Critical Medium Low Low Low Not Specified High Not Specified High Not Specified High High High Critical Low Low High Low Low High Medium Medium Medium Not Specified Medium Not Specified Not Specified Not Specified High High High Medium Not Specified Low Low Low Low Low Low Not Specified Critical 24 29 43 33 36 45 32 5 17 26 19 42 31 9 36 16 13 46 5 50 13 28 48 38 3 19 16 40 48 23 5 2 40 45 11 31 7 41 1 1 31 24 47 31 48 30 12 54177 48003 32966 28129 48003 32966 36418 41760 41760 41760 4804 31170 41760 45984 46852 36484 8070 46852 3168 9925 9253 20003 20003 9925 9925 44167 53795 53795 57280 54020 54020 41312 20256 34470 58113 6757 58113 50148 6757 8832 32513 41345 32513 22916 39813 7072 40100 1/25/2012 1/26/2012 1/26/2012 1/26/2012 1/26/2012 1/26/2012 1/27/2012 1/27/2012 1/27/2012 1/27/2012 1/27/2012 1/27/2012 1/27/2012 1/27/2012 1/28/2012 1/28/2012 1/28/2012 1/28/2012 1/29/2012 1/30/2012 1/30/2012 1/30/2012 1/30/2012 1/30/2012 1/30/2012 1/30/2012 1/30/2012 1/30/2012 1/31/2012 1/31/2012 1/31/2012 1/31/2012 1/31/2012 2/1/2012 2/1/2012 2/1/2012 2/1/2012 2/1/2012 2/1/2012 2/2/2012 2/2/2012 2/2/2012 2/2/2012 2/2/2012 2/2/2012 2/4/2012 2/4/2012 Critical Medium Low Medium Medium Low Not Specified Low Low Low High Medium Low Medium Not Specified Critical Medium Not Specified Low Critical Critical Medium Medium Critical Critical Critical High High Medium Low Low Not Specified Low Critical High Medium High Medium Medium Low Low Medium Low Medium Critical Critical Low 25 12 4 5 30 43 33 22 21 40 13 32 7 27 46 41 14 44 14 31 36 39 5 43 17 23 21 40 44 43 35 21 24 31 12 27 48 9 11 39 23 36 40 18 48 29 47 50567 40098 16548 16548 40098 34083 2755 24448 2755 16866 58978 27909 11683 27909 8224 28390 34117 50822 50822 23140 27109 27557 43906 23140 37763 28198 37763 29507 11239 4162 51111 29507 33414 30599 10917 50784 35492 18500 56514 13157 17093 8007 18500 18500 56514 8007 54981 2/5/2012 2/5/2012 2/5/2012 2/5/2012 2/5/2012 2/5/2012 2/6/2012 2/6/2012 2/6/2012 2/6/2012 2/6/2012 2/7/2012 2/7/2012 2/7/2012 2/7/2012 2/7/2012 2/7/2012 2/7/2012 2/7/2012 2/8/2012 2/8/2012 2/8/2012 2/8/2012 2/8/2012 2/8/2012 2/8/2012 2/8/2012 2/9/2012 2/9/2012 2/9/2012 2/9/2012 2/9/2012 2/10/2012 2/10/2012 2/10/2012 2/10/2012 2/10/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 2/11/2012 Medium Low Not Specified Not Specified Low Not Specified Not Specified High Not Specified Not Specified Low Critical Not Specified Critical Not Specified High High Medium Medium High Critical Low High High Not Specified Medium Not Specified Low Critical Low Not Specified Low Not Specified Not Specified Critical High Medium Medium Low Medium Not Specified Low Medium Medium Low Low High 22 46 40 22 50 29 50 46 30 43 13 1 28 47 41 44 45 6 37 16 48 18 50 18 24 50 29 14 33 2 1 41 9 23 14 20 36 30 3 2 50 35 44 30 35 5 31 10593 38661 4199 38661 14272 10593 40772 33184 34211 33184 1154 43203 1537 1154 54053 54053 1154 1154 29473 54371 32292 54371 29473 32292 38052 31106 31106 31106 31106 14212 14212 24775 41830 40065 40065 14240 801 40067 24775 4391 40673 42115 32192 37123 37445 12418 52003 2/12/2012 2/12/2012 2/12/2012 2/12/2012 2/12/2012 2/12/2012 2/13/2012 2/13/2012 2/13/2012 2/13/2012 2/14/2012 2/14/2012 2/14/2012 2/14/2012 2/14/2012 2/14/2012 2/14/2012 2/14/2012 2/15/2012 2/15/2012 2/15/2012 2/15/2012 2/15/2012 2/15/2012 2/15/2012 2/16/2012 2/16/2012 2/16/2012 2/16/2012 2/16/2012 2/16/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/17/2012 2/18/2012 2/18/2012 2/18/2012 2/18/2012 2/18/2012 2/18/2012 High High Critical High Medium High Critical Not Specified Not Specified Not Specified Critical Not Specified Not Specified Critical High High Critical Critical Medium Not Specified Low Not Specified Medium Low Low Low Low Low Low Critical Critical Critical Low High High High Critical Low Critical High Low Critical Not Specified High High Not Specified Low 26 6 43 48 32 27 15 1 15 32 44 32 5 11 34 18 23 7 31 28 49 7 40 1 13 37 7 43 45 8 4 6 42 4 49 24 20 38 15 20 14 21 4 50 37 38 11 52003 42115 35905 26309 39075 5860 1057 12711 12711 6 46466 8388 40132 8388 40132 35392 9281 8388 41921 40132 9281 51239 41921 25314 13668 11776 25637 53221 59075 53026 57157 59075 36257 18950 1282 19332 56261 50721 1282 49954 7653 59204 59204 59204 45317 45317 8035 2/18/2012 2/18/2012 2/19/2012 2/19/2012 2/19/2012 2/19/2012 2/19/2012 2/19/2012 2/19/2012 2/20/2012 2/21/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/23/2012 2/24/2012 2/24/2012 2/24/2012 2/25/2012 2/26/2012 2/26/2012 2/26/2012 2/26/2012 2/26/2012 2/27/2012 2/27/2012 2/27/2012 2/27/2012 2/27/2012 2/27/2012 2/27/2012 2/27/2012 2/27/2012 2/29/2012 2/29/2012 2/29/2012 3/1/2012 3/1/2012 3/1/2012 Low Critical Low Low Not Specified Not Specified Critical Critical Critical Not Specified Medium Low Low Low Low High Critical Low Medium Low Critical Low Medium High Critical Low Not Specified Not Specified Low Low Critical Low High Low Not Specified High Critical High Not Specified Critical Medium Medium Medium Medium Low Low Medium 2 19 20 42 50 12 41 45 32 2 7 39 36 42 26 9 31 37 29 16 24 48 32 43 42 40 12 29 4 35 18 38 43 33 10 46 43 33 26 36 32 7 8 25 36 28 7 56358 33606 56967 58917 27392 58917 47042 50564 21478 384 21478 51489 25767 41666 4230 32902 51489 35968 4230 43296 32902 32902 51489 25767 1925 37188 44199 51559 46404 1925 48322 2240 42437 42437 2240 24677 15044 13991 13991 51876 52645 55651 55651 52645 55651 59586 49602 3/1/2012 3/1/2012 3/2/2012 3/2/2012 3/2/2012 3/2/2012 3/2/2012 3/2/2012 3/2/2012 3/2/2012 3/2/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/3/2012 3/4/2012 3/4/2012 3/4/2012 3/4/2012 3/4/2012 3/4/2012 3/4/2012 3/5/2012 3/5/2012 3/5/2012 3/5/2012 3/5/2012 3/6/2012 3/6/2012 3/6/2012 3/6/2012 3/7/2012 3/7/2012 3/7/2012 3/7/2012 3/7/2012 3/7/2012 3/8/2012 Not Specified High Low High Low High Critical High Low Low Low Critical High Medium Critical High Critical Not Specified Critical Medium High High Critical High Critical Critical Low Low Critical Critical Medium Not Specified Critical Critical Not Specified Low Low High High Critical Low Medium Medium Low Medium Low Not Specified 1 46 17 27 37 3 45 30 33 50 16 5 7 26 18 8 42 21 46 41 23 34 22 15 40 24 12 34 50 7 14 17 43 14 5 44 42 21 24 2 11 41 11 10 2 25 31 31523 31523 51620 22085 2848 22085 2848 42471 16804 53156 16804 51237 24707 55779 7174 24707 42243 2912 46631 42243 2912 44099 17152 23584 32067 44099 29607 35173 35173 20194 43138 2022 43138 14784 27490 53571 19207 17571 21223 21223 17571 19207 21607 52995 55458 4515 18112 3/8/2012 3/8/2012 3/8/2012 3/9/2012 3/9/2012 3/9/2012 3/9/2012 3/9/2012 3/10/2012 3/10/2012 3/10/2012 3/10/2012 3/10/2012 3/10/2012 3/10/2012 3/10/2012 3/11/2012 3/11/2012 3/11/2012 3/11/2012 3/11/2012 3/12/2012 3/12/2012 3/12/2012 3/12/2012 3/12/2012 3/13/2012 3/13/2012 3/13/2012 3/13/2012 3/14/2012 3/14/2012 3/14/2012 3/14/2012 3/14/2012 3/15/2012 3/15/2012 3/15/2012 3/15/2012 3/15/2012 3/15/2012 3/15/2012 3/15/2012 3/15/2012 3/16/2012 3/16/2012 3/16/2012 Low Low Medium Low Critical Low Critical Low High Not Specified High Medium Medium Critical Not Specified Medium Medium Low Not Specified Medium Low Medium High Critical High Medium Medium Not Specified Not Specified High Low Critical Low Medium Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified High Critical Not Specified 19 17 12 27 35 41 8 23 46 47 36 26 3 26 10 14 19 9 39 42 7 34 32 14 27 19 20 29 13 10 43 45 50 43 18 21 23 32 8 3 50 11 17 8 32 7 13 55458 55268 49953 24672 49953 24672 11202 24672 322 322 26660 1856 24865 1856 324 54534 1856 58051 55073 26535 30051 49510 31586 4705 31586 29926 9826 11301 44261 49634 44261 12352 15616 29921 44261 44261 3973 7941 38853 15616 49634 39655 49634 9794 59491 59491 5473 3/16/2012 3/17/2012 3/17/2012 3/17/2012 3/17/2012 3/17/2012 3/17/2012 3/17/2012 3/18/2012 3/18/2012 3/18/2012 3/19/2012 3/19/2012 3/19/2012 3/19/2012 3/19/2012 3/19/2012 3/20/2012 3/20/2012 3/20/2012 3/20/2012 3/20/2012 3/21/2012 3/21/2012 3/21/2012 3/22/2012 3/22/2012 3/22/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/23/2012 3/24/2012 3/24/2012 3/24/2012 3/24/2012 High High Not Specified Medium Not Specified Medium Medium Medium Critical Critical Medium Not Specified High Not Specified Critical Not Specified Not Specified High Low Not Specified Not Specified Critical Low Not Specified Low Medium Medium Medium High Not Specified High Medium Critical Medium High High Not Specified Low Low Critical Not Specified High Not Specified Not Specified High High Not Specified 13 11 36 5 18 37 8 37 46 20 1 44 46 43 25 16 24 6 40 33 42 16 25 16 22 9 7 29 31 39 34 5 34 33 1 10 21 50 13 12 3 35 45 25 31 46 42 1764 59491 16390 59491 46023 11045 24546 6950 41056 3970 3970 35814 55462 55462 20995 55462 26979 22466 26979 10439 10439 10439 10439 34279 36512 40611 40611 18464 22373 29280 22466 29280 18464 36512 18464 18464 10567 29831 46787 15104 32642 46787 55299 37124 11173 15782 20964 3/24/2012 3/24/2012 3/24/2012 3/24/2012 3/24/2012 3/25/2012 3/26/2012 3/26/2012 3/26/2012 3/26/2012 3/26/2012 3/27/2012 3/27/2012 3/27/2012 3/27/2012 3/27/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/28/2012 3/29/2012 3/29/2012 3/29/2012 3/29/2012 3/29/2012 3/29/2012 3/30/2012 3/30/2012 3/30/2012 3/30/2012 3/30/2012 Critical High Medium High Not Specified Medium Critical Low Critical Medium Medium High Medium Medium Medium Medium Medium Low Medium Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified High High Medium Low Medium High Not Specified High High High Critical Medium Medium Medium Medium Low Low Critical High Critical 7 8 8 6 50 35 7 4 4 39 13 11 31 13 37 35 50 40 43 30 46 27 41 3 3 12 43 31 26 30 31 19 27 30 37 41 10 29 32 23 50 28 20 33 37 35 11 49351 37895 28835 40839 33284 50978 8546 47041 21604 18208 18208 35045 13633 33605 57894 13633 52518 7458 7458 15142 7458 194 194 28868 21856 17986 8005 21856 29411 29411 29411 39143 29411 45635 4738 43364 25793 54370 21605 21605 36132 46566 16193 15236 44386 16193 15236 3/30/2012 3/30/2012 3/31/2012 3/31/2012 3/31/2012 3/31/2012 4/1/2012 4/1/2012 4/1/2012 4/1/2012 4/1/2012 4/2/2012 4/3/2012 4/3/2012 4/3/2012 4/3/2012 4/3/2012 4/4/2012 4/4/2012 4/4/2012 4/4/2012 4/4/2012 4/4/2012 4/5/2012 4/5/2012 4/5/2012 4/5/2012 4/5/2012 4/6/2012 4/6/2012 4/6/2012 4/6/2012 4/6/2012 4/7/2012 4/7/2012 4/7/2012 4/7/2012 4/8/2012 4/8/2012 4/8/2012 4/9/2012 4/9/2012 4/9/2012 4/9/2012 4/9/2012 4/9/2012 4/9/2012 Low Critical Not Specified Medium Low High High Not Specified Medium Not Specified Not Specified Medium Not Specified Critical Low Not Specified Critical Critical Critical Not Specified Critical Medium Medium High Not Specified Not Specified Critical Not Specified High High High Not Specified High Low High High Low Not Specified High High Low Medium Not Specified Not Specified Medium Not Specified Not Specified 27 14 1 23 21 4 4 35 6 36 34 44 39 42 47 18 8 46 16 21 9 6 49 30 26 43 24 47 33 38 45 46 29 50 2 21 27 49 46 32 3 49 8 33 43 29 30 53574 48293 44386 15687 3205 13894 27939 3205 13894 48128 59589 19044 49062 56453 57767 19044 52225 52225 56418 18373 2052 45575 8450 51202 17702 39876 44422 39876 39876 44422 44422 51202 8450 52164 24066 17702 52007 59905 59905 43043 38310 56161 8609 52007 59905 1344 20615 4/9/2012 Medium 4/9/2012 Critical 4/9/2012 Medium 4/9/2012 Critical 4/10/2012 Low 4/10/2012 Medium 4/10/2012 Medium 4/10/2012 Low 4/10/2012 Medium 4/11/2012 Medium 4/11/2012 Medium 4/11/2012 Low 4/11/2012 Low 4/11/2012 Critical 4/11/2012 Critical 4/11/2012 Low 4/12/2012 Critical 4/12/2012 Critical 4/12/2012 Critical 4/12/2012 Critical 4/12/2012 High 4/12/2012 Critical 4/13/2012 Not Specified 4/13/2012 High 4/13/2012 High 4/13/2012 High 4/13/2012 Medium 4/13/2012 High 4/13/2012 High 4/13/2012 Medium 4/13/2012 Medium 4/13/2012 High 4/13/2012 Not Specified 4/13/2012 Not Specified 4/13/2012 High 4/13/2012 High 4/14/2012 Medium 4/14/2012 High 4/14/2012 High 4/14/2012 Critical 4/14/2012 High 4/14/2012 High 4/14/2012 Critical 4/14/2012 Medium 4/14/2012 High 4/15/2012 Low 4/15/2012 Medium 8 47 27 48 8 50 8 42 31 5 25 29 33 1 34 32 10 33 47 35 23 46 24 34 48 43 11 41 46 36 1 4 22 30 30 9 25 5 19 4 4 38 4 19 6 18 29 44071 1826 54183 28871 1344 54183 44071 5028 21638 50982 24098 21253 22688 25895 24098 24098 48742 832 1221 45476 32386 35040 1221 1221 45315 5986 5095 5986 8390 5986 57638 57638 35104 59395 39300 57638 35104 45698 45698 51872 22183 51872 51872 46368 8033 23172 25478 4/15/2012 4/15/2012 4/15/2012 4/15/2012 4/15/2012 4/15/2012 4/15/2012 4/16/2012 4/16/2012 4/16/2012 4/17/2012 4/17/2012 4/17/2012 4/17/2012 4/17/2012 4/17/2012 4/17/2012 4/18/2012 4/18/2012 4/18/2012 4/18/2012 4/18/2012 4/18/2012 4/18/2012 4/20/2012 4/21/2012 4/21/2012 4/21/2012 4/21/2012 4/21/2012 4/22/2012 4/22/2012 4/22/2012 4/22/2012 4/22/2012 4/22/2012 4/22/2012 4/23/2012 4/23/2012 4/23/2012 4/23/2012 4/23/2012 4/23/2012 4/24/2012 4/24/2012 4/24/2012 4/24/2012 Not Specified Not Specified Critical High Low Critical Not Specified High High High Critical Medium Medium Medium Critical Critical Not Specified Low Not Specified Critical Critical Not Specified Not Specified Not Specified Medium High High High Medium High Low Low High Critical High Low High High High Medium Medium Medium Medium High High Low Critical 20 5 32 10 15 9 19 10 13 23 42 5 40 37 10 32 42 7 11 48 1 44 1 16 32 20 7 41 24 48 49 49 1 20 9 35 18 40 36 11 30 10 37 48 27 13 50 4805 12931 25478 1217 3845 3845 16711 52999 3845 52999 21573 29861 52999 21573 21573 42246 42246 30310 48673 15329 13892 33378 38498 38498 26912 33670 46337 26912 33670 33159 22497 21860 30405 5767 26982 5767 38279 28742 36103 34086 28742 2691 24643 36103 52519 134 644 4/24/2012 4/24/2012 4/24/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/25/2012 4/26/2012 4/26/2012 4/26/2012 4/26/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/27/2012 4/28/2012 4/28/2012 4/28/2012 4/28/2012 4/28/2012 4/28/2012 4/29/2012 4/29/2012 4/29/2012 4/29/2012 4/29/2012 4/29/2012 4/29/2012 4/29/2012 4/29/2012 4/30/2012 4/30/2012 Not Specified Medium Critical Not Specified Critical Critical Not Specified Not Specified Critical Not Specified Critical Critical Not Specified Critical Critical Not Specified Not Specified Medium Not Specified High High High Critical Critical Low High Low Low High Medium Medium Critical Low High Not Specified High Medium Low Critical High Low Low Medium Critical High Not Specified Critical 7 11 47 25 9 15 3 7 22 5 7 11 39 3 31 40 5 21 36 34 47 25 1 30 18 4 34 21 50 3 37 9 7 31 37 36 1 35 10 41 7 14 30 45 6 11 5 9952 21410 40131 54339 57093 54339 3524 57093 51267 22951 7488 30375 18917 55749 8833 49380 39652 10470 10470 39652 10470 10470 9409 16257 2023 48197 53477 2023 53477 53477 53477 21796 27265 6785 8679 21796 21796 27265 27265 22272 22272 21796 46977 130 130 17862 46977 5/1/2012 5/1/2012 5/2/2012 5/2/2012 5/2/2012 5/2/2012 5/2/2012 5/2/2012 5/3/2012 5/3/2012 5/3/2012 5/3/2012 5/3/2012 5/3/2012 5/4/2012 5/4/2012 5/4/2012 5/4/2012 5/4/2012 5/4/2012 5/4/2012 5/4/2012 5/5/2012 5/5/2012 5/5/2012 5/5/2012 5/5/2012 5/5/2012 5/5/2012 5/5/2012 5/5/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/6/2012 5/7/2012 5/7/2012 5/7/2012 5/7/2012 5/7/2012 High Critical Low Low Low Low High Low Low Medium Critical Low Critical Critical Low Medium Low Low Low Low Low Critical Critical Not Specified Low Not Specified High Low High High High Low Critical Medium Medium Low Low Critical Critical High High Low Medium High High Not Specified Medium 47 16 24 48 47 41 21 3 46 24 9 20 14 42 40 11 5 8 20 4 40 35 12 16 4 32 27 50 36 32 28 2 49 7 46 46 41 36 49 37 30 31 19 3 23 31 10 17862 58435 130 30784 30784 38437 52673 38437 52673 21510 57058 25348 13282 25348 13282 57058 26756 43493 26756 7106 7106 43493 26756 7106 43493 5121 14851 14851 16454 31393 31393 15524 53024 4069 56672 52932 53024 50403 4069 4069 56672 56672 30886 50403 25733 10688 11011 5/7/2012 5/7/2012 5/7/2012 5/7/2012 5/7/2012 5/8/2012 5/8/2012 5/8/2012 5/8/2012 5/8/2012 5/9/2012 5/9/2012 5/9/2012 5/9/2012 5/9/2012 5/9/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/10/2012 5/11/2012 5/11/2012 5/11/2012 5/11/2012 5/11/2012 5/11/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/12/2012 5/13/2012 Not Specified Low High Medium Medium Critical Medium Critical Medium High Medium Critical Low Critical Low Medium Medium High Medium Low Low High Medium Low High Not Specified Not Specified Not Specified Medium Critical Critical Medium Not Specified Medium High Low Not Specified Not Specified Medium Medium High High Low Not Specified Low Medium High 1 11 29 48 10 19 4 17 14 16 28 6 22 7 2 27 25 14 20 8 36 37 40 31 22 45 26 6 12 31 4 27 46 30 34 3 9 22 8 47 45 8 28 38 24 14 36 15399 36644 17698 15399 17698 58853 11011 17698 11011 8130 47014 15399 39365 16359 16359 58145 16039 59425 39168 59425 39168 53667 57602 53667 39168 53120 13572 1701 1701 9312 54181 17447 20642 20642 23681 37350 7841 1088 14497 38817 7841 49029 22563 30343 52290 37634 18466 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/13/2012 5/14/2012 5/14/2012 5/14/2012 5/16/2012 5/16/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/17/2012 5/18/2012 5/18/2012 5/18/2012 5/18/2012 5/18/2012 5/19/2012 5/19/2012 5/19/2012 5/20/2012 5/20/2012 5/20/2012 5/20/2012 5/20/2012 5/20/2012 5/20/2012 5/20/2012 5/21/2012 5/21/2012 5/21/2012 5/21/2012 Critical High High Critical High Critical High High High Critical Critical Critical High Critical Critical Medium High Medium High Medium High Medium Low Medium High Not Specified Critical High High Not Specified High Low High High High Critical Not Specified Low Medium Not Specified Not Specified High Critical Critical Low Medium Low 7 24 40 46 22 27 36 43 33 15 33 38 32 39 8 33 3 46 30 24 50 33 43 16 22 5 7 49 1 43 12 42 47 32 42 7 21 13 34 1 17 49 32 48 28 32 25 52290 30343 18466 30343 17701 18757 18757 18757 38182 32608 28294 32100 25447 13670 25447 43523 53285 35842 6693 17543 17543 36929 12804 20451 20451 17543 36929 12804 20451 12804 55460 59015 44768 59015 26336 11269 55460 26336 59015 11269 11269 3650 17216 3650 40933 59878 45125 5/21/2012 5/21/2012 5/21/2012 5/21/2012 5/21/2012 5/22/2012 5/22/2012 5/22/2012 5/22/2012 5/22/2012 5/22/2012 5/23/2012 5/23/2012 5/23/2012 5/23/2012 5/23/2012 5/24/2012 5/24/2012 5/24/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/25/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/26/2012 5/27/2012 5/27/2012 5/27/2012 5/27/2012 5/28/2012 5/28/2012 Low Critical Low Critical Critical Low Low Low High High High Medium Not Specified Critical Not Specified Medium Critical High Critical Critical Critical Low Medium Critical Critical Critical Low Medium Critical Medium High Medium Not Specified Medium High Low High High Medium Low Low Not Specified Medium Not Specified High High Critical 7 8 24 28 21 9 5 43 45 20 47 29 18 27 25 50 6 18 16 1 35 37 50 33 6 26 45 21 17 34 49 32 45 32 45 1 12 39 32 39 49 24 7 36 37 6 32 45125 34757 59878 21763 56802 29218 29218 29218 29221 25635 25635 23363 50181 42177 42177 27138 27138 38914 47456 33029 1285 48993 48614 33029 1285 23911 36832 23911 53762 36832 50883 23911 3172 3654 19652 9024 9024 46055 1027 19652 3654 3654 9024 12292 44679 44679 34754 5/28/2012 5/28/2012 5/28/2012 5/28/2012 5/29/2012 5/29/2012 5/29/2012 5/29/2012 5/29/2012 5/29/2012 5/29/2012 5/29/2012 5/30/2012 5/30/2012 5/30/2012 5/30/2012 5/30/2012 5/30/2012 5/31/2012 5/31/2012 5/31/2012 5/31/2012 5/31/2012 5/31/2012 5/31/2012 6/1/2012 6/1/2012 6/1/2012 6/1/2012 6/1/2012 6/1/2012 6/1/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/2/2012 6/3/2012 6/3/2012 6/4/2012 Critical High High Low High Low Low Low High Critical Critical Low High Not Specified Not Specified High High Medium Low High Critical Low Critical High Critical Critical Low Critical Critical Low Low Critical Not Specified Low Critical Medium Medium Medium Medium Critical Low Low Medium Not Specified Medium Medium Critical 6 40 23 22 50 13 19 26 41 14 22 46 2 49 38 31 37 43 43 8 8 17 46 39 27 21 43 19 28 24 35 3 33 39 34 44 30 25 19 28 41 47 2 32 22 35 16 23809 37315 36354 56805 37315 15591 37762 24390 50144 2054 9505 39943 39943 21028 2054 9505 35012 39686 868 55431 35012 55431 39686 868 29856 19874 45664 39938 43874 42887 42887 42887 38851 50977 58658 43460 58658 58658 44839 28901 12551 26853 10823 26274 6535 17507 17507 6/4/2012 6/5/2012 6/5/2012 6/5/2012 6/5/2012 6/6/2012 6/6/2012 6/6/2012 6/7/2012 6/7/2012 6/7/2012 6/7/2012 6/7/2012 6/7/2012 6/7/2012 6/7/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/8/2012 6/9/2012 6/10/2012 6/10/2012 6/10/2012 6/10/2012 6/10/2012 6/10/2012 6/11/2012 6/11/2012 6/11/2012 6/11/2012 6/11/2012 6/11/2012 6/11/2012 6/11/2012 6/12/2012 6/12/2012 6/12/2012 6/12/2012 6/12/2012 6/12/2012 Not Specified Low Medium High Low Critical Medium Low Critical Not Specified High High High Critical Not Specified High Medium Not Specified Not Specified Not Specified Medium Not Specified Not Specified Not Specified Medium High Not Specified High High Medium Medium Medium Critical Low Medium Medium Medium Medium Critical High Low Low Low Not Specified Critical Medium Medium 7 43 13 38 31 31 20 2 36 34 5 16 12 38 1 2 11 2 31 13 10 39 48 32 24 31 24 5 46 11 3 3 1 1 46 2 7 41 27 23 46 21 3 41 11 27 22 9573 48868 9573 43815 43815 43815 48868 43045 14241 28899 43045 6183 16897 13383 16897 19972 29893 53698 1346 30147 43488 43488 43488 43488 59680 43488 26407 33222 33222 26407 6885 33222 33541 46497 6885 967 967 41667 8294 967 49255 25986 24580 24580 11044 46691 19718 6/13/2012 6/13/2012 6/13/2012 6/13/2012 6/13/2012 6/13/2012 6/13/2012 6/14/2012 6/14/2012 6/14/2012 6/14/2012 6/15/2012 6/15/2012 6/15/2012 6/15/2012 6/16/2012 6/16/2012 6/16/2012 6/17/2012 6/17/2012 6/18/2012 6/18/2012 6/18/2012 6/18/2012 6/18/2012 6/18/2012 6/19/2012 6/19/2012 6/19/2012 6/19/2012 6/19/2012 6/19/2012 6/19/2012 6/19/2012 6/19/2012 6/20/2012 6/20/2012 6/20/2012 6/20/2012 6/20/2012 6/22/2012 6/22/2012 6/23/2012 6/23/2012 6/24/2012 6/24/2012 6/24/2012 Medium Not Specified Medium Not Specified Not Specified Not Specified Not Specified Medium Critical Low Medium Medium Not Specified Not Specified Not Specified Critical Medium Medium High Not Specified Critical Critical Critical Critical Critical Critical Critical Medium Medium Critical Low Medium Critical High Low Medium Medium High Medium Medium High Medium High High Medium Critical Low 41 43 21 40 22 45 47 12 22 27 47 41 1 35 48 6 24 10 48 37 46 3 46 13 15 28 16 48 30 34 4 18 43 30 40 48 42 18 28 6 20 48 14 25 3 47 6 12005 19074 55494 55494 24386 14210 24386 24386 47620 57025 16706 17508 6695 46626 33793 16706 16706 43751 24743 44037 44037 50466 24743 29191 4416 48067 28387 23685 17414 48067 28387 52324 26272 17414 17826 46912 40801 4096 55938 4103 23297 55526 55938 37313 37313 23297 50914 6/24/2012 6/25/2012 6/25/2012 6/25/2012 6/26/2012 6/26/2012 6/26/2012 6/26/2012 6/26/2012 6/26/2012 6/27/2012 6/27/2012 6/27/2012 6/27/2012 6/27/2012 6/27/2012 6/27/2012 6/27/2012 6/28/2012 6/28/2012 6/28/2012 6/28/2012 6/28/2012 6/28/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/29/2012 6/30/2012 6/30/2012 7/1/2012 7/2/2012 7/2/2012 7/2/2012 7/2/2012 7/2/2012 7/2/2012 7/2/2012 7/2/2012 7/2/2012 7/3/2012 Not Specified Critical Not Specified Not Specified High Not Specified High High Low Medium High Low Low Low Critical High High High Low High High Critical Low Medium Low Low Not Specified Not Specified High Low Not Specified Not Specified Low High High Low Not Specified Not Specified Not Specified Low Critical High Not Specified Not Specified Not Specified Critical Critical 4 17 49 4 12 19 15 41 27 8 49 50 49 8 17 6 47 43 47 38 39 32 26 26 46 24 37 46 32 31 13 4 6 39 18 5 20 21 42 3 20 23 18 44 17 34 49 29761 29761 29761 21509 43555 46726 51747 46726 4741 41120 41120 30436 32835 48577 13923 13923 13923 13923 25569 44486 24450 58368 28165 2209 58368 58368 2209 52706 2209 2209 24450 24450 17797 30403 34822 53600 17797 30403 45767 36833 1793 29985 14016 28228 29985 17735 17735 7/3/2012 7/3/2012 7/3/2012 7/3/2012 7/3/2012 7/5/2012 7/5/2012 7/5/2012 7/6/2012 7/7/2012 7/7/2012 7/7/2012 7/7/2012 7/8/2012 7/8/2012 7/8/2012 7/8/2012 7/8/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/9/2012 7/10/2012 7/10/2012 7/10/2012 7/10/2012 7/10/2012 7/10/2012 7/10/2012 7/11/2012 7/11/2012 7/11/2012 7/11/2012 7/11/2012 7/11/2012 7/12/2012 7/12/2012 Medium Medium Medium High Medium Not Specified Medium Not Specified Not Specified Low Low Low Medium Medium High High High High High Critical Critical High Not Specified High High High High Low High High Critical Critical Low High Not Specified Medium Low High High Low Not Specified Critical Low Not Specified Critical Low Low 48 19 42 13 34 10 3 46 40 35 13 30 15 6 39 27 28 49 27 36 37 4 2 42 39 5 1 34 27 13 41 4 16 24 23 8 10 41 49 25 36 2 9 5 22 28 45 50758 21925 549 549 549 5858 53378 41927 53378 53378 14215 5858 52325 14980 53223 16103 55683 55683 16103 46979 46979 24613 33666 30786 9892 59558 30786 30208 24613 24613 42374 24039 38532 42374 45734 42374 53635 43907 11745 25825 14727 34595 25825 14727 49927 5408 49927 7/12/2012 7/12/2012 7/12/2012 7/12/2012 7/12/2012 7/13/2012 7/13/2012 7/13/2012 7/13/2012 7/13/2012 7/13/2012 7/13/2012 7/14/2012 7/14/2012 7/14/2012 7/15/2012 7/15/2012 7/15/2012 7/15/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/16/2012 7/17/2012 7/17/2012 7/17/2012 7/17/2012 7/17/2012 7/17/2012 7/18/2012 7/18/2012 7/19/2012 7/19/2012 7/19/2012 7/19/2012 7/19/2012 7/19/2012 7/20/2012 7/20/2012 7/20/2012 Medium Not Specified Critical Critical Critical Not Specified Medium Not Specified Medium Medium Medium Not Specified Not Specified Critical Low Not Specified High High Not Specified Low Low Low Not Specified Medium Medium Not Specified Medium Low Low Low Critical Not Specified High Critical Critical Critical Not Specified Critical High Not Specified Medium Medium Not Specified Medium Not Specified Low Not Specified 17 3 30 13 5 48 50 46 49 38 44 29 23 27 2 31 50 23 22 30 26 39 17 4 50 34 23 46 36 16 47 5 44 11 47 21 33 42 17 27 33 12 45 50 39 11 28 5408 49927 41831 22465 33568 6182 6182 16098 33568 17091 20807 17634 16098 11396 20807 40357 41831 29764 54023 43556 57574 17218 40388 27201 27201 30727 5254 23174 32903 23174 37831 11684 42982 23812 42982 16161 49153 16161 11782 55813 11782 44423 36864 59234 26310 5699 40901 7/20/2012 7/20/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/21/2012 7/22/2012 7/22/2012 7/22/2012 7/23/2012 7/23/2012 7/24/2012 7/25/2012 7/25/2012 7/25/2012 7/25/2012 7/26/2012 7/26/2012 7/26/2012 7/26/2012 7/27/2012 7/27/2012 7/27/2012 7/27/2012 7/28/2012 7/28/2012 7/28/2012 7/28/2012 7/28/2012 7/28/2012 7/29/2012 7/29/2012 7/29/2012 7/29/2012 7/29/2012 7/29/2012 Low Not Specified Not Specified Not Specified Medium Low Low Low Medium Medium Not Specified High Low Critical Not Specified Not Specified Not Specified Critical Not Specified Low Critical Critical Critical High High Medium Not Specified Low Low Low Not Specified High Low Critical Low Medium Medium Medium Low Low Low Critical Low Low Not Specified Low Medium 20 26 43 4 10 18 40 44 23 45 39 5 31 42 16 4 38 10 45 31 20 32 17 10 45 28 31 8 31 16 30 8 42 32 12 49 31 38 27 39 46 39 9 16 5 41 22 59234 26310 52678 5699 20932 40901 26469 16352 27616 26469 11808 2562 56384 2562 56384 2562 13988 31302 47399 13988 13988 11431 11431 2247 33445 52039 33445 33445 37412 26691 36803 52197 8167 54886 36803 36803 8167 52197 1540 33761 933 59909 18849 27299 18849 30597 30597 7/29/2012 7/29/2012 7/29/2012 7/29/2012 7/29/2012 7/29/2012 7/30/2012 7/30/2012 7/30/2012 7/30/2012 7/31/2012 7/31/2012 7/31/2012 7/31/2012 7/31/2012 7/31/2012 8/1/2012 8/1/2012 8/1/2012 8/1/2012 8/1/2012 8/1/2012 8/1/2012 8/1/2012 8/2/2012 8/2/2012 8/2/2012 8/2/2012 8/3/2012 8/3/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/4/2012 8/5/2012 8/5/2012 8/5/2012 8/5/2012 8/5/2012 8/5/2012 Low Not Specified High Low High Medium Medium Medium Low Medium Not Specified Critical Critical Critical Critical Critical Not Specified High Low Not Specified Not Specified High High Not Specified Low Critical Low Low High Not Specified Not Specified Critical Critical Critical Not Specified Not Specified Critical Critical High High Not Specified Low High Critical High High High 32 19 3 2 38 40 50 16 3 4 1 17 47 6 29 28 34 41 26 39 18 8 5 6 18 48 49 16 17 37 42 6 48 39 2 2 4 23 30 45 15 11 43 41 6 42 18 59909 16423 18849 11398 28454 11398 45670 51365 15296 44323 51365 25861 32327 13543 42400 48774 49442 42436 9347 42400 45440 54630 23748 28738 35299 8293 8801 38656 38656 8293 28738 38656 8801 29376 47846 47846 47846 47846 58883 39490 45860 19905 13284 20002 19905 27078 29347 8/5/2012 Low 8/5/2012 Medium 8/5/2012 High 8/6/2012 High 8/6/2012 Medium 8/6/2012 High 8/7/2012 Low 8/7/2012 High 8/7/2012 Not Specified 8/7/2012 Medium 8/7/2012 High 8/7/2012 High 8/7/2012 Low 8/8/2012 Medium 8/9/2012 Low 8/9/2012 High 8/9/2012 High 8/9/2012 Critical 8/9/2012 Low 8/9/2012 Low 8/9/2012 Critical 8/10/2012 Low 8/10/2012 High 8/10/2012 Medium 8/10/2012 Not Specified 8/10/2012 Low 8/10/2012 Low 8/10/2012 Low 8/10/2012 Low 8/10/2012 Low 8/10/2012 Medium 8/10/2012 Low 8/10/2012 Low 8/11/2012 Critical 8/11/2012 High 8/11/2012 High 8/11/2012 High 8/11/2012 High 8/12/2012 Low 8/12/2012 Low 8/12/2012 Low 8/12/2012 Critical 8/12/2012 High 8/12/2012 Medium 8/12/2012 Critical 8/12/2012 Not Specified 8/12/2012 Medium 46 19 39 26 25 16 2 35 38 27 35 44 45 2 44 31 11 30 31 41 5 11 26 2 41 22 25 41 3 50 10 13 32 20 25 50 5 37 36 38 12 25 49 9 20 22 50 39490 13284 48000 10948 42596 51175 24608 50532 50532 4294 2500 51175 8454 5635 54209 5635 11108 36038 13601 39877 39425 38884 56930 38884 487 56930 3907 3907 25571 6018 31297 31173 6018 3907 31297 58084 58084 40608 32230 40608 32610 20096 32610 4099 4099 17953 4099 8/12/2012 8/12/2012 8/13/2012 8/13/2012 8/14/2012 8/14/2012 8/14/2012 8/14/2012 8/14/2012 8/14/2012 8/14/2012 8/14/2012 8/15/2012 8/15/2012 8/15/2012 8/15/2012 8/16/2012 8/16/2012 8/16/2012 8/16/2012 8/16/2012 8/17/2012 8/17/2012 8/17/2012 8/17/2012 8/17/2012 8/18/2012 8/18/2012 8/18/2012 8/18/2012 8/18/2012 8/18/2012 8/18/2012 8/18/2012 8/18/2012 8/19/2012 8/19/2012 8/19/2012 8/19/2012 8/19/2012 8/19/2012 8/19/2012 8/19/2012 8/20/2012 8/20/2012 8/20/2012 8/20/2012 Low High High Medium Medium High Medium Medium Medium Medium High High Medium Medium Medium Medium Not Specified High Low Critical Critical High Low High Critical Low Medium Medium Critical Low Low Low Low Medium Low Medium Medium Not Specified High Not Specified Not Specified Low Not Specified Critical Critical High Critical 17 22 12 50 9 28 50 22 10 8 5 3 38 50 21 17 20 26 17 41 23 47 47 20 19 10 34 36 42 39 44 24 2 36 39 3 36 39 46 29 20 35 47 42 12 21 4 36101 11875 4099 17953 36294 17953 4896 4896 34148 25313 4896 24067 24067 3361 3361 49350 24067 44869 8039 36709 16452 1185 33031 33031 20933 2497 31460 39266 39266 39266 43682 1504 23489 33186 28544 52580 52676 18113 23616 7267 52580 13575 31232 22434 59361 22434 38178 8/20/2012 8/20/2012 8/20/2012 8/20/2012 8/20/2012 8/20/2012 8/21/2012 8/21/2012 8/21/2012 8/21/2012 8/21/2012 8/22/2012 8/22/2012 8/22/2012 8/22/2012 8/22/2012 8/22/2012 8/22/2012 8/23/2012 8/23/2012 8/23/2012 8/23/2012 8/24/2012 8/24/2012 8/26/2012 8/26/2012 8/26/2012 8/27/2012 8/27/2012 8/27/2012 8/27/2012 8/27/2012 8/28/2012 8/28/2012 8/28/2012 8/28/2012 8/28/2012 8/28/2012 8/28/2012 8/28/2012 8/28/2012 8/29/2012 8/29/2012 8/29/2012 8/29/2012 8/29/2012 8/29/2012 High Medium Critical High Medium High Critical Critical Critical Critical Critical High High Not Specified Not Specified High High Medium Medium Critical Medium Low High High High Critical High High High High Medium Medium High Low Critical High High Not Specified Not Specified High High Critical High Critical High Critical Medium 3 19 39 17 46 30 25 10 33 19 21 46 19 49 23 50 30 43 37 42 46 7 18 24 45 21 9 16 14 4 14 31 42 24 24 23 46 27 47 19 16 15 9 39 45 3 32 58369 58369 52230 40007 26981 26981 50565 9155 14439 25797 43588 43588 37253 30054 43270 25666 40193 13345 33702 39808 25666 39808 20066 25985 20066 13345 25985 15781 57152 57152 49094 40802 4581 2560 2560 39555 16231 34852 23649 30660 56548 2147 22182 23649 52130 22182 22182 8/30/2012 8/30/2012 8/30/2012 8/30/2012 8/30/2012 8/30/2012 8/30/2012 8/30/2012 8/30/2012 9/1/2012 9/1/2012 9/1/2012 9/1/2012 9/1/2012 9/1/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/2/2012 9/3/2012 9/3/2012 9/3/2012 9/3/2012 9/3/2012 9/3/2012 9/4/2012 9/4/2012 9/4/2012 9/4/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 9/5/2012 High High Critical Not Specified Medium Medium High Critical High Not Specified Medium Medium High Not Specified Critical Critical High Not Specified Not Specified Low Critical Low Critical Low Critical Not Specified Low High Low Low Critical High Not Specified Critical Critical Low Low Low Not Specified Critical Medium Not Specified Medium Not Specified Low Medium Medium 16 46 29 45 44 13 43 17 27 28 16 6 46 33 35 23 34 45 14 50 36 31 16 22 3 24 50 29 18 6 31 28 25 32 23 38 20 26 30 16 7 15 4 42 36 9 48 52130 14695 1991 1991 34309 54086 43713 29536 29536 29536 59202 36743 18661 18661 59202 17959 17959 11874 32804 32804 31744 11874 11362 11362 7552 11362 58278 58278 43332 11362 7552 19653 41766 41766 4578 42564 46212 49862 27302 4578 47622 46212 27302 4578 36130 4996 46053 9/5/2012 9/5/2012 9/6/2012 9/6/2012 9/6/2012 9/6/2012 9/7/2012 9/7/2012 9/7/2012 9/7/2012 9/8/2012 9/8/2012 9/8/2012 9/8/2012 9/8/2012 9/9/2012 9/9/2012 9/9/2012 9/9/2012 9/9/2012 9/9/2012 9/9/2012 9/10/2012 9/10/2012 9/10/2012 9/10/2012 9/10/2012 9/10/2012 9/10/2012 9/10/2012 9/10/2012 9/11/2012 9/11/2012 9/11/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/12/2012 9/13/2012 9/13/2012 9/13/2012 Low High Not Specified Not Specified High Low Medium Medium Medium Medium Medium Critical Low Low Medium Medium Medium Medium Medium Medium Medium Medium Low Low Critical Low High High High Low Critical Not Specified Critical Critical Low Low Not Specified Not Specified Low Low Not Specified Not Specified Low Low Critical Medium High 13 40 37 27 16 23 12 11 5 26 7 3 12 11 36 28 21 1 20 49 12 20 32 25 49 27 37 4 31 9 47 34 7 10 45 35 43 24 3 48 41 7 16 15 23 30 25 32000 2146 2146 32000 46053 36901 26021 42054 51140 51140 42306 44805 42306 42306 51140 32640 31874 3333 32640 57798 55335 24263 31874 3333 3810 42951 41286 3810 31684 31684 32994 27841 56291 56291 24261 56291 33479 52419 2885 57537 57537 33479 33479 2885 57537 12096 33729 9/13/2012 9/13/2012 9/13/2012 9/13/2012 9/13/2012 9/13/2012 9/14/2012 9/14/2012 9/14/2012 9/14/2012 9/14/2012 9/14/2012 9/14/2012 9/14/2012 9/14/2012 9/15/2012 9/15/2012 9/15/2012 9/15/2012 9/15/2012 9/15/2012 9/15/2012 9/15/2012 9/15/2012 9/16/2012 9/16/2012 9/16/2012 9/16/2012 9/16/2012 9/16/2012 9/16/2012 9/16/2012 9/17/2012 9/17/2012 9/17/2012 9/17/2012 9/18/2012 9/18/2012 9/18/2012 9/18/2012 9/18/2012 9/18/2012 9/18/2012 9/18/2012 9/18/2012 9/19/2012 9/19/2012 Low Not Specified Not Specified Low High Critical Critical Medium Low Low High High High High Low High High Not Specified High High Not Specified Low High Not Specified Critical Critical Medium Critical Critical Critical Critical High Not Specified Not Specified Critical Not Specified Critical High Not Specified Medium Medium Critical Critical Not Specified Medium Medium Not Specified 26 41 44 49 31 30 17 32 28 14 18 40 19 4 3 18 39 9 12 20 30 16 29 42 25 20 40 40 15 28 34 33 25 47 28 22 50 32 46 29 4 24 27 29 13 46 26 12096 17157 20354 29537 38723 39783 38723 33893 17799 39783 33893 39783 55170 36229 36229 25443 30913 59585 30913 3556 3556 30913 30913 37158 19361 19361 45571 19361 45571 45571 17187 22055 13984 52320 35554 11650 55655 11650 23648 19425 23648 21792 51107 39972 39972 39972 30720 9/19/2012 9/19/2012 9/19/2012 9/19/2012 9/20/2012 9/20/2012 9/20/2012 9/20/2012 9/20/2012 9/20/2012 9/20/2012 9/20/2012 9/21/2012 9/21/2012 9/21/2012 9/22/2012 9/22/2012 9/22/2012 9/22/2012 9/22/2012 9/22/2012 9/22/2012 9/22/2012 9/22/2012 9/23/2012 9/23/2012 9/23/2012 9/23/2012 9/23/2012 9/23/2012 9/23/2012 9/23/2012 9/24/2012 9/24/2012 9/24/2012 9/24/2012 9/24/2012 9/24/2012 9/24/2012 9/24/2012 9/24/2012 9/25/2012 9/25/2012 9/25/2012 9/25/2012 9/25/2012 9/27/2012 Medium Low Critical Low Critical Not Specified Critical Not Specified Medium Not Specified Not Specified Not Specified Critical Not Specified Not Specified Medium Medium High Medium Not Specified Not Specified Medium Medium Low Low Low Medium Low Medium Medium High Medium Critical Low Not Specified Not Specified Low Not Specified Critical Not Specified Critical Not Specified Not Specified Not Specified Not Specified Not Specified Low 23 31 24 30 39 29 9 6 8 19 16 31 22 24 12 33 23 45 44 48 41 24 36 25 21 43 47 21 43 44 4 40 30 41 34 30 33 26 44 34 4 26 36 35 19 36 27 30720 30720 57570 34406 57570 26657 16518 36998 16518 36998 36998 18592 27300 39654 27300 18374 55968 8678 293 6150 22980 929 293 22980 929 20579 4261 4261 18596 25476 18596 25476 4261 4261 46534 31266 5697 15651 44000 51333 50849 51333 44000 44000 15651 15651 44000 9/27/2012 9/27/2012 9/28/2012 9/28/2012 9/28/2012 9/29/2012 9/29/2012 9/29/2012 9/29/2012 9/29/2012 9/29/2012 9/30/2012 9/30/2012 9/30/2012 9/30/2012 9/30/2012 9/30/2012 9/30/2012 10/1/2012 10/1/2012 10/1/2012 10/1/2012 10/1/2012 10/1/2012 10/1/2012 10/1/2012 10/2/2012 10/2/2012 10/2/2012 10/2/2012 10/2/2012 10/2/2012 10/2/2012 10/2/2012 10/3/2012 10/3/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 10/4/2012 Low Low High Medium High Medium Critical Low Critical Low Low Critical Not Specified Medium Not Specified Low Low Low High Critical Not Specified High High Not Specified High Medium Critical Critical Low Not Specified Low Not Specified Critical Critical High High Critical Critical Not Specified Not Specified Low Not Specified Not Specified Not Specified Critical Critical Not Specified 37 5 15 29 27 28 36 8 4 50 41 2 27 39 50 21 40 31 49 38 17 21 27 10 39 16 22 48 32 21 42 4 33 32 13 16 31 8 19 25 47 30 18 15 14 40 17 38336 55623 3655 29991 3655 38336 50818 33444 33444 42848 4067 16709 42722 42722 9509 45825 8677 9509 481 9509 58181 34241 33731 33731 33731 3232 28929 40994 43010 43010 28929 32356 55366 32356 58722 47686 9473 9473 9473 6500 9765 6500 36390 44678 44678 48801 59683 10/5/2012 10/5/2012 10/5/2012 10/5/2012 10/5/2012 10/5/2012 10/6/2012 10/6/2012 10/6/2012 10/6/2012 10/6/2012 10/6/2012 10/7/2012 10/7/2012 10/7/2012 10/7/2012 10/7/2012 10/7/2012 10/7/2012 10/7/2012 10/7/2012 10/8/2012 10/8/2012 10/8/2012 10/8/2012 10/8/2012 10/9/2012 10/9/2012 10/9/2012 10/9/2012 10/9/2012 10/10/2012 10/10/2012 10/10/2012 10/11/2012 10/11/2012 10/11/2012 10/11/2012 10/11/2012 10/12/2012 10/12/2012 10/12/2012 10/12/2012 10/13/2012 10/13/2012 10/13/2012 10/13/2012 Critical Critical Critical Low Critical Critical Medium Medium Medium Not Specified High High Not Specified Not Specified Not Specified Medium High Not Specified High Not Specified Not Specified Low High High High Critical Medium High Critical Critical Medium Not Specified Critical Not Specified Critical Not Specified Not Specified Not Specified Not Specified Critical Low Critical High Low Low High Not Specified 31 47 3 41 24 14 34 8 11 50 16 3 23 2 5 43 38 36 44 32 5 4 27 12 32 5 37 42 24 40 46 47 7 12 45 48 3 31 34 20 26 15 3 4 36 43 37 56069 32165 25473 25473 1447 32165 21665 15715 25152 36034 14630 56740 56740 56740 26084 35713 34182 51940 12356 8231 30401 48643 48643 8231 50308 48643 19782 33924 55296 50055 50055 54721 19777 27750 27750 19777 33477 19777 27780 27780 612 27780 612 11168 8065 2275 54180 10/14/2012 10/14/2012 10/14/2012 10/14/2012 10/14/2012 10/14/2012 10/15/2012 10/15/2012 10/15/2012 10/16/2012 10/16/2012 10/16/2012 10/16/2012 10/16/2012 10/16/2012 10/17/2012 10/17/2012 10/17/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/18/2012 10/19/2012 10/19/2012 10/19/2012 10/19/2012 10/19/2012 10/19/2012 10/20/2012 10/20/2012 10/20/2012 10/20/2012 10/20/2012 10/21/2012 10/21/2012 10/21/2012 10/22/2012 Low Not Specified High High High Not Specified High Critical Critical High Low Low Critical Low Low Medium Critical High Critical Critical Medium Medium Medium Critical Low Medium Low Not Specified Low Medium Medium Not Specified Not Specified Low Low Not Specified High Not Specified Critical Critical Medium Critical Medium Critical Medium Not Specified Critical 10 47 20 36 40 38 5 43 29 10 17 6 33 29 33 49 31 11 39 27 39 50 14 5 19 6 18 12 32 11 1 19 24 12 18 2 28 22 18 39 43 39 50 35 17 49 43 55716 31845 31845 47522 14372 2630 35712 48902 35712 3559 53445 30976 5378 53445 56676 17831 56224 3521 57861 17831 56224 56224 56224 32871 16197 32871 55171 32871 39269 55171 16197 16132 23395 18918 1345 17700 51556 9861 38912 21634 43104 21634 38912 23428 8289 41504 18531 10/22/2012 High 10/22/2012 Low 10/22/2012 Low 10/23/2012 High 10/23/2012 Critical 10/23/2012 Low 10/23/2012 High 10/23/2012 Medium 10/23/2012 High 10/23/2012 Medium 10/24/2012 High 10/24/2012 High 10/24/2012 Critical 10/24/2012 High 10/25/2012 Critical 10/25/2012 Critical 10/25/2012 Medium 10/25/2012 Low 10/25/2012 Medium 10/25/2012 Critical 10/25/2012 Medium 10/25/2012 Medium 10/25/2012 Medium 10/26/2012 High 10/26/2012 Critical 10/26/2012 High 10/26/2012 High 10/26/2012 High 10/26/2012 Low 10/26/2012 High 10/26/2012 Critical 10/27/2012 Medium 10/27/2012 Medium 10/27/2012 Not Specified 10/27/2012 Low 10/27/2012 Critical 10/27/2012 High 10/28/2012 Low 10/28/2012 Low 10/28/2012 Not Specified 10/28/2012 High 10/28/2012 Not Specified 10/28/2012 Low 10/28/2012 High 10/28/2012 Low 10/28/2012 Critical 10/29/2012 Critical 9 11 36 5 34 31 24 7 42 34 8 10 6 21 39 34 35 50 40 38 9 32 46 14 19 9 29 42 16 43 23 26 31 7 24 20 10 47 26 1 50 8 46 41 38 20 50 40672 41378 3014 16864 26116 41378 47971 43653 30499 15872 17061 15872 26306 30499 53536 43653 48706 43653 48706 17510 53536 15872 26306 37185 9350 9350 59492 23585 48423 32325 32231 37287 35456 19586 37287 53990 37287 3297 5890 34022 34022 19143 37798 53188 20032 36163 15937 10/29/2012 10/29/2012 10/29/2012 10/29/2012 10/29/2012 10/29/2012 10/29/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/30/2012 10/31/2012 10/31/2012 10/31/2012 10/31/2012 10/31/2012 10/31/2012 11/1/2012 11/1/2012 11/1/2012 11/1/2012 11/1/2012 11/1/2012 11/1/2012 11/1/2012 11/2/2012 11/3/2012 11/3/2012 11/3/2012 11/4/2012 11/4/2012 11/5/2012 11/5/2012 11/5/2012 11/6/2012 Low Not Specified Not Specified Not Specified Critical Not Specified High High High Not Specified Critical Not Specified Low High High High Low High Low Critical High Not Specified Low High Critical Critical Not Specified Critical High Critical Low Low Critical Not Specified Low Not Specified Low High High Not Specified Not Specified High High High Medium Low Low 16 30 13 42 36 42 24 3 33 48 28 23 39 16 35 39 18 10 28 28 5 19 15 8 2 13 25 44 49 45 44 45 37 36 22 44 18 40 42 6 50 3 23 22 8 32 17 25249 50370 10951 15937 31681 29927 57671 51109 57056 20292 42469 20292 42469 39364 39364 23847 21827 48803 21827 42758 9602 4864 22819 42758 57699 9602 55777 55777 57699 9602 57699 57600 31552 31552 57600 51297 57600 58564 45700 19936 19936 21191 31456 45346 13346 24801 24801 11/6/2012 11/6/2012 11/6/2012 11/6/2012 11/7/2012 11/7/2012 11/7/2012 11/8/2012 11/8/2012 11/8/2012 11/8/2012 11/8/2012 11/8/2012 11/9/2012 11/9/2012 11/9/2012 11/9/2012 11/9/2012 11/9/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/10/2012 11/11/2012 11/11/2012 11/11/2012 11/11/2012 11/11/2012 11/11/2012 11/12/2012 11/13/2012 11/13/2012 11/13/2012 11/14/2012 11/15/2012 11/15/2012 11/15/2012 11/15/2012 11/15/2012 Medium Critical Not Specified Low Not Specified High Not Specified High Low Medium Not Specified Medium Not Specified High High Not Specified Not Specified Critical Not Specified Critical Critical Low High Critical Low Critical Not Specified Not Specified Low Critical Low Critical High High Critical Low Critical Critical High Critical Critical High High High Low High High 34 25 14 32 38 19 6 28 29 26 18 5 31 29 15 7 21 19 25 12 15 16 1 42 47 16 1 6 36 27 20 32 24 17 44 41 12 49 43 41 19 48 10 37 44 10 3 24801 47682 48448 35938 35938 3328 42944 129 24579 24579 44737 16134 34659 31042 1187 31042 44737 54656 50017 13158 50017 1796 41063 41063 50503 22817 41063 16775 36160 20676 31270 31270 31270 34976 34976 37765 33637 37765 37765 47777 26055 9504 40289 40838 25377 23777 40289 11/15/2012 11/16/2012 11/16/2012 11/17/2012 11/17/2012 11/18/2012 11/18/2012 11/18/2012 11/18/2012 11/18/2012 11/19/2012 11/19/2012 11/19/2012 11/19/2012 11/19/2012 11/19/2012 11/19/2012 11/19/2012 11/20/2012 11/20/2012 11/20/2012 11/20/2012 11/21/2012 11/21/2012 11/21/2012 11/21/2012 11/21/2012 11/22/2012 11/22/2012 11/22/2012 11/23/2012 11/23/2012 11/23/2012 11/24/2012 11/24/2012 11/24/2012 11/24/2012 11/24/2012 11/24/2012 11/25/2012 11/25/2012 11/25/2012 11/26/2012 11/26/2012 11/26/2012 11/26/2012 11/26/2012 High Not Specified Low Not Specified Not Specified Low Critical Low High High Medium High High Medium Medium Medium Medium High Low Critical Low High Low Low Medium Critical Low Low Low Low Medium Medium Medium Medium Medium Low Low Low Low Low Not Specified Medium Not Specified Not Specified Low Not Specified Not Specified 7 38 20 48 6 12 43 4 40 45 11 43 42 48 14 26 16 22 43 26 24 43 10 22 28 27 26 49 12 22 3 5 21 29 45 18 35 7 12 13 46 17 26 40 3 16 4 6529 40838 23618 23713 28934 22432 56644 28934 29282 28934 54501 11137 54501 54501 614 40032 18368 18368 18368 614 14435 14435 48576 14435 48576 12837 56708 35590 12837 55747 13570 56708 5954 13570 55747 48615 21505 48615 41671 24451 55239 55239 15712 53216 59329 59329 13031 11/26/2012 11/26/2012 11/27/2012 11/28/2012 11/28/2012 11/28/2012 11/28/2012 11/28/2012 11/28/2012 11/28/2012 11/29/2012 11/29/2012 11/29/2012 11/29/2012 11/30/2012 11/30/2012 11/30/2012 11/30/2012 11/30/2012 11/30/2012 12/1/2012 12/1/2012 12/1/2012 12/1/2012 12/1/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/2/2012 12/3/2012 12/3/2012 12/3/2012 12/3/2012 12/3/2012 12/3/2012 12/3/2012 12/4/2012 12/4/2012 12/4/2012 12/4/2012 12/4/2012 Medium Not Specified Medium Not Specified Medium Not Specified Not Specified Medium Medium Medium Critical High Critical Critical High Low Not Specified Not Specified Not Specified High Not Specified Not Specified Not Specified Not Specified Not Specified Medium Not Specified Critical Medium High Not Specified Not Specified Critical Not Specified High Low Low Low Critical Critical Critical Critical High High Critical Critical Low 35 10 45 38 26 45 36 26 4 12 36 48 16 38 24 9 3 35 3 41 9 44 47 41 17 50 36 4 22 36 2 36 32 42 42 8 3 4 49 24 13 6 1 36 35 41 34 59329 59329 23745 23745 21729 58210 21729 22752 20450 49798 41634 49798 41634 21344 32449 3680 21344 34723 34723 21344 3680 37063 46276 34723 32449 32449 46276 51205 10982 10982 51205 59685 35011 10982 59685 26919 26919 53984 34532 24576 46048 46048 24576 49190 6339 23555 23555 12/4/2012 12/4/2012 12/5/2012 12/5/2012 12/6/2012 12/6/2012 12/6/2012 12/7/2012 12/7/2012 12/8/2012 12/8/2012 12/8/2012 12/8/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/9/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/10/2012 12/11/2012 12/11/2012 12/11/2012 12/11/2012 12/11/2012 12/11/2012 12/11/2012 12/11/2012 12/11/2012 Critical Critical Low Low Low Medium Low Low Critical Critical Not Specified Critical Not Specified Low Critical Not Specified Low Medium Medium Low Not Specified Not Specified Critical Medium Critical Critical Critical High Not Specified Not Specified High Critical Not Specified Not Specified Critical Low Low Medium Low Not Specified Medium Medium Not Specified High Critical High High 41 25 47 12 14 38 28 2 26 5 10 29 7 29 12 24 48 46 4 39 27 50 4 29 44 39 23 5 29 30 17 46 14 14 12 32 12 23 41 29 35 10 10 4 20 29 5 59781 59781 49889 59781 49889 59781 59781 49381 4771 32102 48353 7427 7427 16935 16935 388 33570 38848 58949 33570 18851 33570 39399 19745 12256 19745 19745 19745 28224 26661 8803 54791 54791 54791 8803 43109 23619 51813 23619 23619 10341 6117 43109 43109 21220 7751 3202 12/12/2012 12/12/2012 12/12/2012 12/12/2012 12/12/2012 12/12/2012 12/12/2012 12/13/2012 12/13/2012 12/14/2012 12/15/2012 12/15/2012 12/15/2012 12/15/2012 12/15/2012 12/15/2012 12/16/2012 12/16/2012 12/16/2012 12/16/2012 12/16/2012 12/16/2012 12/17/2012 12/18/2012 12/18/2012 12/18/2012 12/18/2012 12/18/2012 12/19/2012 12/19/2012 12/20/2012 12/20/2012 12/20/2012 12/20/2012 12/20/2012 12/21/2012 12/21/2012 12/21/2012 12/21/2012 12/21/2012 12/21/2012 12/21/2012 12/21/2012 12/21/2012 12/22/2012 12/23/2012 12/23/2012 Not Specified Not Specified Critical Not Specified Critical Not Specified Not Specified Not Specified Critical Medium Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified Not Specified High Critical Not Specified Critical Not Specified Medium High Medium High High High Critical Medium Not Specified High High High Not Specified Critical Medium Not Specified Medium Medium High Critical Critical Critical Not Specified Not Specified Low 43 24 21 24 47 28 18 21 4 2 18 9 47 3 43 46 19 6 50 1 32 46 28 50 44 29 2 25 25 31 17 42 27 45 6 10 45 13 7 48 17 7 19 25 4 45 10 44992 44992 16005 34400 34400 30469 19394 19394 10466 12129 48672 16772 29505 28611 26726 1573 26726 26726 28611 4706 28453 5891 42945 29220 13507 29216 53730 29216 49344 50950 49344 25542 50950 45127 47815 12/24/2012 12/24/2012 12/24/2012 12/24/2012 12/24/2012 12/25/2012 12/25/2012 12/25/2012 12/25/2012 12/25/2012 12/26/2012 12/26/2012 12/27/2012 12/27/2012 12/27/2012 12/27/2012 12/27/2012 12/27/2012 12/27/2012 12/28/2012 12/28/2012 12/28/2012 12/29/2012 12/29/2012 12/29/2012 12/29/2012 12/29/2012 12/29/2012 12/30/2012 12/30/2012 12/30/2012 12/30/2012 12/30/2012 12/30/2012 12/30/2012 Critical Critical Not Specified Low Low Not Specified Medium Medium High Medium High High Medium Low High High High High Low Not Specified Critical Medium Not Specified Medium Medium Critical High Critical Low Not Specified Low Low Not Specified Medium Not Specified 32 32 7 17 25 46 16 5 27 36 43 38 22 30 37 13 11 41 42 30 26 2 45 36 27 46 40 17 1 6 31 37 35 10 45 Expanded Order Type Sales Discount Sales with Discount Sales with Free Shipping 2354.8 187.88 192.58 7325.63 279.4 3668.28 1170.025 10.39 2354.15 69.38 5859.25 741.57 3353.54 500.5 452.28 172.04 12723.95 113.14 3531.75 742.8 55.82 1724.82 79.81 192.39 2323.36 169.22 4962.05 1319.421 550.93 1666 41.94 120.53 453.98 154.44 89.25 2160.27 1483.49 14729.36 4805.36 86 114.17 197.11 91.43 48.91 202.84 198.29 Ship Mode Regular Air Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Delivery Truck Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air 78.39 1187.864 3849.8 310.87 243.52 162.57 182.92 251.34 1247.8595 88.94 278.902 113.98 6815.23 5811.97 12741.81 322.73 162.58 437.73 380.28 172.54 7190.06 9843.11 275.01 250.13 171.71 31.35 412.62 145.93 260.12 21.07 430.41 49.18 312.03 6435.87 1217.5 441.53 336.65 163.27 236.99 24559.91 4617.336 17605.77 1585.6 215.85 290.68 50.85 255.31 Express Air Delivery Truck Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Delivery Truck Delivery Truck Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Delivery Truck Regular Air Express Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Delivery Truck Delivery Truck Regular Air Regular Air Regular Air Delivery Truck Regular Air Delivery Truck Regular Air Regular Air Regular Air Express Air Regular Air 99.1 106.78 792.21 3633.03 380.34 4072.8175 5934.39 901.374 155.89 1333.18 117.27 11460.76 354.45 1662.048 1606.4 1684.96 238.43 8177.07 66.92 6628.55 109.58 697.5 24701.12 952.47 171.9635 208.28 1554.53 111.04 1494.232 133.69 11.25 202.64 1500.17 377.31 1559.4355 2080.035 145.42 221.08 62.77 3.63 614.35 302.91 23239.96 172.99 878.75 251.11 480.73 Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Delivery Truck Regular Air Delivery Truck Delivery Truck Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Delivery Truck Express Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Delivery Truck Regular Air Express Air Regular Air Regular Air 159 88.06 1035.2 107.41 183.33 74.17 207.92 247.45 6688.66 3232.1335 463.83 320.57 685.7205 80.33 1591.89 2380.5695 622.72 220.07 80.6 684.5 1644.22 796.08 141.9755 1751.68 86.47 3194.05 3356.735 264.6 299.85 270.56 648.58 787.63 512.83 2966.13 2077.1875 869.78 362.71 17965.45 2503.008 647.81 3982.21 66.41 66.55 122.02 314.34 258.61 1001.17 Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Express Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Express Air Express Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Express Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air 1505.67 557.35 3028.86 75.19 490.87 1415.148 346.06 11036.16 736.3 2357.9085 75.89 62.26 1650.411 58.53 89.77 809.77 299.94 1635.29 316.35 116.69 538.22 56.13 3601.07 1713.8 1247.9275 7703.9665 169.61 3049.632 6170.02 381.6 61.098 1274.949 37.22 105.93 1281.358 638.72 455.93 2536.31 110 38.93 4550.06 3332.06 2507.79 1052.68 186.89 820.5645 1024.31 Delivery Truck Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Express Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air 723.82 170.374 639.71 326.1 2409.96 435.27 128.27 1754.29 136.49 402.49 4462.23 225.16 16.6 663.784 5634.3525 821.7885 115.1 516.65 206.2865 115.02 5008.761 118.63 13367.82 13.53 542.6 101.9 187.33 4697.032 259.17 21.99 31.18 96.21 5361.08 76.8655 21141.07 68.88 59.85 2157.3085 1616.66 2592.432 157.49 673.92 159.256 794.58 2180.23 299.01 1884.208 Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Express Air Regular Air Express Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Express Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Regular Air Delivery Truck 93.3385 540.56 37.4 128.13 512.33 56.73 341.36 558.04 1486.72 6.93 271.27 290.3 4698.5 288.9 1363 70.88 199.8 434.11 337.38 347.47 68.97 4046.25 16313.51 7679.512 282.61 57.24 2409.424 433.44 21.84 322.82 203.57 425.91 894.51 3008.5 29.41 8246.86 16886.76 9758.7 892.38 1921.1275 1425.06 251.59 250.29 151.75 1435.95 961.06 104.38 Regular Air Regular Air Express Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Delivery Truck Regular Air Delivery Truck Regular Air Express Air Regular Air Express Air Regular Air Regular Air Delivery Truck Delivery Truck Regular Air Regular Air Express Air Delivery Truck Regular Air Regular Air Regular Air Regular Air Regular Air Regular Air Deliver

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra and Its Applications

Authors: David C. Lay

4th edition

321791541, 978-0321388834, 978-0321791542

More Books

Students also viewed these Mathematics questions

Question

Determine by direct integration the centroid of the area shown. sin

Answered: 1 week ago

Question

1. Discuss how to test a hypothesis for paired samples.

Answered: 1 week ago