Use the file named Makeup2007.xlsx for questions 1016. Create a table that contains sales of each product
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
Create a table that contains sales of each product made by each person.
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% (3 reviews)
Creating a table that contains sales of each product made by each person Lip gloss Foundation Lips...View the full answer
Answered By
Rishi Anand
Hello and welcome to my profile.Let me introduce myself.I am Laiba Ayyub.I am Master degree holder.I got my Masters degree in Mathematics from Riphah International University Islamabad.I have been a good student.I am teaching many students right now.I taught in a High private school in my city.I also take classes in evening from class 8th to 14th.I am expert in doing maths.I believe in students satisfaction.
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
-
Use the file named Makeup2007.xlsx for questions 1016. Create a table that, when you enter a year in your worksheet, contains sales of each product by person during that year. G H 4 Trans Number Name...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
(6. A cylinder weighing 120N rests between two frictionless walls as shown in the following figure. B 3 The wall reaction (N) at Point A is most nearly: (A) (B) (C) 96 139 150 200 (7. A body is...
-
This chapter describes the mechanisms in place to regulate accounting and financial reporting in five countries. Required: Compare and contrast these mechanisms in the United Kingdom and China.
-
Assume that you have finished your substantive analytical procedures in the area of revenue. You used trend analysis and a reasonableness test and conducted the procedures at a disaggregated level....
-
If Boeing's management decided to keep all production in America, what do you think the effect would be on the company, its employees, and the communities that depend on it?
-
List three ways to get input from the console and convert that input to the desired data type.
-
Shannon Inc., which produces a single product, has prepared the following standard cost sheet for one unit of the product. Direct materials (8 pounds at $2.50 per pound) ...... $20 Direct labor (3...
-
1. A thin film is laid over a glass pane as shown. White light is incident on the film, coming straight in. At a point where the light is incident on the film, it appears green ( = 525 nm). Find (a)...
-
Billingham Packaging is considering expanding its production capacity by purchasing a new machine, the XC-750. The cost of the XC-750 is $2.75 million. Unfortunately, installing this machine will...
-
Use the file named Makeup2007.xlsx for questions 1016. How many units of lip gloss did Cici sell in 2004? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18 19 222 1 Betsy 2 Hallagan 3 Ashley...
-
What value of Year 1 unit cost would increase our NPV in the car example in Chapter 16 to $1 million?
-
What is the difference between self-pollination and cross-pollination? If pollen is transferred from the stamens of a flower to the stigma of the very same flower, is that cross-pollination or...
-
What is a net gift?
-
Which do you prefer: a bank account that pays 5.4% per year (EAR) for three years or a. an account that pays 2.5% every six months for three years? b. an account that pays 6.9% every 18 months for...
-
You have been offered a job with an unusual bonus structure. As long as you stay with the firm, you will get an extra $67,000 every seven years, starting seven years from now. What is the present...
-
Which transfers are subject to the gift tax?
-
You have found three investment choices for a one-year deposit: 10.3% APR compounded monthly, 10.3% APR compounded annually, and 9.6% APR compounded daily. Compute the EAR for each investment choice....
-
Campus Stop Inc. is a student co-op. On January 1, 2014, the beginning inventory was $ 150,000, the trade receivables balance was $ 4,000, and the allowance for doubtful accounts had a credit balance...
-
Name some of the various types of financial intermediaries described in the chapter and indicate the primary reason(s) each was created.
-
Identify two decisions at the organizations described in this case that were improved by using big data, and two decisions that were not improved by using big data.
-
List and describe the limitations to using big data.
-
Should all organizations try to analyze big data? Why or why not? What management, organization, and technology issues should be addressed before a company decides to work with big data?
-
The following table shows the nominal returns on Brazilian stocks and the rate of inflation. Year Nominal Return (%) 2012 2013 0.2 -16.0 Inflation (%) 6.9 7.0 2014 -14.0 7.5 2015 -42.5 11.8 2016 2017...
-
You have the option of investing in one of two projects G: project G needs 1.000.000 immediatly and gives 2.270.000 after 4 years. K: Project K needs 1.200.000 immediatly and gives 2.500.000 after 5...
-
Suppose you are the money manager of a $5.26 million investment fund. The fund consists of four stocks with the following investments and betas: Stock Investment Beta A $ 580,000 1.60 B 600,000 (0.60...
Study smarter with the SolutionInn App