DIAMOND JEWELERS SALES DASHBOAR Month May Store Sales Simsbury Hartford Farmington Canton Avon 0 500 1000 1500 2000 2500 Monthly Sales 6000 5000 4000 3000 2000 1000 0 Jan Feb Mar

Document Sample
DIAMOND JEWELERS SALES DASHBOAR Month May Store Sales Simsbury Hartford Farmington Canton Avon 0 500 1000 1500 2000 2500 Monthly Sales 6000 5000 4000 3000 2000 1000 0 Jan Feb Mar Powered By Docstoc
					DIAMOND JEWELERS SALES DASHBOAR Month
May

Store Sales
Simsbury Hartford Farmington Canton Avon 0 500 1000 1500 2000 2500

Monthly Sales
6000

5000
4000

3000
2000

1000 0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

S SALES DASHBOARD Total Sales
2172

Sales Person
Michael Thomas
Joe Stone

Tom Reftery Paul Smith Mary Jane Susan Miller John Doe
0 500 1000 1500 2000

Marketing
Other 25% Magazine 0% Newspaper 25%

Internet 0%

Radio 0%

Television 50%

Retail Sales Dashboard
1) The template contains sample data for a jewelery stores. To modify the dashboard follow the steps: a. b. c. >> Change the title of the dashboard in 'Dashboard' sheet (first unprotect the sheet using Review menu). Fill the 'Stores', 'Salesperson' and 'Marketing' lists in 'Lists' sheet. Enter your data in 'Data' sheet. You can use up to row 250. For more data, you need to update the range of name 'DB'.

Your Retail Store Dashboard is ready to use. Now you can check the Dashboard sheet for the analysis of the data provided in the Data sheet.

the range of name 'DB'.

of the data provided

StoreLocation TDate Avon Farmington Avon Simsbury Hartford Canton Avon Farmington Avon Farmington Avon Simsbury Hartford Canton Hartford Avon Farmington Avon Simsbury Hartford Avon Simsbury Hartford Canton Hartford Avon Farmington Avon Simsbury Avon Simsbury Hartford Canton Hartford Avon Farmington Avon Simsbury

SalesPerson

Name InterestSource NewOrExisting efe MNO MNO MNO MNO MNO MNO MNO MNO MNO efe MNO MNO MNO MNO MNO MNO MNO MNO MNO efe MNO MNO MNO MNO MNO MNO MNO MNO efe MNO MNO MNO MNO MNO MNO MNO MNO Magazine Magazine Newspaper Radio Television Internet Other Other Television Magazine Newspaper Radio Television Internet Other Television Television Other Newspaper Radio Television Internet Other Magazine Newspaper Radio Television Internet Other Magazine Magazine Newspaper Radio Television Internet Other Other Other New New New Existing New New New New New New Existing Existing Existing New New New New New New Existing Existing Existing New New New Existing Existing New New New New New New New Existing New New Existing

SelfOrGift ItemBoughtFor 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male 0 Male

1/2/2008 John Doe 1/2/2008 Susan Miller 2/1/2008 Mary Jane 12/1/2008 Paul Smith 5/3/2008 Tom Reftery 3/3/2008 Joe Stone 7/2/2008 Michael Thomas 9/11/2008 John Doe 11/11/2008 Susan Miller 10/2/2008 Mary Jane 1/2/2008 Paul Smith 3/3/2008 Tom Reftery 2/1/2008 Joe Stone 12/1/2008 Michael Thomas 5/3/2008 John Doe 1/2/2008 Susan Miller 7/2/2008 Mary Jane 9/11/2008 Mary Jane 11/11/2008 Paul Smith 10/2/2008 Tom Reftery 1/2/2008 Joe Stone 3/3/2008 Michael Thomas 2/1/2008 Joe Stone 12/1/2008 Michael Thomas 5/3/2008 John Doe 4/2/2008 Mary Jane 7/2/2008 Paul Smith 9/11/2008 Tom Reftery 11/11/2008 Joe Stone 1/2/2008 Michael Thomas 4/2/2009 Tom Reftery 2/1/2008 Joe Stone 12/1/2008 Michael Thomas 5/3/2008 John Doe 1/2/2008 Susan Miller 7/2/2008 Mary Jane 9/11/2008 Paul Smith 11/11/2008 Tom Reftery

JewelryType DiamondJewelery Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagement Rings Engagem
				
DOCUMENT INFO
Stats:
views:1626
posted:8/3/2009
language:English
pages:25
Description: This is a sample dashboard that may be used for analyzing the performances of retail stores. The data is stored on a Data sheet. Each record may contain information of the store, date, salesperson, interest source, item type and price. Using this data, the dashboard displays 4 charts: sales by stores, sales by salespersons, sales by months and sales by marketing type. The charts may be created for any month that may be selected using a combo box.
BUY THIS DOCUMENT NOW PRICE: $12.99 100% MONEY BACK GUARANTEED
PARTNER SpreadsheetZone
SpreadsheetZONE features one of the biggest Microsoft Excel template repositories on the web. Supported by an active community and Excel Pros SpreadsheetZONE grows rapidly, delivering new templates everyday. Find the template you need now!