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?
-
Reread the Management Focus on Vizio and answer the following questions: a. Why is the manufacturing of flat-panel TVs migrating to different locations around the world? b. Who benefits from the...
-
How many times can you define a function?
-
The following data have been extracted from the records of Riddle Co.: Required: a. Calculate the missing costs. b. Calculate the cost formula for mixed cost using the highlow method. c. Calculate...
-
(20%) The output of an argon ion laser can consist of a number of modes of frequency that match the cavity resonance condition and are within the gain bandwidth of the lasing transition. Assume the...
-
The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2014, the end of the current fiscal year, the accountant for The Gorman Group prepared an...
-
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...
-
Just as you describe curves in the plane parametrically with a pair of equations x = (t), y = g(t) defined on some parameter interval I, you can sometimes describe surfaces in space with a triple of...
-
You are looking to buy a car and you have been offered a loan with an APR of 5.6%, compounded monthly. a. What is the true monthly rate of interest? b. What is the EAR?
-
A corporation terminates its status as an S corporation. Describe the requirements for re-electing S corporation status.
-
You are considering two ways of financing a spring break vacation. You could put it on your credit card, at 12% APR, compounded monthly, or borrow the money from your parents, who want a 7% interest...
-
What are the advantages of gift-splitting?
-
An online bank is offering to pay 0.20% interest per month on deposits. Your local bank offers to pay 0.65% interest quarterly (every 3 months). Which is the higher interest rate?
-
The statements of earnings for Pruitt Company summarized for a four- year period show the following (amounts in thousands of dollars): An audit revealed that in determining these amounts, the ending...
-
San Carlos Bank and Trust Company uses a credit-scoring system to evaluate most consumer loans that amount to more than $2,500. The key factors used in its scoring system are found at the conclusion...
-
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.
-
4 Calculating EFN - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA ? REVIEW VIEW Calibri Paste 11 A A % M BIU Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles...
-
MISSING LETTER D Suppose a company has fixed costs of $24,000 and variable cost per unit of 1/3 x + 444 dollars, where x is the total number of units produced. Suppose further that the selling price...
-
According to the article if you charge $3000 at 17% and you only make the minimum payment. How many years would it take to pay off the $3000?
Study smarter with the SolutionInn App