Hello there,

I need help with my assignment. Please see attachments for detail.

Thank you.

Throughout this course, we've practiced ways to analyze and model data from financial operations so that it assists in decision-making. Most of our models have been discrete, standalone designs. Often managers in organizations would like a high-level snapshot of financial performance that coveys critical information at a glance. Dashboards are such presentation tools. Excel has made creating dashboards easier and more effective. In this assignment, you are required to create an Excel Dashboard by using at least three of the Excel functions and/or capabilities that we have learned in class. 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. Attached is a special lecture on Dashboards. Please read it carefully. You should recognize most of this advice from our early lectures on graphs and charts. What is different for this dashboard assignment is that you are bringing 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). The DUE DATE on this assignment is end of week 11. I suggest that you start the project early. You will also have Session 11 to work on it. In this situation, you MAY use the spreadsheet that contains the raw data as the starting place for your dashboard. As you research and work on this project, I encourage you to post additional references and/or video links in this conference that you think may be helpful to the group. You have a lot of freedom in this project and it is an opportunity to practice and demonstrate the skills you've gained in class. You will be graded on the following criteria: 1) appropriateness and complexity of Excel features used 2) accuracy of calculations, analyses, or presentations 3) overall theme and presentation 4) effectiveness of dashboard in communicating results and responding to the question 5) the quality and accuracy of your narrative response to the question Make the dashboard meaningful, but have fun! Dashboard data FY 2010 Sales Forecast by Month Jan Total Sales $ Feb 82,880 82,280 Mar 83,630 Apr 83,900 May 83,700 Jun 83,800 Jul 83,580 Aug 83,680 Sep 83,800 Oct 84,000 Nov 85,100 Dec 85,650 $ 9,750 $ 10,010 7,680 9,850 8,400 6,550 11,050 9,430 10,160 82,880 $ Mar 9,840 $ 10,100 7,750 9,930 8,480 6,610 11,150 9,520 10,250 83,630 $ Apr 9,880 $ 10,130 7,800 9,940 8,510 6,630 11,180 9,550 10,280 83,900 $ May 9,850 $ 10,110 7,750 9,940 8,490 6,610 11,160 9,530 10,260 83,700 $ Jun 9,870 $ 10,120 7,760 9,950 8,500 6,620 11,170 9,540 10,270 83,800 $ Jul 9,840 $ 10,090 7,740 9,950 8,470 6,600 11,140 9,510 10,240 83,580 $ Aug 9,850 $ 10,110 7,750 9,940 8,480 6,620 11,150 9,520 10,260 83,680 $ Sep 9,870 $ 10,120 7,760 9,950 8,500 6,620 11,170 9,540 10,270 83,800 $ Oct 9,890 $ 10,150 7,780 9,960 8,520 6,640 11,200 9,560 10,300 84,000 $ Nov 10,030 $ 10,280 7,880 10,090 8,630 6,730 11,340 9,690 10,430 85,100 $ FY 2010 1,006,000 FY 2010 Product Sales Forecast by Customer Type Customer Type Product Corporate Copy Paper Ink Jet Cartridges Toner Cartridges Educational Copy Paper Ink Jet Cartridges Toner Cartridges Governmental Copy Paper Ink Jet Cartridges Toner Cartridges Total Sales Jan $ $ 9,670 $ 9,940 7,620 9,800 8,340 6,500 10,970 9,360 10,080 82,280 $ FY 2010 Sales Forecast by Sales Representative Sales Forecasted FY 2010 Representative Sales Karen Winthrop $ 236,700 Nathan Clark 244,700 Rachel Smith 272,600 Walter Jones 252,000 Total $ 1,006,000 Feb Dec FY 2010 10,100 $ 118,440 10,340 121,500 7,930 93,200 10,160 119,460 8,680 102,000 6,770 79,500 11,420 134,100 9,750 114,500 10,500 123,300 85,650 $ 1,006,000 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 Region East East East East East East East East East East East East East East East East East East East 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 North North North North North South South South South South South South B Product Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges C Customer Type Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational D Sales Representative 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 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 E F G H I J K L M N O P Q R S T U V W X 31-Oct-08 30-Nov-08 31-Dec-08 31-Jan-09 28-Feb-09 31-Mar-09 30-Apr-09 31-May-09 30-Jun-09 31-Jul-09 31-Aug-09 30-Sep-09 31-Oct-09 30-Nov-09 31-Dec-09 31-Jan-10 28-Feb-10 31-Mar-10 30-Apr-10 31-May-10 $ 697 $ 356 101 104 336 310 727 466 192 784 764 676 725 254 872 321 735 472 115 460 114 801 912 847 645 899 914 125 955 704 233 858 713 957 987 535 475 98 820 568 304 166 653 399 853 803 535 206 640 408 450 376 298 394 547 152 749 257 114 725 613 221 187 949 257 148 801 689 364 740 773 754 524 872 496 574 877 100 466 711 $ 362 100 105 338 313 733 476 191 792 766 679 732 254 877 324 746 472 117 464 113 798 924 855 652 892 918 126 972 709 237 855 710 977 1,006 532 483 99 833 581 304 168 652 404 855 800 534 211 635 408 460 375 303 394 560 153 742 259 117 735 625 219 188 949 263 147 794 702 372 742 772 749 525 873 492 576 885 100 471 713 $ 360 101 104 336 310 736 473 193 795 768 676 730 ### 885 327 745 476 ### 466 115 796 932 848 651 902 929 125 964 716 241 854 722 974 1,025 528 481 ### 829 595 302 167 651 407 857 795 533 214 ### 406 459 372 304 395 ### ### 738 265 ### 736 626 221 189 956 267 146 787 712 377 741 774 757 527 867 497 580 904 101 ### 710 $ 358 ### 105 342 312 743 484 ### 812 770 686 739 254 891 324 766 482 116 475 116 806 939 844 650 914 921 ### 963 709 ### 853 718 984 1,035 530 478 100 850 596 ### ### 657 406 862 789 531 212 638 ### 458 371 306 397 569 152 749 ### 117 735 628 219 188 962 266 149 805 706 385 748 775 750 540 875 501 595 913 ### 469 710 $ 361 100 105 339 322 745 493 195 810 771 690 745 259 886 327 764 487 116 474 116 798 954 838 646 939 917 124 985 704 243 873 720 1,000 1,047 531 481 100 846 602 302 169 651 406 861 791 531 213 652 404 459 369 303 399 579 151 771 266 119 732 634 219 188 971 270 150 805 701 392 752 776 751 548 876 496 603 917 102 470 724 $ 365 101 104 344 322 753 494 197 815 767 690 742 257 884 324 760 497 118 473 118 804 958 857 645 953 921 123 985 699 243 868 713 997 1,048 542 494 99 861 606 301 172 657 402 867 801 538 216 646 402 455 367 306 400 587 153 778 266 121 732 652 219 187 991 271 154 800 702 395 747 771 756 548 885 494 620 936 104 469 732 $ 368 103 105 ### 319 760 496 ### 822 764 698 735 256 886 325 774 500 119 469 ### 800 953 852 651 956 ### 127 1,009 701 246 870 724 1,005 1,052 547 492 ### 857 607 304 174 655 400 ### 815 542 214 648 399 ### 372 305 397 595 157 781 ### ### 742 655 220 188 1,014 279 157 798 697 404 759 768 762 551 887 490 635 945 ### 476 735 $ 373 105 105 345 318 756 496 197 819 774 707 731 264 882 327 784 500 119 469 117 801 944 852 660 969 914 126 1,023 713 252 869 723 1,009 1,060 543 497 99 850 604 301 174 651 397 865 817 545 218 642 405 453 380 304 399 607 158 786 266 121 741 658 219 188 1,036 283 158 794 709 403 758 764 759 563 906 487 636 940 103 475 742 $ 379 ### 104 350 320 752 506 199 839 777 705 734 266 878 325 791 495 121 472 120 797 ### 860 665 963 928 ### 1,034 719 253 891 720 1,006 1,064 553 506 101 873 607 298 175 645 ### 866 810 553 222 639 ### 449 384 307 ### 608 ### 790 267 120 749 664 223 ### 1,048 288 160 791 717 409 756 ### 757 559 902 483 633 958 105 478 738 $ 382 105 ### 348 325 759 515 198 844 787 704 751 ### 894 327 794 499 ### ### 119 802 941 865 663 954 950 125 1,047 727 255 884 721 1,009 1,060 551 509 100 869 605 299 176 639 397 876 817 ### 221 660 404 445 386 306 397 602 157 ### 266 119 ### 679 225 189 1,042 287 ### 812 721 416 754 761 759 566 914 481 631 951 106 476 732 $ 380 106 103 350 323 759 510 201 849 801 701 753 267 891 334 800 503 120 473 121 803 946 880 657 957 941 126 1,043 740 258 876 731 1,016 1,078 546 504 100 869 604 300 176 637 395 873 811 556 219 659 405 453 389 304 399 598 160 790 267 119 764 677 225 189 1,061 286 161 820 721 420 756 760 759 566 924 485 626 949 105 479 749 $ 382 106 104 352 322 757 505 200 842 800 697 762 265 896 331 817 514 120 473 122 795 942 878 653 951 941 127 1,056 739 261 887 744 1,035 ### 559 503 100 863 624 301 177 632 394 890 811 551 217 669 412 456 391 307 407 603 160 792 274 121 773 677 224 192 1,086 286 162 828 717 424 778 756 764 573 925 485 625 942 105 484 748 $ 387 107 103 356 320 775 513 198 838 797 696 755 263 905 339 843 525 121 ### 121 806 945 879 654 964 935 130 1,070 737 262 881 752 1,043 1,084 570 514 102 ### 618 303 ### 627 396 883 818 ### 216 676 410 453 392 306 403 608 ### 804 272 120 774 695 229 191 1,096 ### 163 831 722 425 787 ### 768 585 920 484 645 950 104 482 755 386 107 104 353 325 775 511 199 842 798 710 762 265 903 347 847 531 120 483 123 803 938 881 652 963 933 131 1,078 742 267 890 745 1,049 1,100 567 511 101 862 616 305 179 625 397 891 816 559 215 691 414 461 393 313 404 610 161 809 270 119 791 695 233 192 1,114 291 164 828 728 422 784 753 762 595 917 486 660 946 104 485 ### $ 387 106 105 356 327 768 506 200 841 800 703 765 263 ### 352 ### 532 ### ### ### 813 951 874 647 970 926 130 1,084 741 265 909 760 1,045 1,105 562 506 100 873 618 310 184 623 ### 898 823 554 220 700 410 474 390 317 401 617 160 810 269 ### 787 698 ### 191 1,108 ### 166 833 731 426 790 755 768 601 912 ### 658 962 103 482 827 $ 463 186 186 337 313 749 490 199 845 812 713 739 227 861 316 879 562 155 522 161 870 1,011 905 644 973 931 132 995 647 174 819 774 1,048 ### 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 638 423 806 761 765 682 990 569 737 946 86 463 825 $ 467 185 187 334 313 759 495 201 845 818 712 732 227 862 317 878 563 154 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 644 427 804 766 772 685 1,002 566 748 943 85 465 826 $ 465 186 186 331 315 768 494 204 838 813 722 732 230 854 326 872 559 153 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 646 429 805 777 767 693 1,005 563 750 935 86 462 827 $ 470 185 185 337 313 777 491 205 832 811 718 733 237 852 330 879 ### ### 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 645 432 803 781 766 697 999 564 759 944 ### 461 830 467 186 185 341 311 782 495 203 839 818 729 733 241 851 331 885 561 152 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 644 432 820 784 762 697 1,005 563 769 935 86 468 A 1 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 Region 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 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 B Product Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper C Customer Type Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental D Sales Representative 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 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 E F G H I J K L M N O P Q R S T U V W X 31-Oct-08 30-Nov-08 31-Dec-08 31-Jan-09 28-Feb-09 31-Mar-09 30-Apr-09 31-May-09 30-Jun-09 31-Jul-09 31-Aug-09 30-Sep-09 31-Oct-09 30-Nov-09 31-Dec-09 31-Jan-10 28-Feb-10 31-Mar-10 30-Apr-10 31-May-10 391 679 949 699 548 412 869 414 984 666 313 772 937 478 955 167 982 926 891 306 864 197 585 263 420 992 956 944 103 685 366 192 135 177 213 162 288 160 559 892 101 437 919 358 989 674 815 205 248 162 436 126 902 273 961 482 516 169 683 527 881 362 736 245 223 396 674 957 696 547 409 888 414 986 669 316 767 930 487 958 168 974 919 896 312 866 198 584 263 421 993 953 949 102 689 363 196 135 176 215 161 292 159 561 898 103 433 923 358 1,002 676 807 203 250 163 436 126 900 272 959 478 515 168 679 522 878 364 734 243 221 404 681 953 691 552 407 885 410 991 687 318 762 929 ### 967 171 976 916 ### 315 870 200 596 267 418 990 956 943 ### 688 ### 199 134 177 217 162 293 ### 558 909 ### 439 924 355 1,001 673 805 202 252 166 439 127 899 276 953 481 ### 170 681 ### 872 368 741 ### 223 401 678 ### 690 560 403 880 406 989 696 316 780 ### 486 977 173 974 924 895 316 874 198 597 275 416 993 947 935 101 687 366 ### 133 179 218 ### 294 158 553 905 106 440 932 357 992 678 812 ### 257 168 ### ### 907 275 955 477 526 169 682 520 887 370 742 242 221 401 681 980 698 556 400 875 404 981 696 313 787 948 490 983 172 983 916 913 313 871 197 604 282 416 1,016 977 928 101 685 364 198 132 181 224 162 292 159 553 898 105 442 939 360 984 692 815 200 256 171 447 130 899 276 972 477 528 170 679 523 883 369 738 248 222 401 689 991 705 567 408 868 402 985 706 311 782 948 490 984 173 1,009 937 916 318 888 200 603 280 428 1,010 978 943 101 695 368 200 133 181 230 163 297 158 554 891 105 441 951 359 985 687 815 201 255 174 446 131 896 280 972 485 530 174 678 524 899 369 734 247 224 402 685 985 701 566 414 860 405 982 709 313 780 941 493 976 172 1,000 938 917 316 894 202 602 283 431 1,016 974 954 100 691 369 198 132 183 ### 166 ### 160 560 906 106 440 954 356 982 690 822 206 ### 173 444 132 898 285 973 492 ### ### 683 523 919 375 727 251 228 407 693 1,000 698 571 415 878 409 975 705 310 781 935 492 967 172 997 961 921 314 897 203 599 286 429 1,010 988 954 99 685 367 199 132 182 236 166 298 159 572 900 107 437 951 363 987 692 824 205 254 176 446 132 912 285 973 496 528 176 680 521 917 375 729 250 230 406 705 1,007 703 588 411 881 411 992 708 312 788 941 488 985 176 992 988 919 320 899 206 605 291 426 1,015 979 948 ### 698 368 ### 133 181 ### 170 301 162 574 924 ### 443 943 367 994 686 818 209 253 178 448 131 930 ### 971 502 523 175 683 532 922 376 722 254 234 409 703 1,004 709 589 420 894 413 1,008 706 314 790 936 487 992 178 988 ### 923 ### 894 ### ### 299 ### 1,010 1,000 941 99 696 ### 199 134 180 239 ### 300 164 587 940 110 444 944 378 1,005 697 ### ### 254 180 451 130 921 285 ### 499 529 174 686 534 914 377 718 258 232 408 702 1,003 712 584 426 919 419 1,013 708 318 787 943 490 1,005 180 1,012 1,000 915 317 888 207 606 304 423 1,011 993 937 100 698 366 200 134 183 237 170 297 164 582 940 111 455 939 376 1,007 704 824 208 257 183 448 130 916 283 979 499 526 175 690 542 906 378 714 261 235 411 702 1,002 725 584 422 912 419 1,026 701 315 784 943 492 997 184 1,039 1,013 913 314 885 211 600 303 424 1,007 992 928 99 697 366 199 137 183 237 171 302 164 592 940 111 456 930 374 1,009 711 825 210 257 184 453 129 918 283 984 504 530 176 685 540 922 390 719 261 235 423 717 1,007 724 587 423 920 420 1,025 697 312 781 940 497 1,024 185 1,056 1,011 918 323 881 209 615 307 423 1,011 1,004 931 100 691 363 198 138 185 239 170 300 ### 591 945 ### 457 923 380 1,004 712 817 213 256 185 461 ### 933 287 986 502 528 ### 679 546 921 392 717 262 240 432 721 1,005 732 595 427 912 418 1,034 695 309 774 933 505 1,014 184 1,065 1,014 920 320 901 212 615 307 422 1,015 1,006 928 99 686 363 200 138 189 237 171 306 165 591 951 113 455 945 380 1,005 716 815 214 257 188 458 132 932 288 994 506 529 175 675 556 914 389 718 265 242 430 722 1,000 725 601 431 903 424 1,030 691 313 780 937 504 1,024 186 1,061 1,017 927 317 928 ### 612 308 426 1,013 1,011 930 ### 688 361 205 140 188 238 173 304 168 592 961 112 452 970 ### 1,009 709 820 213 258 ### 460 134 952 289 1,014 504 530 174 685 562 907 390 728 266 246 412 718 1,004 722 ### 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 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 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 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 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 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 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 ### 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 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 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 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 Region East East East East East East East East East East East East East East East East East East East 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 North North North North North South South South South South South South B Product Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges C Customer Type Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational D Sales Representative 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 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 Y Z AA AB AC AD AE 30-Jun-10 31-Jul-10 31-Aug-10 30-Sep-10 31-Oct-10 30-Nov-10 31-Dec-10 $ 830 $ 468 188 184 340 317 800 495 203 831 829 746 732 240 850 337 896 558 152 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 74 793 647 430 830 805 781 714 1,017 564 767 942 85 466 852 $ 469 ### 185 341 314 ### 491 205 848 835 751 745 243 849 341 ### 557 ### 516 161 906 1,001 932 665 1,044 946 133 ### 645 177 811 762 1,084 1,142 551 589 ### 942 711 ### 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 654 438 835 808 802 712 1,026 563 761 937 87 478 877 $ 466 187 185 342 316 824 506 207 847 829 758 740 241 858 350 900 553 154 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 658 439 828 803 807 709 1,029 571 772 951 87 475 884 464 190 185 346 313 823 508 209 843 829 760 746 239 881 358 903 556 157 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 ### 790 660 440 831 802 811 703 1,031 581 786 944 88 474 A 1 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 Region 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 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 B Product Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Toner Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Ink Jet Cartridges Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper Copy Paper C Customer Type Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental Corporate Corporate Corporate Corporate Educational Educational Educational Educational Governmental Governmental Governmental Governmental D Sales Representative 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 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 Y Z AA AB AC AD AE 30-Jun-10 31-Jul-10 31-Aug-10 30-Sep-10 31-Oct-10 30-Nov-10 31-Dec-10 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 99 799 439 280 226 179 221 160 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 424 730 1,008 747 ### ### 951 391 ### 764 341 ### 972 556 1,048 234 1,104 1,045 972 315 ### 116 518 218 332 1,021 1,049 926 100 803 436 278 ### 181 ### 163 301 168 619 996 109 440 ### 358 1,011 783 887 260 295 ### 500 ### 1,010 294 1,010 516 570 87 649 472 845 412 771 269 ### 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 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 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 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 FIN 615 Excel Dashboard Assignment Print it Green, Inc. is a manufacturer of recycled printing supplies. The company began operations on 10/1/2008 and is dedicated to producing sustainable green printing products. Print it Green, Inc. provides recycled laser toner cartridges, recycled ink jet cartridges as well as cases of recycled copy paper to a variety of customers across the United States. Upper management created several detailed sales forecasts for FY 2010. Now that Print it Green, Inc. is beginning the final quarter of their year, management has requested that a detailed analysis be performed as to whether the company is expected to achieve the forecasted results. Print it Green's Sales Manager has pulled together the detailed sales forecasts for FY 2010 as well as the inception-todate sales data from their accounting system (see the additional tabs below). She has requested that an Excel Dashboard be created to illustrate on a detailed basis whether or not the company is expected to achieve total forecasted sales of $1,006,000 for FY 2010. Using at least three of the Excel functions and/or capabilities that we have learned in class, create an Excel Dashboard that will address the Sales Manager's request for Print it Green, Inc