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: 71% (7 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?
-
Explain why a company might want to split its shares.
-
Of course, political party identification is related to traditionalism: Republicans are more likely to espouse traditionalism than Democrats. But is this relationship nonlinear? Use the ANES...
-
Your grandfather would like to share some of his fortune with you. He offers to give you money under one of the following scenarios (you get to choose): 1. $8,750 a year at the end of each of the...
-
summary/ analysis of Enron: the smartest guys in the room. one page summary atleast I'd like to roll out an extra credit opportunity worth 10 points. It is a 1-2 page memo (as if to your Boss or...
-
A beam ABCD consisting of a simple span BD and an overhang AB is loaded by a force P acting at the end of the bracket CEF (see figure). (a) Determine the deflection δA at the end of the...
-
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...
-
Tailor Johnson, a U.S. maker of fine menswear, has a subsidiary in Ethiopia. This year, the subsidiary reported and repatriated earnings before interest and taxes (EBIT) of 100 million Ethiopian...
-
Based on the reading,How to make sure your next product or service launch drives growth (click the underlined link),what stands out to you as the most important factor in a differentiated launch...
-
OM in the News has previously looked at the Waffle House Index, used to measure the damage from hurricanes. The index made the news again for Hurricane Ian. According to the Boston Globe, 40 Waffle...
-
Mixture of persuasive and negative formal I am Elizabeth grinderFirst part email Next part setting up the meeting Final part memo The reader is Robert * do not come off accusatory*** Project TWO:...
-
Anyone who has sampled today's social media offerings has probably experienced this situation: You find a few fascinating blogs, a few interesting people to follow on Twitter, a couple of podcast...
-
a. Begin with a converging lens of focal length f. Place an illuminated object a distance p, in front of the lens. For all positive values of p;: 1. calculate and sketch a graph of the location of...
-
Alfred's Print Shop can use any one of three fixed proportion technologies. Each involves one printer and one worker. Describe the possible shapes of the firm's isoquant?
-
Explain five different cases of income exempt from tax with clear examples.
-
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 ?
-
why would an auditor want to complete dual-purpose tests? what procedure can be put into place to help prevent fraud? List 4 procedures.
-
Based on the following information, calculate sustainable growth rate for Groot, Inc.: Profit margin= 7.1% Total asset turnover = 1.90 Total debt ratio = .45 Payout ratio = 20% What is the ROA here?
-
Consider the following: a call option on a stock has strike price $100, premium of $5 and the current price of the underlying stock is $100. If you buy the call option today, what is your holding...
Study smarter with the SolutionInn App