Use the file named Makeup2007.xlsx for questions 1016. How much revenue was made on sales transactions involving
Question:
Use the file named Makeup2007.xlsx for questions 10–16.
How much revenue was made on sales transactions involving at least 50 units of makeup?
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: 0% (1 review)
We must add up all of the transactional dollars for purchases involving at ...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 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...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Please, find Arithmetic Mean by using Coding method, Geometric Mean, Harmonic Mean, Mode, Median & Quartile Deviation of the given data. ASAP Classes 50-59 f 45 0-9 60-69 7 24 10-19 70-79 16 14 20-29...
-
An auditor has to determine both the reliability and the relevance of potential audit evidence in order to determine that appropriate audit evidence is gathered. a. Explain the difference between...
-
What do you think would happen if the U.S. government removed all support for U.S. sugar producers?
-
What happens if you specify an invalid format string?
-
Life, Inc., experienced the following events in 2016, its first year of operation: 1. Performed counseling services for $36,000 cash. 2. On February 1, 2016, paid $18,000 cash to rent office space...
-
A student performs a double-slit experiment using two slits spaced 0.20 mm apart and located 1.50 m from the screen. The monochromatic light source creates an interference pattern in which the...
-
Consider a hospital in which each doctor is responsible for many patients while each patient is cared for by just one doctor. Each doctor has a unique employee number, name, telephone number, and...
-
The file named Problem11data.xlsx contains statistics on NFL quarterbacks. A QBs name is entered in cell I2. Set up a format that will highlight the entire row of data for the QB entered in cell I2....
-
The file named Adagency.xlsx contains salaries and ages of employees of an ad agency. Set up a spreadsheet that will compute the average salary and age of the agencys employees. Of course, your...
-
In Problem use the given annual interest rate r and the compounding period to find i, the interest rate per compounding period. 5.52% compounded monthly
-
You are pleased to see that you have been given a 4.97% raise this year. However, you read on the Wall Street Journal Web site that inflation over the past year has been 2.24%. How much better off...
-
State whether each of the following statements is true or false, or whether the answer depends on other factors (which you should identify): i. Airlines fall under the category of high labor/low...
-
How can a runs test for randomness be used to test for autocorrelation?
-
Suppose the interest rate is 6.8% APR with monthly compounding. What is the present value of an annuity that pays $120 every six months for four years?
-
Distinguish between first-order and higher-order autocorrelation. Give examples of each.
-
Le Chteau Inc. is a Canadian specialty retailer and manufacturer of contemporary fashion apparel, accessories, and footwear for women and men of all ages. Its products are sold in over 200 retail...
-
F.(3e* -2x 3 sin(2x)) is equal to 2 3 Cos 8. IT 3, t (4+@ 2 3, 1+o 1 4 Cos 4 4 1 3. 1 +4cos V7 (1+o 4 1 4 Cos 4 1+0 4-
-
What difference would it make to a business or to an individual consumer if Apple, Google, or Facebook dominated the Internet experience? Explain your answer.
-
Identify the problem and the control weaknesses described in this case.
-
What management, organization, and technology factors contributed to this problem? To what extent was it a technology problem? To what extent was it a management and organizational problem?
-
1. If Maria discontinues the use of her credit card but continues only to make a $50 monthly payment, how long will it take Maria to pay off her debt? How much will she pay in total interest charges?...
-
Create an AD/AS diagram model using the following information: - This year in June, the Real GDP increased to $532,228 million, indicating that the economy has steadily recovered from its downturn. -...
-
1. In this question you will need to calculate the elasticity of demand for white beans with respect to the price of white beans, the price of two related goods, and income. In addition to...
Study smarter with the SolutionInn App