In the Summary sheet, create a new column to the right of %Total Sales to Dealers Annual.
Fantastic news! We've Found the answer you've been seeking!
Question:
In the Summary sheet, create a new column to the right of “%Total Sales to Dealers Annual”. Name it “Top Model?”. Format this column to have borders that match the rest of the table. Use a function to display “TOP” for each model that has a % of total sales greater than the average of the % total sales for all models.(Using Excel)
Transcribed Image Text:
%Total %Total %Total Top Model Sales to Sales to Sales to July-December Sales to Dealer Annual Jan-June Sales Total Sales to Dealers Dealers Dealers Volume 260 Jan-June July-Dec 0.21 Model to Dealer Dealers Annual 5.473,683.28 5,821,218.73 11,294,902.01 6,816,608.57 VX207 0.24 0.23 0.27 0.14 VX212 VX208 VX217 159 6,816,608.57 883 35.272,858.04 35,272,858.04 60,712,724.58 1.46 0.71 30,587,502.11 56.003.840.64 94,514,075.28 100,581,879.93 191,578, 127.63 22,835,451.32 152,479,783.53 156,593.107.66 1576 30,125,222.48 1.19 1.24 1.22 VX220 2870 52,232,538.24 94,655,246.42 108,236,378.88 189, 169,321.70 201,554,576.06 380,456,046.15 23,176,788.41 306,667,449.93 258,443,835.00 524,824.32 315,246, 184.67 2.18 2.16 2.17 5360 VX219 VX201 3.68 3.91 3.79 5673 100,972,696.13 3.91 4.17 4.04 7.46 7.62 0.46 VX209 11131 188,877.918.52 341,337.09 154,187,666.41 101,850,727.34 524,824.32 158,217,784.25 156,368,569.90 7.79 VX204 679 0.89 0.01 5.93 6.09 6.36 VX215 VX210 8978 6.14 4.20 0.02 8125 5.18 VX211 16 0.01 VX216 VX214 10602 6.11 157,028.400.42 157,093,841.56 6.53 6.31 10805 313,462,411.45 6.11 6.45 6.28 6.58 5.13 164,559,987.24 128,176,406.06 182,420,189.91 127,815,757.09 VX224 11448 163,756,975.80 127,850,864.90 245,727,863.64 328,316,963.04 256,027,270.97 428,148,053.55 256,910,071.30 250,354,419.65 338,108,335.49 228,932,028.00 251,884,312.82 222,212,558.34 221,179,543.20 6.37 6.79 VX218 11797 4.98 5.29 7.53 5.27 VX223 9.56 8.57 5.15 5.01 21114 VX213 12860 129,094,314.21 5.02 4.84 VX206 VX202 VX205 12866 124,398,865.60 168,836,501.43 125,955,554.05 169,271,834.05 98,616,873.60 125.495, 164.22 5.20 6.98 4.07 18640 6.57 6.77 130,315,154.40 126,389,148.59 111,017,084.94 12610 5.07 4.58 VX222 14933 4.92 5.18 5.04 VX221 14948 111,195,473.40 110,532,322.37 4.32 4.59 4.45 VX203 15400 110,647,220.83 4.31 4.56 4.43 Total 213733 $2,569,620,296.27 $2,423,488,169.86| S4,993, 108,466.13| 100 100 100.00 %Total %Total %Total Top Model Sales to Sales to Sales to July-December Sales to Dealer Annual Jan-June Sales Total Sales to Dealers Dealers Dealers Volume 260 Jan-June July-Dec 0.21 Model to Dealer Dealers Annual 5.473,683.28 5,821,218.73 11,294,902.01 6,816,608.57 VX207 0.24 0.23 0.27 0.14 VX212 VX208 VX217 159 6,816,608.57 883 35.272,858.04 35,272,858.04 60,712,724.58 1.46 0.71 30,587,502.11 56.003.840.64 94,514,075.28 100,581,879.93 191,578, 127.63 22,835,451.32 152,479,783.53 156,593.107.66 1576 30,125,222.48 1.19 1.24 1.22 VX220 2870 52,232,538.24 94,655,246.42 108,236,378.88 189, 169,321.70 201,554,576.06 380,456,046.15 23,176,788.41 306,667,449.93 258,443,835.00 524,824.32 315,246, 184.67 2.18 2.16 2.17 5360 VX219 VX201 3.68 3.91 3.79 5673 100,972,696.13 3.91 4.17 4.04 7.46 7.62 0.46 VX209 11131 188,877.918.52 341,337.09 154,187,666.41 101,850,727.34 524,824.32 158,217,784.25 156,368,569.90 7.79 VX204 679 0.89 0.01 5.93 6.09 6.36 VX215 VX210 8978 6.14 4.20 0.02 8125 5.18 VX211 16 0.01 VX216 VX214 10602 6.11 157,028.400.42 157,093,841.56 6.53 6.31 10805 313,462,411.45 6.11 6.45 6.28 6.58 5.13 164,559,987.24 128,176,406.06 182,420,189.91 127,815,757.09 VX224 11448 163,756,975.80 127,850,864.90 245,727,863.64 328,316,963.04 256,027,270.97 428,148,053.55 256,910,071.30 250,354,419.65 338,108,335.49 228,932,028.00 251,884,312.82 222,212,558.34 221,179,543.20 6.37 6.79 VX218 11797 4.98 5.29 7.53 5.27 VX223 9.56 8.57 5.15 5.01 21114 VX213 12860 129,094,314.21 5.02 4.84 VX206 VX202 VX205 12866 124,398,865.60 168,836,501.43 125,955,554.05 169,271,834.05 98,616,873.60 125.495, 164.22 5.20 6.98 4.07 18640 6.57 6.77 130,315,154.40 126,389,148.59 111,017,084.94 12610 5.07 4.58 VX222 14933 4.92 5.18 5.04 VX221 14948 111,195,473.40 110,532,322.37 4.32 4.59 4.45 VX203 15400 110,647,220.83 4.31 4.56 4.43 Total 213733 $2,569,620,296.27 $2,423,488,169.86| S4,993, 108,466.13| 100 100 100.00
Expert Answer:
Answer rating: 100% (QA)
Please note that the cell address used by me eg I2 and H2 are abou... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
If you add a new column to an existing table, where does the column appear in relation to existing columns?
-
Add a new column to Table 10.1, listing the specific gravity of each substance. TABLE 10.1 Densities of Some Common Solids, Liquids, and Gases Density (kg/m) Substance SOLIDS Ice (at 0C) 917 Aluminum...
-
Create an Excel sheet that calculates safety stock for six different products. For a given set of historical demand, you should be able to experiment with different desired service levels, and lead...
-
A 0.831-g sample of SO3 is placed in a 1.00-L container and heated to 1100 K. The SO3 decomposes to SO2 and O2: At equilibrium the total pressure in the container is 1.300 atm. Find the values of Kp...
-
Time Warner has bonds that are selling for $ 1,371. The coupon interest rate on the bonds is 9.15 percent and they mature in 21 years. What is the yield to maturity on the bonds? What is the current...
-
A new method of postoperative treatment was evaluated for patients undergoing a certain surgical procedure. Under the old method, the mean length of hospital stay was 6.3 days. The sample mean for...
-
A test of homogeneity is performed and the null hypothesis is rejected. True or false: We can conclude that the distributions are not the same in every row.
-
1. Would it be best for Victoria Oilfield Equipment to select a manager who is a local (citizen of Nigeria), a home country national (citizen of the United States), or a third-country national...
-
Funding and support is very important in the improvement of a team-based approach to care as it is necessary in order to do any improvement mechanisms. What are ways for organizations to obtain...
-
Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are as follows: Consumer tests with coffee products were...
-
A District of Columbia ordinance prohibits the use of any vehicle in any form in a District of Columbia park. Does the ordinance apply to the following? Why or why not? How would you change the law...
-
The basic facts are not in dispute. At the trial the government presented the testimony of four Drug Enforcement Administration (DEA) special agents. In essence their testimony established that Soto...
-
Each of appellants four convictions of forcible rape involved a different victim but a similar scenario. Count 1: V.B. In late October of 2007, V.B. was working as a prostitute on Motel Drive when...
-
Whenever a man does a thoroughly stupid thing, it is always from the noblest motives . . . The Government alleges that on or about February through February 10, 2010, Defendant committed the crime of...
-
We relate the evidence in the light most favorable to the Commonwealth. On the day of the incident, the sixty-six year old victim went to an apartment building that she owned. Her purpose was to...
-
Jeremy Ferrara [Ferrara] appeals his conviction of burglary of a dwelling for stealing a screen door and attempting to steal copper tubing from the air conditioning unit of a vacant residence. He...
-
A comparative balance sheet for Allen Corporation reveals the following information: Assets Cash Bank notes account receivable Inventories Federal bonds State Bonds Prepaid Federal tax Building and...
-
U.S. households have become smaller over the years. The following table from the 2010 GSS contains information on the number of people currently aged 18 years or older living in a respondent's...
-
What does a database account with the CREATE SESSION privilege allow the user to do?
-
Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE * FROM homework10; b. DELETE *.* FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid...
-
Display the most recent publication date of all books sold by JustLee Books.
-
Refer to Problem P3-46 Problem P3-46 The accounts of Marciano Services Ltd. at March 31, 2020, are listed in alphabetical order. 1. Use the Marciano Lid. data in problem P3-46A to prepare the...
-
The accounts of Marciano Services Ltd. at March 31, 2020, are listed in alphabetical order. Requirements 1. All adjustments have been journalized and posted, but the closing entries have not been...
-
Sundance Apartments Inc.'s unadjusted and adjusted trial balance at April 30, 2020, follow: Requirements 1. Make the adjusting entries that account for the differences between the two trial balances....
Study smarter with the SolutionInn App