Congratulations! You've been hired as Assistant to the Marketing Manager at a nearby Small Mart store....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Congratulations! You've been hired as Assistant to the Marketing Manager at a nearby Small Mart store. Sarah, the store's Marketing Manager, is concerned about sales in the kitchenware department. She has asked you and your team to perform an analysis of the data provided in this Excel file. All responses should be presented in this Excel workbook. It is your team's responsibility to present tables, graphics, and answers in a clear, organized, and professional manner that will be easy for Sarah and the store's leadership team to understand. 1. Create a table that reports the total unit sales and total dollar sales of each product in the dataset. This table should also include the total unit sales and total dollar sales of all products sold. Sarah wants to know which products generated the highest sales (in units and in dollars) and which products generated the lowest sales (in units and in dollars). 2. Create a table that reports the total unit sales and total dollar sales of each salesperson on staff Sarah needs to know which salespeople sold the most product (in units and in dollars) and which salespeople sold the least product (in units and in dollars). 3. Sarah is evaluating the effectiveness of the sales team. She wants to know who is generating sales most efficiently in this dataset. Create a table that reports the average dollar sales per unit sold for each salesperson. Present this table in descending order so that the highest average dollar sales per unit sold appears at the top and the lowest average dollar sales per unit sold appears at the bottom. Present this table in a manner that makes it easy for Sarah to understand the performance of the sales team members. Congratulations! You've been hired as Assistant to the Marketing Manager at a nearby Small Mart store. Sarah, the store's Marketing Manager, is concerned about sales in the kitchenware department. She has asked you and your team to perform an analysis of the data provided in this Excel file. All responses should be presented in this Excel workbook. It is your team's responsibility to present tables, graphics, and answers in a clear, organized, and professional manner that will be easy for Sarah and the store's leadership team to understand. 1. Create a table that reports the total unit sales and total dollar sales of each product in the dataset. This table should also include the total unit sales and total dollar sales of all products sold. Sarah wants to know which products generated the highest sales (in units and in dollars) and which products generated the lowest sales (in units and in dollars). 2. Create a table that reports the total unit sales and total dollar sales of each salesperson on staff Sarah needs to know which salespeople sold the most product (in units and in dollars) and which salespeople sold the least product (in units and in dollars). 3. Sarah is evaluating the effectiveness of the sales team. She wants to know who is generating sales most efficiently in this dataset. Create a table that reports the average dollar sales per unit sold for each salesperson. Present this table in descending order so that the highest average dollar sales per unit sold appears at the top and the lowest average dollar sales per unit sold appears at the bottom. Present this table in a manner that makes it easy for Sarah to understand the performance of the sales team members.
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
Hemming Co. reported the following current year purchases and sales for its only product. Required Hemming uses a perpetual inventory system. Determine the costs assigned to ending inventory and to...
-
A 1.50-mole sample of an ideal gas is allowed to expand adiabatically and reversibly to twice its original volume. In the expansion the temperature dropped from 296 K to 239 K. Calculate E and H for...
-
Welles Corporation was organized on January 1, 2014. It is authorized to issue 20,000 shares of 6%, $40 par value preferred stock, and 500,000 shares of no-par common stock with a stated value of $1...
-
Performance and Segment Margin Division \(\mathrm{X}\) of Competitive Corp. had sales of \(\$ 4,000,000\) during the third quarter of 20X2. The following costs were recorded for Division...
-
Calculate the following: (a) The bubble-point temperature of an Equimolar mixture of liquid n-hexane and n-heptanes at 1.0 atm and the composition (mole fractions) of the vapor in equilibrium with...
-
On November 23, 2023, the police showed up at Ms. Skyler's house in Toronto to arrest her 16-year-olld son Flynn for sexual assault. The officers stated that a 16-year-old girl alleged that Flynn had...
-
Directions: Use the information below to answer the following question. What accounts were sources of cash in year 2 ? End of Year 1 End of Year 2 Net Fixed Assets $ 3 4 0 $ 3 6 0 Inventory 8 4 7 8...
-
Find the directional derivative of the given function at the given point in the indicated direction. (-2, 3), 6i + 8j f(x, y) = x+y D(-2, 3) = eBook Submit Answer [-/1 Points] DETAILS ZILLENGMATH7...
-
1- The results of a sieve analysis of two soil samples are as follows: Sieve aperture (mm) Mass of soil retained on sieve (g) Soil A Soil B 0.0 26.0 31.0 11.0 18.0 24.0 21.0 41.0 32.0 16.0 15.0 15.0...
-
Chad Everhart, age 56, is a geologist living in Bozeman, MT. His address is 426 Ridgetop Road, Bozeman, MT, 59717. Chad's social security number is 123-45-6789, and he works as a geologist for the...
-
If f(x)=4x-5x+7, find f'(1). Use this to find the equation of the tangent line to the parabola y = 4x-5x+7 at the point (1,6). The equation of this tangent line can be written in the form y = mx + b...
-
Using the data that is shown below - (a) calculate the individual after-tax cash flow effect of each relevant item in each independent situation, and (b) sum the individual after-tax cash flows in...
-
Present the "monetary rule" of the Monetarists. How does this rule depend on the Quantity Theory of Money?
-
Nate prepares slides for his microscope. In 1 day he prepared 12 different slides. Which equation best represents y, the total number of slides Nate prepares in x days if he continues at this rate? A...
-
Resources are _________ used to produce goods and services.
-
_________ occurs because our unlimited wants exceed our limited resources.
-
The economic problem is the fact that _________ forces us to choose, and choices are costly because we must give up other opportunities that we _________.
Study smarter with the SolutionInn App