Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San...

Transcribed Image Text:

Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San Diego May $11,667 San Diego Apri $11,649 San Francisco Mar $9,010 San Diego Feb Feb $5,686 Los Angeles Jan $9,121 San Francisco Mar $8,703 San Francisco Apr $4,369 San Diego $5,936 Los Angeles $9,990 San Diego May Joe $5,217 San Diego Apr Bill $5,582 San Francisco Apr Joe $7,913 Los Angeles Jun Jane Feb $8,581 San Francisco Jan Joe $7,472 San Diego Feb Bill $4,716 San Francisco Feb $3,020 San Diego Jan $11,552 San Francisco Apr $8,507 Los Angeles Mar $8,573 San Francisco Mar $4,827 San Diego Jun $11,146 San Diego $10,898 San Diego Date Sales Rep Type Wine Bill Joe Jane Jane Red Organic Red Bill Jane Jane Joe Jane Jane Jane Bill Joe Jane Jane Joe Bill Jane Jun Joe Apri Jane Organic White Red Red Red Organic Red Organic White Organic White Red White Red Red White Organic Red White White Red Organic Red What are the total sales by person? Bill $ 245,921.00 Joe $ 251,513.00 Jane $ 269,805.00 $245,921.00 Bill Total Sales by Person Red Red Red $251,513.00 Joe $269,805.00 Jane What were the total sales of red wine in California over the last six month? Bill $ 95,536.00 Joe $ 101,154.00 Jane $ 77,475.00 $10,424 San Francisco Apr Bill $6,077 Los Angeles Apr Bill Jane $4,908 Los Angeles Feb $4,652 San Francisco Jan Jane Apri Joe $7,498 San Diego $4,641 San Diego $10,440 San Diego Jun Bill Jan Jane $4,168 San Diego Joe Mar $4,031 San Francisco Feb Bill $4,031 San Francisco Feb. Jane $7,498 San Diego Apr Jane $8,305 San Diego Feb Jane Jane Joe $4,788 San Francisco May $11,953 San Diego May Jane Jane Jane Joe $11,482 San Francisco Jun $11,959 San Diego Jan $8,681 San Francisco Jun $10,399 Los Angeles Mar $11,310 Los Angeles Feb Joe $6,981 San Francisco Jun Jane $8,758 Los Angeles May Jane $9,837 San Diego May Bill $4,276 San Francisco Apr Joe Bill Joe Joe Joe $7,515 San Francisco Apr Bill $10,497 Los Angeles May Bill $8,587 San Francisco Jan $7,373 Los Angeles Feb $8,722 San Francisco Jan $5,607 San Francisco Jun $11,029 San Francisco Jan Bill $6,262 San Francisco Mar Bill $9,432 San Diego May $6,685 San Diego $3,913 San Diego $7,642 Los Angeles Lan cao main rao v Bill Apri Joe Jan Joe Mar Bill AA.. Jame White White White White Organic White White Red White White Organic Red White White Red White Organic Red Red Organic Organic Red White Red Red White White Red White White Organic Organic Organic Red Organic JAZA. $95,536.00 Red Bill Total Sales Red Wine $299,361.00 $101,154.00 Red Joe Which Type of wine were the best and and worst sellers? Red $ 299,361.00 White $ 301,704.00 Organic $ 154,953.00 Sales by Type of Wine $301,704.00 $77,475.00 Red Jane $154,953.00 Jan Joe $3,913 San Diego $7,642 Los Angeles Mar Bill $9,549 San Diego Mar Jane $9,014 San Diego Feb Bill $7,390 San Francisco May Jane $3,390 Los Angeles Feb Jane Bill Joe Jane Bill Joe Bill $4,670 San Francisco Juni Joe $8,535 Los Angeles Jun $9,112 San Francisco May $8,197 San Francisco Jan $3,287 Los Angeles Jan $6,388 Los Angeles Apr $9,887 San Diego Jan $6,326 Los Angeles Feb $10,694 Los Angeles Jan Joe $9,779 San Francisco Jun $10,157 San Francisco May $5,286 San Francisco Jan $8,516 Los Angeles $7,177 San Diego $6,312 Los Angeles $5,546 San Diego Joe Bill Joe $5,294 San Francisco Jan $7,879 San Francisco Mar $6,437 San Francisco Jun $6,061 San Diego Jan $7,763 San Francisco Jun $5,761 Los Angeles Jun Jane Jane Bill $9,248 San Francisco Apr Joe Joe Bill Jane Joe May Bill Apr Bill May Joe Feb Bill Jane Jane Bill $10,919 San Francisco Feb $11,498 Los Angeles Jani $8,950 San Diego May Mar Joe $9,133 Los Angeles $9,332 San Francisco Apr Bill $5,437 Los Angeles Joe Feb $7,914 San Diego Feb Joe Red Organic White White Organic Red Organic Red Red Red Red White Red Organic White Red Red Red White White Organic Red White White Red Organic White Red Organic White White White White Red White White Red White Organic $7,914 San Diego Feb Joe $8,559 Los Angeles May Jane $8,274 San Francisco Mar Bill $3,877 San Diego Jan $3,407 San Francisco Jan $5,605 San Diego Jun Jane Bill Jane White Red White Organic Red Red Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San Diego May $11,667 San Diego Apri $11,649 San Francisco Mar $9,010 San Diego Feb Feb $5,686 Los Angeles Jan $9,121 San Francisco Mar $8,703 San Francisco Apr $4,369 San Diego $5,936 Los Angeles $9,990 San Diego May Joe $5,217 San Diego Apr Bill $5,582 San Francisco Apr Joe $7,913 Los Angeles Jun Jane Feb $8,581 San Francisco Jan Joe $7,472 San Diego Feb Bill $4,716 San Francisco Feb $3,020 San Diego Jan $11,552 San Francisco Apr $8,507 Los Angeles Mar $8,573 San Francisco Mar $4,827 San Diego Jun $11,146 San Diego $10,898 San Diego Date Sales Rep Type Wine Bill Joe Jane Jane Red Organic Red Bill Jane Jane Joe Jane Jane Jane Bill Joe Jane Jane Joe Bill Jane Jun Joe Apri Jane Organic White Red Red Red Organic Red Organic White Organic White Red White Red Red White Organic Red White White Red Organic Red What are the total sales by person? Bill $ 245,921.00 Joe $ 251,513.00 Jane $ 269,805.00 $245,921.00 Bill Total Sales by Person Red Red Red $251,513.00 Joe $269,805.00 Jane What were the total sales of red wine in California over the last six month? Bill $ 95,536.00 Joe $ 101,154.00 Jane $ 77,475.00 $10,424 San Francisco Apr Bill $6,077 Los Angeles Apr Bill Jane $4,908 Los Angeles Feb $4,652 San Francisco Jan Jane Apri Joe $7,498 San Diego $4,641 San Diego $10,440 San Diego Jun Bill Jan Jane $4,168 San Diego Joe Mar $4,031 San Francisco Feb Bill $4,031 San Francisco Feb. Jane $7,498 San Diego Apr Jane $8,305 San Diego Feb Jane Jane Joe $4,788 San Francisco May $11,953 San Diego May Jane Jane Jane Joe $11,482 San Francisco Jun $11,959 San Diego Jan $8,681 San Francisco Jun $10,399 Los Angeles Mar $11,310 Los Angeles Feb Joe $6,981 San Francisco Jun Jane $8,758 Los Angeles May Jane $9,837 San Diego May Bill $4,276 San Francisco Apr Joe Bill Joe Joe Joe $7,515 San Francisco Apr Bill $10,497 Los Angeles May Bill $8,587 San Francisco Jan $7,373 Los Angeles Feb $8,722 San Francisco Jan $5,607 San Francisco Jun $11,029 San Francisco Jan Bill $6,262 San Francisco Mar Bill $9,432 San Diego May $6,685 San Diego $3,913 San Diego $7,642 Los Angeles Lan cao main rao v Bill Apri Joe Jan Joe Mar Bill AA.. Jame White White White White Organic White White Red White White Organic Red White White Red White Organic Red Red Organic Organic Red White Red Red White White Red White White Organic Organic Organic Red Organic JAZA. $95,536.00 Red Bill Total Sales Red Wine $299,361.00 $101,154.00 Red Joe Which Type of wine were the best and and worst sellers? Red $ 299,361.00 White $ 301,704.00 Organic $ 154,953.00 Sales by Type of Wine $301,704.00 $77,475.00 Red Jane $154,953.00 Jan Joe $3,913 San Diego $7,642 Los Angeles Mar Bill $9,549 San Diego Mar Jane $9,014 San Diego Feb Bill $7,390 San Francisco May Jane $3,390 Los Angeles Feb Jane Bill Joe Jane Bill Joe Bill $4,670 San Francisco Juni Joe $8,535 Los Angeles Jun $9,112 San Francisco May $8,197 San Francisco Jan $3,287 Los Angeles Jan $6,388 Los Angeles Apr $9,887 San Diego Jan $6,326 Los Angeles Feb $10,694 Los Angeles Jan Joe $9,779 San Francisco Jun $10,157 San Francisco May $5,286 San Francisco Jan $8,516 Los Angeles $7,177 San Diego $6,312 Los Angeles $5,546 San Diego Joe Bill Joe $5,294 San Francisco Jan $7,879 San Francisco Mar $6,437 San Francisco Jun $6,061 San Diego Jan $7,763 San Francisco Jun $5,761 Los Angeles Jun Jane Jane Bill $9,248 San Francisco Apr Joe Joe Bill Jane Joe May Bill Apr Bill May Joe Feb Bill Jane Jane Bill $10,919 San Francisco Feb $11,498 Los Angeles Jani $8,950 San Diego May Mar Joe $9,133 Los Angeles $9,332 San Francisco Apr Bill $5,437 Los Angeles Joe Feb $7,914 San Diego Feb Joe Red Organic White White Organic Red Organic Red Red Red Red White Red Organic White Red Red Red White White Organic Red White White Red Organic White Red Organic White White White White Red White White Red White Organic $7,914 San Diego Feb Joe $8,559 Los Angeles May Jane $8,274 San Francisco Mar Bill $3,877 San Diego Jan $3,407 San Francisco Jan $5,605 San Diego Jun Jane Bill Jane White Red White Organic Red Red

Answer rating: 100% (QA)

To find the total sales by person we need to sum up the sales amounts for each salesperson Heres the ... View the full answer