Please answer the following questions in the excel spreadsheet. Data is in link below. THANK YOU https://elearn.mtsu.edu/d2l/le/dropbox/8816297/8048487/DownloadAttachme

Please answer the following questions in the excel spreadsheet. Data is in link below. THANK YOU

https://elearn.mtsu.edu/d2l/le/dropbox/8816297/8048487/DownloadAttachment?fid=255080120

[email protected]

Instructions

Instruction/Question Finding/Response
Import Sales data from Sales.txt. This file is tab delimited. NA
Store the data on a new sheet titled Sales NA
Create a new column in "H" titled "Total Cost" calculating the Total Cost for each sale NA
Which Salesperson sold the most $ of Chameleon Couch and how many $ was it?
What was Asa Byrd's Total Sales $ for all products?
How many $ of Bamboo coffee Tables did Lucas, John Sale?
Which region had the highest total sales and how much?
What % of the total does the region above represent?
How many (total) Media Armoires were sold in the NW?
What was the average number of Captain Recliners sold per order in the NE? (round to whole number)
How many (total) qty Bamboo End Tables were sold to Home USA in the NE?
How many (total) dollars of Bamboo End Tables were sold to Home USA in the NE?
How many $ worth of Product was sold to B&B Spaces?
For the above, what % of the total sales was this?
For B&B Spaces, which region generated the most sales and how much was it?
In the SW, which customer buys the least $ of Bamboo end Tables, & how much?
Which Salesperson sold the most $ to Home Emporium and what was the $ amount?
Which Salesperson sold the least $ to HomeUSA and what was the $ amount?
We are thinking of dropping a product line in the NE. NA
Which product have we sold the lowest qty of in that region and how much?
Which product have we sold the lowest dollars in that region and how much?
In terms of total sales $ who is the leading salesperson in the NW and how much?
In terms of total sales $ who is the leading salesperson in the NE and how much?
In terms of total sales $ who is the leading salesperson in the SE and how much?
This file includes 2 years worth of data. We want to determine the trend
2014 sales $ is what % of the total sales for NE?
2014 sales $ is what % of the total sales for NW?
2014 sales $ is what % of the total sales for SE?
For each item, what was the change in QTY sold from 2014 to 2015 (+ is increase) NA
Bamboo Coffee Table
Bamboo End Table
Captain Recliner
Chameleon Couch
Media Armoire

sales analysis data

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

