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% (4 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.
-
The term "practice before the IRS" includes the representation of clients in the U.S. Tax Court for cases being handled under the "small tax case procedure." True or false? Explain your answer. (IRS...
-
Refer to the information in Exercise 17-7 to answer the following requirements. Required 1. Using ABC, compute the overhead cost per unit for each product line. 2. Determine the total cost per unit...
-
SuperCity is a large retailer of electronics and appliances. The store sells three different models of TVs that are ordered from different manufacturers. The demands, costs, and storage requirements...
-
Research Web-based database technologies and identify a database management system (other than SQL Server, MySQL, or Oracle) that is used to deploy applications to the Web and the cloud. Discuss the...
-
The shaft is supported by a smooth thrust bearing at B and a journal bearing at C. Determine the resultant internal loadings acting on the cross section at E. - 4 ft 4 ft +4 ft- 4 ft- 400 lb 800 lb
-
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...
-
Les Cliniques du Parc reports the following information for July 2015 regarding its nursing staff consisting of nurses, nursing assistants and orderlies. Required 1 Calculate the total direct nursing...
-
Discuss aggregate planning in services.
-
Describe some of the graphical and quantitative techniques planners use.
-
Describe some of the strategies that can be used for meeting uneven demand.
-
Identify the variables decision makers have to work with in aggregate planning.
-
Explain what aggregate planning is and how it is useful.
-
V. R. Rao and Company has been operating for five years as a software consulting firm specializing in the installation of industry standard products. During this period, it has experienced rapid...
-
DC has unused FTC carryover from 2017 in the separate category for GC income as the result of income generated by a foreign branch. The income was foreign source general category income. In 2018 the...
-
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.
-
(1) If the net price (excluding material costs) of a pizza is $4.00. And the nominal wage of a worker is $20.00 per hour. How much is the real wage in this case? And how many workers should be...
-
In the paper "The longevity society" Scott (2021) comments: "As we live longer, what becomes increasingly important is how we age." In the paper "The longevity economy" Scott (2021) comments "The...
-
An industry consists of two firms, unimaginatively called firm 1 and firm 2. The two firms compete by simultaneously setting prices. The demand function for the product of firm i = {1,2} is qi (Pi,...
Study smarter with the SolutionInn App