Use the file named Makeup2007.xlsx for questions 1016. How many units of lip gloss did Cici sell
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
How many units of lip gloss did Cici sell in 2004?
Transcribed Image Text:
G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 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 Date J Product 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 K Units L Dollars 45 $137.20 50 $ 152.01 9 $ 28.72 55 $167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 $ 130.84 23 $ 71.03 49 $ 149.59 18 $ 56.47 -8 $ (21.99) 45 $ 137.39 66 $199.65 88 $ 265.19
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (4 reviews)
To find the number of units of lip gloss Cici sold in 2004 we need to look at t...View the full answer
Answered By
Dinesh F
I have over 3 years of professional experience as an assignment tutor, and 1 year as a tutor trainee.
5.00+
1+ 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
-
Using the data in the file named Makeupdb.xlsx, how many units of lip gloss did Zaret sell during 2004 and 2005? 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...
-
How many units of lip gloss did Colleen sell outside the West 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 26 27 28 1 Betsy 2 Hallagan 3 Ashley 4...
-
In the Makeupdb.xlsx file, how many dollars worth of lip gloss did Jen sell? 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...
-
You are an information technology (IT) intern working for Health Network, Inc. (Health Network), a fictitious health services organization headquartered in Minneapolis, Minnesota. Health Network has...
-
Review Exhibit and describe how the two audit approaches presented in the Exhibit differ. What factors would lead to such a difference?
-
This is your first writing assignment. All of you are attending HACC to be trained for a certain career. I would like you to find some current literature (within the last 3 years) that will show how...
-
A crossover trial is a type of experiment used to compare two drugs. Subjects take one drug for a period of time, then switch to the other. The responses of the subjects are then compared using...
-
Frobisher Inc. (Frobisher) uses the lower of cost and NRV rule to value its inventory. Frobishers inventory on February 28, 2017 had a cost of $1,125,000 and a NRV of $1,035,000. Required: a. By how...
-
Avi Abram, CFA, was recently appointed to manage the Nupit University Endowment fund. Over the past few years, Nupit's endowment has grown dramatically as a result of fundraising efforts by Nupit's...
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
Three electricians are wiring my new home. Electrician 1 by himself will need 11 days to do the job. Electrician 2 by himself will need 5 days to do the job. Electrician 3 by herself will need 9 days...
-
Use the file named Makeup2007.xlsx for questions 1016. Create a table that contains sales of each product made by each person. G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 1 Betsy...
-
Find the QR-factorization for each given matrix A. (a) (b) 121 012 112 113 212
-
Why must buyers and sellers be price takers for a market to be perfectly competitive?
-
Classify the following nudges as either a potentially advantageous default nudge, an information or encouragement nudge, or not a nudge. a. A firm redesigns its health enrollment form so that...
-
What will be the effect of a technological development that reduces marginal costs in a competitive market on short-run price, quantity, and profit?
-
If a firm is owned by its workers but otherwise meets all the qualifications for a perfectly competitive firm, will its price and output decisions differ from the price and output decisions of a...
-
Under what cost condition is the shutdown point the same as the point at which a firm exits the market?
-
The multiple regression relationships of SBP (Y) to AGE (X1), SMK (X2), and QUET (X3) are studied. Three regression models are considered, yielding least-squares estimates and ANOVA tables as shown...
-
Name some of the various types of financial intermediaries described in the chapter and indicate the primary reason(s) each was created.
-
What were the business benefits of data governance for Keurig Green M ountain?
-
How did data governance improve operations and management decision making?
-
What business benefits did the companies and services described in this case achieve by analyzing and using big data.
-
you will be required to perform a number of tasks to assess your skills to prepare and produce a variety of basic cookery methods to prepare dishes. You will be required to prepare, plate and present...
-
Sales Budget: 12 points (1 point for each correct plotted data) Production Budget: 25 points (1 point for each correct plotted data) Direct Materials Budget: 45 points (1 point for each correct...
-
What is the purpose of adjusted entries? How is this an example of an adjusted entry: A company received $5,000 as advancement in cash. When the cash is received, how would the entry be input?
Study smarter with the SolutionInn App