Six Sigma Sales Report

Description

Six Sigma spreadsheets for your quality toolbox!

Reviews
Shared by: Jason Cardinal
Categories
Tags
Stats
views:
74
rating:
not rated
reviews:
0
posted:
8/15/2009
language:
English
pages:
0
http://templatestaff.com PRODUCT SALES REPORT Fiscal Year 2005 New Software $$ Software B $$ Upgrade A $$ Widgets A $$ Widgets B Upgrades $$ Conversion A 452 541 155 465 784 541 154 326 452 458 457 985 5770 $61,310 $57,585 $64,546 $68,956 $76,895 $46,587 $56,234 $16,294 $86,597 $46,194 $35,626 $46,164 $662,988 986464 662988 (323476) -33% $$ Upgrade C $$ Upgrade D $$ Upgrade B Conversion A 50607 15968 5770 (10198) -64% Software A Software B Upgrade C October November December January February March April May June July August September Total Units Sold 43 84 22 85 97 56 324 234 543 549 655 126 2818 371 285 28 85 219 35 145 75 16 85 113 162 1619 $148,882 $47,273 $15,632 $15,946 $85,264 $45,825 $54,613 $56,943 $97,643 $56,834 $53,461 $65,983 $744,299 234 452 253 584 658 265 365 526 398 457 152 358 4702 $87,546 $61,356 $43,567 $89,564 $73,564 $73,859 $64,913 $83,567 $46,591 $65,973 $16,495 $64,994 $771,989 152 584 653 578 654 258 154 789 652 356 452 148 5430 $87,546 $65,316 $56,435 $26,531 $43,562 $49,768 $56,498 $56,494 $87,546 $51,356 $12,435 $76,546 $670,033 157 455 658 587 45 154 153 856 574 157 45 415 4256 692 1371 4256 2885 210% $ Increase 5% 10% 0% 0% 0% $2,451 $5,643 $7,658 $5,346 $6,235 $8,659 $4,659 $5,427 $2,465 $5,427 $5,649 $3,562 $63,181 41 45 47 18 62 73 70 48 48 37 44 37 570 286 376 570 194 52% $213 $213 $56 $346 $867 $84 $685 $754 $685 $346 $591 $465 $5,305 3 9 4 3 4 21 9 5 10 9 5 8 90 44 44 90 $4,542 $5,427 $3,562 $8,653 $1,674 $$$$5,689 $4,659 $5,764 $5,543 $45,513 Upgrade D 12 54 58 57 44 59 56 63 25 14 74 15 531 Upgrade A Upgrade B Widgets A Widgets B $5,451 $5,465 $2,356 $8,659 $4,659 $7,685 $5,457 $3,465 $1,645 $4,652 $1,113 $50,607 Same period FY04 FY05 Diff FY05/FY04 % Growth 990 2818 1828 185% 1589 1619 30 2% $ 156676 744299 587623 375% 2,186,321 2437 4702 2265 93% 992343 771989 (220354) -22% 4843 5430 587 12% 1367835 670033 (697802) -51% 176308 63181 (113127) -64% 164,606 111362 5305 40055 NA NA 45513 531 5458 #VALUE! NA 14% #VALUE! NA (106057) 46 -95% 105% New Software Upgrades Conversions Accessories Clothing 27% 2% 37% 34% 0% $ $ $ $ $ $ 2,186,321 164,606 3,009,317 2,812,789 39,231 8,212,264 - $ $ $ $ $ 109,316 16,461 - Total FY05 $ 2% $ $ 125,777 $ (125,777) SALESREP-EN-XLS Page 1 of 4 Conversions $$ Conversion B Conversion B Accessories Clothing Total revenue FY05 $ $ $ 8,212,264 (8,212,264) Sales key product Com Cables USB Cables ABC Total Retrofit C Speakers Retrofit A Retrofit B Pullovers 125 452 255 745 465 865 465 100 100 200 232 588 4592 $451,246 $542,568 $567,689 $99,867 $89,567 $89,564 $89,567 $99,768 $96,856 $97,585 $46,598 $75,454 $2,346,329 426 426 112 692 1734 168 1370 1508 1370 692 1182 930 10610 6 18 8 6 8 42 18 10 20 18 10 16 180 9084 10854 7124 17306 3348 0 0 0 11378 9318 11528 11086 91026 24 108 116 114 88 118 112 126 50 28 148 30 1062 0 10902 10930 4712 17318 9318 15370 10914 6930 3290 9304 2226 101214 904 1082 310 930 1568 1082 308 652 904 916 914 1970 122620 115170 129092 137912 153790 93174 112468 32588 173194 92388 71252 92328 250 904 510 1490 930 1730 930 200 200 400 464 1176 9184 Total REX 17301 9184 (8117) -47% $22,164 $67,986 $87,586 $54,986 $79,865 $79,865 $79,865 $48,568 $78,498 $568,953 $768,985 $875,468 $2,812,789 1448976 1776797 2812789 1035992 58% 136 134 85 38 115 118 130 309 215 236 118 165 1799 $586 $854 $596 $548 $648 $871 $7,456 $563 $456 $5,468 $5,496 $4,566 $28,108 5 7 2 5 6 0 0 0 7 8 5 6 51 $259 $486 $1,000 $1,000 $1,000 $$$$896 $498 $486 $5,498 $11,123 293 725 740 621 775 376 284 1098 874 600 575 319 7280 $ $ $ $ $ $ $ $ $ $ $ $ $ 866,745 860,158 853,792 374,099 467,800 399,741 422,175 373,835 507,387 904,938 956,238 1,225,356 8,212,264 $ $ $ $ $ $ $ $ $ $ $ $ $ 681,254 501,052 535,181 345,529 645,657 829,283 596,518 704,646 739,381 496,870 686,684 584,724 7,346,779 11540 1325976 500963 4592 (496371) -99% 860979 2346329 1485350 173% 3360 10610 7250 216% 2478 180 (2298) -93% 931 91026 90095 9677% 18275 1062 (17213) -94% 2415 101214 98799 4091% 10203 1256 11540 1325976 1337 1324720 13% 105471% 897 1799 902 101% $ 6715 402620 28108 (374512) -93% 39,231 1347 51 (1296) -96% 475340 11123 (464217) -98% SALESREP-EN-XLS Page 2 of 4 Last year sales Glasses Printers Blanks $$ All Caps Tees PRODUCT SALES REPORT Fiscal Year 2004 New Software $$ Software B $$ Upgrade A $$ Widgets A $$ Widgets B Software A Software B Upgrade A Upgrade B Widgets A Widgets B Upgrades $$ Conversion A Conversions $$ Conversion B $$ Upgrade C $$ Upgrade B Conversion A October November December January February March April May June July August September Total Units Sold 10 20 145 3 84 296 193 8 100 24 22 85 990 27 249 61 41 128 120 123 94 190 85 373 98 1589 $4,247 $24,127 $5,619 $5,230 $16,120 $15,554 $18,374 $10,795 $15,834 $9,601 $21,455 $9,720 $156,676 324 204 265 109 219 227 205 174 304 129 132 145 2437 $165,682 $75,886 $100,384 $50,243 $86,586 $94,009 $78,546 $66,905 $114,806 $54,307 $62,204 $42,785 $992,343 366 352 286 290 472 493 363 468 470 338 410 535 4843 $104,956 $84,597 $88,973 $62,070 $147,109 $134,009 $105,956 $158,193 $122,737 $107,984 $120,633 $130,618 $1,367,835 74 80 71 51 181 172 151 167 90 83 108 143 1371 $10,823 $10,695 $791 $7,140 $26,597 $24,130 $20,114 $24,156 $11,612 $11,159 $11,958 $17,133 $176,308 13 23 19 18 23 35 56 33 52 35 31 38 376 $7,077 $7,264 $6,983 $5,151 $7,327 $10,180 $12,390 $10,473 $15,654 $10,363 $8,206 $10,294 $111,362 0 9 2 2 2 4 5 3 2 1 5 9 44 $$6,155 $602 $2,600 $2,600 $5,010 $6,500 $3,900 $1,708 $28 $3,343 $7,609 $40,055 955 1375 1303 723 1000 2532 1401 1214 1796 928 1202 1539 15968 $61,410 $89,368 $87,534 $44,206 $63,669 $152,003 $75,566 $81,907 $102,667 $53,348 $82,885 $91,901 $986,464 Conversion B 31823 32549 34005 22925 48742 44416 51323 54432 66381 30572 49607 34188 500963 Upgrade C $54,988 $57,546 $58,014 $36,418 $84,557 $90,418 $79,093 $91,487 $101,304 $55,750 $96,404 $55,000 $860,979 first 10M FY02 first 10M FY04 Diff FY04/FY02 % Growth NA 883 NA NA 0 1118 1118 NA 3116 2160 (956) -31% 2668 3898 1230 46% 544 1120 576 106% 135 307 172 127% 74 22 (52) -70% 6580 13227 6647 101% SALESREP-EN-XLS Page 3 of 4 EPORT 4 Conversions Com Cables Retrofit C Retrofit A Retrofit B Printers Blanks Accessories USB Cables Speakers $$ All Clothing Sales key product 185 193 359 291 333 335 350 322 219 185 351 237 3360 185 229 192 187 291 0 165 225 249 92 360 303 2478 (118) 77 55 14 183 162 31 137 139 97 65 89 931 1629 879 1750 756 1739 2518 1451 1348 1160 1385 2445 1215 18275 120 153 290 124 230 301 226 158 95 275 252 191 2415 1534 648 967 200 861 1260 458 1191 880 607 800 797 10203 227 11 52 102 54 112 77 98 125 99 156 143 1256 2125 1207 1387 734 1281 2441 939 1924 1400 1009 1313 1541 17301 Total REX 3615 14447 10832 300% $224,228 $115,347 $168,815 $74,752 $149,972 $220,004 $109,266 $165,045 $133,366 $111,844 $171,985 $132,173 $1,776,797 49450 5 27 31 54 63 77 137 100 159 54 135 55 897 $8,643 $16,552 $17,022 $26,606 $31,615 $35,814 $48,585 $47,047 $61,284 $25,219 $57,529 $26,704 $402,620 96 31 23 83 78 132 120 130 166 172 140 176 1347 $39,200 $13,515 $444 $31,113 $29,505 $48,152 $42,128 $44,738 $58,409 $57,267 $50,082 $60,787 $475,340 ABC Total 467 410 340 427 613 702 620 698 795 564 685 766 $ $ $ $ $ $ $ $ $ $ $ $ Pullovers Glasses Caps Tees 681,254 501,052 535,181 345,529 645,657 829,283 596,518 704,646 739,381 496,870 686,684 584,724 3749 2772 (977) -26% 3524 1815 (1709) -48% 1615 777 (838) -52% 9523 14615 5092 53% 2409 1972 (437) -18% 8354 8606 252 3% 1293 957 (336) -26% 289 707 418 145% NA 1031 NA NA All kits 2244 $ 877,960 SALESREP-EN-XLS Page 4 of 4

