QSO 320 Milestone Three Sales City Date Sales Rep Type Wine $7,451 Los Angeles Feb Bill Red $11,221 Los Angeles Jun Joe Organic $9,525 San Francisco Jun Jane Red $3,986 San Diego May Jane Organic $11,667 San Diego Apr Bill White $11,649 San Francisco Mar Jane Red $9,010 San Diego Feb Jane Red $5,686 Los Angeles Jan Joe Red $9,121 San Francisco Mar Jane Organic $8,703 San...
50.1K
Verified Solution
Link Copied!
Question
General Management
QSO 320 Milestone Three
Sales City Date Sales Rep Type Wine $7,451 Los Angeles Feb Bill Red $11,221 Los Angeles Jun Joe Organic $9,525 San Francisco Jun Jane Red $3,986 San Diego May Jane Organic $11,667 San Diego Apr Bill White $11,649 San Francisco Mar Jane Red $9,010 San Diego Feb Jane Red $5,686 Los Angeles Jan Joe Red $9,121 San Francisco Mar Jane Organic $8,703 San Francisco Apr Jane Red $4,369 San Diego Feb Jane Organic $5,936 Los Angeles Feb Bill White $9,990 San Diego May Joe Organic $5,217 San Diego Apr Bill White $5,582 San Francisco Apr Joe Red $7,913 Los Angeles Jun Jane White $8,581 San Francisco Jan Joe Red $7,472 San Diego Feb Bill Red $4,716 San Francisco Feb Joe White $3,020 San Diego Jan Jane Organic $11,552 San Francisco Apr Jane Red $8,507 Los Angeles Mar Joe White $8,573 San Francisco Mar Bill White $4,827 San Diego Jun Jane Red $11,146 San Diego Jun Joe Organic $10,898 San Diego Apr Jane Red $10,424 San Francisco Apr Bill White $6,077 Los Angeles Apr Bill White $4,908 Los Angeles Feb Jane White $4,652 San Francisco Jan Jane White $7,498 San Diego Apr Joe Organic $4,641 San Diego Jun Bill White $10,440 San Diego Jan Jane White $4,168 San Diego Mar Joe Red $4,031 San Francisco Feb Bill White $4,031 San Francisco Feb Jane White $7,498 San Diego Apr Jane Organic $8,305 San Diego Feb Jane Red $4,788 San Francisco May Jane White $11,953 San Diego May Joe White $11,482 San Francisco Jun Jane Red $11,959 San Diego Jan Jane White $8,681 San Francisco Jun Jane Organic $10,399 Los Angeles Mar Joe Red $11,310 Los Angeles Feb Joe Red $6,981 San Francisco Jun Jane Organic $8,758 Los Angeles May Jane Organic $9,837 San Diego May Bill Red $4,276 San Francisco Apr Joe White $7,515 San Francisco Apr Bill Red $10,497 Los Angeles May Bill Red $8,587 San Francisco Jan Bill White $7,373 Los Angeles Feb Joe White $8,722 San Francisco Jan Joe Red $5,607 San Francisco Jun Joe White $11,029 San Francisco Jan Bill White $6,262 San Francisco Mar Bill Organic $9,432 San Diego May Bill Organic $6,685 San Diego Apr Joe Organic $3,913 San Diego Jan Joe Red $7,642 Los Angeles Mar Bill Organic $9,549 San Diego Mar Jane White $9,014 San Diego Feb Bill White $7,390 San Francisco May Jane Organic $3,390 Los Angeles Feb Bill Red $4,670 San Francisco Jun Joe Organic $8,535 Los Angeles Jun Jane Red $9,112 San Francisco May Bill Red $8,197 San Francisco Jan Joe Red $3,287 Los Angeles Jan Jane Red $6,388 Los Angeles Apr Bill White $9,887 San Diego Jan Joe Red $6,326 Los Angeles Feb Joe Organic $10,694 Los Angeles Jan Joe White $9,779 San Francisco Jun Bill Red $10,157 San Francisco May Joe Red $5,286 San Francisco Jan Joe Red $8,516 Los Angeles May Bill White $7,177 San Diego Apr Bill White $6,312 Los Angeles May Joe Organic $5,546 San Diego Feb Bill Red $5,294 San Francisco Jan Jane White $7,879 San Francisco Mar Jane White $6,437 San Francisco Jun Bill Red $6,061 San Diego Jan Jane Organic $7,763 San Francisco Jun Jane White $5,761 Los Angeles Jun Bill Red $9,248 San Francisco Apr Joe Organic $10,919 San Francisco Feb Joe White $11,498 Los Angeles Jan Bill White $8,950 San Diego May Jane White $9,133 Los Angeles Mar Joe White $9,332 San Francisco Apr Bill Red $5,437 Los Angeles Feb Joe White $7,914 San Diego Feb Joe White $8,559 Los Angeles May Jane Red $8,274 San Francisco Mar Bill White $3,877 San Diego Jan Jane Organic $3,407 San Francisco Jan Bill Red $5,605 San Diego Jun Jane Red
1. For White and Organic wine, what were the Measures of CentralTendency based on the sales figures?
2. What would the total profit for each type of wine be giventhe following production costs for the wine; White wine 17% oftotal sales, red wine is 12%, and organic wine is 21%?
3. Deduct the sales commision discussed in question 2 fromMilestone Two: Data Analysis Part II and recalculate. Draft andpresent the answers.
4. How would you summarize the provided data? Develop pivottables using the cle
Commision Data
F. What would thesales commision be for each month if each salesperson earned 5% ofthe sales? Monthly Sales Sales Rep Jan Feb Mar April May June 6 Month Total Bill $34,521.00 $42,840.00 $30,751.00 $63,797.00 $47,394.00 $26,618.00 $245,921.00 Jane $48,590.00 $30,623.00 $38,198.00 $38,651.00 $42,431.00 $71,312.00 $269,805.00 Joe $60,966.00 $53,995.00 $32,207.00 $33,289.00 $38,412.00 $32,644.00 $251,513.00 Total Sales $767,239.00 Sales Commision 5% of sales Monthly Commision by Sales Rep Sales Rep Jan Feb Mar April May June 6 Month Total Bill $1,726.05 $2,142.00 $1,537.55 $3,189.85 $2,369.70 $1,330.90 $12,296.05 Jane $2,429.50 $1,531.15 $1,909.90 $1,932.55 $2,121.55 $3,565.60 $13,490.25 Joe $3,048.30 $2,699.75 $1,610.35 $1,664.45 $1,920.60 $1,632.20 $12,575.65 Total Commision $38,361.95
QSO 320 Milestone Three
| Sales | City | Date | Sales Rep | Type Wine | |
| $7,451 | Los Angeles | Feb | Bill | Red | |
| $11,221 | Los Angeles | Jun | Joe | Organic | |
| $9,525 | San Francisco | Jun | Jane | Red | |
| $3,986 | San Diego | May | Jane | Organic | |
| $11,667 | San Diego | Apr | Bill | White | |
| $11,649 | San Francisco | Mar | Jane | Red | |
| $9,010 | San Diego | Feb | Jane | Red | |
| $5,686 | Los Angeles | Jan | Joe | Red | |
| $9,121 | San Francisco | Mar | Jane | Organic | |
| $8,703 | San Francisco | Apr | Jane | Red | |
| $4,369 | San Diego | Feb | Jane | Organic | |
| $5,936 | Los Angeles | Feb | Bill | White | |
| $9,990 | San Diego | May | Joe | Organic | |
| $5,217 | San Diego | Apr | Bill | White | |
| $5,582 | San Francisco | Apr | Joe | Red | |
| $7,913 | Los Angeles | Jun | Jane | White | |
| $8,581 | San Francisco | Jan | Joe | Red | |
| $7,472 | San Diego | Feb | Bill | Red | |
| $4,716 | San Francisco | Feb | Joe | White | |
| $3,020 | San Diego | Jan | Jane | Organic | |
| $11,552 | San Francisco | Apr | Jane | Red | |
| $8,507 | Los Angeles | Mar | Joe | White | |
| $8,573 | San Francisco | Mar | Bill | White | |
| $4,827 | San Diego | Jun | Jane | Red | |
| $11,146 | San Diego | Jun | Joe | Organic | |
| $10,898 | San Diego | Apr | Jane | Red | |
| $10,424 | San Francisco | Apr | Bill | White | |
| $6,077 | Los Angeles | Apr | Bill | White | |
| $4,908 | Los Angeles | Feb | Jane | White | |
| $4,652 | San Francisco | Jan | Jane | White | |
| $7,498 | San Diego | Apr | Joe | Organic | |
| $4,641 | San Diego | Jun | Bill | White | |
| $10,440 | San Diego | Jan | Jane | White | |
| $4,168 | San Diego | Mar | Joe | Red | |
| $4,031 | San Francisco | Feb | Bill | White | |
| $4,031 | San Francisco | Feb | Jane | White | |
| $7,498 | San Diego | Apr | Jane | Organic | |
| $8,305 | San Diego | Feb | Jane | Red | |
| $4,788 | San Francisco | May | Jane | White | |
| $11,953 | San Diego | May | Joe | White | |
| $11,482 | San Francisco | Jun | Jane | Red | |
| $11,959 | San Diego | Jan | Jane | White | |
| $8,681 | San Francisco | Jun | Jane | Organic | |
| $10,399 | Los Angeles | Mar | Joe | Red | |
| $11,310 | Los Angeles | Feb | Joe | Red | |
| $6,981 | San Francisco | Jun | Jane | Organic | |
| $8,758 | Los Angeles | May | Jane | Organic | |
| $9,837 | San Diego | May | Bill | Red | |
| $4,276 | San Francisco | Apr | Joe | White | |
| $7,515 | San Francisco | Apr | Bill | Red | |
| $10,497 | Los Angeles | May | Bill | Red | |
| $8,587 | San Francisco | Jan | Bill | White | |
| $7,373 | Los Angeles | Feb | Joe | White | |
| $8,722 | San Francisco | Jan | Joe | Red | |
| $5,607 | San Francisco | Jun | Joe | White | |
| $11,029 | San Francisco | Jan | Bill | White | |
| $6,262 | San Francisco | Mar | Bill | Organic | |
| $9,432 | San Diego | May | Bill | Organic | |
| $6,685 | San Diego | Apr | Joe | Organic | |
| $3,913 | San Diego | Jan | Joe | Red | |
| $7,642 | Los Angeles | Mar | Bill | Organic | |
| $9,549 | San Diego | Mar | Jane | White | |
| $9,014 | San Diego | Feb | Bill | White | |
| $7,390 | San Francisco | May | Jane | Organic | |
| $3,390 | Los Angeles | Feb | Bill | Red | |
| $4,670 | San Francisco | Jun | Joe | Organic | |
| $8,535 | Los Angeles | Jun | Jane | Red | |
| $9,112 | San Francisco | May | Bill | Red | |
| $8,197 | San Francisco | Jan | Joe | Red | |
| $3,287 | Los Angeles | Jan | Jane | Red | |
| $6,388 | Los Angeles | Apr | Bill | White | |
| $9,887 | San Diego | Jan | Joe | Red | |
| $6,326 | Los Angeles | Feb | Joe | Organic | |
| $10,694 | Los Angeles | Jan | Joe | White | |
| $9,779 | San Francisco | Jun | Bill | Red | |
| $10,157 | San Francisco | May | Joe | Red | |
| $5,286 | San Francisco | Jan | Joe | Red | |
| $8,516 | Los Angeles | May | Bill | White | |
| $7,177 | San Diego | Apr | Bill | White | |
| $6,312 | Los Angeles | May | Joe | Organic | |
| $5,546 | San Diego | Feb | Bill | Red | |
| $5,294 | San Francisco | Jan | Jane | White | |
| $7,879 | San Francisco | Mar | Jane | White | |
| $6,437 | San Francisco | Jun | Bill | Red | |
| $6,061 | San Diego | Jan | Jane | Organic | |
| $7,763 | San Francisco | Jun | Jane | White | |
| $5,761 | Los Angeles | Jun | Bill | Red | |
| $9,248 | San Francisco | Apr | Joe | Organic | |
| $10,919 | San Francisco | Feb | Joe | White | |
| $11,498 | Los Angeles | Jan | Bill | White | |
| $8,950 | San Diego | May | Jane | White | |
| $9,133 | Los Angeles | Mar | Joe | White | |
| $9,332 | San Francisco | Apr | Bill | Red | |
| $5,437 | Los Angeles | Feb | Joe | White | |
| $7,914 | San Diego | Feb | Joe | White | |
| $8,559 | Los Angeles | May | Jane | Red | |
| $8,274 | San Francisco | Mar | Bill | White | |
| $3,877 | San Diego | Jan | Jane | Organic | |
| $3,407 | San Francisco | Jan | Bill | Red | |
| $5,605 | San Diego | Jun | Jane | Red | |
1. For White and Organic wine, what were the Measures of CentralTendency based on the sales figures?
2. What would the total profit for each type of wine be giventhe following production costs for the wine; White wine 17% oftotal sales, red wine is 12%, and organic wine is 21%?
3. Deduct the sales commision discussed in question 2 fromMilestone Two: Data Analysis Part II and recalculate. Draft andpresent the answers.
4. How would you summarize the provided data? Develop pivottables using the cle
Commision Data
| F. What would thesales commision be for each month if each salesperson earned 5% ofthe sales? | ||||||||
| Monthly Sales | ||||||||
| Sales Rep | Jan | Feb | Mar | April | May | June | 6 Month Total | |
| Bill | $34,521.00 | $42,840.00 | $30,751.00 | $63,797.00 | $47,394.00 | $26,618.00 | $245,921.00 | |
| Jane | $48,590.00 | $30,623.00 | $38,198.00 | $38,651.00 | $42,431.00 | $71,312.00 | $269,805.00 | |
| Joe | $60,966.00 | $53,995.00 | $32,207.00 | $33,289.00 | $38,412.00 | $32,644.00 | $251,513.00 | |
| Total Sales | $767,239.00 | |||||||
| Sales Commision | 5% of sales | |||||||
| Monthly Commision by Sales Rep | ||||||||
| Sales Rep | Jan | Feb | Mar | April | May | June | 6 Month Total | |
| Bill | $1,726.05 | $2,142.00 | $1,537.55 | $3,189.85 | $2,369.70 | $1,330.90 | $12,296.05 | |
| Jane | $2,429.50 | $1,531.15 | $1,909.90 | $1,932.55 | $2,121.55 | $3,565.60 | $13,490.25 | |
| Joe | $3,048.30 | $2,699.75 | $1,610.35 | $1,664.45 | $1,920.60 | $1,632.20 | $12,575.65 | |
| Total Commision | $38,361.95 | |||||||
Answer & Explanation Solved by verified expert
4.0 Ratings (528 Votes)
1 For White Sales City Date Sales Rep Type Wine 1166700 San Diego Apr Bill White 593600 Los Angeles Feb Bill White 521700 San Diego Apr Bill White 791300 Los Angeles Jun Jane White 471600 San Francisco Feb Joe White 850700 Los Angeles Mar Joe White 857300 San Francisco Mar Bill White 1042400 San Francisco Apr Bill White 607700 Los Angeles Apr Bill White 490800 Los Angeles Feb Jane White 465200 San Francisco Jan Jane White 464100 San Diego Jun Bill White 1044000 San Diego Jan Jane White 403100 San Francisco Feb Bill White 403100 San Francisco Feb Jane White 478800 San Francisco May Jane White 1195300 San Diego May Joe White 1195900 San Diego Jan Jane White 427600 San Francisco Apr Joe White 858700 San Francisco Jan Bill White 737300 Los Angeles Feb Joe White 560700 San Francisco Jun Joe White 1102900 San Francisco Jan Bill White 954900 San Diego Mar Jane White 901400 San Diego Feb Bill White 638800 Los Angeles Apr Bill White 1069400 Los Angeles Jan Joe White 851600 Los Angeles May Bill White 717700 San Diego Apr Bill White 529400 San Francisco Jan Jane White 787900 San Francisco Mar Jane White 776300 San Francisco Jun Jane White 1091900 San Francisco Feb Joe White 1149800 Los Angeles Jan Bill White 895000 San Diego May Jane White 913300 Los Angeles Mar Joe White 543700 Los Angeles Feb Joe White 791400 San Diego Feb Joe White 827400 San Francisco Mar Bill White Mean 773600 Median 791300 Mode 4031 For organic Sales City Date Sales Rep Type Wine 1122100 Los Angeles Jun Joe Organic 398600 San Diego May Jane Organic 912100 San Francisco Mar Jane Organic 436900 San Diego Feb Jane Organic 999000 San Diego May Joe Organic 302000 San Diego Jan Jane Organic 1114600 San Diego Jun Joe Organic 749800 San Diego Apr Joe Organic
See Answer
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.