Salesperson Product Region Customer Date Item Cost No.Items
Vaughn, Harlon Captain Recliner NE B&B Spaces 1/6/14 340.95 9
Norman, Rita Media Armoire SE Home USA 1/6/14 340.95 2
Christensen, Jill Bamboo End Table NW Ellington Designs 1/7/14 79.99 7
Norman, Rita Bamboo Coffee Table SE Ellington Designs 1/8/14 168.95 3
Byrd, Asa Bamboo End Table SE B&B Spaces 1/8/14 79.99 12
Owen, Robert Chameleon Couch SW Ellington Designs 1/10/14 799.95 13
Maynard, Susan Bamboo End Table NE Home USA 1/11/14 79.99 10
Norman, Rita Chameleon Couch SE Home USA 1/11/14 799.95 2
Norman, Rita Media Armoire SE Home USA 1/11/14 340.95 6
Norman, Rita Media Armoire SE B&B Spaces 1/14/14 340.95 13
Byrd, Asa Bamboo Coffee Table SE Home USA 1/14/14 168.95 10
Vaughn, Harlon Media Armoire NE Home USA 1/14/14 340.95 4
Byrd, Asa Bamboo Coffee Table SE B&B Spaces 1/15/14 168.95 11
Christensen, Jill Captain Recliner NW B&B Spaces 1/15/14 340.95 7
Byrd, Asa Bamboo End Table SE Ellington Designs 1/16/14 79.99 11
Maynard, Susan Chameleon Couch NE B&B Spaces 1/16/14 799.95 6
Lucas, John Captain Recliner SW B&B Spaces 1/17/14 340.95 14
Owen, Robert Bamboo Coffee Table SW Home USA 1/17/14 168.95 10
Vaughn, Harlon Media Armoire NE Ellington Designs 1/22/14 340.95 4
Lucas, John Bamboo End Table SW B&B Spaces 1/23/14 79.99 20
Owen, Robert Media Armoire SW Home USA 1/24/14 340.95 8
Livingston, Lynette Bamboo End Table NE Home USA 1/26/14 79.99 11
Christensen, Jill Captain Recliner NW Ellington Designs 1/28/14 340.95 13
Christensen, Jill Media Armoire NW B&B Spaces 1/28/14 340.95 7
Livingston, Lynette Media Armoire NE B&B Spaces 1/29/14 340.95 8
Vaughn, Harlon Chameleon Couch NE Ellington Designs 1/30/14 799.95 10
Vaughn, Harlon Chameleon Couch NE Home USA 1/30/14 799.95 7
Lucas, John Media Armoire SW Ellington Designs 1/31/14 340.95 4
Christensen, Jill Captain Recliner NW Home USA 1/31/14 340.95 8
Christensen, Jill Chameleon Couch NW Home Emporium 2/1/14 799.95 5
Owen, Robert Chameleon Couch SW Home USA 2/1/14 799.95 7
Vaughn, Harlon Captain Recliner NE Home USA 2/1/14 340.95 6
Christensen, Jill Bamboo End Table NW Home USA 2/2/14 79.99 5
Norman, Rita Bamboo End Table SE Home USA 2/5/14 79.99 10
Kelly, Icelita Captain Recliner SW B&B Spaces 2/6/14 340.95 7
Kelly, Icelita Captain Recliner SW B&B Spaces 2/6/14 340.95 11
Maynard, Susan Captain Recliner NE B&B Spaces 2/6/14 340.95 9
Maynard, Susan Captain Recliner NE B&B Spaces 2/6/14 340.95 12
Vaughn, Harlon Captain Recliner NE B&B Spaces 2/6/14 340.95 15
Vaughn, Harlon Captain Recliner NE B&B Spaces 2/6/14 340.95 17
Norman, Rita Bamboo End Table SE Home Emporium 2/8/14 79.99 9
Norman, Rita Bamboo End Table SE Home Emporium 2/8/14 79.99 14
Owen, Robert Captain Recliner SW Home USA 2/9/14 340.95 1
Owen, Robert Captain Recliner SW Home USA 2/9/14 340.95 3
Owen, Robert Chameleon Couch SW Home Emporium 2/11/14 799.95 4
Owen, Robert Chameleon Couch SW Home Emporium 2/11/14 799.95 11
Leon, Emily Media Armoire SW Ellington Designs 2/12/14 340.95 4
Leon, Emily Media Armoire SW Ellington Designs 2/12/14 340.95 6
Vaughn, Harlon Bamboo Coffee Table NE B&B Spaces 2/12/14 168.95 8
Vaughn, Harlon Bamboo Coffee Table NE B&B Spaces 2/12/14 168.95 13
Vaughn, Harlon Bamboo End Table NE B&B Spaces 2/12/14 79.99 8
Vaughn, Harlon Bamboo End Table NE B&B Spaces 2/12/14 79.99 14
Kelly, Icelita Bamboo End Table SW B&B Spaces 2/15/14 79.99 17
Leon, Emily Chameleon Couch SW Home Emporium 2/16/14 799.95 1
Livingston, Lynette Bamboo Coffee Table NE Home USA 2/16/14 168.95 11
Leon, Emily Chameleon Couch SW Ellington Designs 2/19/14 799.95 9
Maynard, Susan Bamboo End Table NE B&B Spaces 2/19/14 79.99 15
Owen, Robert Chameleon Couch SW B&B Spaces 2/19/14 799.95 14
Vaughn, Harlon Bamboo End Table NE B&B Spaces 2/19/14 79.99 20
Livingston, Lynette Chameleon Couch NE Home Emporium 2/19/14 799.95 5
Livingston, Lynette Chameleon Couch NE B&B Spaces 2/20/14 799.95 18
Christensen, Jill Bamboo Coffee Table NW Home Emporium 2/20/14 168.95 8
Livingston, Lynette Chameleon Couch NE Home Emporium 2/21/14 799.95 14
Owen, Robert Captain Recliner SW B&B Spaces 2/22/14 340.95 18
Byrd, Asa Captain Recliner SE Home USA 2/22/14 340.95 2
Owen, Robert Chameleon Couch SW B&B Spaces 2/23/14 799.95 17
Kelly, Icelita Captain Recliner SW Home Emporium 2/23/14 340.95 12
Owen, Robert Media Armoire SW Home USA 2/27/14 340.95 14
Owen, Robert Chameleon Couch SW Ellington Designs 2/28/14 799.95 9
Norman, Rita Bamboo Coffee Table SE Ellington Designs 3/4/14 168.95 4
Maynard, Susan Media Armoire NE B&B Spaces 3/4/14 340.95 20
Norman, Rita Bamboo End Table SE Home USA 3/5/14 79.99 10
Owen, Robert Bamboo End Table SW Ellington Designs 3/7/14 79.99 12
Byrd, Asa Bamboo Coffee Table SE Ellington Designs 3/8/14 168.95 11
Owen, Robert Media Armoire SW Fabulous Homes 3/9/14 340.95 1
Kelly, Icelita Chameleon Couch SW Ellington Designs 3/12/14 799.95 8
Leon, Emily Bamboo Coffee Table SW Home USA 3/12/14 168.95 15
Vaughn, Harlon Captain Recliner NE Fabulous Homes 3/12/14 340.95 6
Leon, Emily Captain Recliner SW B&B Spaces 3/13/14 340.95 17
Christensen, Jill Captain Recliner NW Home Emporium 3/13/14 340.95 2
Leon, Emily Captain Recliner SW Home Emporium 3/13/14 340.95 9
Owen, Robert Chameleon Couch SW Home Emporium 3/13/14 799.95 8
Vaughn, Harlon Media Armoire NE Ellington Designs 3/14/14 340.95 5
Maynard, Susan Chameleon Couch NE Ellington Designs 3/16/14 799.95 11
Vaughn, Harlon Bamboo End Table NE Ellington Designs 3/18/14 79.99 9
Christensen, Jill Bamboo End Table NW Fabulous Homes 3/18/14 79.99 1
Livingston, Lynette Captain Recliner NE Fabulous Homes 3/18/14 340.95 11
Byrd, Asa Bamboo End Table SE Ellington Designs 3/19/14 79.99 5
Livingston, Lynette Bamboo Coffee Table NE Home USA 3/20/14 168.95 12
Kelly, Icelita Media Armoire SW Home Emporium 3/21/14 340.95 1
Livingston, Lynette Chameleon Couch NE Home Emporium 3/21/14 799.95 9
Maynard, Susan Media Armoire NE B&B Spaces 3/23/14 340.95 16
Owen, Robert Chameleon Couch SW Home USA 3/26/14 799.95 8
Vaughn, Harlon Bamboo End Table NE B&B Spaces 3/27/14 79.99 20
Leon, Emily Media Armoire SW Fabulous Homes 3/27/14 340.95 6
Kelly, Icelita Media Armoire SW B&B Spaces 3/29/14 340.95 20
Leon, Emily Media Armoire SW Ellington Designs 3/30/14 340.95 15
Vaughn, Harlon Chameleon Couch NE Home USA 4/2/14 799.95 7
Arnold, Cole Captain Recliner NW Fabulous Homes 4/2/14 340.95 9
Kelly, Icelita Bamboo End Table SW Home USA 4/4/14 79.99 6
Byrd, Asa Bamboo Coffee Table SE Ellington Designs 4/5/14 168.95 14
Christensen, Jill Media Armoire NW Home Emporium 4/5/14 340.95 3
Vaughn, Harlon Captain Recliner NE Fabulous Homes 4/6/14 340.95 5
Livingston, Lynette Captain Recliner NE Home USA 4/8/14 340.95 3
Livingston, Lynette Media Armoire NE B&B Spaces 4/9/14 340.95 18
Maynard, Susan Bamboo Coffee Table NE Home Emporium 4/9/14 168.95 13
Kelly, Icelita Media Armoire SW Home USA 4/9/14 340.95 11
Leon, Emily Bamboo End Table SW Home USA 4/9/14 79.99 13
Christensen, Jill Media Armoire NW Fabulous Homes 4/9/14 340.95 6
Leon, Emily Media Armoire SW Fabulous Homes 4/9/14 340.95 2
Livingston, Lynette Bamboo End Table NE Ellington Designs 4/10/14 79.99 13
Byrd, Asa Bamboo Coffee Table SE Home USA 4/11/14 168.95 3
Livingston, Lynette Bamboo Coffee Table NE Home Emporium 4/13/14 168.95 10
Christensen, Jill Media Armoire NW Home USA 4/13/14 340.95 14
Arnold, Cole Captain Recliner NW Fabulous Homes 4/13/14 340.95 8
Kelly, Icelita Chameleon Couch SW Home USA 4/15/14 799.95 4
Vaughn, Harlon Media Armoire NE Home USA 4/15/14 340.95 4
Leon, Emily Media Armoire SW Ellington Designs 4/16/14 340.95 6
Christensen, Jill Chameleon Couch NW B&B Spaces 4/16/14 799.95 7
Leon, Emily Bamboo Coffee Table SW Fabulous Homes 4/16/14 168.95 12
Arnold, Cole Bamboo End Table NE B&B Spaces 4/18/14 79.99 12
Arnold, Cole Bamboo End Table NE Fabulous Homes 4/18/14 79.99 12
Livingston, Lynette Bamboo End Table NE Home Emporium 4/19/14 79.99 8
Maynard, Susan Media Armoire NE Home USA 4/20/14 340.95 5
Kelly, Icelita Chameleon Couch SW Home USA 4/22/14 799.95 8
Leon, Emily Media Armoire SW Ellington Designs 4/23/14 340.95 2
Kelly, Icelita Bamboo End Table SW B&B Spaces 4/23/14 79.99 11
Arnold, Cole Media Armoire NE Home Emporium 4/23/14 340.95 1
Christensen, Jill Bamboo Coffee Table NW Fabulous Homes 4/24/14 168.95 12
Kelly, Icelita Captain Recliner SW Ellington Designs 4/25/14 340.95 8
Arnold, Cole Bamboo End Table NE B&B Spaces 4/25/14 79.99 10
Maynard, Susan Media Armoire NE Home Emporium 4/25/14 340.95 4
Kelly, Icelita Bamboo End Table SW Home USA 4/25/14 79.99 7
Vaughn, Harlon Media Armoire NE Fabulous Homes 4/25/14 340.95 7
Kelly, Icelita Chameleon Couch SW B&B Spaces 4/26/14 799.95 16
Owen, Robert Chameleon Couch SW Fabulous Homes 4/29/14 799.95 8
Maynard, Susan Chameleon Couch NE Home Emporium 4/30/14 799.95 2
Owen, Robert Media Armoire SW Home Emporium 4/30/14 340.95 11
Vaughn, Harlon Captain Recliner NE Ellington Designs 5/1/14 340.95 8
Owen, Robert Bamboo Coffee Table SW Fabulous Homes 5/1/14 168.95 12
Norman, Rita Bamboo End Table SE Home Emporium 5/2/14 79.99 1
Christensen, Jill Media Armoire NW Ellington Designs 5/7/14 340.95 2
Leon, Emily Chameleon Couch SW Fabulous Homes 5/8/14 799.95 6
Christensen, Jill Bamboo End Table NW Ellington Designs 5/10/14 79.99 5
Arnold, Cole Chameleon Couch NE Home Emporium 5/11/14 799.95 6
Norman, Rita Media Armoire SE Home Emporium 5/11/14 340.95 15
Christensen, Jill Chameleon Couch NW Ellington Designs 5/13/14 799.95 9
Byrd, Asa Chameleon Couch SE Home USA 5/14/14 799.95 10
Livingston, Lynette Captain Recliner NE Fabulous Homes 5/14/14 340.95 11
Christensen, Jill Bamboo End Table NW Home USA 5/15/14 79.99 3
Owen, Robert Bamboo Coffee Table SW Home Emporium 5/16/14 168.95 15
Leon, Emily Bamboo Coffee Table SW Fabulous Homes 5/16/14 168.95 14
Leon, Emily Captain Recliner SW B&B Spaces 5/17/14 340.95 6
Livingston, Lynette Bamboo End Table NE B&B Spaces 5/18/14 79.99 7
Maynard, Susan Captain Recliner NE Home Emporium 5/18/14 340.95 12
Maynard, Susan Captain Recliner NE Home USA 5/18/14 340.95 5
Byrd, Asa Media Armoire SE B&B Spaces 5/20/14 340.95 15
Christensen, Jill Bamboo Coffee Table NW Home USA 5/20/14 168.95 11
McCullough, Scott Media Armoire NW Fabulous Homes 5/20/14 340.95 15
Owen, Robert Captain Recliner SW B&B Spaces 5/21/14 340.95 18
Kelly, Icelita Media Armoire SW Ellington Designs 5/23/14 340.95 3
Arnold, Cole Bamboo Coffee Table NE Ellington Designs 5/24/14 168.95 4
Leon, Emily Bamboo Coffee Table SW B&B Spaces 5/25/14 168.95 9
Kelly, Icelita Media Armoire SW Home Emporium 5/27/14 340.95 3
Vaughn, Harlon Chameleon Couch NE Home Emporium 5/27/14 799.95 10
Kelly, Icelita Bamboo End Table SW Ellington Designs 5/28/14 79.99 1
Leon, Emily Bamboo Coffee Table SW B&B Spaces 5/28/14 168.95 6
Maynard, Susan Captain Recliner NE B&B Spaces 5/28/14 340.95 14
Livingston, Lynette Bamboo Coffee Table NE Home USA 5/28/14 168.95 9
Owen, Robert Captain Recliner SW Fabulous Homes 5/28/14 340.95 1
Owen, Robert Chameleon Couch SW Ellington Designs 5/31/14 799.95 5
Maynard, Susan Bamboo Coffee Table NE B&B Spaces 6/3/14 168.95 14
Arnold, Cole Captain Recliner NW Home USA 6/4/14 340.95 2
Livingston, Lynette Bamboo End Table NE Home USA 6/4/14 79.99 12
Kelly, Icelita Captain Recliner SW Ellington Designs 6/6/14 340.95 9
Owen, Robert Bamboo End Table SW Home Emporium 6/7/14 79.99 6
Leon, Emily Bamboo Coffee Table SW B&B Spaces 6/10/14 168.95 18
Maynard, Susan Captain Recliner NE B&B Spaces 6/11/14 340.95 13
Byrd, Asa Bamboo End Table SE Home Emporium 6/12/14 79.99 14
Maynard, Susan Chameleon Couch NE Home Emporium 6/12/14 799.95 3
Maynard, Susan Media Armoire NE B&B Spaces 6/13/14 340.95 18
Christensen, Jill Bamboo End Table NW Fabulous Homes 6/13/14 79.99 9
Kelly, Icelita Chameleon Couch SW Home Emporium 6/14/14 799.95 10
McCullough, Scott Captain Recliner NW Ellington Designs 6/15/14 340.95 6
Leon, Emily Bamboo Coffee Table SW Ellington Designs 6/18/14 168.95 6
Livingston, Lynette Bamboo Coffee Table NE Ellington Designs 6/18/14 168.95 9
McCullough, Scott Captain Recliner NW Ellington Designs 6/18/14 340.95 10
Vaughn, Harlon Chameleon Couch NE Fabulous Homes 6/18/14 799.95 3
Vaughn, Harlon Chameleon Couch NE B&B Spaces 6/19/14 799.95 19
Arnold, Cole Media Armoire NE Home USA 6/19/14 340.95 14
Arnold, Cole Chameleon Couch NE Home USA 6/21/14 799.95 11
Kelly, Icelita Chameleon Couch SW Fabulous Homes 6/21/14 799.95 6
Vaughn, Harlon Bamboo End Table NE Home USA 6/22/14 79.99 3
Christensen, Jill Bamboo Coffee Table NW Ellington Designs 6/25/14 168.95 5
Maynard, Susan Chameleon Couch NE B&B Spaces 6/25/14 799.95 19
Maynard, Susan Bamboo End Table NE Home Emporium 6/25/14 79.99 10
Livingston, Lynette Captain Recliner NE Fabulous Homes 6/25/14 340.95 8
Maynard, Susan Chameleon Couch NE Fabulous Homes 6/25/14 799.95 9
Maynard, Susan Media Armoire NE Home Emporium 6/26/14 340.95 6
Owen, Robert Bamboo End Table SW Home USA 6/26/14 79.99 11
Livingston, Lynette Bamboo Coffee Table NE Ellington Designs 6/27/14 168.95 7
Kelly, Icelita Media Armoire SW Home USA 6/27/14 340.95 2
Livingston, Lynette Media Armoire NE Fabulous Homes 6/27/14 340.95 15
Arnold, Cole Bamboo End Table NE B&B Spaces 6/28/14 79.99 12
Byrd, Asa Chameleon Couch SE Fabulous Homes 6/28/14 799.95 14
Leon, Emily Chameleon Couch SW Fabulous Homes 6/28/14 799.95 15
Leon, Emily Captain Recliner SW Fabulous Homes 6/28/14 340.95 4
Christensen, Jill Chameleon Couch NW Ellington Designs 7/4/14 799.95 11
Owen, Robert Captain Recliner SW Home Emporium 7/4/14 340.95 14
Christensen, Jill Bamboo End Table NW Ellington Designs 7/5/14 79.99