Required information Before you begin this part of the project, you should create a new blank Word document or PPT file where you will record your screenshots and save the file and name it Term Project Part 2 Your group Your last name first name Note The tools presented in this project periodically change Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect The following information applies to Part 2 requirements 1 2 Case Summary As Slinte's management evaluates different aspects of their business, they are increasingly interested in identifying areas where they can track performance and quickly determine where improvement should be made The managers have asked you to develop a dashboard to help track different dimensions of the Balanced Scorecard including Financial, Process, Growth, and Customer measures Data Lab 7 2 Slainte Sales zip 128K Zip 130K Excel OQ1 For the year 2020, Qtr 1, in the month of March, what is management's expected profit margin for each product Management's expected profit margin someone please answer this help Required information Before you begin this part of the project, you should create a new blank Word document or PPT file where you will record your screenshots and save the file and name it Term Project Part 2 Your group Your last name first name Note The tools presented in this project periodically change Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect The following information applies to Part 2 requirements 1 2 Case Summary As SIlnte's management evaluates different aspects of their business, they are increasingly interested in identifying areas where they can track performance and quickly determine where improvement should be made The managers have asked you to develop a dashboard to help track different dimensions of the Balanced Scorecard including Financial, Process, Growth, and Customer measures Data Lab 7 2 Slainte Sales zir 128K Zip 130K Excel DQ1 For the year 2020 , Qtr 1 , in the month of March, what is management's expected profit margin for each product OQ2 For the year 2020 , Qtr 1 , in the month of March, what is the average revenue threshold for our best customers OQ3 For the year 2020, Qtr 1, in the month of March, what color should you use to show favorable metrics Blue Green Red Yellow begin tabular c c c c c c c c hline Sales Order ID Sales Order Date Sales Empl Customer Account IC hipping C proval ES Ship Date hline 20010 11 3 19 1015 2033 1000264 23 4 1004 11 7 19 hline 20014 11 5 19 1015 2004 1000264 58 98 1004 11 15 19 hline 20015 11 5 19 1015 2042 1000264 14 19 1004 11 9 19 hline 20022 11 7 19 1015 2033 1000264 27 43 1004 11 13 19 hline 20024 11 8 19 1015 2033 1000264 34 33 1004 11 11 19 hline 20030 11 11 19 1015 2045 1000264 10 93 1004 11 17 19 hline 20042 11 16 19 1015 2033 1000264 30 33 1004 11 22 19 hline 20044 11 16 19 1015 2033 1000264 36 2 1004 11 20 19 hline 20054 11 20 19 1015 2045 1000264 29 2 1004 11 26 19 hline 20059 11 22 19 1015 2060 1000264 64 53 1004 11 24 19 hline 20071 11 25 19 1015 2004 1000264 58 53 1004 11 29 19 hline 20078 11 28 19 1015 2045 1000264 33 17 1004 12 2 19 hline 20103 12 5 19 1015 2060 1000264 77 91 1004 12 9 19 hline 20113 12 10 19 1015 2004 1000264 68 58 1004 12 15 19 hline 20115 12 11 19 1015 2045 1000264 32 09 1004 12 19 19 hline 20129 12 17 19 1015 2060 1000264 69 15 1004 12 23 19 hline 20142 12 20 19 1015 2042 1000264 17 8 1004 12 25 19 hline 20157 12 23 19 1015 2033 1000264 39 87 1004 12 27 19 hline 20159 12 24 19 1015 2060 1000264 54 13 1004 1 1 20 hline 20172 12 28 19 1015 2042 1000264 22 53 1004 1 3 20 hline 20181 12 31 19 1015 2060 1000264 57 05 1004 1 3 20 hline 20186 1 2 20 1015 2004 1000264 53 56 1004 1 5 20 hline 20220 1 12 20 1015 2004 1000264 67 12 1004 1 15 20 hline 20259 1 24 20 1015 2060 1000264 59 15 1004 1 28 20 hline 20271 1 28 20 1015 2060 1000264 69 05 1004 2 1 20 hline 20278 1 30 20 1015 2060 1000264 77 64 1004 2 2 20 hline 20280 1 30 20 1015 2040 1000264 42 7 1004 2 2 20 hline 20287 2 1 20 1015 2040 1000264 31 73 1004 2 3 20 hline 20297 2 6 20 1015 2040 1000264 51 35 1004 2 11 20 hline 20303 2 8 20 1015 2040 1000264 38 78 1004 2 13 20 hline 20308 2 11 20 1015 2004 1000264 67 92 1004 2 17 20 hline 20320 2 14 20 1015 2042 1000264 13 41 1004 2 19 20 hline 20340 2 23 20 1015 2033 1000264 23 8 1004 2 28 20 hline 20349 2 25 20 1015 2033 1000264 33 06 1004 3 2 20 hline 20357 2 27 20 1015 2045 1000264 42 49 1004 3 3 20 hline 20358 2 27 20 1015 2045 1000264 23 78 1004 3 4 20 hline 20361 2 28 20 1015 2062 1000264 59 02 1004 3 5 20 hline end tabular begin tabular c c c c c c c c hline 8 C D L r H hline 20365 2 28 20 1015 2042 1000264 28 26 1004 3 6 20 hline 20367 2 28 20 1015 2062 1000264 51 04 1004 3 7 20 hline 20373 3 1 20 1015 2004 1000264 77 06 1004 3 6 20 hline 20378 3 3 20 1015 2040 1000264 44 54 1004 3 6 20 hline 20382 3 4 20 1015 2060 1000264 59 29 1004 3 9 20 hline 20387 3 5 20 1015 2004 1000264 55 16 1004 3 12 20 hline 20403 3 9 20 1015 2040 1000264 27 03 1004 3 16 20 hline 20416 3 13 20 1015 2040 1000264 28 04 1004 3 16 20 hline 20441 3 19 20 1015 2062 1000264 56 26 1004 3 24 20 hline 20466 3 28 20 1015 2040 1000264 34 04 1004 4 3 20 hline 20473 3 29 20 1015 2040 1000264 19 13 1004 4 10 20 hline 20475 3 31 20 1015 2040 1000264 28 8 1004 4 4 20 hline 20478 4 2 20 1015 2033 1000264 56 58 1004 4 7 20 hline 20490 4 6 20 1015 2062 1000264 72 34 1004 4 10 20 hline 20491 4 7 20 1015 2060 1000264 65 52 1004 4 12 20 hline 20500 4 9 20 1015 2033 1000264 40 98 1004 4 15 20 hline 20503 4 10 20 1015 2062 1000264 48 18 1004 4 14 20 hline 20531 4 16 20 1015 2040 1000264 17 23 1004 4 21 20 hline 20532 4 17 20 1015 2060 1000264 56 97 1004 4 21 20 hline 20535 4 19 20 1015 2045 1000264 25 85 1004 4 24 20 hline 20536 4 19 20 1015 2060 1000264 59 16 1004 4 23 20 hline 20556 4 24 20 1015 2042 1000264 18 7 1004 4 29 20 hline 20559 4 25 20 1015 2042 1000264 27 73 1004 4 29 20 hline 20002 11 1 19 1013 2031 1000264 144 63 1004 11 5 19 hline 20009 11 2 19 1013 2005 1000264 146 93 1004 11 8 19 hline 20019 11 7 19 1013 2027 1000264 115 78 1004 11 12 19 hline 20027 11 9 19 1013 2049 1000264 107 74 1004 11 14 19 hline 20028 11 9 19 1013 2005 1000264 127 61 1004 11 17 19 hline 20062 11 22 19 1013 2001 1000264 104 19 1004 12 1 19 hline 20064 11 23 19 1013 2027 1000264 102 87 1004 11 26 19 hline 20072 11 26 19 1013 2027 1000264 101 66 1004 12 6 19 hline 20073 11 26 19 1013 2031 1000264 112 18 1004 12 3 19 hline 20074 11 26 19 1013 2031 1000264 107 06 1004 12 1 19 hline 20120 12 12 19 1013 2031 1000264 133 29 1004 12 14 19 hline 20128 12 17 19 1013 2001 1000264 108 14 1004 12 23 19 hline 20144 12 20 19 1013 2005 1000264 139 67 1004 12 31 19 hline 20151 12 22 19 1013 2049 1000264 105 3 1004 12 25 19 hline end tabular

