Use the file named Makeup2007.xlsx for questions 1016. In transactions in which Ashley sold at least 40
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
In transactions in which Ashley sold at least 40 units of lipstick, what is the total dollar amount?
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: 66% (6 reviews)
To calculate the total dollar amount from transactions in which Ashley sold at least 40 uni...View the full answer
Answered By
Akash M Rathod
I have been utilized by educators and students alike to provide individualized assistance with everything from grammar and vocabulary to complex problem-solving in various academic subjects. I can provide explanations, examples, and practice exercises tailored to each student's individual needs, helping them to grasp difficult concepts and improve their skills.
My tutoring sessions are interactive and engaging, utilizing a variety of tools and resources to keep learners motivated and focused. Whether a student needs help with homework, test preparation, or simply wants to improve their skills in a particular subject area, I am equipped to provide the support and guidance they need to succeed.
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
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Use the file named Makeup2007.xlsx for questions 1016. How much revenue was made on sales transactions involving at least 50 units of makeup? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17 18...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Liberty Ventures Inc. reported a $320,000 profit in 2020 and declared preferred dividends of $20,000. The following changes in common shares outstanding occurred during the year: Jan 1 100,000 common...
-
What factors should the auditor consider when evaluating the professional qualifications of a specialist?
-
1. Comcast argued that it refunded Santangelo's $50, plus interest in the amount of $10, four months after pulling his credit report. Does this argument undercut the plaintiff's claim to have...
-
What are the three parts of a make rule?
-
Bramlett Company has several divisions and just built a new plant with a capacity of 20,000 units of a new product. A standard costing system has been introduced to aid in evaluating managers...
-
A swimmer wants to cross a river, from point A to point B, as shown in the figure. The distance di (from A to C) is 200 m, the distance d (from C to B) is 150 m, and the speed vr of the current in...
-
Daniel Fowler, senior vintner at Napa Winery, had been put in charge of developing an optimal blending plan for the upcoming season. This assignment was the result of a recent Napa Winery board...
-
For the cell range D4:G15, count the cells containing a numeric value. Count the number of blank cells. Count the number of nonblank cells.
-
Use the file named Makeup2007.xlsx for questions 1016. What is the average dollar size of a foundation sale made by Betsy after the end of 2004? G H 4 Trans Number Name 456789 10 11 12 13 14 15 16 17...
-
Suggest some cautions that an individual from a highcontext culture should take when dealing with someone from a low-context culture. Do the same for low- to high-context situations.
-
Your research assistant has discovered that the model you have been working with to explain changes in shipping costs suffers from heteroscedasticity. She bemoans the loss of time and the increased...
-
Suppose Compco Systems pays no dividends but spent $5.09 billion on share repurchases last year. If Compcos equity cost of capital is 11.4%, and if the amount spent on repurchases is expected to grow...
-
AFW Industries has 219 million shares outstanding and expects earnings at the end of this year of $724 million. AFW plans to pay out 65% of its earnings in total, paying 39% as a dividend and using...
-
Your pro forma income statement shows sales of $1,022,000, cost of goods sold as $483,000, depreciation expense of $97,000, and taxes of $176,800 due to a tax rate of 40%. What are your pro forma...
-
You are evaluating a new product. In year 3 of your analysis, you are projecting pro forma sales of $5.8 million and cost of goods sold of $3.48 million. You will be depreciating a $1 million machine...
-
Kramer Corp. reported the following sale and purchase transactions related to a specific product in January 2014: Kramer Corp. uses a periodic inventory system and the FIFO inventory costing method....
-
A. Select a recent issue (paper or online) of Report on Business Magazine, Canadian Business Magazine (online only), Bloomberg Businessweek, Fast Company, The Economist, or another business magazine....
-
What business benefits do cloud computing services provide? What problems do they solve?
-
What are the disadvantages of cloud computing ?
-
What kinds of businesses are most likely to benefit from using cloud computing? Why ?
-
Explain in detail why its important to have standard based protocols.
-
The administration's goals and objectives can be divided into functional categories like public safety, transportation, the environment, social services, etc. to establish a programme budget...
-
Suppose that a packet switched network is used and the only traffic in this network comes from such applications described above. Further assume that the sum of the application data rates is less...
Study smarter with the SolutionInn App