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....
-
Missy Mansion opened a public relations firm called Solid Gold on August 1, 2016. The following amounts summarize her business on August 31, 2016: During September 2016, the business completed the...
-
Theres often talk of middle-aged people being sandwiched with responsibilities: while they are still caring for their own children, they start to have responsibilities taking care of their own...
-
A-Rod Fishing Supplies had sales of $2,500,000 and cost of goods sold of $1,710,000. Selling and administrative expenses represented 10 percent of sales. Depreciation was 6 percent of the total...
-
The Fishing Pier has 7.40 percent, semi-annual bonds outstanding that mature in 12 years. The bonds have a face value of $1,000 and a market value of $1,127. What is the yield to maturity?
-
Pie Corporation acquired 75 percent of Slice Companys ownership on January 1, 20X8, for $96,000. At that date, the fair value of the noncontrolling interest was $32,000. The book value of Slices net...
-
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?
-
Starburst Coffee Company roasts and packs coffee beans. The process begins in the Roasting Department. From the Roasting Department, the coffee beans are transferred to the Packaging Department. On...
-
The accounting records of the Eco Paper Company include the following information relating to the current year ended 31 March 2023: Materials 31 March 2023 $20,000 1 April 2022 $25,000 Work in...
-
The first read is an article on the development of money of a World War II prisoner-of-war, which was published in 1945. The second article was published in the opinion section of the New York Times...
-
Describe each Speaker's basic assumptions regarding employee motivation. That is, what are the underlying principles which guide how the Speaker treats his/her people (i.e., their direct report...
-
Find the area of the shaded region. The graph to the rate of IQ scores of adults, and those scores are normally distributed with the mean of 100 and a standard deviation of 15. x=81
-
In which scenario is Nikki showing resilience to stress? Nikki lost her job as an engineer 3 months ago. At first, she was depressed, but she realized she wanted to change career paths and decided to...
-
U.S., Canadian, and many other governments limit the amount of a child-care subsidy that a family may receive. How does such a limit affect the Challenge Solution analysis?
-
With your classmates, form small teams of skunkworks. Your task is to identify an innovation that you think would benefit your school, college, or university, and to outline an action plan for...
-
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?
-
Product Weight Sales Additional Processing Costs P 300,000 lbs. $ 245,000 $ 200,000 Q 100,000 lbs. 30,000 -0- R 100,000 lbs. 175,000 100,000 If joint costs are allocated based on relative weight of...
-
The projected benefit obligation was $380 million at the beginning of the year. Service cost for the year was $21 million. At the end of the year, pension benefits paid by the trustee were $17...
-
CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on...
Study smarter with the SolutionInn App