How do the sales volume in each store relate to revenues

Assignment Help Computer Engineering

Reference no: EM131925087

Problem

Laptop Sales at a London Computer Chain: Interactive Visualization. The next exercises are designed for using an interactive visualization tool. The file LaptopSales.txt is a comma-separated file with nearly 300,000 rows. ENBIS (the European Network for Business and Industrial Statistics) provided these data as part of a contest organized in the fall of 2009.

Scenario: Imagine that you are a new analyst for a company called Acell (a company selling laptops). You have been provided with data about products and sales. You need to help the company with their business goal of planning a product strategy and pricing policies that will maximize Acell projected revenues in 2009. Using an interactive visualization tool, answer the following questions.

a. Price Questions:

i. At what price are the laptops actually selling?

ii. Does price change with time? The software should then enable different temporal aggregation choices, e.g., plotting the data by weekly or monthly aggregates, or even by day of week.)

iii. Are prices consistent across retail outlets?

iv. How does price change with configuration?

b. Location Questions:

i. Where are the stores and customers located?

ii. Which stores are selling the most?

iii. How far would customers travel to buy a laptop?

iv. Try an alternative way of looking at how far customers traveled. Do this by creating a new data column that computes the distance between customer and store.

c. Revenue Questions:

i. How do the sales volume in each store relate to Acell revenues?

ii. How does this relationship depend on the configuration?

d. Configuration Questions:

i. What are the details of each configuration? How does this relate to price? ii. Do all stores sell all configurations?

Reference no: EM131925087

Questions Cloud

Implement a strategy that gives priority to actions : A states is partially explored if there exists an unexplored action. Implement a strategy that gives priority to actions that lead to interesting states.

What type of corporation is it in kentucky : Laura and Erin form a corporation to prevent spouse and child abuse. The corporation operates a shelter for battered women and homeless children.

Implement a strategy that records for each transition : Implement a strategy that records for each transition (s1, a, s2) an abstract transition (g(s1), g(a), g(s2)), where g is a grouping function; use Get Hash Code

Propose the manner in which you would apply portfolio : Imagine that one (1) of your clients has $100,000 to invest. Propose the manner in which you would apply portfolio theory to this scenario.

How do the sales volume in each store relate to revenues : How do the sales volume in each store relate to revenues? How does this relationship depend on the configuration?

Identify three sources of governmental insurance plans : Identify three sources of governmental insurance plans. In your opinion, are these sources of health care resourceful?

Create a bar chart showing the average retail price by store : Create a bar chart, showing the average retail price by store. Which store has the highest average? Which has the lowest?

Create a scatter plot of lot size vs income : Create a scatter plot of Lot Size vs. Income, color-coded by the outcome variable owner/nonowner. Make sure to obtain a well-formatted plot.

Identify ten pairs of companies with sources of synergy : Identify 10 pairs of companies with sources of synergy.For each example give the company name providing these services and the synergy obtained.

User Account

All Pages