Question

In: Finance

Please asnwer all parts of question 2 Fiscal Year Company code Sales (millions) Number of Customers...

Please asnwer all parts of question 2

Fiscal Year Company code Sales (millions) Number of Customers
2002 K 203.00 1103.00
2000 K 470.00 6024.00
2003 I 478.00 9226.00
2001 K 523.00 2644.00
2008 E 581.00 3252.00
2004 H 902.00 9240.00
2000 N 970.00 9896.00
2004 N 1078.00 863.00
2006 O 1346.00 7265.00
2002 H 1354.00 9824.00
2007 I 1366.00 3728.00
2002 O 1372.00 230.00
2006 E 1431.00 7018.00
2000 L 1480.00 8804.00
2008 K 1500.00 7011.00
2007 O 1520.00 4079.00
2009 B 1523.00 5215.00
2001 D 1526.00 9694.00
2003 L 1538.00 7319.00
2000 P 1546.00 4547.00
2009 I 1560.00 4889.00
2008 C 1579.00 958.00
2003 D 1582.00 8827.00
2003 M 1861.00 3924.00
2005 B 1985.00 9416.00
2001 H 2128.00 6303.00
2005 G 2151.00 8743.00
2002 A 2217.00 1083.00
2001 B 2297.00 8865.00
2001 E 2298.00 6285.00
2004 A 2302.00 3106.00
2000 I 2359.00 6726.00
2004 C 2362.00 5379.00
2004 O 2367.00 8230.00
2001 I 2530.00 2474.00
2009 H 2530.00 320.00
2007 B 2554.00 300.00
2007 M 2570.00 1015.00
2005 O 2659.00 8243.00
2006 G 2687.00 6088.00
2007 C 2877.00 830.00
2005 I 2887.00 6675.00
2006 L 2898.00 4667.00
2009 K 3037.00 9862.00
2003 B 3074.00 2605.00
2009 A 3136.00 7330.00
2003 E 3140.00 8093.00
2003 A 3157.00 3296.00
2004 G 3335.00 5684.00
2000 E 3375.00 7578.00
2003 P 3378.00 2139.00
2004 D 3393.00 2868.00
2002 D 3526.00 500.00
2005 H 3620.00 8803.00
2006 A 3620.00 627.00
2007 P 3620.00 5203.00
2001 N 3635.00 2641.00
2000 A 3698.00 5941.00
2008 I 3754.00 3812.00
2004 E 3853.00 1467.00
2008 B 3972.00 1289.00
2007 D 4112.00 9247.00
2007 N 4146.00 2962.00
2008 O 4192.00 3199.00
2000 H 4197.00 2272.00
2005 P 4224.00 2151.00
2002 G 4280.00 9513.00
2009 L 4300.00 7610.00
2002 C 4640.00 7953.00
2002 N 4784.00 327.00
2007 E 4838.00 6613.00
2001 P 4876.00 9627.00
2009 D 4944.00 8902.00
2005 M 5055.00 5559.00
2005 N 5221.00 5446.00
2009 G 5230.00 3026.00
2006 C 5463.00 7089.00
2000 D 5570.00 6787.00
2006 H 5690.00 8200.00
2009 E 5726.00 8354.00
2000 G 5801.00 2664.00
2006 B 5924.00 8727.00
2005 K 5952.00 9790.00
2005 A 5995.00 1910.00
2004 M 6101.00 8082.00
2007 K 6101.00 954.00
2008 H 6229.00 7640.00
2001 L 6230.00 1330.00
2003 N 6268.00 7765.00
2001 M 6349.00 4803.00
2001 A 6398.00 3494.00
2008 M 6580.00 1020.00
2008 D 6585.00 8559.00
2008 G 6594.00 7162.00
2002 E 6595.00 2644.00
2000 M 6646.00 9390.00
2008 P 6696.00 8070.00
2003 C 6725.00 9058.00
2004 P 6745.00 6060.00
2002 B 6960.00 5446.00
2005 C 7015.00 8798.00
2006 P 7019.00 8702.00
2005 D 7067.00 1232.00
2004 B 7133.00 9529.00
2002 P 7135.00 7005.00
2008 L 7145.00 8213.00
2009 C 7147.00 9260.00
2003 O 7166.00 8344.00
2007 H 7184.00 8591.00
2001 C 7264.00 2561.00
2009 N 7398.00 8520.00
2003 K 7545.00 277.00
2006 M 7576.00 8802.00
2009 M 7604.00 9689.00
2006 D 7734.00 4564.00
2007 A 7759.00 7131.00
2005 L 7780.00 8629.00
2001 O 7798.00 3380.00
2002 M 7956.00 2699.00
2003 G 8201.00 7433.00
2006 N 8205.00 4906.00
2008 A 8249.00 6330.00
2004 I 8306.00 3813.00
2008 N 8358.00 6190.00
2002 I 8435.00 4017.00
2004 L 8441.00 8741.00
2006 K 8527.00 313.00
2004 K 8564.00 6500.00
2007 G 8898.00 2634.00
2007 L 8972.00 2953.00
2000 C 8988.00 2330.00
2001 G 9002.00 437.00
2009 P 9062.00 4748.00
2000 B 9088.00 6072.00
2000 O 9474.00 4339.00
2005 E 9515.00 5160.00
2003 H 9584.00 5417.00
2006 I 9614.00 9526.00
2009 O 9616.00 6763.00
2002 L 9825.00 3453.00

