Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please download the file final.xlsx and refer to Worksheet A. Transaction 12 was the ___th largest transaction in terms of the Total. Enter just the

Please download the file final.xlsx and refer to Worksheet A. Transaction 12 was the ___th largest transaction in terms of the Total. Enter just the cardinal number; e.g., 9

Transaction number Quantity Unit price Total
76 147 $ 39.51 $ 5,807.97
95 135 $ 39.62 $ 5,348.70
33 142 $ 37.66 $ 5,347.72
35 130 $ 39.23 $ 5,099.90
47 149 $ 34.19 $ 5,094.31
29 139 $ 35.56 $ 4,942.84
4 135 $ 36.52 $ 4,930.20
34 129 $ 38.06 $ 4,909.74
13 128 $ 35.99 $ 4,606.72
11 145 $ 31.59 $ 4,580.55
96 126 $ 35.36 $ 4,455.36
30 114 $ 38.92 $ 4,436.88
25 135 $ 32.38 $ 4,371.30
85 136 $ 31.82 $ 4,327.52
55 134 $ 32.12 $ 4,304.08
70 122 $ 33.43 $ 4,078.46
100 120 $ 33.78 $ 4,053.60
6 146 $ 26.50 $ 3,869.00
58 138 $ 27.55 $ 3,801.90
83 98 $ 38.76 $ 3,798.48
80 144 $ 25.35 $ 3,650.40
89 113 $ 32.29 $ 3,648.77
20 118 $ 30.81 $ 3,635.58
53 125 $ 28.58 $ 3,572.50
14 91 $ 38.48 $ 3,501.68
46 118 $ 29.14 $ 3,438.52
69 101 $ 34.04 $ 3,438.04
31 83 $ 39.77 $ 3,300.91
54 100 $ 32.98 $ 3,298.00
50 139 $ 23.63 $ 3,284.57
26 95 $ 34.21 $ 3,249.95
7 81 $ 38.76 $ 3,139.56
91 93 $ 33.51 $ 3,116.43
87 106 $ 28.49 $ 3,019.94
37 140 $ 20.60 $ 2,884.00
23 149 $ 19.08 $ 2,842.92
97 85 $ 33.44 $ 2,842.40
67 138 $ 20.53 $ 2,833.14
43 98 $ 28.63 $ 2,805.74
66 70 $ 39.56 $ 2,769.20
44 85 $ 32.39 $ 2,753.15
8 92 $ 29.92 $ 2,752.64
78 120 $ 22.40 $ 2,688.00
16 84 $ 31.21 $ 2,621.64
79 66 $ 39.72 $ 2,621.52
28 97 $ 26.87 $ 2,606.39
36 71 $ 35.38 $ 2,511.98
2 110 $ 22.68 $ 2,494.80
45 97 $ 24.48 $ 2,374.56
56 62 $ 38.24 $ 2,370.88
1 73 $ 32.41 $ 2,365.93
17 104 $ 22.55 $ 2,345.20
65 93 $ 25.10 $ 2,334.30
57 132 $ 17.44 $ 2,302.08
64 66 $ 34.73 $ 2,292.18
98 87 $ 25.64 $ 2,230.68
72 112 $ 19.82 $ 2,219.84
27 60 $ 36.79 $ 2,207.40
41 67 $ 32.32 $ 2,165.44
22 63 $ 33.95 $ 2,138.85
32 81 $ 25.48 $ 2,063.88
48 88 $ 22.96 $ 2,020.48
21 58 $ 34.82 $ 2,019.56
12 97 $ 20.70 $ 2,007.90
19 100 $ 20.04 $ 2,004.00
99 55 $ 35.06 $ 1,928.30
81 64 $ 29.06 $ 1,859.84
90 89 $ 20.62 $ 1,835.18
3 79 $ 22.84 $ 1,804.36
40 60 $ 29.31 $ 1,758.60
84 54 $ 31.94 $ 1,724.76
88 70 $ 24.42 $ 1,709.40
61 58 $ 29.08 $ 1,686.64
52 44 $ 37.52 $ 1,650.88
38 42 $ 39.16 $ 1,644.72
51 66 $ 24.81 $ 1,637.46
49 88 $ 17.40 $ 1,531.20
10 75 $ 20.35 $ 1,526.25
68 48 $ 31.35 $ 1,504.80
9 69 $ 20.93 $ 1,444.17
39 43 $ 32.32 $ 1,389.76
18 48 $ 28.48 $ 1,367.04
86 55 $ 24.60 $ 1,353.00
92 71 $ 18.95 $ 1,345.45
73 70 $ 19.08 $ 1,335.60
62 39 $ 32.21 $ 1,256.19
71 38 $ 32.32 $ 1,228.16
59 60 $ 19.46 $ 1,167.60
77 51 $ 21.65 $ 1,104.15
24 37 $ 29.68 $ 1,098.16
42 33 $ 32.47 $ 1,071.51
5 54 $ 18.31 $ 988.74
63 26 $ 37.43 $ 973.18
60 37 $ 22.93 $ 848.41
82 46 $ 17.37 $ 799.02
74 30 $ 26.42 $ 792.60
75 44 $ 17.24 $ 758.56
15 43 $ 17.36 $ 746.48
94 25 $ 26.29 $ 657.25
93 26 $ 23.14 $ 601.64

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

Intermediate Financial Management

Authors: Eugene F. Brigham, Phillip R. Daves

7th Edition

0030333288, 9780030333286

More Books

Students also viewed these Finance questions

Question

What is the purpose of the statement of cash flows?

Answered: 1 week ago

Question

Do you believe that Matilda overreacted to James? Why or why not?

Answered: 1 week ago