For the data in the file named Tablemakeuptemp.xlsx (in this chapters Templates folder), determine the total units
Question:
For the data in the file named Tablemakeuptemp.xlsx (in this chapter’s Templates folder), determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the East region.
Transcribed Image Text:
E 3 Trans Number 34567 8 600 9 10 11 12 23 13 14 56 15 16 17 18 19 20 21 22 F Name 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 19 Jen Date H Product 38078 lip gloss 38056 foundation 38408 lipstick 38859 lip gloss 38155 lip gloss 38683 eye liner 38067 eye liner 39068 lip gloss 38903 eye liner 38936 lip gloss 38320 mascara 38309 lip gloss 38595 lip gloss 38353 eye liner 38980 foundation 38089 mascara 38837 mascara 38595 lip gloss 38287 eye liner G Units K Location Dollars 45 137.2045583 south 50 152.0073031 midwest 9 28.71948312 midwest 55 167.0753225 west 43 130.6028724 midwest 58 175.9909741 midwest 8 25.80069218 midwest 72 217.8396539 midwest 75 226.6423269 south 24 73.50234217 east 43 130.8353684 east 23 71.03436769 west 49 149.5927969 west 18 56.47199923 south -8 -21.99304472 east 45 137.3903759 east 66 199.6543347 south 88 265.1875515 midwest 78 236.1469779 south
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 0% (5 reviews)
To determine the total units and revenue for all lip gloss or lipstick sold by Jen or Ashley in the ...View the full answer
Answered By
Joshua Marie Geuvara
I am an academic writer with over 5 years of experience. I write term papers, essays, dissertations, reports, and any other academic paper. My main objective is to produce a high-quality paper free from plagiarism and ensure a student scores an A+. Being a fluent English speaker, I have great communication skills that also enable me to produce excellent papers.
I am conversant with most academic referencing styles (APA, MLA, and Harvard).
You can trust me with your paper and expect nothing less than quality and excellent results. I look forward to meeting with you and, more importantly, developing something that will both make us happy and satisfied.
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
-
Find all transactions where Liam sold candy. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure your answers will automatically...
-
Find all transactions where Ava was the salesperson or magazines were sold. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all cases, make sure...
-
Sort the data in descending order of units, breaking ties based on dollars in descending order. Each row gives the salesperson, product sold, units sold, and revenue from a sales transaction. In all...
-
The Goodson Company manufactures four different products that it ships to customers throughout Canada. Delivery times are not a driving factor in the decision as to which type of carrier to use...
-
Describe how auditing standards affect the design of audit programs.
-
Why do sellers feel the need to justify price increases as caused by increased costs, but not the need to similarly justify price reductions?
-
A simple random sample of 75 people are given a new drug that is designed to relieve pain. A second sample of 50 people are given a standard drug. The question of interest is whether the proportion...
-
1. For each CardioGood Fitness treadmill product line (see the CardioGoodFitness file), construct two- way contingency tables of gender, education in years, relationship status, and self- rated...
-
Find f'(x). 33. f(x) = 0.6x1.5
-
Laval produces lighting fixtures. Budgeted Information for Its two production departments follows. The departments use machine hours (MH) and direct labor hours (DLH). Overhead cost Direct labor...
-
In the file named Problem29data.xlsx, columns EI contain the following information: The opening price of a stock Whether we owned stock at the beginning of the day Whether we sold the stock that day...
-
The file named Problem28data.xlsx contains information about voters in 20 congressional districts. In cell I2, we will enter the number of a congressional district. Your job is to set up a format...
-
Find an equation for the hyperbola described. Graph the equation. Center at (4, -1); focus at (7, -1); vertex at (6, -1)
-
As the ratio of the cost of overstocking to the cost of understocking gets smaller, the optimal level of product availability becomes irrelevant. the optimal level of product availability decreases....
-
Use a supply-and-demand graph to show the impact of cell phones in India on prices in the fishing market.
-
Bazar Company produces one product, a lighter called LIT-lighter. Bazar uses a standard cost system and determines that it should take one hour of direct labor to produce one LIT-lighter. The normal...
-
What is not included in Section 1231 property? Section 1231 Section 1231 property is a type of property, defined by section 1231 of the U.S. Internal Revenue Code. Section 1231 property is real or...
-
Based upon the organization oft he Internal Revenue Code, what general topic would be covered in Code Sec. 731? a. Capital gains and losses b. Partners and partnerships c. Exempt organizations d....
-
The data shown in the following table were obtained from the 1990 Census. Included is information on 26 randomly selected Metropolitan Statistical Areas (MSAs). Of interest are factors that...
-
A police officer pulls you over and asks to search your vehicle because he suspects you have illegal drugs inside your car. Since he doesn't have reasonable suspicion to search your car, legally he...
-
How much does baseball rely on sabermetrics? Explain your answer.
-
How important is location data to Starbucks's business strategy? Explain your answer.
-
How do location analytics help Starbucks managers make better decisions? Give examples of two decisions that the Atlas system helps support.
-
A rope joins two toboggans. The first toboggan has a 65 kg crate on it and the second has a similar 25 kg crate. A 75 N force is applied to the first toboggan resulting in both moving forward....
-
Q1. A 10 kg bowling ball moving at 6 m/s can be stopped in either of two ways. The ball might crash into a sil stack of hay and take 0.78 seconds to stop, or it might crash into your mom's sore shin...
-
Consider a molecular beam of water molecules (m = 2.9 x 10-26 kg) that diffract through a narrow slit. The the water molecules are traveling at an average speed of 800 m/s. Treat the water molecules...
Study smarter with the SolutionInn App