Question 2:         Use Data2 Sheet

2a.          Conduct a 2-level sort: on Fiscal Year (Largest to Smallest) and then on Company code (Z to A).

                                Report company code and year of 5th record (do not count the header of the table).

                                In Answer Sheet, put Company code and year continuously like: K2002

2b.          For each company, calculate the annual sales growth. Report the company code and year of the 8th Highest growth number.

                Annual sales growth = Sale year (i)/Sale year (i-1) -1

                                In Answer Sheet, put Company code and year continuously like: K2002

2c.          For each year, if you want to find a firm with the smallest Sales, how will you sort the data so that you can systematically identify these records? (this sort answers a question such as: in 2002, which firm has the lowest sales number?)

                                Sort first by:

                                Then by:

                                Then by:

                                Then by:

In Answer Sheet, we use column A, B, C, D instead of typing Fiscal year (column A), Company code (column B), Sales (column C) …

So if you think you should sort on Fiscal Year (column A), then on Company Code (column B), then on Sales (column C), simply type ABC

Solutions

Expert Solution

Q2a Fifth record
Company code L
Year 2009
L2009
Q2b 2009C
Q2c Sort first by Fiscal year Smallest to largest
Then By Sales Smallest to largest
Then By Company code

A to Z

Fiscal Year Company code Sales (millions) Number of Customers
2000 K 470 6024
2000 N 970 9896
2000 L 1480 8804
2000 P 1546 4547
2000 I 2359 6726
2000 E 3375 7578
2000 A 3698 5941
2000 H 4197 2272
2000 D 5570 6787
2000 G 5801 2664
2000 M 6646 9390
2000 C 8988 2330
2000 B 9088 6072
2000 O 9474 4339
2001 K 523 2644
2001 D 1526 9694
2001 H 2128 6303
2001 B 2297 8865
2001 E 2298 6285
2001 I 2530 2474
2001 N 3635 2641
2001 P 4876 9627
2001 L 6230 1330
2001 M 6349 4803
2001 A 6398 3494
2001 C 7264 2561
2001 O 7798 3380
2001 G 9002 437
2002 K 203 1103
2002 H 1354 9824
2002 O 1372 230
2002 A 2217 1083
2002 D 3526 500
2002 G 4280 9513
2002 C 4640 7953
2002 N 4784 327
2002 E 6595 2644
2002 B 6960 5446
2002 P 7135 7005
2002 M 7956 2699
2002 I 8435 4017
2002 L 9825 3453
2003 I 478 9226
2003 L 1538 7319
2003 D 1582 8827
2003 M 1861 3924
2003 B 3074 2605
2003 E 3140 8093
2003 A 3157 3296
2003 P 3378 2139
2003 N 6268 7765
2003 C 6725 9058
2003 O 7166 8344
2003 K 7545 277
2003 G 8201 7433
2003 H 9584 5417
2004 H 902 9240
2004 N 1078 863
2004 A 2302 3106
2004 C 2362 5379
2004 O 2367 8230
2004 G 3335 5684
2004 D 3393 2868
2004 E 3853 1467
2004 M 6101 8082
2004 P 6745 6060
2004 B 7133 9529
2004 I 8306 3813
2004 L 8441 8741
2004 K 8564 6500
2005 B 1985 9416
2005 G 2151 8743
2005 O 2659 8243
2005 I 2887 6675
2005 H 3620 8803
2005 P 4224 2151
2005 M 5055 5559
2005 N 5221 5446
2005 K 5952 9790
2005 A 5995 1910
2005 C 7015 8798
2005 D 7067 1232
2005 L 7780 8629
2005 E 9515 5160
2006 O 1346 7265
2006 E 1431 7018
2006 G 2687 6088
2006 L 2898 4667
2006 A 3620 627
2006 C 5463 7089
2006 H 5690 8200
2006 B 5924 8727
2006 P 7019 8702
2006 M 7576 8802
2006 D 7734 4564
2006 N 8205 4906
2006 K 8527 313
2006 I 9614 9526
2007 I 1366 3728
2007 O 1520 4079
2007 B 2554 300
2007 M 2570 1015
2007 C 2877 830
2007 P 3620 5203
2007 D 4112 9247
2007 N 4146 2962
2007 E 4838 6613
2007 K 6101 954
2007 H 7184 8591
2007 A 7759 7131
2007 G 8898 2634
2007 L 8972 2953
2008 E 581 3252
2008 K 1500 7011
2008 C 1579 958
2008 I 3754 3812
2008 B 3972 1289
2008 O 4192 3199
2008 H 6229 7640
2008 M 6580 1020
2008 D 6585 8559
2008 G 6594 7162
2008 P 6696 8070
2008 L 7145 8213
2008 A 8249 6330
2008 N 8358 6190
2009 B 1523 5215
2009 I 1560 4889
2009 H 2530 320
2009 K 3037 9862
2009 A 3136 7330
2009 L 4300 7610
2009 D 4944 8902
2009 G 5230 3026
2009 E 5726 8354
2009 C 7147 9260
2009 N 7398 8520
2009 M 7604 9689
2009 P 9062 4748
2009 O 9616 6763

