In the Makeupdb.xlsx file, how many dollars of sales were made by Emilee or in the East
Question:
In the Makeupdb.xlsx file, how many dollars of sales were made by Emilee or in the East region?
Transcribed Image Text:
G H 4 Trans Number Name 5 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret 21 Zaret 22 Betsy 23 Colleen 26 Emilee Date K Product Units 4/1/2004 lip gloss 3/10/2004 foundatior 2/25/2005 lipstick 5/22/2006 lip gloss 6/17/2004 lip gloss 11/27/2005 eye liner 3/21/2004 eye liner 12/17/2006 lip gloss 7/5/2006 eye liner 8/7/2006 lip gloss 11/29/2004 mascara 11/18/2004 lip gloss 8/31/2005 lip gloss 1/1/2005 eye liner 9/20/2006 foundatior 4/12/2004 mascara 4/30/2006 mascara 8/31/2005 lip gloss 10/27/2004 eye liner 11/27/2005 lip gloss 6/2/2006 mascara 9/24/2004 eye liner 2/1/2006 mascara lip gloss 12/6/2006 1 M L Dollars Location 45 $137.20 south 50 $152.01 midwest 9 $28.72 midwest 55 $167.08 west 43 $130.60 midwest 58 $ 175.99 midwest 8 $25.80 midwest 72 $ 217.84 midwest 75 $ 226.64 south 24 $ 73.50 east 43 $130.84 east 23 $ 71.03 west 49 $149.59 west 18 $ 56.47 south -8 $ (21.99) east 45 $137.39 east 66 $199.65 south 88 $265.19 midwest 78 $236.15 south 57 $173.12 midwest 12 $38.08 west 28 $ 86.51 midwest 25 $77.31 midwest 24 $ 74.62 west
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (2 reviews)
To calculate the total sales made by Emilee or in the East region from the provided image we ...View the full answer
Answered By
Benish Ahmad
I'm a professional software engineer. I'm lectutrer at GCUF and I have 3 years of teaching experience. I'm looking forward to getting mostly computer science work including:
Programming fundamentals
Object oriented programming
Data structures
object oriented design and analysis
Database system
Computer networks
Discrete mathematics
Web application
I am expert in different computer languages such as C++, java, JavaScript, Sql, CSS, Python and C#. I'm also have excellent knowledge of essay writing and research. I have worked in other Freelancing website such as Fiverr and Upwork. Now I have finally decided to join the SolutionInn platform to continue with my explicit work of helping dear clients and students to achieve their academic dreams. I deliver plagiarism free work and exceptional projects on time. I am capable of working under high pressure.
5.00+
2+ 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
-
1. Use LU-factorization method. Find the solution of the linear system x + 2x + 4x3 = 3, 3x+8x2 + 14x3 = 13, 2x + 6x2 + 13x3 = 4.
-
Identify the ratio that is relevant to answering each of the following questions. a. How much net income does the company earn from each dollar of sales? b. Is the company financed primarily by debt...
-
In the Makeupdb.xlsx file, how many dollars worth of lipstick were sold by Colleen or Zaret in the East region? G H 4 Trans Number Name 5 6 7 8 9 10 11 123 12 13 14 15 16 17 18 19 20 21 22 23 24 25...
-
The following information provides details of costs, volume and cost drivers for a particular period in respect of ABC plc, a hypothetical company: ( Details Direct Material $25 Cost Direct Labor 4/3...
-
Part A The common stock of Wilson, Incorporated is owned by twenty stockholders. Wilson's financial statements as of December 31, 2013, were audited by Doe & Company, CPAs, who rendered an...
-
The Churchill Corporation uses a periodic inventory system and the LIFO inventory cost method for its one product. Beginning inventory of 20,000 units consisted of the following, listed in...
-
Show that after nearly all of the positrons were annihilated and the electron number density had nearly leveled off at the proton density, the ratio of the positron number density to the photon...
-
Ellis Perry is an electronics components manufacturer. Information about the companys two products follows: The company incurs $899,000 in overhead per year and has traditionally applied overhead on...
-
An airplane flies level in the + x direction 1 0 0 m above the ground at 1 6 0 m / s . the plane drops goods and supplies to some people on the ground. 1 . Draw the path the supplies would follow...
-
The operations manager at Sebago Manufacturing is considering three proposals for supplying a critical component for its new line of electric watercraft. Proposal one is to purchase the component,...
-
The file named Makeupsortfont.xlsx contains our makeup data with certain dates shown in blue, red, or brown font. Sort the data so that the brown dates are on top, followed by the red dates and then...
-
The Sorticons.xlsx file contains annual investment returns with an up arrow used to indicate good years, a horizontal arrow used to indicate average years, and a red arrow used to indicate bad years....
-
In Exercises find the general solution of the differential equation. y ln x - xy' = 0
-
What are the most important investigative tools available to an agency?
-
Agency rules are not as legally binding as the laws that Congress enacts. (True/False)
-
Regarding the Economics in Action Erin Go Broke, identify the following: a. The asset bubble b. The channel of financial contagion
-
Courts generally defer (yield) to an agencys factual judgment on a subject within the agencys area of expertise. (True/False)
-
Again regarding Erin Go Broke, why do you think the Irish government tried to stabilize the situation by guaranteeing the debts of the banks? Why was this a questionable policy?
-
The concepts of accounting covered in Chapters 2 through 6 are shown below. Match each transaction with its related concept by entering the appropriate letter in the space provided. Use only one...
-
Havel says the grocer doesnt believe what is on the sign and indeed, he says the grocers customers will barely notice it. But Havel maintains that the sign serves a specific function. How would you...
-
The following financial information is for Caravelli Company. Of the total raw materials placed in production for the year, $36,000 was for indirect materials. The company had $3,795,000 in sales for...
-
The following information is for Rockville, Inc., for the year ended December 31, 2016. Of the total raw materials placed in production for the year, $72,000 was for indirect materials. Required: a....
-
The balance in the work-in-process inventory account of Quest, Inc., was $900,000 at the beginning of May. Manufacturing costs for the month are as follows: Required: a. Prepare separate journal...
-
Bunter was asked the following question: A Soma producing monopolist incurs a cost of C(q) = 49q-(9-1) for producing q units of Soma where q4. The demand for Soma as a function of the unit price p is...
-
b) Suppose instead that B-Team Inc plans to finance the investment by borrowing $150K in the third year. The firm plans to repay this debt (both interest and principal) in the fourth year. For...
-
Suppose an elevator in the Empire State Building weighs 1700 pounds. Find the work W required to raise the elevator from ground level to story number 91, some 1092 feet above the ground level. W =
Study smarter with the SolutionInn App