Related docs
Six Sigma
Views: 783  |  Downloads: 101
Six Sigma Product Change Notification
Views: 25  |  Downloads: 9
Six Sigma Software Quality Matrix
Views: 130  |  Downloads: 29
Six Sigma Management
Views: 254  |  Downloads: 0
Six Sigma Concepts
Views: 19  |  Downloads: 8
Buku Six Sigma
Views: 43  |  Downloads: 4
Six Sigma Test Report
Views: 58  |  Downloads: 14
Lean Six Sigma Roadmap
Views: 575  |  Downloads: 238
Six sigma
Views: 430  |  Downloads: 132
What is Six Sigma?
Views: 110  |  Downloads: 15
Lean Six Sigma, the union of
Views: 0  |  Downloads: 0
Six Sigma Toll Gate Road Map
Views: 132  |  Downloads: 9
Other docs by Jason Cardinal
Six Sigma Z Table
Views: 100  |  Downloads: 11
Six Sigma Vendor Evaluation
Views: 149  |  Downloads: 22
Six Sigma Toll Gate Road Map
Views: 132  |  Downloads: 9
Six Sigma Toll Gate Checklist
Views: 285  |  Downloads: 29
Six Sigma Test Report
Views: 58  |  Downloads: 14
Six Sigma Test Case Checklist
Views: 179  |  Downloads: 10
Six Sigma Technical Training Plan
Views: 48  |  Downloads: 10
Six Sigma Supplier Evaluation Form
Views: 672  |  Downloads: 72
Six Sigma Sum Squares
Views: 90  |  Downloads: 19
Six Sigma Solution Tree
Views: 85  |  Downloads: 16
Six Sigma Software Quality Matrix Deluxe
Views: 73  |  Downloads: 25
Six Sigma Software Quality Matrix
Views: 130  |  Downloads: 29
Six Sigma Shift & Drift Table
Views: 64  |  Downloads: 15
Six Sigma Regression Sum
Views: 51  |  Downloads: 11
Six Sigma Quality Control Form
Views: 87  |  Downloads: 22