Question

1 Approved Answer

Posted on Sep 30, 2024

7. You started off as a bartender, but you have advanced into the financial planning department of a chain of expensive restaurants, and now you

7. You started off as a bartender, but you have advanced into the financial planning department of a chain of expensive restaurants, and now you are trying to identify spending patterns. Please download the file final.xlsx and refer to Worksheet A. Rounded to the nearest dollar, what was the 10th largest total transaction booked on this particular evening? 3802 4078 4581 5347 A B C NM 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 9 20 21 32 23 24 25 26 7 8 9 100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.789056 2066.104678 2892.54655 4049.56517 5669.391238 7937.147733 11112.00683 15556.80956 21779.53338 30491.34673 42687.88542 59763.03959 83668.25543 117135.5576 163989.7806 229585.6929 321419.97 449987.9581 629983.1413 881976.3978 1234766.957 1728673.74 2420143.236 3388200.53 4743480.742 6640873.038 0 1 2 3 4 5 6 7 8 Quantity 0 mm Transaction number 23 47 76 6 11 80 33 37 29 50 58 67 85 4 25 95 55 57 35 34 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 + 149 $ 149 $ 147 S 146 $ 145 $ 144 $ 142 $ 140 $ 139 $ 139 $ 138 138 $ 136 $ 135 $ 135 S 135 S 134 S 132 $ 130 $ 129 $ 128 $ 126 $ 125 $ 122 $ 120 $ 120 s 118 $ 118 $ 114 $ 113 $ 112 $ 110 S 106 $ 104 $ 101 $ 100 $ 100 $ 98 $ 98 $ 97 $ 97 $ 97 $ 95 S 13 96 53 70 78 100 20 46 30 89 72 2 87 17 69 19 54 43 83 12 28 45 26 Unit price 19.08 $ 34.19 $ 39.51 S 26.50 $ 31.59 $ 25.35 $ 37.66 $ 20.60 $ 35.56 $ 23.63 $ 27.55 $ 20.53 $ 31.82 36.52 $ 32.38 $ 39.62 $ 32.12 $ 17.44 S 39.23 $ 38.06 $ 35.99 $ 35.36 $ 28.58 $ 33.43 $ 22.40 $ 33.78 $ 30.81 S 29.14 $ 38.92 $ 32.29 $ 19.82 $ 22.68 $ 28.49 $ 22.55 $ 34.04 $ 20.04 5 32.98 $ 28.63 $ 38.76 $ 20.70 $ 26.87 S 24.48 $ 34 21 Total 2,842.92 5,094.31 5,807.97 3,869.00 4,580.55 3,650.40 5,347.72 2,884.00 4,942.84 3,284,57 3,801.90 2,833.14 4,327.52 4,930.20 4,371.30 5,348.70 4,304.08 2,302.08 5,099.90 4,909.74 4,606.72 4,455.36 3,572.50 4,078.46 2,688.00 4,053.60 3,635.58 3,438.52 4,436.88 3,648.77 2,219.84 2,494.80 3,019.94 2,345.20 3,438.04 2,004.00 3,298.00 2,805.74 3,798.48 2,007.90 2,606.39 2,374.56 nar D E F B 26 65 91 8 14 90 48 49 98 6 44 97 16 31 7 32 3 10 1 36 92 66 73 88 9 41 51 64 79 81 22 56 27 40 59 21 61 86 99 5 84 77 18 68 95 $ 93 $ 93 S 92 $ 91 $ 89 $ 88 $ 88 $ 87 85 $ 85 S 84 $ 83 $ 81 $ 81 $ 79 $ 75 $ 73 $ 71 $ 71 $ 70 S 70 $ 70 $ 69 $ 67 $ 66 $ 66 $ 66 $ 64 $ 63 $ 62 $ 60 S 60 $ 60 $ 58 $ SBS 55 $ 55 $ 54 $ 54 $ 51 $ 48 S 48 $ 34.21 $ 25.10 $ 33.51 $ 29.92 $ 38.48 $ 20.62 $ 22.96 $ 17.40 $ 25.64 $ 32.39 $ 33.44 $ 31.21 $ 39.77 $ 38.76 $ 25,48 $ 22.84 $ 20.35 $ 32.41 $ 35.38 $ 18.95 $ 39.56 $ 19.08 $ 24.42 $ 20.93 $ 32.32 $ 24.81 $ 34.73 $ 39.72 $ 29.06 $ 33.95 $ 38.24 $ 36.79 $ 29.31 $ 19.46 $ 34.82 $ 29.08 $ 24.60 $ 35.06 $ 18.31 $ 31.94 $ 21.65 $ 28.48 $ 31.35 $ 3,249.95 2,334.30 3,116.43 2,752.64 3,501.68 1,835.18 2,020.48 1,531.20 2,230.68 2,753.15 2,842.40 2,621.64 3,300.91 3,139.56 2,063.88 1,804.36 1,526.25 2,365.93 2,511.98 1,345.45 2,769.20 1,335.60 1,709.40 1,444.17 2,165.44 1,637.46 2,292.18 2,621.52 1,859.84 2,138.85 2,370.88 2,207,40 1,758.60 1,167.60 2,019.56 1,686.64 1,353.00 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504.80 1 2 3 4 5 "6 17 18 29 30 31 B2 B3 84 85 86 + Worksheet A Worksheet B + + D TUU YOU 81 82 83 84 85 86 87 99 5 84 77 18 68 82 52 75 15 39 38 62 71 24 60 42 88 89 90 91 92 93 94 95 96 97 98 99 00 01 02 a 55 $ 54 $ 54 $ 51 $ 48 $ 48 $ 46 $ 44 $ 44 $ 43 $ 43 $ 42 $ 39 $ 38 $ 37 $ 37 $ 33 $ 30 $ 26 $ 26 $ 25 $ 35.06 $ 18.31 $ 31.94 $ 21.65 $ 28.48 $ 31.35 $ 17.37 $ 37.52 $ 17.24 $ 17.36 $ 32.32 $ 39.16 $ 32.21 $ 32.32 $ 29.68 $ 22.93 $ 32.47 $ 26.42 $ 37.43 $ 23.14 $ 26.29 $ 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504.80 799.02 1,650.88 758.56 746.48 1,389.76 1,644.72 1,256.19 1,228.16 1,098.16 848.41 1,071.51 792.60 973.18 601.64 657.25 74 63 93 94 7. You started off as a bartender, but you have advanced into the financial planning department of a chain of expensive restaurants, and now you are trying to identify spending patterns. Please download the file final.xlsx and refer to Worksheet A. Rounded to the nearest dollar, what was the 10th largest total transaction booked on this particular evening? 3802 4078 4581 5347 A B C NM 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 9 20 21 32 23 24 25 26 7 8 9 100 140 196 274.4 384.16 537.824 752.9536 1054.13504 1475.789056 2066.104678 2892.54655 4049.56517 5669.391238 7937.147733 11112.00683 15556.80956 21779.53338 30491.34673 42687.88542 59763.03959 83668.25543 117135.5576 163989.7806 229585.6929 321419.97 449987.9581 629983.1413 881976.3978 1234766.957 1728673.74 2420143.236 3388200.53 4743480.742 6640873.038 0 1 2 3 4 5 6 7 8 Quantity 0 mm Transaction number 23 47 76 6 11 80 33 37 29 50 58 67 85 4 25 95 55 57 35 34 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 + 149 $ 149 $ 147 S 146 $ 145 $ 144 $ 142 $ 140 $ 139 $ 139 $ 138 138 $ 136 $ 135 $ 135 S 135 S 134 S 132 $ 130 $ 129 $ 128 $ 126 $ 125 $ 122 $ 120 $ 120 s 118 $ 118 $ 114 $ 113 $ 112 $ 110 S 106 $ 104 $ 101 $ 100 $ 100 $ 98 $ 98 $ 97 $ 97 $ 97 $ 95 S 13 96 53 70 78 100 20 46 30 89 72 2 87 17 69 19 54 43 83 12 28 45 26 Unit price 19.08 $ 34.19 $ 39.51 S 26.50 $ 31.59 $ 25.35 $ 37.66 $ 20.60 $ 35.56 $ 23.63 $ 27.55 $ 20.53 $ 31.82 36.52 $ 32.38 $ 39.62 $ 32.12 $ 17.44 S 39.23 $ 38.06 $ 35.99 $ 35.36 $ 28.58 $ 33.43 $ 22.40 $ 33.78 $ 30.81 S 29.14 $ 38.92 $ 32.29 $ 19.82 $ 22.68 $ 28.49 $ 22.55 $ 34.04 $ 20.04 5 32.98 $ 28.63 $ 38.76 $ 20.70 $ 26.87 S 24.48 $ 34 21 Total 2,842.92 5,094.31 5,807.97 3,869.00 4,580.55 3,650.40 5,347.72 2,884.00 4,942.84 3,284,57 3,801.90 2,833.14 4,327.52 4,930.20 4,371.30 5,348.70 4,304.08 2,302.08 5,099.90 4,909.74 4,606.72 4,455.36 3,572.50 4,078.46 2,688.00 4,053.60 3,635.58 3,438.52 4,436.88 3,648.77 2,219.84 2,494.80 3,019.94 2,345.20 3,438.04 2,004.00 3,298.00 2,805.74 3,798.48 2,007.90 2,606.39 2,374.56 nar D E F B 26 65 91 8 14 90 48 49 98 6 44 97 16 31 7 32 3 10 1 36 92 66 73 88 9 41 51 64 79 81 22 56 27 40 59 21 61 86 99 5 84 77 18 68 95 $ 93 $ 93 S 92 $ 91 $ 89 $ 88 $ 88 $ 87 85 $ 85 S 84 $ 83 $ 81 $ 81 $ 79 $ 75 $ 73 $ 71 $ 71 $ 70 S 70 $ 70 $ 69 $ 67 $ 66 $ 66 $ 66 $ 64 $ 63 $ 62 $ 60 S 60 $ 60 $ 58 $ SBS 55 $ 55 $ 54 $ 54 $ 51 $ 48 S 48 $ 34.21 $ 25.10 $ 33.51 $ 29.92 $ 38.48 $ 20.62 $ 22.96 $ 17.40 $ 25.64 $ 32.39 $ 33.44 $ 31.21 $ 39.77 $ 38.76 $ 25,48 $ 22.84 $ 20.35 $ 32.41 $ 35.38 $ 18.95 $ 39.56 $ 19.08 $ 24.42 $ 20.93 $ 32.32 $ 24.81 $ 34.73 $ 39.72 $ 29.06 $ 33.95 $ 38.24 $ 36.79 $ 29.31 $ 19.46 $ 34.82 $ 29.08 $ 24.60 $ 35.06 $ 18.31 $ 31.94 $ 21.65 $ 28.48 $ 31.35 $ 3,249.95 2,334.30 3,116.43 2,752.64 3,501.68 1,835.18 2,020.48 1,531.20 2,230.68 2,753.15 2,842.40 2,621.64 3,300.91 3,139.56 2,063.88 1,804.36 1,526.25 2,365.93 2,511.98 1,345.45 2,769.20 1,335.60 1,709.40 1,444.17 2,165.44 1,637.46 2,292.18 2,621.52 1,859.84 2,138.85 2,370.88 2,207,40 1,758.60 1,167.60 2,019.56 1,686.64 1,353.00 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504.80 1 2 3 4 5 "6 17 18 29 30 31 B2 B3 84 85 86 + Worksheet A Worksheet B + + D TUU YOU 81 82 83 84 85 86 87 99 5 84 77 18 68 82 52 75 15 39 38 62 71 24 60 42 88 89 90 91 92 93 94 95 96 97 98 99 00 01 02 a 55 $ 54 $ 54 $ 51 $ 48 $ 48 $ 46 $ 44 $ 44 $ 43 $ 43 $ 42 $ 39 $ 38 $ 37 $ 37 $ 33 $ 30 $ 26 $ 26 $ 25 $ 35.06 $ 18.31 $ 31.94 $ 21.65 $ 28.48 $ 31.35 $ 17.37 $ 37.52 $ 17.24 $ 17.36 $ 32.32 $ 39.16 $ 32.21 $ 32.32 $ 29.68 $ 22.93 $ 32.47 $ 26.42 $ 37.43 $ 23.14 $ 26.29 $ 1,928.30 988.74 1,724.76 1,104.15 1,367.04 1,504.80 799.02 1,650.88 758.56 746.48 1,389.76 1,644.72 1,256.19 1,228.16 1,098.16 848.41 1,071.51 792.60 973.18 601.64 657.25 74 63 93 94