Reference no: EM131232903
Marketing Research
Utilizing the Homework2.xls attached at the bottom, answer and perform the following questions and summarizations.
Within the excel file, label each request (1a, 1b, etc.) as a separate worksheet within the excel file. Make sure to answer the questions asked within the sheets and not just do the tables and charts. Before jumping right into the questions, it is recommended that you look at the data and the fields first to understand what the information is and its importance.
1. The Makeup worksheet gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this data to perform the following exercises:
a. Summarize the total revenue and units sold by each person for each product. How many lipsticks did Betsy sell? What is the total amount of revenue for Jen?
b. Summarize the percentage of each person's revenue sales that came from each location. Create a PivotChart to summarize this information. What area is Cristina's strongest?
c. Summarize each girl's unit sales (not revenue) by location and use the Report Filter to include the subsets of products. What location has the most number units sold? What location has the most unit sales of eyeliner?
2. The Tape worksheet contains data for the unit sales of 3M tape, price charged, whether an ad campaign was run that week (1 = ad campaign), and whether the product was displayed on the end of the aisle (1 = end cap). Use this date to perform the following exercises:
a. Analyze the nature of the monthly seasonality of tape sales. Use average monthly sales for your table and chart. Is there a season where tape sales is high? Low?
b. What are the total unit sales using an ad vs. no ad? What are the average unit sales using an ad vs. no ad? Does an ad campaign appear to increase sales? How many weeks was an ad used?
c. What are the total unit sales using an end cap vs. no end cap? What are the average unit sales using an end cap vs. no end cap? Does placing items on the end cap appear to increase sales?
Attachment:- homework.rar
|
Ex-world com ceo ebbers guilty
: Identify which two barriers to effective communication were most prominent within WorldCom and explain how these barriers led to the downfall of the company. The barriers are filtering, selective perception, information overload, emotional discon..
|
|
Explain the value of cost classifications
: Conduct some research to explain the value of cost classifications for Mal Ltd. and how this may assist Mr and Mrs Long in improving their decision-making processes.
|
|
Create a half adder module and testbench in verilog
: CMPE212 Fall16 Assignment. Create a Half Adder module and testbench in Verilog. Show your output as a truth table. Create a Full Adder using the Half Adder module, and a testbench for the Full Adder. Show your output as a truth table
|
|
Explain how design elements encourage learning and transfer
: Case: The CEO Institute Identify the design elements which help ensure that participants learn about leadership and put it into practice. Explain how these design elements encourage learning and transfer.
|
|
What are the total unit sales using an ad vs. no ad
: Analyze the nature of the monthly seasonality of tape sales. Use average monthly sales for your table and chart. Is there a season where tape sales is high? Low?
|
|
Assignment-concept map-short paragraph
: Before you begin, take a moment to look ahead to Week 7 Assignment. Read the assignment carefully. Shape your work in this Week 2 Assignment, and all other assignments, around the goal of producing a multi-media presentation.
|
|
List and diagram the structures of the prokaryotic cell
: List and diagram the structures of the prokaryotic cell. Provide the structures/organelles found in animal and plant cells (FYI: to yourself or a classmate. be able to describe the function of each structure/organelle).
|
|
Create your own annotated bibliography
: When searching for sources it is helpful to develop a system of organization. One of the most commonly used methods of organizing sources is to keep an annotated bibliography. Create your own annotated bibliography with the sources you are using for ..
|
|
Dysfunctional organizational culture
: Name one organization that is widely known to have a dysfunctional organizational culture. List an example of an organizational ritual used to represent organizational culture. List two examples of organizational ceremonies used to signify organizati..
|