Related Solutions

Please answer all the parts of this question Please answer all the parts of this question...
Please answer all the parts of this question Please answer all the parts of this question Question: a) Where is the flow accelerating in the control volume? b) Will the pressure be greater or less than hydrostatic in a region of accelerating flow? c) Is the hydrostatic estimate of force on the gate; larger, smaller, or the same, as that obtained from the Momentum Equation? Explain. d) Where does the change in flow momentum go in this control volume? Explain.
Can you please explain the asnwer for #1 (parts A - D) 1) A company manufactures...
Can you please explain the asnwer for #1 (parts A - D) 1) A company manufactures hair dryers. It buys some of the components, but it makes the heating element, which it can produce at the rate of 800 per day. Hair dryers are assembled daily, 250 days a year, at a rate of 300 per day. Because of the disparity between the production and usage rates, the heating elements are periodically produced in batches of 2,000 units. A) Approximately...
please asnwer all parts of question 5 Date Yearmonth SP500 WMT MSFT MGM CERN XOM 12/3/2012...
please asnwer all parts of question 5 Date Yearmonth SP500 WMT MSFT MGM CERN XOM 12/3/2012 201212 1426.19 65.33 25.39 11.64 38.76 82.52 11/1/2012 201211 1416.18 68.58 25.31 10.15 38.61 84.03 10/1/2012 201210 1412.16 71.43 26.91 10.31 38.1 86.38 9/4/2012 201209 1440.67 70.27 28.06 10.75 38.69 86.65 8/1/2012 201208 1406.58 69.13 29.06 9.86 36.57 82.72 7/2/2012 201207 1379.32 70.49 27.61 9.52 36.96 81.76 6/1/2012 201206 1362.16 66.03 28.66 11.16 41.33 80.55 5/1/2012 201205 1310.33 62.34 27.34 10.83 38.98 74.02 4/2/2012...
answer all parts please Brunell Products has projected the following sales for the coming year:   ...
answer all parts please Brunell Products has projected the following sales for the coming year:    Q1 Q2 Q3 Q4 Sales $360 $450 $600 $540    Sales in the year following this one are projected to be 10 percent greater in each quarter.    Calculate payments to suppliers assuming that the company places orders during each quarter equal to 25 percent of projected sales for the next quarter. Assume that the company pays immediately.    a. What is the payables...
Please answer all parts of this question for both parts!! Prompt: In our study of the...
Please answer all parts of this question for both parts!! Prompt: In our study of the skeletal system this week it should be readily apparent to you how important synovial joints are in the normal function of the human body. This week you will pick two synovial joints to discuss. Pick one from each category below. For each selected joint you should provide the following information: the movements that are possible at that joint (use appropriate anatomical terminology), identification of...
Please solve all parts of the following question. Please show all work and all steps. 1a.)...
Please solve all parts of the following question. Please show all work and all steps. 1a.) Solve x' = x + 3y + 2t y' = x - y + t^2 1b.) Solve x' + ty = -1 y' + x' = 2 1c.) Solve x' + y = 3t y' - tx' = 0
Please answer all parts of the question. Please show all work and all steps. 1a.) Show...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show that the solutions of x' = arc tan (x) + t cannot have maxima 1b.) Find the value of a such that the existence and uniqueness theorem applies to the ivp x' = (3/2)((|x|)^(1/3)), x(0) = a. 1c.) Find the limits, as t approaches both positive infinity and negative infinity, of the solution Φ(t) of the ivp x' = (x+2)(1-x^4), x(0) = 0
HELLO, PLEASE ANSWER THE FOLLOWING QUESTION. IT WAS ASSIGNED WITH 2 PARTS. THANKS 42A) A company...
HELLO, PLEASE ANSWER THE FOLLOWING QUESTION. IT WAS ASSIGNED WITH 2 PARTS. THANKS 42A) A company uses the periodic inventory system and had the following activity during the current monthly period. November 1: Beginning inventory 112 Units @ $20 November 5: Purchased 112 Units @ $22 November 8: Purchased 62 Units @ $23 November 16: Sold 174 Units @ $105 November 19: Purchased 75 Units @ $25 Using the weighted-average inventory method, the company's ending inventory would be 42B. A...
Please make sure to complete all parts of the question and to show all work used...
Please make sure to complete all parts of the question and to show all work used to compute the answer so I can see how the answer was found. A five-year annuity of 10 $5,230 semiannual payments will begin nine years from now, with the first payment coming nine and a half years from now. If the discount rate is 10 percent compounded monthly, what is the value of this annuity five years from now? What is the value three...
Java Problem: Please answer both parts of the question fully: (a). Write Java code for a...
Java Problem: Please answer both parts of the question fully: (a). Write Java code for a method to test if a LinkedList<Long> has Long values that form a Fibonacci sequence from the beginning to the end and return true if it is and false otherwise. A sequence of values is Fibonnaci if every third value is equal to sum of the previous two. Eg., 3,4,7,11,18,29 is a Fibonacci sequence whereas 1,2,3,4 is not, because 2+3 is not equal to 4....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT