For the data in the file named Tablemakeuptemp.xlsx (in this chapters Templates folder), determine the total units
Question:
For the data in the file named Tablemakeuptemp.xlsx (in this chapter’s Templates folder), determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the East region.
Transcribed Image Text:
E 3 Trans Number 34567 8 600 9 10 11 12 23 13 14 56 15 16 17 18 19 20 21 22 F Name 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen Date H Product 38078 lip gloss 38056 foundation 38408 lipstick 38859 lip gloss 38155 lip gloss 38683 eye liner 38067 eye liner 39068 lip gloss 38903 eye liner 38936 lip gloss 38320 mascara 38309 lip gloss 38595 lip gloss 38353 eye liner 38980 foundation 38089 mascara 38837 mascara 38595 lip gloss 38287 eye liner G Units K Location Dollars 45 137.2045583 south 50 152.0073031 midwest 9 28.71948312 midwest 55 167.0753225 west 43 130.6028724 midwest 58 175.9909741 midwest 8 25.80069218 midwest 72 217.8396539 midwest 75 226.6423269 south 24 73.50234217 east 43 130.8353684 east 23 71.03436769 west 49 149.5927969 west 18 56.47199923 south -8 -21.99304472 east 45 137.3903759 east 66 199.6543347 south 88 265.1875515 midwest 78 236.1469779 south
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 28% (7 reviews)
To determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the ...View the full answer
Answered By
Joshua Marie Geuvara
I am an academic writer with over 5 years of experience. I write term papers, essays, dissertations, reports, and any other academic paper. My main objective is to produce a high-quality paper free from plagiarism and ensure a student scores an A+. Being a fluent English speaker, I have great communication skills that also enable me to produce excellent papers.
I am conversant with most academic referencing styles (APA, MLA, and Harvard).
You can trust me with your paper and expect nothing less than quality and excellent results. I look forward to meeting with you and, more importantly, developing something that will both make us happy and satisfied.
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
-
Find all transactions where Liam sold candy. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically...
-
Find all transactions where Ava was the salesperson or magazines were sold. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure...
-
Sort the data in descending order of units, breaking ties based on dollars in descending order. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all...
-
The Goodson Company manufactures four different products that it ships to customers throughout Canada. Delivery times are not a driving factor in the decision as to which type of carrier to use...
-
Describe how auditing standards affect the design of audit programs.
-
The unadjusted trial balance of Farmer Investment Advisers at December 31, 2016, follows: Adjustment data at December 31, 2016: a. Unearned Revenue earned during the year, $700. b. Office Supplies on...
-
Which variables, in order of importance, are identified as most important for classifying churn?
-
Why is having multiple health-care plans important for FedEx in slowing down increases in the cost of benefits?
-
A company made a bank deposit on September 30 that did not appear on the bank statement dated September 30. In preparing the September 30 bank reconciliation, the company should A. Deduct the deposit...
-
Every nonempty K-variety in F n may be written uniquely as a finite union V 1 U V 2 U U V k of affine K-varieties in F n such that V j V i for i j and each V i is irreducible (Exercise 8). Data...
-
In the file named Problem29data.xlsx, columns EI contain the following information: The opening price of a stock Whether we owned stock at the beginning of the day Whether we sold the stock that day...
-
The file named Problem28data.xlsx contains information about voters in 20 congressional districts. In cell I2, we will enter the number of a congressional district. Your job is to set up a format...
-
A model for an electrodynamics which respects gauge invariance but violates Lorentz invariance supplements the usual Maxwell Lagrangian with terms drawn from a four-vector (a) Find the restrictions...
-
Consider the following account balances (in thousands) for the Shaker Corporation In the Dec 31.2021 Cash $200,000 and Capital $2,000,000 and Retained earnings $1,500,000 The balances of raw...
-
Unless otherwise stated, assume gravitational acceleration g = 9.81 m/s and the density of water to be 1000 kg/m. Unless otherwise stated, give all numerical answers to 3 significant figures, such as...
-
The purpose of this installment is to classify stock, bond, and mutual fund investments, explore tools for their evaluation and select these securities based on your investment philosophy and goals....
-
Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided...
-
Caldwell (2003) explores differences between the roles of leaders and managers. "Leaders...envision, initiate, or sponsor strategic change of a far-reaching or transformational nature. In contrast,...
-
Since 1979, low-income recipients have been given food stamps without charge. However before 1979, people bought food stamps at a subsidized rate. For example, to get $1 worth of food stamps, a...
-
A glass manufacturer produces hand mirrors. Each mirror is supposed to meet company standards for such things as glass thickness, ability to reflect, size of handle, quality of glass, color of...
-
How much does baseball rely on sabermetrics? Explain your answer.
-
How important is location data to Starbucks's business strategy? Explain your answer.
-
How do location analytics help Starbucks managers make better decisions? Give examples of two decisions that the Atlas system helps support.
-
3 . Accounting.. How does depreciation impact financial statements, and what are the different methods of depreciation?
-
NEED THIS EXCEL TABLE ASAP PLEASE!!!! Presupuesto Operacional y C lculo del COGS Ventas Proyectadas: Ventas Proyectadas: $ 4 5 0 , 0 0 0 Precio por unidad: $ 4 5 0 Unidades vendidas: 4 5 0 , 0 0 0 4...
-
The wash sale rules apply to disallow a loss on a sale of securities_______? Only when the taxpayer acquires substantially identical securities within 30 days before the sale Only when the taxpayer...
Study smarter with the SolutionInn App