M2Assessment

docx

School

University of Texas, Rio Grande Valley *

*We aren’t endorsed by this school

Course

6350

Subject

Marketing

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MinisterOtterPerson4117

Module 2 Assessment Based on the pivot table and pivot chart obtained from the previous activity, please compile the answers to the following questions (please copy and paste the supporting evidence the results) in a word file and submit it as an attachment through this assignment link on Blackboard. (You can use the pivot table for questions 1-3, pivot chart for question 4, and both pivot table and pivot chart for question 5) 1. Among all the product types sold (all dates and all channels), which one has the highest total? _Wolf Pack _ What is the total? _171 _ 2. What is the name of the online salesperson that has the highest total on 1/9/2009? _Eddie _ What is the total? _613 _ 3. On 1/10/2009, what is the total for the salesperson Paulette? _323 _ Which product type did she sell the least? _Mythic World _ Who was the star of this product type (i.e. the one that

achieved the highest total) on that date? _Orin _ 4. Among the three store types, which one has the highest total for each product type? _Warriors of Yore have the highest Online (18517.73) and Wholesale (60255.58) labels. Mythic World has the highest Retail (3627.47) label. 5. Use both the pivot table and pivot chart to identify what comprised the low sales of Guiding Lights on 1/9/2009. _The low sales of "Guiding Lights" are primarily attributed to the relatively low unit sales contributed by specific individuals, with some having no recorded sales for this category. The corresponding store sales from different channels, while not extremely low, reflect the impact of the lower unit sales compared to other categories. Overall, the combination of low unit sales and corresponding store sales contributes to the lower performance of "Guiding Lights" in terms of revenue.

6. Develop a question of your own and answer it with the information extracted with a new pivot table/chart. Question: _How can the organization leverage the data from both unit sales and store sales across different channels to optimize inventory management and distribution strategies for each product category? Answer: _The organization can enhance inventory management and distribution strategies by identifying top-performing categories such as "Warriors of Yore" and "Mythic World," where both unit sales and store sales are high across various channels. This suggests allocating more resources and inventory to these successful categories. Additionally, for underperforming categories like "Guiding Lights," efforts can be focused on improving individual contributions and exploring marketing strategies to boost both unit and store sales. This will include the following:

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

 Unit Sales:  Guiding Lights: 736 units  Mythic World: 545 units  Warriors of Yore: 2609 units  Woodland Creatures: 1110 units  Grand Total: 5000 units  Store Sales (in dollars):  Guiding Lights: o Online: $2580.9 o Retail: $404.25 o Wholesale: $10918.95  Mythic World: o Online: $12693.13 o Retail: $3627.47 o Wholesale: $21280.39  Warriors of Yore: o Online: $18517.73 o Retail: $3118.5 o Wholesale: $60255.58  Woodland Creatures: o Online: $11266.93 o Retail: $2584.8 o Wholesale: $44223.43  Grand Total: o Online: $45058.69 o Retail: $9735.02 o Wholesale: $136678.35 These numbers provide a comprehensive overview of both unit sales and store sales across different categories and channels.

Related Documents

F23 Assignment-2 Sampling (2), form to be completed.docx

MKT205_Module_Five_Milestone.docx

Executive Summary.docx

RodgersKBUS-7105-7.docx

MKTG 450W Markstrat Presentation Essay.docx

ch 2 mcq.pdf

Kendra Walls -MKT205 - MOD-2 Milestone.docx

N.Lett_MKT Plan_v1.docx

Thomas, Dysha Last name, MKTG 340-98 Final Exam.docx

5-2 Milestone Three.docx

Mapping Your Competition Assignment - Radio Channels.docx

Functions of Business Case Study-BDV.docx

Recommended textbooks for you

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

Management, Loose-Leaf Version

Management

ISBN:9781305969308

Author:Richard L. Daft

Publisher:South-Western College Pub

Foundations of Business (MindTap Course List)

Marketing

ISBN:9781337386920

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

Foundations of Business - Standalone book (MindTa...

Marketing

ISBN:9781285193946

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Management, Loose-Leaf Version
Management
ISBN:9781305969308
Author:Richard L. Daft
Publisher:South-Western College Pub
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Foundations of Business - Standalone book (MindTa...
Marketing
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning