Sales G H E A Additional Bonus Based on Bonus Based on Average Sales Status Bonus Amount 954,670.00 Below Average 764.140.00 Below Average 675,930.00 Below Average Total Sales Status Status Sales Bonus Rate First Last 1 Identifier 400 S 954,270.00 2010130 Chastity Middleton $ 95,427.00 $15.904 50 Gold 2 400 S S 76,374.00 $12,729.00 Gold $ 67,553.00 $11.258.83 Gold $209,210.00 $107,669 00 $15.381 29 Platinum $1.615.035.00 $109,495.00 $ 15.642 14 Platinum $ 1,642,425.00 $177,853 00 $ 17,785 30 Platinum $2,667,795.00 S 68,248 00 S 9,749.71 Gold $209,210.00 763,740.00 2009242 Kasimir Baird Dyer 400 S 675,530.00 2010045 Sharon 500 S 3.138.650.00 Above Average $ 16,093.08 Platinum $ 3,138,150.00 Barnes 2009404 Alan 500 S 1615.535.00 Above Average 2009717 Candace Burt 6 500 $ 1,642,925.00 Above Average 500 S 2,668,295.00 Above Average 682 880 00 Below Average 500 S 3,138,650.00 Above Average 558,700.00 Above Average 2010392 Nina Craft 7 2009270 Isabella Leonard Russell 2009651 Lenore 2009404 Mason 2008397 Florence Rasmussen $103,880 00 2008649gor 400 S S 682,480.00 $ 16,093.08 Platinum S 3,138,150.00 $ 14,840 00 Platinum $1558,200 00 10 Osborne 500 S 11 $123,124 00 $17,589 14 Platinum $1846,860 00 S 54,257.00 $27,128 50 Silver 12 Rogers 500 S 1,847,360.00 Above Average 434,356.00 Below Average 2008883 Brandon Clayton 2008596 Jeanette Mcconnell $ 6,46100 $ 3,230 50 Bronze 2009169 Elmo 2008619 Hilel 13 434.056 00 300 S 14 200 S 200 S 38.966.00 Below Average 130.904.00 Below Average 359,676.00 Below Average 430.964.00 Below Average 346 180.00 Below Average 363,716.00 Below Average 38,766.00 130.704 00 359 376.00 $ 21,784.00 $ 10,892.00 Bronze $ 44,922 00 $14.974.00 Silver S 53,833.00 $17,944.33 Silver $ 43.235.00 $14,411 67 Silver $ 45.427 00 $15.142 33 Silver $177,853 00 $ 17,785 30 Platinum $2,567,795.00 $ 88,625.00 $ 22,156 25 Gold $112.116.00 $ 12.457 33 Platinum $ 1.681.74000 $145,836.00 $16.204 00 Platinum $ 2.187,540 00 $ 204,735 00 $ 22,748.33 Platinum $3,071.025 00 15 Lioyd 16 Petersen 2010625 Madonna Parks Banks Sanford S 300 S 300 S 300 S 300 S 500 $ 2.668.295.00 Above Average 400 S 500 S 1,682.240 00 Above Average 500 S 2,188,040.00 Above Average 500 $ 3.071.525.00 Above Average 500 $ 1964,645.00 Above Average 500 $ 1,600,535.00 Above Average 500 $ 1,950,635.00 Above Average 500 $ 1,521,170.0 17 430.664 00 18 2010427 Price 2009359 Levi 345,880 00 19 S 363,416 00 20 2009270 Hedwig Garcia 2008521 Jenette 21 Reese S 886,250 00 886,650 00 Below Average 2009193 Dexter 2008459 Reuben Langley 22 Johns 23 2009203 Lev 24 Rojas Blanchard $130,943.00 $ 13,094 30 Platinum S 1,964.145.00 2009947 Myra 2010313 Thomas Suarez 26 $106,669.00 $ 10,666.90 Platinum $ 1,600.035.00 $130,009.00 $ 101.378.00 5 20,275.60 Platinum $ 1,520,670.00 $77,650.00 S $ 14,445 44 Platinum $ 1,950,135.00 27 2009131 Samson Thornton 2008940 Kimberly Chavez 2008963 Piper 28 Below Average 776.900.00 Below Average 530.00 Gold Floyd S 776,500.00 400 S Company's 31 Average Sales $103,349 14 12 33 Number of Salespersons within each Status Category 34 Platinum 35 Gold 36 Silver 15 37 Bronze 2 Summary
Summary Which of the following formula will correctly compute the Average Sales for a salesperson in Summary!E2? Remember the formula would be copied in other cells of the same column. -AVERAGEI F(Sales! $A$2:$A$ 165,A2,Sales! $ B$2:$B$165) -AVERAGE (A2,Sales! $B$2:$ B$165) AVERAGEIF(Sales!A2:A165,A2,Sales B2:B165) -AVG(Sales!$A$2:$A$165,A2,Sales!$B$2:$B$165)
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Add Answer to:
A B 1 Identifier Total 2010130 20,047.00 2 2009242 $ 3 3,376.00 2010045 $ 6,151.00 4 2009404 $ 14,568.00 2009717...
2. In M6 create a calculation in excel to work out how many Clients have Bronze...
2. In M6 create a calculation in excel to
work out how many Clients have Bronze status. Copy the formula down
to M9.
3. In N6 create a calculation in excel to work out how many jobs
Clients with Bronze status have booked. Copy the formula down to
N9.
4. Create a Donut chart to show the percentage of clients of
each status. Change the Chart Title to Client Status and add Data
Labels to show percentages. Use Chart Element...
Use the following information for the next 3 questions. Metro Health & Spa offers three membership...
Use the following information for the next 3 questions. Metro Health & Spa offers three membership programs: Platinum, Gold and Silver. Metro incurs annual fixed costs of $19,200,000 Additional information about the programs is presented below Platinum Gold Silver 30,000 150,000120,000 $2,500 $1,000 $800 Variable cost per membership $1,000 $500 $200 Memberships sold Membership price 13. What is the weighted-average unit contribution margin? 14. Assuming that the sales mix of memberships remains constant, what is the total number of memberships...
Please help P(A)-P(B)-PAB)PAB n! 1. The medal distribution from the 2004 Summer Olympic Games is shown...
Please help
P(A)-P(B)-PAB)PAB n! 1. The medal distribution from the 2004 Summer Olympic Games is shown below. (Need to write all statements in the probability notations and do appropriate estimations.) 29Total 38 14 14 Countries Gold (G)Silver (S) Bronze (B) United States (U) Russia (R) China (C) Australia (A) Others (O) 35 27 32 17 133 2 244 39 27 17 16 136 E235 292 263 2A7 £422 Σ 727 Total 2 248 Write all statements in probability notations and...
Metro Health & Spa offers three membership programs: Platinum, Gold and Silver. Metro incurs annual fixed...
Metro Health & Spa offers three membership programs: Platinum, Gold and Silver. Metro incurs annual fixed costs of $19,200,000. Additional information about the programs is presented below: Platinum Gold Silver Memberships sold 30,000 150,000 120,000 Membership price $2,500 $1,000 $800 Variable cost per membership $1,000 $500 $200 13. What is the weighted-average unit contribution margin? 14. Assuming that the sales mix of memberships remains constant, what is the total number of memberships that the company must sell to break even?...
Marginal Cost Average Variable Cost Average Total Cost Quantity of Exercise Machines 1 2 3 4...
Marginal Cost Average Variable Cost Average Total Cost Quantity of Exercise Machines 1 2 3 4 5 6 7 8 9 10 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $200 $300 $400 $500 $600 $700 $800 $900 $1000 $1100 $1200 $800 $733.33 $750 $800 $866.67 $942.86 $1025 $1111.11 $1200 The above table shows the costs of a small manufacturer producing different quantities of exercise machines. If the exercise machine market is perfectly competitive and exercise machines cost...
Table 1.2 1 4 5 6 Average 2 3 Investment A 400 300 500 200 100...
Table 1.2 1 4 5 6 Average 2 3 Investment A 400 300 500 200 100 - 300 After tax benefits Value of Investment Jan 1 Dec 31 Average 200 ---- 1000 800 900 800 600 700 600 400 500 400 2000 300 100 --- 500 1 4 5 6 Average 2 3 Investment B 200 300 100 400 500 600 350 After tax benefits Value of Investment Jan 1 Dec 31 1000 833 917 833 666 750 666 499...
Table 1 Estimated Total Returns &...
Table 1 Estimated Total Returns State of the Economy Probability T-Bond SETX Golden S&P 500 Recession 5% 5% -19% 20% -14% Below Average 15% 5% 2% 13% 3% Average 45% 5% 9% 10% 11% Above Average 25% 5% 34% 5% 22% Boom 10% 5% 25% -5% 33% Golden's AA-Rated bonds yield 5.95%. What is the required return on Golden's stock using the bond risk premium method? (Assume 6% premium)
Marginal Cost Quantity of Exercise Machines Average Variable Cost Average Total Cost 1 2 3 4...
Marginal Cost Quantity of Exercise Machines Average Variable Cost Average Total Cost 1 2 3 4 5 6 7 8 9 10 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $200 $300 $400 $500 $600 $700 $800 $900 $1000 $1100 $1200 $800 $733.33 $750 $800 $866.67 $942.86 $1025 $1111.11 $1200 The above table shows the costs of a small manufacturer producing different quantities of exercise machines. If the exercise machine market is perfectly competitive and exercise machines cost...
Table 1 Estimated Total Returns &n
Table 1 Estimated Total Returns State of the Economy Probability T-Bond SETX Golden S&P 500 Recession 5% 5% -19% 20% -14% Below Average 15% 5% 2% 13% 3% Average 45% 5% 9% 10% 11% Above Average 25% 5% 34% 5% 22% Boom 10% 5% 25% -5% 33% Golden expects to have $1.45 in earnings next year. Golden had $1.30 in earnings 3 years ago. What should Golden sell for?
Table 1 Estimated Total Returns &n
Table 1 Estimated Total Returns State of the Economy Probability T-Bond SETX Golden S&P 500 Recession 5% 5% -19% 20% -14% Below Average 15% 5% 2% 13% 3% Average 45% 5% 9% 10% 11% Above Average 25% 5% 34% 5% 22% Boom 10% 5% 25% -5% 33% Why is the T-bond return in table 1 shown to be independent of the state of the economy? Is the return on a 1-year T-bond risk-free?
2. In M6 create a calculation in excel to
work out how many Clients have Bronze status. Copy the formula down
to M9.
3. In N6 create a calculation in excel to work out how many jobs
Clients with Bronze status have booked. Copy the formula down to
N9.
4. Create a Donut chart to show the percentage of clients of
each status. Change the Chart Title to Client Status and add Data
Labels to show percentages. Use Chart Element...
Use the following information for the next 3 questions. Metro Health & Spa offers three membership programs: Platinum, Gold and Silver. Metro incurs annual fixed costs of $19,200,000 Additional information about the programs is presented below Platinum Gold Silver 30,000 150,000120,000 $2,500 $1,000 $800 Variable cost per membership $1,000 $500 $200 Memberships sold Membership price 13. What is the weighted-average unit contribution margin? 14. Assuming that the sales mix of memberships remains constant, what is the total number of memberships...
Please help
P(A)-P(B)-PAB)PAB n! 1. The medal distribution from the 2004 Summer Olympic Games is shown below. (Need to write all statements in the probability notations and do appropriate estimations.) 29Total 38 14 14 Countries Gold (G)Silver (S) Bronze (B) United States (U) Russia (R) China (C) Australia (A) Others (O) 35 27 32 17 133 2 244 39 27 17 16 136 E235 292 263 2A7 £422 Σ 727 Total 2 248 Write all statements in probability notations and...
Marginal Cost Average Variable Cost Average Total Cost Quantity of Exercise Machines 1 2 3 4 5 6 7 8 9 10 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $200 $300 $400 $500 $600 $700 $800 $900 $1000 $1100 $1200 $800 $733.33 $750 $800 $866.67 $942.86 $1025 $1111.11 $1200 The above table shows the costs of a small manufacturer producing different quantities of exercise machines. If the exercise machine market is perfectly competitive and exercise machines cost...
Table 1.2 1 4 5 6 Average 2 3 Investment A 400 300 500 200 100 - 300 After tax benefits Value of Investment Jan 1 Dec 31 Average 200 ---- 1000 800 900 800 600 700 600 400 500 400 2000 300 100 --- 500 1 4 5 6 Average 2 3 Investment B 200 300 100 400 500 600 350 After tax benefits Value of Investment Jan 1 Dec 31 1000 833 917 833 666 750 666 499...
Marginal Cost Quantity of Exercise Machines Average Variable Cost Average Total Cost 1 2 3 4 5 6 7 8 9 10 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $200 $300 $400 $500 $600 $700 $800 $900 $1000 $1100 $1200 $800 $733.33 $750 $800 $866.67 $942.86 $1025 $1111.11 $1200 The above table shows the costs of a small manufacturer producing different quantities of exercise machines. If the exercise machine market is perfectly competitive and exercise machines cost...
Most questions answered within 3 hours.
-
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 52 minutes ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 54 minutes ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 59 minutes ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 1 hour ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 1 hour ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 1 hour ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 1 hour ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 1 hour ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 1 hour ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 2 hours ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 1 hour ago -
Inheritance pattern in BRCA 1
Describe the inheritance pattern of BRCA 1 Is it recessive or...
asked 1 hour ago