Please help with this finance questions and see below necessary attached documents.

Dashboards You are presented with a data file that includes sales to date by product, customer type etc. You have the yearly forecast. You have to develop a dashboard that indicates whether they will hit their year en sufficient analysis and visual presentation for the sales executives to be able to understand why, or wh You must use at least 3 of the functions we have used this semester. Present results by quarter. t, customer type etc. You have actuals to date as well as ether they will hit their year end target, and provide able to understand why, or why not. Forecast detail RegionCustomer Type Americas Corporate $ Educationa $ Governmen$ Europe Corporate $ Educationa $ Governmen$ Asia Corporate $ Educationa $ Governmen$ Total Sales $ Jan 8,242 8,472 6,494 8,352 7,108 5,540 9,350 7,977 8,591 70,126 $ $ $ $ $ $ $ $ $ $ Feb 9,497 9,750 7,481 9,594 8,182 6,380 10,763 9,185 9,896 80,728 $ $ $ $ $ $ $ $ $ $ Mar 13,312 13,664 10,484 13,434 11,472 8,942 15,084 12,879 13,866 113,137 $ $ $ $ $ $ $ $ $ $ Apr 13,366 13,704 10,552 13,447 11,513 8,969 15,125 12,920 13,907 113,502 $ $ $ $ $ $ $ $ $ $ May 13,325 13,677 10,484 13,447 11,486 8,942 15,098 12,892 13,880 113,232 $ $ $ $ $ $ $ $ $ $ Jun 13,352 13,691 10,498 13,461 11,499 8,956 15,111 12,906 13,894 113,367 $ $ $ $ $ $ $ $ $ $ Jul 13,312 13,650 10,471 13,461 11,458 8,929 15,071 12,865 13,853 113,069 $ $ $ $ $ $ $ $ $ $ Aug 13,325 13,677 10,484 13,447 11,472 8,956 15,084 12,879 13,880 113,205 $ $ $ $ $ $ $ $ $ $ Sep 13,352 13,691 10,498 13,461 11,499 8,956 15,111 12,906 13,894 113,367 $ $ $ $ $ $ $ $ $ $ Oct 13,379 13,731 10,525 13,474 11,526 8,983 15,152 12,933 13,934 113,638 $ $ $ $ $ $ $ $ $ $ Nov 13,569 13,907 10,660 13,650 11,675 9,105 15,341 13,109 14,110 115,126 $ $ $ $ $ $ $ $ $ $ Dec 13,664 13,988 10,728 13,745 11,743 9,159 15,449 13,190 14,205 115,870 $ $ $ $ $ $ $ $ $ $ FY 2016 151,695 155,602 119,360 152,972 130,632 101,815 171,738 146,642 157,910 1,288,366 Region Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Americas Asia Asia Asia Asia Asia Asia Asia Asia Asia ProductCustomer Type GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedGovernmen$ GalvanizedGovernmen$ GalvanizedGovernmen$ GalvanizedGovernmen$ PVCs Corporate $ PVCs Corporate $ PVCs Corporate $ PVCs Corporate $ PVCs Educationa $ PVCs Educationa $ PVCs Educationa $ PVCs Educationa $ PVCs Governmen$ PVCs Governmen$ PVCs Governmen$ PVCs Governmen$ Conduit Corporate $ Conduit Corporate $ Conduit Corporate $ Conduit Corporate $ Conduit Educationa $ Conduit Educationa $ Conduit Educationa $ Conduit Educationa $ Conduit Governmen$ Conduit Governmen$ Conduit Governmen$ Conduit Governmen$ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedGovernmen$ Jan 992 555 223 223 404 376 899 588 239 1,014 974 856 886 272 1,033 379 1,055 675 186 627 194 1,044 1,214 1,086 773 1,168 1,117 158 1,194 776 209 983 929 1,258 1,326 668 700 214 1,137 837 359 200 722 468 1,074 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Feb 1,072 607 240 243 434 407 987 644 261 1,099 1,063 926 951 295 1,120 412 1,142 732 200 683 211 1,152 1,313 1,200 853 1,270 1,234 172 1,292 834 223 1,053 1,009 1,364 1,435 724 769 235 1,225 900 389 221 785 519 1,197 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Mar 1,156 650 260 260 463 441 1,075 692 286 1,173 1,138 1,011 1,024 322 1,195 456 1,221 783 214 737 226 1,238 1,407 1,298 913 1,401 1,316 190 1,432 915 242 1,134 1,081 1,498 1,547 773 825 251 1,314 970 420 238 871 559 1,308 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Apr 1,240 704 277 277 506 470 1,166 737 308 1,248 1,217 1,077 1,099 355 1,278 495 1,319 839 230 783 240 1,331 1,502 1,389 983 1,497 1,404 203 1,521 973 267 1,219 1,152 1,629 1,689 827 877 269 1,432 1,046 462 261 936 597 1,404 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ May 1,327 746 297 295 546 498 1,251 792 325 1,342 1,309 1,166 1,172 385 1,361 529 1,416 898 243 832 260 1,421 1,609 1,492 1,046 1,610 1,499 216 1,624 1,032 283 1,302 1,229 1,758 1,806 877 940 287 1,521 1,134 509 280 1,005 630 1,501 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Jun 1,410 795 319 312 578 539 1,360 842 345 1,413 1,409 1,268 1,244 407 1,444 572 1,523 949 259 882 276 1,539 1,695 1,599 1,124 1,727 1,607 228 1,751 1,100 302 1,387 1,301 1,860 1,960 944 994 307 1,611 1,203 537 304 1,059 666 1,605 Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Asia Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe GalvanizedGovernmen$ GalvanizedGovernmen$ GalvanizedGovernmen$ PVCs Corporate $ PVCs Corporate $ PVCs Corporate $ PVCs Corporate $ PVCs Educationa $ PVCs Educationa $ PVCs Educationa $ PVCs Educationa $ PVCs Governmen$ PVCs Governmen$ PVCs Governmen$ PVCs Governmen$ Conduit Corporate $ Conduit Corporate $ Conduit Corporate $ Conduit Corporate $ Conduit Educationa $ Conduit Educationa $ Conduit Educationa $ Conduit Educationa $ Conduit Governmen$ Conduit Governmen$ Conduit Governmen$ Conduit Governmen$ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedCorporate $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedEducationa $ GalvanizedGovernmen$ GalvanizedGovernmen$ GalvanizedGovernmen$ GalvanizedGovernmen$ PVCs Corporate $ PVCs Corporate $ PVCs Corporate $ PVCs Corporate $ PVCs Educationa $ PVCs Educationa $ PVCs Educationa $ PVCs Educationa $ PVCs Governmen$ 990 664 270 793 457 522 424 433 527 784 233 1,018 370 188 986 862 283 230 1,338 239 84 888 765 508 967 913 918 818 1,187 682 884 1,135 103 556 494 862 1,205 866 721 466 1,046 465 1,184 873 415 997 1,158 651 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,087 719 290 852 499 561 462 467 572 848 258 1,117 402 206 1,079 939 307 255 1,466 268 95 975 837 555 1,045 996 1,004 890 1,302 735 972 1,226 111 605 549 937 1,294 956 785 510 1,163 500 1,292 937 446 1,097 1,248 714 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,194 769 321 919 554 600 498 500 629 905 279 1,213 439 220 1,155 1,033 329 274 1,595 292 102 1,059 904 601 1,127 1,088 1,074 970 1,406 788 1,049 1,309 120 647 594 1,007 1,399 1,023 865 548 1,296 541 1,391 1,021 480 1,182 1,343 769 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,272 816 342 981 595 646 531 534 672 971 299 1,293 470 236 1,241 1,110 351 293 1,695 309 111 1,152 967 648 1,205 1,172 1,149 1,045 1,498 845 1,138 1,416 129 692 635 1,082 1,499 1,107 929 583 1,408 576 1,482 1,100 510 1,296 1,446 836 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,350 864 368 1,070 633 684 561 567 715 1,027 320 1,386 503 250 1,316 1,187 382 314 1,794 339 118 1,243 1,030 691 1,312 1,254 1,219 1,114 1,607 900 1,230 1,496 138 749 677 1,142 1,629 1,190 1,011 615 1,540 611 1,591 1,197 547 1,386 1,575 889 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,421 930 388 1,159 671 746 606 605 760 1,100 340 1,485 531 269 1,396 1,287 405 332 1,889 360 125 1,348 1,100 731 1,411 1,369 1,328 1,213 1,728 958 1,303 1,601 145 792 719 1,231 1,727 1,258 1,090 656 1,628 662 1,727 1,287 583 1,474 1,663 954 Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe Europe PVCs PVCs PVCs Conduit Conduit Conduit Conduit Conduit Conduit Conduit Conduit Conduit Conduit Conduit Conduit Governmen$ Governmen$ Governmen$ Corporate $ Corporate $ Corporate $ Corporate $ Educationa $ Educationa $ Educationa $ Educationa $ Governmen$ Governmen$ Governmen$ Governmen$ $ 1,274 274 1,328 1,241 1,104 377 1,126 145 621 254 399 1,242 1,202 1,120 120 77,509 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,371 296 1,449 1,340 1,203 413 1,245 156 668 271 431 1,347 1,301 1,222 130 84,365 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,469 325 1,553 1,436 1,292 444 1,334 169 728 292 463 1,441 1,408 1,306 139 91,143 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,598 348 1,670 1,544 1,397 479 1,437 180 775 322 493 1,536 1,535 1,395 149 97,892 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,697 372 1,775 1,677 1,506 507 1,541 190 825 352 526 1,643 1,650 1,485 158 104,837 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,796 395 1,872 1,778 1,634 537 1,673 200 877 369 559 1,729 1,770 1,576 168 111,976 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Jul 1,533 843 338 332 614 565 1,440 884 369 1,526 1,503 1,352 1,340 437 1,528 613 1,613 1,003 274 929 290 1,631 1,802 1,678 1,197 1,879 1,703 239 1,854 1,161 318 1,459 1,372 1,951 2,056 992 1,059 325 1,695 1,279 569 324 1,134 711 1,683 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Aug 1,490 791 317 314 581 537 1,401 860 352 1,440 1,409 1,289 1,257 409 1,458 594 1,530 940 262 881 274 1,529 1,692 1,597 1,125 1,770 1,644 230 1,759 1,089 299 1,365 1,333 1,865 1,945 935 1,026 309 1,604 1,210 542 309 1,063 680 1,605 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Sep 1,414 742 303 295 554 501 1,317 813 334 1,349 1,326 1,216 1,193 382 1,409 572 1,445 890 251 834 257 1,426 1,617 1,505 1,054 1,653 1,552 214 1,662 1,027 281 1,284 1,256 1,765 1,834 888 966 289 1,518 1,142 518 294 998 642 1,546 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,633 6,434 2,573 2,550 4,680 4,333 10,895 6,850 2,818 11,604 11,349 10,160 10,168 3,264 11,826 4,622 12,264 7,707 2,120 7,187 2,228 12,312 13,851 12,844 9,068 13,975 13,075 1,850 14,087 8,907 2,424 11,185 10,660 14,947 15,598 7,627 8,156 2,486 13,056 9,720 4,305 2,433 8,573 5,472 12,922 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,526 979 407 1,214 709 784 638 637 801 1,192 362 1,577 569 289 1,468 1,377 439 356 1,993 390 135 1,414 1,177 788 1,503 1,454 1,444 1,281 1,846 1,013 1,369 1,687 157 860 763 1,314 1,814 1,345 1,154 694 1,711 703 1,828 1,375 614 1,561 1,750 1,001 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,448 945 388 1,161 685 746 618 605 763 1,127 342 1,488 539 271 1,412 1,340 411 337 1,865 370 125 1,329 1,118 746 1,408 1,365 1,372 1,205 1,749 970 1,312 1,617 148 808 721 1,261 1,709 1,267 1,085 651 1,614 659 1,732 1,294 575 1,488 1,702 939 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,366 882 366 1,099 641 702 579 578 712 1,069 320 1,418 506 260 1,330 1,288 389 317 1,757 348 118 1,264 1,056 704 1,330 1,283 1,298 1,124 1,649 929 1,257 1,510 141 758 672 1,187 1,606 1,184 1,018 617 1,551 620 1,614 1,215 543 1,405 1,602 885 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,656 7,567 3,139 9,247 5,443 5,991 4,918 4,927 6,152 9,022 2,752 11,996 4,330 2,188 11,383 10,422 3,296 2,707 15,391 2,915 1,012 10,671 8,954 5,972 11,307 10,894 10,804 9,659 13,972 7,820 10,513 12,997 1,191 6,466 5,823 10,023 13,881 10,196 8,657 5,341 12,959 5,338 13,840 10,298 4,714 11,886 13,486 7,638 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,887 422 1,988 1,881 1,750 567 1,771 208 932 392 597 1,838 1,888 1,667 180 118,829 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,765 405 1,888 1,782 1,654 544 1,663 200 897 375 569 1,743 1,811 1,562 170 112,765 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,655 391 1,810 1,683 1,571 510 1,560 192 846 360 531 1,654 1,710 1,459 160 106,485 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 14,511 3,228 15,332 14,362 13,109 4,378 13,350 1,640 7,169 2,987 4,569 14,172 14,275 12,792 1,374 905,801 DASHBOARD INSTRUCTIONS Instructions You are required to create an Excel Dashboard by using at least three of the Excel functions and/or capabilities in Financial Analysis and Modelling. The details of the case and the raw data from which to work are in the attached Excel workbook. Since this is raw data, there may be analysis steps that you have to perform to prepare the data for its final presentation on your dashboard. What makes the dashboard different how to bring together multiple displays of information in a meaningful way to tell a story, or in this case, respond to the question in the problem (will the company achieve 2010 forecasted sales). Dashboards You are presented with a data file that includes sales to date by product, cu yearly forecast. You have to develop a dashboard that indicates whether th analysis and visual presentation for the sales executives to be able to under 1 2 3 4 5 6 7 8 9 10 11 12 Forecast detail Customer Type Corporate Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Product Forecast Actuals Months Cum forecast $ 82,280 81709.88 Jan $ 82,280 82,880 82116.88 Feb $ 165,160 83,630 82407.88 Mar $ 248,790 83,900 82619.88 Apr $ 332,690 83,700 82972.88 May $ 416,390 83,800 83340.88 Jun $ 500,190 83,580 83569.88 Jul $ 583,770 83,680 83943.88 Aug $ 667,450 83,800 84278.88 Sep $ 751,250 84,000 84562.49 Oct $ 835,250 85,100 84875.86 Nov $ 920,350 85,650 85189.22 Dec $ 1,006,000 $ 1,006,000 $ 1,001,588 This answers the key question - you will not make your targe Jan 27,230 9,670 9,940 7,620 24,640 9,800 8,340 6,500 30,410 10,970 9,360 10,080 82,280 Feb 27,440 9,750 10,010 7,680 24,800 9,850 8,400 6,550 30,640 11,050 9,430 10,160 82,880 165,160 Mar 27,690 9,840 10,100 7,750 25,020 9,930 8,480 6,610 30,920 11,150 9,520 10,250 83,630 248,790 Apr 27,810 9,880 10,130 7,800 25,080 9,940 8,510 6,630 31,010 11,180 9,550 10,280 83,900 332,690 $ $ $ $ Copy Paper $ $ $ $ Ink Jet Cartrid Toner Cartridg Educational $ $ $ $ Copy Paper Ink Jet Cartrid Toner Cartridg Governmental $ $ $ $ Copy Paper Ink Jet Cartrid Toner Cartridg Total Sales $ $ $ $ Cum $ $ $ I did a pivot table with the same row selection as the forecast. 1 2 3 4 5 Data Customer Type Product Sum - Jan Sum - Feb Sum - Mar Sum - Apr Corporate 28,536 28,702 28,826 28,886 Copy Paper 10,502 10,613 10,646 10,643 Ink Jet Cartrid 9,282 9,319 9,391 9,408 Toner Cartridg 8,752 8,770 8,789 8,835 Educational 22,341 22,423 22,535 22,602 Copy Paper 7,442 7,458 7,546 7,553 Ink Jet Cartrid Toner Cartridg Governmental Copy Paper Ink Jet Cartrid Toner Cartridg Total Result 8,795 6,104 30,833 10,948 9,907 9,978 81,710 8,825 6,140 30,992 10,977 9,986 10,029 82,117 8,827 6,162 31,047 10,990 9,982 10,075 82,408 8,854 6,195 31,132 11,047 10,009 10,076 82,620 A useful analysis would be comparing actual v forecast with a drill down ability Region East East East East East East East East East East East East East East East East East East East Product Customer Type Sales Representative Toner CartridgCorporate Nathan Clark $ Toner CartridgCorporate Rachel Smith Toner CartridgCorporate Karen Winthrop Toner CartridgCorporate Walter Jones Toner CartridgEducational Nathan Clark Toner CartridgEducational Rachel Smith Toner CartridgEducational Karen Winthrop Toner CartridgEducational Walter Jones Toner CartridgGovernmental Nathan Clark Toner CartridgGovernmental Rachel Smith Toner CartridgGovernmental Karen Winthrop Toner CartridgGovernmental Walter Jones Ink Jet Cartrid Corporate Nathan Clark Ink Jet Cartrid Corporate Rachel Smith Ink Jet Cartrid Corporate Karen Winthrop Ink Jet Cartrid Corporate Walter Jones Ink Jet Cartrid Educational Nathan Clark Ink Jet Cartrid Educational Rachel Smith Ink Jet Cartrid Educational Karen Winthrop Jan Feb 827 $ 463 186 186 337 313 749 490 199 845 812 713 739 227 861 316 879 562 155 825 467 185 187 334 ### 759 495 201 ### 818 712 732 ### 862 317 878 563 154 East East East East East East East East East East East East East East East East East North North North North North North North North North North North North North North North North North North North North North North North North North North North North North North North Ink Jet Cartrid Educational Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Educational Copy Paper Educational Copy Paper Educational Copy Paper Educational Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Toner CartridgCorporate Toner CartridgCorporate Toner CartridgCorporate Toner CartridgCorporate Toner CartridgEducational Toner CartridgEducational Toner CartridgEducational Toner CartridgEducational Toner CartridgGovernmental Toner CartridgGovernmental Toner CartridgGovernmental Toner CartridgGovernmental Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Educational Copy Paper Educational Copy Paper Educational Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop 522 161 870 1,011 905 644 973 931 132 995 647 174 819 774 1,048 1,105 557 584 179 948 698 299 167 602 390 895 825 553 225 661 381 435 354 361 439 653 194 848 308 156 821 718 236 192 1,115 199 70 740 525 162 886 1,010 923 656 977 949 ### 994 642 172 810 776 1,049 1,104 ### 592 181 943 693 ### 170 604 399 921 836 ### 223 656 384 432 356 359 440 652 198 859 309 158 830 722 ### 196 1,128 206 73 750 North North North North North South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South South West West West West West West West Copy Paper Educational Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Toner CartridgCorporate Toner CartridgCorporate Toner CartridgCorporate Toner CartridgCorporate Toner CartridgEducational Toner CartridgEducational Toner CartridgEducational Toner CartridgEducational Toner CartridgGovernmental Toner CartridgGovernmental Toner CartridgGovernmental Toner CartridgGovernmental Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Educational Copy Paper Educational Copy Paper Educational Copy Paper Educational Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Toner CartridgCorporate Toner CartridgCorporate Toner CartridgCorporate Toner CartridgCorporate Toner CartridgEducational Toner CartridgEducational Toner CartridgEducational Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop 638 423 806 761 765 682 990 569 737 946 86 463 412 718 1,004 722 601 389 872 388 987 727 346 831 965 542 1,061 228 1,106 1,034 920 314 938 121 518 212 333 1,035 1,002 933 100 766 439 285 220 173 226 162 644 427 804 766 772 685 1,002 566 748 943 85 465 422 721 995 735 604 393 895 385 994 721 343 844 960 549 1,054 227 1,114 1,031 925 318 958 120 514 209 332 1,036 1,001 940 ### 762 436 283 222 ### 224 161 West West West West West West West West West West West West West West West West West West West West West West West West West West West West West Toner CartridgEducational Toner CartridgGovernmental Toner CartridgGovernmental Toner CartridgGovernmental Toner CartridgGovernmental Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Corporate Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Educational Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Ink Jet Cartrid Governmental Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Corporate Copy Paper Educational Copy Paper Educational Copy Paper Educational Copy Paper Educational Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Copy Paper Governmental Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones Nathan Clark Rachel Smith Karen Winthrop Walter Jones 289 169 600 986 111 414 942 345 976 764 853 246 296 225 497 172 991 288 1,016 511 540 82 593 469 836 393 730 268 248 294 168 595 990 112 421 946 344 980 780 863 ### 297 228 494 ### 1,006 289 1,035 514 547 ### 611 473 830 ### 735 ### 249 udes sales to date by product, customer rep etc. You have actuals to date as well as the hboard that indicates whether they will hit their year end target, and provide sufficient es executives to be able to understand. Cum actuals + trend $ 81,710 $ 163,827 $ 246,235 $ 328,855 $ 411,827 $ 495,168 $ 578,738 $ 662,682 $ 746,961 $ 831,523 $ 916,399 $ 1,001,588 these are the monthly forecast totals and the actuals for Jan-Sept...and then I trended just the When you trend the individual records there isn't enough data for it to be usable. next, calculate monthly cumulative sales then you do a chart or two charts, basically showing the monthly forecast v actual as well as the trend over the year Next you need to have more than one drill down into the data, to explain why is it due to product, region, customer type or sales rep? on - you will not make your target level of sales $ $ $ $ $ $ May 27,710 9,850 10,110 7,750 25,040 9,940 8,490 6,610 30,950 11,160 9,530 10,260 83,700 416,390 6 $ $ $ $ $ $ Jun 27,750 9,870 10,120 7,760 25,070 9,950 8,500 6,620 30,980 11,170 9,540 10,270 83,800 500,190 Jul $ 27,670 $ 9,840 10,090 7,740 $ 25,020 9,950 8,470 6,600 $ 30,890 11,140 9,510 10,240 $ 83,580 $ 583,770 7 8 $ $ $ $ $ $ Aug 27,710 9,850 10,110 7,750 25,040 9,940 8,480 6,620 30,930 11,150 9,520 10,260 83,680 667,450 9 $ $ $ $ $ $ Sep 27,750 9,870 10,120 7,760 25,070 9,950 8,500 6,620 30,980 11,170 9,540 10,270 83,800 751,250 10 $ $ $ $ $ $ Oct 27,820 9,890 10,150 7,780 25,120 9,960 8,520 6,640 31,060 11,200 9,560 10,300 84,000 835,250 11 $ $ $ $ $ $ Nov 28,190 10,030 10,280 7,880 25,450 10,090 8,630 6,730 31,460 11,340 9,690 10,430 85,100 920,350 12 Nov trend Dec trend Sum - May Sum - Jun Sum - Jul Sum - Aug Sum - Sep $ 29,772 $ 29,894 29,010 29,167 29,270 29,394 29,559 Err:502 Err:502 10,694 10,760 10,808 10,854 10,886 Err:502 Err:502 9,443 9,516 9,547 9,566 9,644 Err:502 Err:502 8,873 8,891 8,915 8,974 9,029 Err:502 Err:502 22,705 22,772 22,841 22,968 23,034 Err:502 Err:502 7,569 7,607 7,628 7,665 7,691 Err:502 Err:502 8,916 6,220 31,258 11,101 10,026 10,131 82,973 Mar $ 826 $ 465 186 186 331 315 768 494 204 838 813 722 732 230 854 326 872 559 153 8,928 6,237 31,402 11,186 10,046 10,170 83,341 8,954 6,259 31,459 11,225 10,024 10,210 83,570 Apr May 827 $ 830 $ 470 467 185 186 185 185 337 341 313 311 777 782 491 495 205 203 832 839 811 818 718 729 733 733 237 241 852 851 330 331 879 885 ### 561 ### 152 8,985 6,318 31,582 11,291 10,036 10,255 83,944 Jun 9,023 6,320 31,686 11,323 10,084 10,279 84,279 Jul 830 $ 468 188 184 340 317 800 495 203 831 829 746 732 240 850 337 896 558 152 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Aug 852 $ 469 188 185 341 314 800 491 205 848 835 751 745 243 849 341 896 557 152 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Sep 877 $ 466 187 185 342 316 824 506 207 847 829 758 740 241 858 350 900 553 154 884 464 190 185 346 313 823 508 209 843 829 760 746 239 881 358 903 556 157 526 161 884 1,005 927 652 1,001 940 136 1,023 654 173 810 772 1,070 1,105 552 590 180 939 693 300 170 622 399 934 853 549 229 657 396 429 356 357 449 646 199 866 313 157 825 738 235 196 1,139 209 73 757 522 160 887 1,001 926 655 998 936 135 1,014 649 178 813 768 1,086 1,126 551 585 ### 955 698 308 174 624 398 936 848 544 228 654 397 431 354 356 448 647 ### 862 ### ### 827 740 234 195 1,130 206 74 768 520 162 888 1,005 932 654 1,006 937 135 1,015 645 177 814 768 1,099 1,129 548 588 180 951 709 318 175 628 394 938 844 540 230 669 396 428 351 354 447 642 200 866 314 156 822 742 239 196 1,121 212 74 777 519 162 905 997 940 661 1,016 945 134 1,030 647 178 816 765 1,094 1,153 555 585 181 948 708 316 179 623 392 944 836 547 228 682 395 439 357 356 447 647 200 873 312 158 821 757 238 195 1,111 212 ### 793 516 161 906 1,001 932 665 1,044 946 133 1,030 645 177 811 762 1,084 1,142 551 589 181 942 711 316 180 630 395 935 848 544 226 675 394 436 355 354 445 662 201 876 316 160 815 765 244 198 1,107 217 75 786 518 161 899 995 939 662 1,041 967 135 1,035 641 176 803 784 1,097 1,144 550 604 182 944 712 319 182 625 400 944 852 556 228 683 403 439 364 356 449 663 201 875 317 159 830 788 242 198 1,097 218 74 782 521 160 891 1,010 940 659 1,033 970 134 1,039 642 176 803 785 1,103 1,146 555 604 181 949 714 324 184 624 401 966 854 551 229 687 401 439 362 361 445 668 200 886 316 162 831 805 243 198 1,098 218 74 790 646 429 805 777 767 693 1,005 563 750 935 86 462 424 719 999 731 618 392 926 387 994 729 343 844 959 549 1,049 232 1,109 1,026 923 317 953 121 520 209 331 1,029 1,006 933 99 780 434 282 224 172 225 161 645 432 803 781 766 697 999 564 759 944 ### 461 423 721 ### 738 619 389 939 384 988 733 340 864 964 557 1,065 ### 1,113 1,029 931 319 958 120 517 215 329 1,024 1,023 930 ### 795 436 281 226 174 223 ### 644 432 820 784 762 697 1,005 563 769 935 86 468 423 714 1,018 744 632 385 963 382 995 748 342 866 984 555 1,060 232 1,109 1,048 941 317 963 119 516 220 329 1,027 1,031 928 99 804 439 280 227 180 221 161 647 430 830 805 781 714 1,017 564 767 942 85 466 423 724 1,016 740 641 386 958 390 1,016 757 343 867 978 561 1,056 232 1,101 1,046 961 316 984 118 516 217 329 1,017 1,041 927 ### 799 439 280 226 179 221 160 654 438 835 808 802 712 1,026 563 761 937 87 478 424 730 1,008 747 641 386 951 391 1,016 764 341 867 972 556 1,048 234 1,104 1,045 972 315 984 116 518 218 332 1,021 1,049 926 100 803 436 278 226 181 221 163 658 439 828 803 807 709 1,029 571 772 951 87 475 424 742 1,005 745 638 383 950 388 1,019 761 338 875 1,001 552 1,038 238 1,110 1,048 973 320 978 118 528 221 335 1,025 1,065 919 100 805 434 277 227 181 222 164 660 440 831 802 811 703 1,031 581 786 944 88 474 420 742 1,004 740 636 386 970 388 1,009 759 339 878 ### 553 1,034 244 1,131 1,052 982 319 975 120 529 225 332 1,034 1,069 912 100 817 438 280 229 181 225 163 298 167 599 989 111 428 960 344 985 780 864 249 296 227 490 171 1,012 294 1,034 511 551 84 626 478 836 391 737 269 249 301 166 606 994 ### 433 952 346 994 773 865 254 ### 226 498 ### 1,009 293 1,027 506 557 ### 639 477 829 400 738 267 253 302 167 612 992 111 436 954 349 984 771 884 260 298 225 503 173 1,019 292 1,030 507 566 87 638 473 833 400 755 266 253 299 166 615 994 110 436 961 349 993 771 881 258 296 225 504 175 1,019 293 1,020 511 572 88 638 473 835 410 757 267 255 301 168 619 996 109 440 961 358 1,011 783 887 260 295 225 500 175 1,010 294 1,010 516 570 87 649 472 845 412 771 269 255 300 167 627 1,001 109 442 952 355 1,004 778 881 259 296 225 500 178 1,015 296 1,024 513 572 88 663 479 850 421 781 269 259 302 168 626 1,012 110 439 981 363 1,000 783 888 259 303 228 500 178 ### 295 1,031 523 569 89 662 488 848 424 778 271 262 Sept...and then I trended just the totals ta for it to be usable. a, to explain why $ $ $ $ $ $ FY $ Dec 28,370 10,100 10,340 7,930 25,610 10,160 8,680 6,770 31,670 11,420 9,750 10,500 85,650 1,006,000 350,662 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 $ $ $ $ $ $ FY 2010 333,140 118,440 121,500 93,200 300,960 119,460 102,000 79,500 371,900 134,100 114,500 123,300 1,006,000 1,006,000 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 31-Jan-10 28-Feb-10 $ 827 $ 825 463 467 186 185 186 187 337 334 ### 313 749 759 490 495 199 201 845 845 812 818 713 712 739 732 227 227 861 862 316 317 879 878 562 563 155 154 522 161 870 1,011 905 644 973 931 132 995 647 174 819 774 1,048 1,105 557 584 179 948 698 299 167 602 390 895 825 553 225 661 381 435 354 ### 439 653 194 848 308 156 821 718 236 192 1,115 199 70 740 525 162 886 1,010 923 656 977 949 132 994 642 172 810 776 1,049 1,104 557 592 181 943 693 299 170 604 399 921 836 553 223 656 384 432 356 359 440 652 198 859 309 158 830 722 236 196 1,128 206 73 750 638 423 806 761 765 682 990 569 737 946 86 463 412 718 ### 722 601 389 872 ### 987 727 346 831 965 542 1,061 228 1,106 1,034 920 314 938 121 518 212 333 1,035 1,002 933 ### 766 439 285 220 173 226 162 644 427 804 766 772 685 1,002 566 748 943 85 465 422 721 995 735 604 393 895 385 994 721 343 844 960 549 1,054 227 1,114 1,031 925 318 958 120 514 209 332 1,036 1,001 940 100 762 436 283 222 173 224 161 289 169 600 986 111 414 942 345 976 764 853 246 296 225 497 172 991 288 1,016 511 540 82 593 469 836 393 730 268 248 294 168 595 990 112 421 946 344 980 780 863 246 297 228 494 172 1,006 289 1,035 514 547 82 611 473 830 393 735 268 249 31-Mar-10 30-Apr-10 31-May-10 30-Jun-10 31-Jul-10 31-Aug-10 30-Sep-10 31-Oct-10 30-Nov-10 $ 826 $ 827 $ 830 ### $ 852 $ 877 $ 884 Err:502 Err:502 465 470 467 468 469 466 464 Err:502 Err:502 186 185 186 188 188 187 190 Err:502 Err:502 186 185 185 184 185 185 185 Err:502 Err:502 331 337 341 340 341 342 346 Err:502 Err:502 315 313 311 317 314 316 313 Err:502 Err:502 768 777 782 800 800 824 823 Err:502 Err:502 494 491 495 ### 491 506 508 Err:502 Err:502 204 205 203 ### 205 207 209 Err:502 Err:502 838 832 839 831 848 847 843 Err:502 Err:502 813 811 818 829 835 829 829 Err:502 Err:502 722 718 729 746 751 758 760 Err:502 Err:502 732 733 733 732 745 740 746 Err:502 Err:502 230 237 241 240 243 241 239 Err:502 Err:502 854 852 851 850 849 858 881 Err:502 Err:502 326 330 331 337 341 350 358 Err:502 Err:502 872 879 885 896 896 900 903 Err:502 Err:502 559 ### 561 558 557 553 556 Err:502 Err:502 153 ### 152 ### 152 154 157 Err:502 Err:502 526 161 884 1,005 927 652 1,001 940 136 1,023 654 173 810 772 1,070 1,105 552 590 180 939 693 300 170 622 399 934 853 549 229 657 396 429 356 357 449 646 199 866 313 157 825 738 235 196 1,139 209 73 757 522 160 887 1,001 926 655 998 936 135 1,014 649 178 813 768 1,086 1,126 551 585 ### 955 698 308 174 624 398 936 848 544 228 654 397 431 354 356 448 647 ### 862 ### ### 827 740 234 195 1,130 206 74 768 520 162 888 1,005 932 654 1,006 937 135 1,015 645 177 814 768 1,099 1,129 548 588 180 951 709 318 175 628 394 938 844 540 230 669 396 428 351 354 447 642 200 866 314 156 822 742 239 196 1,121 212 74 777 519 ### 905 997 940 661 1,016 945 134 1,030 647 178 816 765 1,094 1,153 555 585 181 948 708 316 179 623 392 944 836 547 228 682 395 439 357 356 ### 647 ### 873 312 158 821 757 238 195 1,111 ### ### 793 516 161 906 1,001 932 665 1,044 946 133 ### 645 177 811 762 1,084 1,142 551 589 181 942 711 316 180 630 395 935 848 544 226 675 394 436 355 354 445 662 201 876 316 160 815 765 244 198 1,107 217 75 786 518 161 899 995 939 662 1,041 967 135 1,035 641 176 803 784 1,097 1,144 550 604 182 944 712 319 182 625 400 944 852 556 228 683 403 439 364 356 449 663 201 875 317 159 830 788 242 198 1,097 218 74 782 521 160 891 1,010 940 659 1,033 970 134 1,039 642 176 803 785 1,103 1,146 555 604 181 949 714 324 184 624 401 966 854 551 229 687 401 439 362 361 445 668 200 886 316 162 831 805 243 198 1,098 218 74 790 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 646 429 805 777 767 693 1,005 563 750 935 86 462 424 719 999 731 618 392 926 387 994 729 343 844 959 549 1,049 232 1,109 1,026 923 317 953 121 520 209 331 1,029 1,006 933 99 780 434 282 224 172 225 161 645 432 803 781 766 697 999 564 759 944 ### 461 423 721 ### 738 619 389 939 384 988 733 340 864 964 557 1,065 ### 1,113 1,029 931 319 958 120 517 215 329 1,024 1,023 930 ### 795 436 281 226 174 223 ### 644 432 820 784 762 697 1,005 563 769 935 86 468 423 714 1,018 744 632 385 963 382 995 748 342 866 984 555 1,060 232 1,109 1,048 941 317 963 119 516 220 329 1,027 1,031 928 99 804 439 280 227 180 221 161 647 430 830 805 781 714 1,017 564 767 942 85 466 ### 724 1,016 740 641 386 958 390 1,016 757 343 867 978 561 1,056 ### 1,101 1,046 961 316 984 118 ### 217 ### 1,017 1,041 927 ### 799 ### ### 226 179 ### 160 654 438 835 808 802 712 1,026 563 761 937 87 478 424 730 1,008 747 641 386 951 391 ### 764 341 867 972 556 1,048 234 1,104 1,045 972 315 984 116 518 218 332 1,021 1,049 926 100 803 436 278 226 181 221 163 658 439 828 803 807 709 1,029 571 772 951 87 475 424 742 1,005 745 638 383 950 388 1,019 761 338 875 1,001 552 1,038 238 1,110 1,048 973 320 978 118 528 221 335 1,025 1,065 919 100 805 434 277 227 181 222 164 660 440 831 802 811 703 1,031 581 786 944 88 474 420 742 1,004 740 636 386 970 388 1,009 759 339 878 ### 553 1,034 244 1,131 1,052 982 319 975 120 529 225 332 1,034 1,069 912 100 817 438 280 229 181 225 163 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 298 167 599 989 111 428 960 344 985 780 864 249 296 227 490 171 1,012 294 1,034 511 551 84 626 478 836 391 737 269 249 301 166 606 994 ### 433 952 346 994 773 865 254 ### 226 498 ### 1,009 293 1,027 506 557 ### 639 477 829 400 738 267 253 302 167 612 992 111 436 954 349 984 771 884 260 298 225 503 173 1,019 292 1,030 507 566 87 638 473 833 400 755 266 253 299 166 615 994 110 ### 961 ### 993 ### 881 258 296 ### 504 175 ### 293 1,020 511 572 88 ### ### 835 410 757 267 255 301 168 619 996 109 440 961 358 1,011 783 887 260 295 225 500 175 1,010 294 1,010 516 570 87 649 472 845 412 771 269 255 300 167 627 1,001 109 442 952 355 1,004 778 881 259 296 225 500 178 1,015 296 1,024 513 572 88 663 479 850 421 781 269 259 302 168 626 1,012 110 439 981 363 1,000 783 888 259 303 228 500 178 ### 295 1,031 523 569 89 662 488 848 424 778 271 262 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 31-Dec-10 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 Err:502 SALES DASHBOARD Forecast v. Actual + trend $1,100,000 $1,000,000 $900,000 $800,000 $700,000 $600,000 Axis Title $500,000 $400,000 $300,000 $200,000 $100,000 $- Jan Feb Mar Apr May Cum forecast Cum actuals + trend Year to date Jan Feb Mar Apr May Jun Jul Aug Sep Forecast $ 82,280 $ 82,880 $ 83,630 $ 83,900 $ 83,700 $ 83,800 $ 83,580 $ 83,680 $ 83,800 Actuals+ trend $ 81,710 $ 82,117 $ 82,408 $ 82,620 $ 82,973 $ 83,341 $ 83,570 $ 83,944 $ 84,279 Variance from forecast $ (570) $ (763) $ (1,222) $ (1,280) $ (727) $ (459) $ (10) $ 264 $ 479 Jun Jul Aug Linear (Cum forecast) Linear (Cum actuals + trend) Sep Oc Oct Nov Dec Total $ $ $ $ 84,000 85,100 85,650 1,006,000 $ $ $ $ 84,562 84,876 85,189 1,001,588 $ $ $ $ 562 (224) (461) (4,412) =If(E47