Analysis1
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Analysis1 as PDF for free.
More details
- Words: 2,306
- Pages: 21
Product Category Alternative Ambient Ancient Ancient Animation Architecture Architecture Asian Avant-Garde Bebop Biographies Biographies Bluegrass Cajun and Zydeco Certification Childrens Classics Classics Composers Composers Contemporary Contemporary Contemporary Crafts Crime Data Warehousing Educators Electronic Entertaining Espionage Family Adventures Family Adventures Fiction Forms Games Historical Periods Hong Kong How It Works How It Works How To Humor Indie International James Bond James Bond Management Management Modern Electric Modern Electric New Wave
Store Name State Province Super BMV Stockholm Stockholm Super BMV Sydney New South Wales BMV Lyon Rhône-Alpes www.downtownbmv.comTexas Super BMV Stockholm Stockholm Super BMV Vancouver British Columbia Super BMV Westwood California BMV Lyon Rhône-Alpes Super BMV Stockholm Stockholm Super BMV Westwood California BMV Brooklyn New York Super BMV Sydney New South Wales Super BMV Vancouver British Columbia Super BMV Stockholm Stockholm BMV Brooklyn New York BMV Lyon Rhône-Alpes BMV Lyon Rhône-Alpes Super BMV Westwood California BMV Brooklyn New York Super BMV Sydney New South Wales BMV Lyon Rhône-Alpes Super BMV Stockholm Stockholm Super BMV Sydney New South Wales Super BMV Sydney New South Wales Super BMV Tokyo Tokyo www.downtownbmv.com Texas Super BMV Westwood California Super BMV Westwood California Super BMV Westwood California Super BMV Vancouver British Columbia BMV Brooklyn New York BMV Brooklyn New York Super BMV Stockholm Stockholm Super BMV Tokyo Tokyo BMV Brooklyn New York Super BMV Westwood California Super BMV Vancouver British Columbia Super BMV Stockholm Stockholm Super BMV Westwood California BMV Lyon Rhône-Alpes BMV Lyon Rhône-Alpes BMV Lyon Rhône-Alpes BMV Brooklyn New York Super BMV Tokyo Tokyo Super BMV Westwood California BMV Lyon Rhône-Alpes Super BMV Westwood California BMV Lyon Rhône-Alpes Super BMV Westwood California BMV Brooklyn New York
City Stockholm Sydney Lyon Dallas Stockholm Vancouver Los Angeles Lyon Stockholm Los Angeles Brooklyn Sydney Vancouver Stockholm Brooklyn Lyon Lyon Los Angeles Brooklyn Sydney Lyon Stockholm Sydney Sydney Tokyo Dallas Los Angeles Los Angeles Los Angeles Vancouver Brooklyn Brooklyn Stockholm Tokyo Brooklyn Los Angeles Vancouver Stockholm Los Angeles Lyon Lyon Lyon Brooklyn Tokyo Los Angeles Lyon Los Angeles Lyon Los Angeles Brooklyn
New Wave New Wave Performers Performers Pets Pets Philosophers Philosophers Photography Photography Programming Programming Reggae Reggae Reggae Salsa Salsa Series Swing Techno-House Tejano Tejano Traditional Traditional United States Weddings Westerns Westerns Writers
Super BMV Sydney Super BMV Westwood BMV Lyon Super BMV Sydney Super BMV Vancouver Super BMV Westwood BMV Brooklyn Super BMV Vancouver Super BMV Vancouver Super BMV Westwood Super BMV Tokyo Super BMV Westwood Super BMV Tokyo Super BMV Tokyo Super BMV Vancouver Super BMV Vancouver Super BMV Westwood Super BMV Sydney Super BMV Stockholm BMV Lyon BMV Brooklyn BMV Lyon BMV Lyon Super BMV Westwood Super BMV Sydney www.downtownbmv.com BMV Lyon Super BMV Westwood BMV Brooklyn
New South Wales California Rhône-Alpes New South Wales British Columbia California New York British Columbia British Columbia California Tokyo California Tokyo Tokyo British Columbia British Columbia California New South Wales Stockholm Rhône-Alpes New York Rhône-Alpes Rhône-Alpes California New South Wales Texas Rhône-Alpes California New York
Sydney Los Angeles Lyon Sydney Vancouver Los Angeles Brooklyn Vancouver Vancouver Los Angeles Tokyo Los Angeles Tokyo Tokyo Vancouver Vancouver Los Angeles Sydney Stockholm Lyon Brooklyn Lyon Lyon Los Angeles Sydney Dallas Lyon Los Angeles Brooklyn
New York Brooklyn Store Name Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon
Store Name Acient Acient Acient BMV Brooklyn BMV Brooklyn Acient Acient Acient BMV Brooklyn BMV Brooklyn BMV Brooklyn
Product Name Ancient Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct
230 244 254 267 278 298 307 320 333 346
Nov Dec
359 372 350GB*24
Year->Qtr->Month Day->Hour->Min
Jan->2nd->22,24 Sales Sales Sales Sales
Unit Sales Full Date Time 370 10/01/2001 308 10/01/2001 370 10/01/2001 1540 10/01/2001 277 10/01/2001 770 10/01/2001 619 10/01/2001 370 10/01/2001 554 10/01/2001 619 10/01/2001 770 10/01/2001 246 10/01/2001 619 10/01/2001 370 10/01/2001 770 10/01/2001 462 10/01/2001 370 10/01/2001 619 10/01/2001 619 10/01/2001 246 10/01/2001 554 10/01/2001 370 10/01/2001 308 10/01/2001 185 10/01/2001 246 10/01/2001 1239 10/01/2001 619 10/01/2001 770 10/01/2001 619 10/01/2001 921 10/01/2001 619 10/01/2001 619 10/01/2001 370 10/01/2001 246 10/01/2001 770 10/01/2001 770 10/01/2001 619 10/01/2001 277 10/01/2001 770 10/01/2001 277 10/01/2001 462 10/01/2001 370 10/01/2001 770 10/01/2001 246 10/01/2001 461 10/01/2001 370 10/01/2001 619 10/01/2001 462 10/01/2001 619 10/01/2001 770 10/01/2001
8:35 8:38 8:42 8:46 8:55 9:00 9:01 9:06 9:07 9:07 9:10 9:12 9:12 9:13
Business Analysis Questions Q1 Q2 Q3 Q4 Q5
Total sales for Product Category "Ancient" vs " Sales growth vs Operating expences for Produ Sales/Expenses for Store Name "Super BMV W Sales of "Contemporary" Product Category for Total sales in last 3 months for Product Catego
Sales/Operating Expence Qua Time Qtr2 230 340 543 444 756 456
Qtr1 Ancient Composer Classis
600 500 400 300 200 100 0 Qtr1
Qtr1
Classis Qtr2
246 619 554 308 619 770 619 619 619 461 185 461 246 185 770 619 770 185 370 370 619 370 462 461 185 1239 370 619 461
10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001
450 400 350 300 250 200 150 100 50 0 Month
Product Name Operating Cost Sales 120 122 145 178 234 254 279 309 339 368
Composer Operating Cost 345 356 378 398 344 367 374 377 379 382
Feb
Mar
Apr
May
Jun
Jul
Sales Operating Cost
California Los Angeles
Ancient
Jan
102 132 143 144 158 159 176 186 197 207
Aug
398 428
385 387
Analysis 98% Analysis 2%
Relational DB
Drill Down/Drill Up Dimension Hierarchy Yearly Qtr Month Weekly
218 228
s
ory "Ancient" vs "Composer" for last two Quarters ? pences for Product category "Ancient" last 6 months? me "Super BMV Westwood" in City "Lyon" and Sydney? duct Category for all stores in 12 Months Rolling? or Product Category "Contemporary in Lyon City in BMV Store"?
perating Expence Quarterly Time Qtr3 Qtr4 312 532 566
Measures
388 567 864
Ancient Composer
Qtr2
Jun
Jul
Sales Operating Cost
Aug
Sep
Oct
Nov
Dec
Quarterly Analysis
Jan Feb Mar
2006_Q1 2007_Q1 2008_Q1 New York Florida Carlifornia New York Florida Carlifornia New York Florida 230 304 234 354 347 459 340 434 240 230 239 356 280 469 346 300 256 360 343 388 390 444 455 454
Anslysis For Florida
800
Quarterly Analysis
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2006 2007 2008 Florida Florida Florida 304 347 434
230
280
300
360 345 236 453 454 545 345 345 654 345
390 354 454 345 345 564 567 456 466 467
454 464 565 456 375 545 754 478 457 456
700 600 500 400 300 200 100 0 Jan
Contact Point : [email protected]
Feb
Mar
Apr
May
Jun
Jul
Aug
2008_Q1
May
Carlifornia 565 655 456
Jun
Jul
Aug
Sep
Oct
2006 Florida 2007 Florida 2008 Florida
Nov
Dec
Sales/Operating Cost Analysis
Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Cost $330 $345 $340 $360 $377 $378 $399 $381 $387 $393 $399 $406
Margin
$120 $157 $189 $212 $245 $276 $307 $337 $368 $398 $429 $459
$210 $188 $151 $148 $132 $102 $92 $43 $19 -$5 -$29 -$53
Margin % $63.64 $54.49 $44.41 $41.11 $35.01 $26.96 $23.16 $11.42 $4.98 -$1.26 -$7.30 -$13.16
450 400 350 300 250 200 150 100 50 0 Month
Note ** Report as of 10th Aug 2008
Jan
Feb
Sales/Operating Cost Analysis
Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Cost $330 $345 $340 $360 $377 $389 $347 $381 $387 $393 $399 $406
$120 $157 $189 $212 $245 $276 $307 $337 $368 $398 $429 $459
Margin $210 $188 $151 $148 $132 $113 $40 $43 $19 -$5 -$29 -$53
Margin % $63.64 $54.49 $44.41 $41.11 $35.01 $29.02 $11.64 $11.42 $4.98 -$1.26 -$7.30 -$13.16
500 450 400 350 300 250 200 150 100 50 0 Month
Jan
Feb
Mar
Apr
May
500 400 300 200 100 0 -100 1
2
3
4
5
6
200 100 0 -100 1
2
Sales/Operating Cost Analysis
Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Cost $330 $345 $340 $360 $377 $378 $399 $381 $387 $393 $399 $406
$120 $157 $189 $212 $245 $276 $307 $337 $368 $398 $429 $459
Margin $210 $188 $151 $148 $132 $102 $92 $43 $19 -$5 -$29 -$53
Margin % Operting Cost Planned $63.64 $54.49 $44.41 $41.11 $35.01 $26.96 $23.16 $11.42 $4.98 -$1.26 -$7.30 -$13.16
$100 $110 $120 $130 $140 $150 $160 $300 $180 $190 $200 $210
3
4
5
6
1
Current Statistics (Sales/Operating Cost
Jan
Feb
Mar
Apr
Sales Operating Cost Jul Jun
May
Future Statistics (Sales/Operating Cost)
Sales Operating Cost
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Margin is Getting shink
Operating Cost Margin Month
2
3
4
5
6
7
8
9
10
11
12
13
1
Operating Cost Margin Month
2
3
4
5
6
7
Operating Cost Actual $120 $157 $189
$337
20
8
9
10
11
12
13
Sales Operating Cost Jul un
Sales Operating Cost
Operating Cost Margin Month
Operating Cost Margin Month
Product Category Biographies Composers New Wave Philosophers Certification Family Adventures Games Family Adventures Tejano Writers International Childrens Westerns How To Asian Contemporary Tejano Management Classics Techno-House Humor Ancient Modern Electric Indie Traditional Performers Contemporary How It Works Alternative Avant-Garde Cajun and Zydeco Swing Fiction Animation United States Crafts Series New Wave Biographies Performers Contemporary Ambient Composers Crime James Bond Forms Reggae Reggae Programming Reggae
Store Name BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Vancouver
State Province New York New York New York New York New York New York New York New York New York New York New York Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Stockholm Stockholm Stockholm Stockholm Stockholm Stockholm Stockholm Stockholm New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales Tokyo Tokyo Tokyo Tokyo Tokyo Tokyo British Columbia
City Unit Sales Brooklyn 770 Brooklyn 619 Brooklyn 770 Brooklyn 619 Brooklyn 770 Brooklyn 619 Brooklyn 770 Brooklyn 619 Brooklyn 619 Brooklyn 461 Brooklyn 770 Lyon 462 Lyon 370 Lyon 277 Lyon 370 Lyon 554 Lyon 370 Lyon 370 Lyon 370 Lyon 370 Lyon 462 Lyon 370 Lyon 462 Lyon 370 Lyon 462 Lyon 554 Stockholm 370 Stockholm 277 Stockholm 370 Stockholm 554 Stockholm 370 Stockholm 370 Stockholm 370 Stockholm 277 Sydney 185 Sydney 185 Sydney 185 Sydney 246 Sydney 246 Sydney 308 Sydney 308 Sydney 308 Sydney 246 Tokyo 246 Tokyo 246 Tokyo 246 Tokyo 185 Tokyo 246 Tokyo 185 Vancouver 770
Espionage Photography Hong Kong Pets Salsa Philosophers Architecture Bluegrass James Bond Historical Periods Photography Bebop Modern Electric Architecture How It Works Electronic Traditional Programming Pets Entertaining Westerns Educators Management New Wave Classics Salsa Data Warehousing Ancient Weddings
Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood www.downtownbmv.com www.downtownbmv.com www.downtownbmv.com
British Columbia British Columbia British Columbia British Columbia British Columbia British Columbia British Columbia British Columbia California California California California California California California California California California California California California California California California California California Texas Texas Texas
Vancouver Vancouver Vancouver Vancouver Vancouver Vancouver Vancouver Vancouver Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Dallas Dallas Dallas
921 619 619 619 619 619 770 619 461 770 461 619 619 619 770 770 461 461 770 619 619 619 619 619 619 770 1239 1540 1239
Full Date Time 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001
8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38
10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001
8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35
Store Name State Province Super BMV Stockholm Stockholm Super BMV Sydney New South Wales BMV Lyon Rhône-Alpes www.downtownbmv.comTexas Super BMV Stockholm Stockholm Super BMV Vancouver British Columbia Super BMV Westwood California BMV Lyon Rhône-Alpes Super BMV Stockholm Stockholm Super BMV Westwood California BMV Brooklyn New York Super BMV Sydney New South Wales Super BMV Vancouver British Columbia Super BMV Stockholm Stockholm BMV Brooklyn New York BMV Lyon Rhône-Alpes BMV Lyon Rhône-Alpes Super BMV Westwood California BMV Brooklyn New York Super BMV Sydney New South Wales BMV Lyon Rhône-Alpes Super BMV Stockholm Stockholm Super BMV Sydney New South Wales Super BMV Sydney New South Wales Super BMV Tokyo Tokyo www.downtownbmv.com Texas Super BMV Westwood California Super BMV Westwood California Super BMV Westwood California Super BMV Vancouver British Columbia BMV Brooklyn New York BMV Brooklyn New York Super BMV Stockholm Stockholm Super BMV Tokyo Tokyo BMV Brooklyn New York Super BMV Westwood California Super BMV Vancouver British Columbia Super BMV Stockholm Stockholm Super BMV Westwood California BMV Lyon Rhône-Alpes BMV Lyon Rhône-Alpes BMV Lyon Rhône-Alpes BMV Brooklyn New York Super BMV Tokyo Tokyo Super BMV Westwood California BMV Lyon Rhône-Alpes Super BMV Westwood California BMV Lyon Rhône-Alpes Super BMV Westwood California BMV Brooklyn New York
City Stockholm Sydney Lyon Dallas Stockholm Vancouver Los Angeles Lyon Stockholm Los Angeles Brooklyn Sydney Vancouver Stockholm Brooklyn Lyon Lyon Los Angeles Brooklyn Sydney Lyon Stockholm Sydney Sydney Tokyo Dallas Los Angeles Los Angeles Los Angeles Vancouver Brooklyn Brooklyn Stockholm Tokyo Brooklyn Los Angeles Vancouver Stockholm Los Angeles Lyon Lyon Lyon Brooklyn Tokyo Los Angeles Lyon Los Angeles Lyon Los Angeles Brooklyn
New Wave New Wave Performers Performers Pets Pets Philosophers Philosophers Photography Photography Programming Programming Reggae Reggae Reggae Salsa Salsa Series Swing Techno-House Tejano Tejano Traditional Traditional United States Weddings Westerns Westerns Writers
Super BMV Sydney Super BMV Westwood BMV Lyon Super BMV Sydney Super BMV Vancouver Super BMV Westwood BMV Brooklyn Super BMV Vancouver Super BMV Vancouver Super BMV Westwood Super BMV Tokyo Super BMV Westwood Super BMV Tokyo Super BMV Tokyo Super BMV Vancouver Super BMV Vancouver Super BMV Westwood Super BMV Sydney Super BMV Stockholm BMV Lyon BMV Brooklyn BMV Lyon BMV Lyon Super BMV Westwood Super BMV Sydney www.downtownbmv.com BMV Lyon Super BMV Westwood BMV Brooklyn
New South Wales California Rhône-Alpes New South Wales British Columbia California New York British Columbia British Columbia California Tokyo California Tokyo Tokyo British Columbia British Columbia California New South Wales Stockholm Rhône-Alpes New York Rhône-Alpes Rhône-Alpes California New South Wales Texas Rhône-Alpes California New York
Sydney Los Angeles Lyon Sydney Vancouver Los Angeles Brooklyn Vancouver Vancouver Los Angeles Tokyo Los Angeles Tokyo Tokyo Vancouver Vancouver Los Angeles Sydney Stockholm Lyon Brooklyn Lyon Lyon Los Angeles Sydney Dallas Lyon Los Angeles Brooklyn
New York Brooklyn Store Name Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon
Store Name Acient Acient Acient BMV Brooklyn BMV Brooklyn Acient Acient Acient BMV Brooklyn BMV Brooklyn BMV Brooklyn
Product Name Ancient Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct
230 244 254 267 278 298 307 320 333 346
Nov Dec
359 372 350GB*24
Year->Qtr->Month Day->Hour->Min
Jan->2nd->22,24 Sales Sales Sales Sales
Unit Sales Full Date Time 370 10/01/2001 308 10/01/2001 370 10/01/2001 1540 10/01/2001 277 10/01/2001 770 10/01/2001 619 10/01/2001 370 10/01/2001 554 10/01/2001 619 10/01/2001 770 10/01/2001 246 10/01/2001 619 10/01/2001 370 10/01/2001 770 10/01/2001 462 10/01/2001 370 10/01/2001 619 10/01/2001 619 10/01/2001 246 10/01/2001 554 10/01/2001 370 10/01/2001 308 10/01/2001 185 10/01/2001 246 10/01/2001 1239 10/01/2001 619 10/01/2001 770 10/01/2001 619 10/01/2001 921 10/01/2001 619 10/01/2001 619 10/01/2001 370 10/01/2001 246 10/01/2001 770 10/01/2001 770 10/01/2001 619 10/01/2001 277 10/01/2001 770 10/01/2001 277 10/01/2001 462 10/01/2001 370 10/01/2001 770 10/01/2001 246 10/01/2001 461 10/01/2001 370 10/01/2001 619 10/01/2001 462 10/01/2001 619 10/01/2001 770 10/01/2001
8:35 8:38 8:42 8:46 8:55 9:00 9:01 9:06 9:07 9:07 9:10 9:12 9:12 9:13
Business Analysis Questions Q1 Q2 Q3 Q4 Q5
Total sales for Product Category "Ancient" vs " Sales growth vs Operating expences for Produ Sales/Expenses for Store Name "Super BMV W Sales of "Contemporary" Product Category for Total sales in last 3 months for Product Catego
Sales/Operating Expence Qua Time Qtr2 230 340 543 444 756 456
Qtr1 Ancient Composer Classis
600 500 400 300 200 100 0 Qtr1
Qtr1
Classis Qtr2
246 619 554 308 619 770 619 619 619 461 185 461 246 185 770 619 770 185 370 370 619 370 462 461 185 1239 370 619 461
10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001
450 400 350 300 250 200 150 100 50 0 Month
Product Name Operating Cost Sales 120 122 145 178 234 254 279 309 339 368
Composer Operating Cost 345 356 378 398 344 367 374 377 379 382
Feb
Mar
Apr
May
Jun
Jul
Sales Operating Cost
California Los Angeles
Ancient
Jan
102 132 143 144 158 159 176 186 197 207
Aug
398 428
385 387
Analysis 98% Analysis 2%
Relational DB
Drill Down/Drill Up Dimension Hierarchy Yearly Qtr Month Weekly
218 228
s
ory "Ancient" vs "Composer" for last two Quarters ? pences for Product category "Ancient" last 6 months? me "Super BMV Westwood" in City "Lyon" and Sydney? duct Category for all stores in 12 Months Rolling? or Product Category "Contemporary in Lyon City in BMV Store"?
perating Expence Quarterly Time Qtr3 Qtr4 312 532 566
Measures
388 567 864
Ancient Composer
Qtr2
Jun
Jul
Sales Operating Cost
Aug
Sep
Oct
Nov
Dec
Quarterly Analysis
Jan Feb Mar
2006_Q1 2007_Q1 2008_Q1 New York Florida Carlifornia New York Florida Carlifornia New York Florida 230 304 234 354 347 459 340 434 240 230 239 356 280 469 346 300 256 360 343 388 390 444 455 454
Anslysis For Florida
800
Quarterly Analysis
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2006 2007 2008 Florida Florida Florida 304 347 434
230
280
300
360 345 236 453 454 545 345 345 654 345
390 354 454 345 345 564 567 456 466 467
454 464 565 456 375 545 754 478 457 456
700 600 500 400 300 200 100 0 Jan
Contact Point : [email protected]
Feb
Mar
Apr
May
Jun
Jul
Aug
2008_Q1
May
Carlifornia 565 655 456
Jun
Jul
Aug
Sep
Oct
2006 Florida 2007 Florida 2008 Florida
Nov
Dec
Sales/Operating Cost Analysis
Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Cost $330 $345 $340 $360 $377 $378 $399 $381 $387 $393 $399 $406
Margin
$120 $157 $189 $212 $245 $276 $307 $337 $368 $398 $429 $459
$210 $188 $151 $148 $132 $102 $92 $43 $19 -$5 -$29 -$53
Margin % $63.64 $54.49 $44.41 $41.11 $35.01 $26.96 $23.16 $11.42 $4.98 -$1.26 -$7.30 -$13.16
450 400 350 300 250 200 150 100 50 0 Month
Note ** Report as of 10th Aug 2008
Jan
Feb
Sales/Operating Cost Analysis
Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Cost $330 $345 $340 $360 $377 $389 $347 $381 $387 $393 $399 $406
$120 $157 $189 $212 $245 $276 $307 $337 $368 $398 $429 $459
Margin $210 $188 $151 $148 $132 $113 $40 $43 $19 -$5 -$29 -$53
Margin % $63.64 $54.49 $44.41 $41.11 $35.01 $29.02 $11.64 $11.42 $4.98 -$1.26 -$7.30 -$13.16
500 450 400 350 300 250 200 150 100 50 0 Month
Jan
Feb
Mar
Apr
May
500 400 300 200 100 0 -100 1
2
3
4
5
6
200 100 0 -100 1
2
Sales/Operating Cost Analysis
Sales Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Operating Cost $330 $345 $340 $360 $377 $378 $399 $381 $387 $393 $399 $406
$120 $157 $189 $212 $245 $276 $307 $337 $368 $398 $429 $459
Margin $210 $188 $151 $148 $132 $102 $92 $43 $19 -$5 -$29 -$53
Margin % Operting Cost Planned $63.64 $54.49 $44.41 $41.11 $35.01 $26.96 $23.16 $11.42 $4.98 -$1.26 -$7.30 -$13.16
$100 $110 $120 $130 $140 $150 $160 $300 $180 $190 $200 $210
3
4
5
6
1
Current Statistics (Sales/Operating Cost
Jan
Feb
Mar
Apr
Sales Operating Cost Jul Jun
May
Future Statistics (Sales/Operating Cost)
Sales Operating Cost
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Margin is Getting shink
Operating Cost Margin Month
2
3
4
5
6
7
8
9
10
11
12
13
1
Operating Cost Margin Month
2
3
4
5
6
7
Operating Cost Actual $120 $157 $189
$337
20
8
9
10
11
12
13
Sales Operating Cost Jul un
Sales Operating Cost
Operating Cost Margin Month
Operating Cost Margin Month
Product Category Biographies Composers New Wave Philosophers Certification Family Adventures Games Family Adventures Tejano Writers International Childrens Westerns How To Asian Contemporary Tejano Management Classics Techno-House Humor Ancient Modern Electric Indie Traditional Performers Contemporary How It Works Alternative Avant-Garde Cajun and Zydeco Swing Fiction Animation United States Crafts Series New Wave Biographies Performers Contemporary Ambient Composers Crime James Bond Forms Reggae Reggae Programming Reggae
Store Name BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Brooklyn BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon BMV Lyon Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Stockholm Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Sydney Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Tokyo Super BMV Vancouver
State Province New York New York New York New York New York New York New York New York New York New York New York Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Rhône-Alpes Stockholm Stockholm Stockholm Stockholm Stockholm Stockholm Stockholm Stockholm New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales New South Wales Tokyo Tokyo Tokyo Tokyo Tokyo Tokyo British Columbia
City Unit Sales Brooklyn 770 Brooklyn 619 Brooklyn 770 Brooklyn 619 Brooklyn 770 Brooklyn 619 Brooklyn 770 Brooklyn 619 Brooklyn 619 Brooklyn 461 Brooklyn 770 Lyon 462 Lyon 370 Lyon 277 Lyon 370 Lyon 554 Lyon 370 Lyon 370 Lyon 370 Lyon 370 Lyon 462 Lyon 370 Lyon 462 Lyon 370 Lyon 462 Lyon 554 Stockholm 370 Stockholm 277 Stockholm 370 Stockholm 554 Stockholm 370 Stockholm 370 Stockholm 370 Stockholm 277 Sydney 185 Sydney 185 Sydney 185 Sydney 246 Sydney 246 Sydney 308 Sydney 308 Sydney 308 Sydney 246 Tokyo 246 Tokyo 246 Tokyo 246 Tokyo 185 Tokyo 246 Tokyo 185 Vancouver 770
Espionage Photography Hong Kong Pets Salsa Philosophers Architecture Bluegrass James Bond Historical Periods Photography Bebop Modern Electric Architecture How It Works Electronic Traditional Programming Pets Entertaining Westerns Educators Management New Wave Classics Salsa Data Warehousing Ancient Weddings
Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Vancouver Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood Super BMV Westwood www.downtownbmv.com www.downtownbmv.com www.downtownbmv.com
British Columbia British Columbia British Columbia British Columbia British Columbia British Columbia British Columbia British Columbia California California California California California California California California California California California California California California California California California California Texas Texas Texas
Vancouver Vancouver Vancouver Vancouver Vancouver Vancouver Vancouver Vancouver Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Dallas Dallas Dallas
921 619 619 619 619 619 770 619 461 770 461 619 619 619 770 770 461 461 770 619 619 619 619 619 619 770 1239 1540 1239
Full Date Time 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001
8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38
10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001 10/01/2001
8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35 8:38 8:42 8:35
Related Documents
Analysis1
July 2020 7
Water Analysis1
April 2020 16
Job Analysis1
June 2020 7
Poisonwood Bible Quote Analysis1
July 2020 1
Break-even Analysis1.xls
May 2020 6