Question

Required information Before you begin this part of the project, you should create a new blank Word document or PPT file where you will record your screenshots and save the file and name it  Term Project Part 2  Your group   Your last name first name  Note  The tools presented in this project periodically change  Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect   The following information applies to Part 2   requirements 1   2  Case Summary  As Slinte's management evaluates different aspects of their business, they are increasingly interested in identifying areas where they can track performance and quickly determine where improvement should be made  The managers have asked you to develop a dashboard to help track different dimensions of the Balanced Scorecard including Financial, Process, Growth, and Customer measures  Data  Lab 7 2 Slainte Sales zip   128K Zip 130K Excel OQ1  For the year 2020, Qtr 1, in the month of March, what is management's expected profit margin for each product  Management's expected profit margin   someone please answer this help Required information Before you begin this part of the project, you should create a new blank Word document or PPT file where you will record your screenshots and save the file and name it  Term Project Part 2  Your group   Your last name first name  Note  The tools presented in this project periodically change  Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect   The following information applies to Part 2   requirements 1  2  Case Summary  As SIlnte's management evaluates different aspects of their business, they are increasingly interested in identifying areas where they can track performance and quickly determine where improvement should be made  The managers have asked you to develop a dashboard to help track different dimensions of the Balanced Scorecard including Financial, Process, Growth, and Customer measures  Data  Lab 7 2 Slainte Sales zir   128K Zip   130K Excel DQ1  For the year 2020 , Qtr 1 , in the month of March, what is management's expected profit margin for each product  OQ2  For the year 2020 , Qtr 1 , in the month of March, what is the average revenue threshold for our best customers  OQ3  For the year 2020, Qtr 1, in the month of March, what color should you use to show favorable metrics  Blue Green Red Yellow  begin tabular   c c c c c c c c    hline Sales Order ID   Sales Order Date   Sales Empl   Customer    Account IC   hipping C   proval ES   Ship Date     hline 20010   11 3 19   1015   2033   1000264   23 4   1004   11 7 19     hline 20014   11 5 19   1015   2004   1000264   58 98   1004   11 15 19     hline 20015   11 5 19   1015   2042   1000264   14 19   1004   11 9 19     hline 20022   11 7 19   1015   2033   1000264   27 43   1004   11 13 19     hline 20024   11 8 19   1015   2033   1000264   34 33   1004   11 11 19     hline 20030   11 11 19   1015   2045   1000264   10 93   1004   11 17 19     hline 20042   11 16 19   1015   2033   1000264   30 33   1004   11 22 19     hline 20044   11 16 19   1015   2033   1000264   36 2   1004   11 20 19     hline 20054   11 20 19   1015   2045   1000264   29 2   1004   11 26 19     hline 20059   11 22 19   1015   2060   1000264   64 53   1004   11 24 19     hline 20071   11 25 19   1015   2004   1000264   58 53   1004   11 29 19     hline 20078   11 28 19   1015   2045   1000264   33 17   1004   12 2 19     hline 20103   12 5 19   1015   2060   1000264   77 91   1004   12 9 19     hline 20113   12 10 19   1015   2004   1000264   68 58   1004   12 15 19     hline 20115   12 11 19   1015   2045   1000264   32 09   1004   12 19 19     hline 20129   12 17 19   1015   2060   1000264   69 15   1004   12 23 19     hline 20142   12 20 19   1015   2042   1000264   17 8   1004   12 25 19     hline 20157   12 23 19   1015   2033   1000264   39 87   1004   12 27 19     hline 20159   12 24 19   1015   2060   1000264   54 13   1004   1 1 20     hline 20172   12 28 19   1015   2042   1000264   22 53   1004   1 3 20     hline 20181   12 31 19   1015   2060   1000264   57 05   1004   1 3 20     hline 20186   1 2 20   1015   2004   1000264   53 56   1004   1 5 20     hline 20220   1 12 20   1015   2004   1000264   67 12   1004   1 15 20     hline 20259   1 24 20   1015   2060   1000264   59 15   1004   1 28 20     hline 20271   1 28 20   1015   2060   1000264   69 05   1004   2 1 20     hline 20278   1 30 20   1015   2060   1000264   77 64   1004   2 2 20     hline 20280   1 30 20   1015   2040   1000264   42 7   1004   2 2 20     hline 20287   2 1 20   1015   2040   1000264   31 73   1004   2 3 20     hline 20297   2 6 20   1015   2040   1000264   51 35   1004   2 11 20     hline 20303   2 8 20   1015   2040   1000264   38 78   1004   2 13 20     hline 20308   2 11 20   1015   2004   1000264   67 92   1004   2 17 20     hline 20320   2 14 20   1015   2042   1000264   13 41   1004   2 19 20     hline 20340   2 23 20   1015   2033   1000264   23 8   1004   2 28 20     hline 20349   2 25 20   1015   2033   1000264   33 06   1004   3 2 20     hline 20357   2 27 20   1015   2045   1000264   42 49   1004   3 3 20     hline 20358   2 27 20   1015   2045   1000264   23 78   1004   3 4 20     hline 20361   2 28 20   1015   2062   1000264   59 02   1004   3 5 20     hline  end tabular   begin tabular   c c c c c c c c    hline   8   C   D   L   r     H     hline 20365   2 28 20   1015   2042   1000264   28 26   1004   3 6 20     hline 20367   2 28 20   1015   2062   1000264   51 04   1004   3 7 20     hline 20373   3 1 20   1015   2004   1000264   77 06   1004   3 6 20     hline 20378   3 3 20   1015   2040   1000264   44 54   1004   3 6 20     hline 20382   3 4 20   1015   2060   1000264   59 29   1004   3 9 20     hline 20387   3 5 20   1015   2004   1000264   55 16   1004   3 12 20     hline 20403   3 9 20   1015   2040   1000264   27 03   1004   3 16 20     hline 20416   3 13 20   1015   2040   1000264   28 04   1004   3 16 20     hline 20441   3 19 20   1015   2062   1000264   56 26   1004   3 24 20     hline 20466   3 28 20   1015   2040   1000264   34 04   1004   4 3 20     hline 20473   3 29 20   1015   2040   1000264   19 13   1004   4 10 20     hline 20475   3 31 20   1015   2040   1000264   28 8   1004   4 4 20     hline 20478   4 2 20   1015   2033   1000264   56 58   1004   4 7 20     hline 20490   4 6 20   1015   2062   1000264   72 34   1004   4 10 20     hline 20491   4 7 20   1015   2060   1000264   65 52   1004   4 12 20     hline 20500   4 9 20   1015   2033   1000264   40 98   1004   4 15 20     hline 20503   4 10 20   1015   2062   1000264   48 18   1004   4 14 20     hline 20531   4 16 20   1015   2040   1000264   17 23   1004   4 21 20     hline 20532   4 17 20   1015   2060   1000264   56 97   1004   4 21 20     hline 20535   4 19 20   1015   2045   1000264   25 85   1004   4 24 20     hline 20536   4 19 20   1015   2060   1000264   59 16   1004   4 23 20     hline 20556   4 24 20   1015   2042   1000264   18 7   1004   4 29 20     hline 20559   4 25 20   1015   2042   1000264   27 73   1004   4 29 20     hline 20002   11 1 19   1013   2031   1000264   144 63   1004   11 5 19     hline 20009   11 2 19   1013   2005   1000264   146 93   1004   11 8 19     hline 20019   11 7 19   1013   2027   1000264   115 78   1004   11 12 19     hline 20027   11 9 19   1013   2049   1000264   107 74   1004   11 14 19     hline 20028   11 9 19   1013   2005   1000264   127 61   1004   11 17 19     hline 20062   11 22 19   1013   2001   1000264   104 19   1004   12 1 19     hline 20064   11 23 19   1013   2027   1000264   102 87   1004   11 26 19     hline 20072   11 26 19   1013   2027   1000264   101 66   1004   12 6 19     hline 20073   11 26 19   1013   2031   1000264   112 18   1004   12 3 19     hline 20074   11 26 19   1013   2031   1000264   107 06   1004   12 1 19     hline 20120   12 12 19   1013   2031   1000264   133 29   1004   12 14 19     hline 20128   12 17 19   1013   2001   1000264   108 14   1004   12 23 19     hline 20144   12 20 19   1013   2005   1000264   139 67   1004   12 31 19     hline 20151   12 22 19   1013   2049   1000264   105 3   1004   12 25 19     hline  end tabular

Accepted Answer

The Answer is in the image, click to view ...

Question

Required information Before you begin this part of the project, you should create a new blank Word document or PPT file where you will record

Step by Step Solution

Step: 1

Get Instant Access with AI-Powered Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question