Find the units sold and revenue for each salesperson. B 4 Trans Number Name 10 Betsy 11
Question:
Find the units sold and revenue for each salesperson.
Transcribed Image Text:
B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81 Jen 86 Jen 87 Emilee 98 Jen 108 Cici 114 Betsy 116 Zaret 119 Colleen 131 Jen 133 Betsy 140 Jen 567 7 8 68 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Date C D Product 8/7/2006 lip gloss 11/29/2004 mascara 9/20/2006 foundation 4/12/2004 mascara 9/20/2006 lip gloss 8/9/2005 mascara 4/12/2004 foundation 10/27/2004 mascara 1/23/2005 eye liner 1/15/2004 mascara 1/10/2006 lip gloss 8/9/2005 eye liner 8/31/2005 eye liner 4/12/2004 lip gloss 8/31/2005 lip gloss 9/22/2005 lipstick 6/24/2006 eye liner 5/22/2006 eye liner 11/29/2004 mascara 7/9/2004 mascara 6/28/2004 eye liner E Units F Dollars 24 $ 43 $ -8 $ 45 $ 2 $ 93 $ 34 $ 89 $ 73 $ 27 $ 69 $ -2 $ 5 $ 92 $ -10 $ 77 $ 22 $ 20 $ 56 $ 11 $ 80 $ Location 73.50 east 130.84 east (21.99) east 137.39 east 7.85 east 280.69 east 104.09 east 269.09 east 221.41 east 83.29 east 208.69 east (4.24) east 17.03 east G 277.54 east (28.41) east 233.33 east 68.07 east 62.37 east 168.87 east 34.42 east 242.50 east
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (6 reviews)
To find the units sold and revenue for each salesperson we need to multipl...View the full answer
Answered By
Monette Taban
I am currently studying Computer Science Engineering, Due to my interest in programming languages and coding, I am interesetd on Technology so I search about it read about different types of technologies, I think my this habbis will help me to solve problems of students and that is why I am signing as a question answer expert.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
Eastern Productions is a medium- sized maker of promotional films and advertisements for the beverage industry. It has six salespeople on pay roll. The following table shows the results against plan...
-
Potter- Bowen (PB) manufactures and sells postage meters throughout the world. Postage meters print the necessary postage on envelopes, eliminating the need to affix stamps. The meter keeps track of...
-
At the beginning of the current tennis season, on April 1, 2024, Kicked-Back Tennis Shops inventory consisted of 50 tennis racquets at a cost of $40 each. Kicked-Back uses a perpetual inventory...
-
The following problem requires a basic knowledge about probabilities and the calculation of expected values. In addition, the problem is more easily solved using Excel spreadsheet software. a....
-
The U-Z Door Company manufactures garage door units. The units include hinges, door panels, and other hardware. Prepare a direct materials purchases budget for the first quarter of the year based on...
-
The data given below show percentages of work completed for a construction project: Graph the data in Excel and comment on the shapes of the distributions. Forecast the cumulative percentages of...
-
Calculate the proportion of terminal value to total estimated value of equity under the abnormal earnings method and the discounted cash flow method for the Scenario 2 results shown in Table 8-6. Why...
-
Two companies are selling software which are imperfect substitutes of each other. Let pi and x denote the price and the quantity sold of software 1. Similarly, let p2 and x2 denote the price and the...
-
A business issued a 60-day, 9% note for $61,000 to a creditor on account. Illustrate the effects on the accounts and financial statements of recording (a) the issuance of the note and (b) the payment...
-
The following table contains performance reviews for five employees. Use a radar chart to summarize the performance reviews. Person Hard-working Wayne 1 Vivian 5 Greg 10 Collegial 2 6 9.5 Completes...
-
Find the largest transaction (in terms of revenue) for each product. B 4 Trans Number Name 10 Betsy 11 Ashley 15 Zaret 16 Emilee 45 Emilee 46 Ashley 58 Cristina 60 Jen 69 Cristina 77 Cristina 81 Jen...
-
A coffee centrifuge? In one popular demonstration, a full cup of hot coffee is placed on a platform suspended by strings to the lecturer???s hand as seen in Figure Q5.20. With some practice, the...
-
You are constructing an improvised detector for radon gas, using the cooling core from an old refrigerator capable of cooling air to \(255 \mathrm{~K}\), a detector tube \(50 \mathrm{~mm}\) long, a...
-
What is the thermal energy associated with \(5.6 \times 10^{18}\) nitrogen molecules, \(\mathrm{N}_{2}\), at \(100^{\circ} \mathrm{F}\) ? Assume the nitrogen can be treated as an ideal gas.
-
As a sample of argon gas is heated in a sealed container, its root-mean-square speed changes from \(350 \mathrm{~m} / \mathrm{s}\) to \(540 \mathrm{~m} / \mathrm{s}\). By how much has the entropy...
-
An ideal gas is inside a cylinder fitted with a piston of cross-sectional area \(0.10 \mathrm{~m}^{2}\), and initially the gas pressure is \(5.0 \times 10^{4} \mathrm{~Pa}\). A quantity \(Q=5.0...
-
A 3. 50-L expandable chamber contains monatomic neon gas at \(2.00 \mathrm{~atm}\) and \(30.0^{\circ} \mathrm{C}\). Thermal energy is slowly added to the gas until its volume is \(8.00 \mathrm{~L}\)...
-
A diffuser, shown in Fig. P6.36, has air entering at 100 kPa, 300 K, with a velocity of 200 m/s. The inlet cross-sectional area of the diffuser is 100 mm2. At the exit, the area is 860 mm2, and the...
-
What is an access control list?
-
Discuss the probable impact on your hometown if a major breakthrough in air transportation allowed foreign producers to ship into any U.S. market for about the same transportation cost that domestic...
-
Will the elimination of trade barriers between countries in Europe eliminate the need to consider submarkets of European consumers? Why or why not?
-
What and who is the U.S. government attempting to protect in its effort to preserve and regulate competition?
-
Book Print ciences Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of...
-
.There are 10 people waiting in line for a ride. Only 2 people can ride at a time. How many ways can 2 people go on the ride at once? You are going golfing. You have 3 drivers, 7 wedges, 6 irons, and...
-
The annual log returns on a portfolio is 15% and 10% separately over two years. Assume the initial investment on this portfolio is $10,000, what is the portfolio value at the end of the year two?
Study smarter with the SolutionInn App