Sales City $7,451 Los Angeles Feb $11,221 Los Angeles Jun $9,525 San Francisco Jun $3,986 San...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the companys Pacific region salespeople just returned to the office with a newly designed...
-
(a) Do an additive time series model on the tornado data using years 1998 through Dec. 2018. The months of 2019 will be used for a holdout sample Make sure that the assumptions are valid. Interpret...
-
Raheem & Co. purchased a fixed asset on 1.4.2018 for Rs.2,50,000. Depreciation is to be provided @10% annually according to the Straight-line method. The books are closed on 31st March every year....
-
1. Could the WARN Act apply to Darby given the stipulated facts? Why or why not? 2. Suppose the layoffs were for a period of 5 months. Are the laws requirements triggered? Explain.
-
It has been proposed that patent protection is a limited monopoly provided by governments to meet economic development objectives for the "greater good" of a nation's economy. Explain, being sure to...
-
A four ply symmetric \([0 / 90]_{\mathrm{s}}\) laminate has the following ply properties; ply thickness \(=0.25 \mathrm{~mm}\); \[E_{1}=129 \mathrm{GPa}, \quad E_{2}=12.8 \mathrm{GPa}, \quad...
-
Information related to Gustavo Company for 2012 is summarized below. Total credit sales $1,100,000 Accounts receivable at December 31 369,000 Bad debts written off 22,150 Instructions (a) What amount...
-
Law is a pervasive part of our lives; regulations shape our daily activities, govern our interactions with one another and our relationships to the planet and to other nations. Often our legal...
-
On the geologic map in Fig. G-1 (Appendix G) draw the correct strike and dip symbol in each circle to indicate the attitude of Formation B and each dike. To verify your attitude symbols, Fig. G-2 can...
-
In a riveted joint, the tearing efficiency is 80% and the diameter of the rivet hole is 20mm. The pitch of the joint is (a) 60 mm (c) 120 mm (b) 100 mm (d) 160 mm
-
Accounting failures occur when reported results are not presented in accordance with generally accepted accounting principles. These failures can produce significant financial losses to investors and...
-
In the Challenge Solution, show that shareholders' expected earnings are higher with the new compensation scheme than with the original one.
-
So far, we've researched the viewpoints of leaders in the field of information presentation and human interface design for computer systems. What about experts in other areas? a. Find and interview...
-
Suppose that a market for toothpaste has two sellers, each of which says its product has the best combination of ingredients to protect against tooth decay and to control plaque, tartar, and gum...
-
Consider the two toothpaste producers in Question 5.4. If instead of undertaking an advertising campaign, Firm 1 convinced Firm 2 to form a cartel, would it have been better off? Assume that both...
-
Several years ago, there was a case in DC where a judge sued his dry cleaner for $5 million because the dry cleaner purportedly lost the judge's pants. The owners claimed that they had performed the...
-
4. Jobe dy -Y 2 et by
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 4.3. Briefly describe how spreadsheet modeling was applied in...
-
a. Formulate and solve a linear programming model for this problem. b. What is your resulting recommendation to the school board? After seeing your recommendation, the school board expresses concern...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 13.5. Briefly describe how computer simulation was applied in...
-
Explain how the financial manager might use industry norms in the design of the companys financing mix.
-
You have developed the following income statement for Sing-Tel Corporation. It represents the most recent years operations, which ended yesterday. Your supervisor in the controllers office has just...
-
Footwear, Inc. manufactures a complete line of mens and womens formal shoes for independent merchants. The average selling price of its finished product is \($85\) per pair. The variable cost for...
Study smarter with the SolutionInn App