Cim Marketing Research Proposal - Excel

Document Sample
Cim Marketing Research Proposal - Excel Powered By Docstoc
					Central Team
Project Hours                                                                     Not Included in Reporting
Revision 04-15-03                                                                 Completed and Closed out Activity




                                                                                                                                                                                                      ny
                                                                                                                                                               y




                                                                                                                                                                                                                        on
                                                                                                                                               ex




                                                                                                                                                            or




                                                                                                                                                                                  m




                                                                                                                                                                                                    To




                                                                                                                                                                                                                       Tr
                                                                                                                                             Al




                                                                                                                                                           C




                                                                                                                                                                                Ji
 Task                                                                              Task Running                                        Task     Admin   Task     Admin   Task         Admin   Task     Admin    Task         Admin
  #     Task Name                                                   Duration          Totals    Start                 Finish           Time      Time   Time      Time   Time          Time   Time      Time    Time          Time
   1    EEMP Capstone Project                                       160.81 days          0      ############          6/6/2003 15:30
   2    Kick Off Meeting                                            5 hrs                0      ############          ############
   3    Project Report #2 Preparation                               20 hrs               3      ############          ############                                                             3
   4    Progress Report #2                                          5 hrs                0      3/6/2003 17:00        3/6/2003 17:00
   5    Review Comments - Progress Report #2                        10 hrs               0      3/7/2003 17:00        3/7/2003 17:00
   6    Project Report #3 Preparation                               20 hrs               0      ############          ############
   7    Progress Report #3                                          5 hrs                0      ############          ############
   8    Project Report #4 Preparation                               20 hrs               0      ############          ############
   9    Project Report #4                                           5 hrs                0      ############          ############
  10    Final Meeting                                               20 hrs               0      6/6/2003 12:00        6/6/2003 12:00
  11    Project Proposal                                            10 days             17      ############          ############                                        5             2      12
  12    Executive Summary                                           4 hrs                0      ############          ############
  13    Organizational Background                                   3 hrs                0      ############          ############
  14    Statement of Work                                           3 hrs                0      ############          ############
  15    Problem Statement                                           3 hrs                0      ############          ############
  16    Project Statement                                           3 hrs                0      ############          ############
  17    Main Activities                                             4 hrs                0      ############          ############
  18    Budget                                                      3 hrs                0      ############          ############
  19    Communication Plan                                          4 hrs                0      ############          ############
  20    Project Time Line with Main Activities                      6 hrs                0      ############          ############
  21    Team Meeting #1                                             5 hrs                3      ############          ############                                        1                    1                  1
  22    Progress Report #1                                          0 days               0      11/1/2002 8:00        11/1/2002 8:00
  23    Review Comments - Progress Proposal Report #1               3 hrs               2.5     ############          ############                                        1                   1.5
  24    Team Meeting #2                                             24 hrs              20      ############          ############      6                                 6                    4                  4
  25    Final Time Line Review and Team Approval                    8 hrs                6      ############          ############      1                                 1                    3                  1
  26    Case Study                                                  75.56 days           0      11/6/2002 8:00        ############
  27    Brainstorm                                                  5 days               0      11/6/2002 8:00        ############
  28    Brainstorm Methodologies                                    20 hrs             15.5     11/6/2002 8:00        ############      3.5                               2             1      7           4      3           0.5
  29    Determine Methodologies for Review                          5 hrs                5      ############          ############       1               1                1                    1                  1
  30    Teleconference #1                                           5 hrs                5      ############          ############       1               1                1                    1                  1
  31    Assign Methodologies for in Depth Study                     2.5 hrs            1.25     ############          ############     0.25             0.25             0.25           2     0.25               0.25
  32    Research Criteria and Research Activities                   28 days              0      ############          ############
  33    Establish deliverables (criteria) for methodologies study   15 hrs             7.25     ############          ############      3           1   0.25             0.25           1     0.25               3.5
  34    Research Methodologies per establish criteria               70 hrs              63      ############          ############      16               8         1      8             2      11                20           4.5
  35    Write Report for each Methodology                           15 hrs              20      ############          ############      3                7                6                    1                  3
  36    Present Individuals findings on each Methodology            5 hrs               15      ############          ############      3                3                3                    3                  3
  37    Compile Team Reports                                        10 hrs               5      ############          ############      1                1                1                    1                  1
  38    Develop Continuous Improvement Methodology                  43 days              0      ############          ############
  39    Analyze each methodology and determine best practices       5 hrs               15      ############          ############      3                3                3                    3                  3
  40    Compile best practices and formulate our own CIM            50 hrs              29      ############          ############      12          2    6                                                        11           7
  41    Determine the most appropriate communication method         10 hrs             1.25     ############          ############     0.25         3   0.25             0.25                 0.25               0.25
  42    Complete final Case Study document                          100 hrs             93      ############          ############                  4              4      45            4      48          4                   4
  43    Case Study Approval                                         0 hrs                0      ############          ############
  44    Business Start-up Analysis                                  59.83 days           0      ############          ############
  45    1. Executive Summary                                        2.5 days             0      ############          ############
  46    Business Concept Objectives                                 3 hrs                3      ############          ############      3
  47    Mission                                                     3 hrs                0      ############          ############
  48    Keys to Success                                             3 hrs                0      ############          ############
  49    2. Company Summary                                          1.5 days             0      ############          3/1/2003 15:00




                                                                                                   3808db0b-d63d-4bc8-bb1f-0439d8c24306.xls                                                                    Page 1 of 5
Central Team
Project Hours                                                           Not Included in Reporting
Revision 04-15-03                                                       Completed and Closed out Activity




                                                                                                                                                                                                 ny
                                                                                                                                                          y




                                                                                                                                                                                                                    on
                                                                                                                                      ex




                                                                                                                                                         or




                                                                                                                                                                               m




                                                                                                                                                                                               To




                                                                                                                                                                                                                   Tr
                                                                                                                                    Al




                                                                                                                                                        C




                                                                                                                                                                             Ji
 Task                                                                    Task Running                                         Task     Admin      Task        Admin   Task         Admin   Task     Admin    Task         Admin
  #     Task Name                                         Duration          Totals    Start                 Finish            Time      Time      Time         Time   Time          Time   Time      Time    Time          Time
   1    EEMP Capstone Project                             160.81 days          0      ############          6/6/2003 15:30
  50    Company Ownership                                 1 hr                 5      ############          ############       1                   4
  51    Start-up Summary                                  4 hrs                4      ############          ############       4            2
  52    Company Locations and Facilities                  3 hrs                3      2/28/2003 8:00        ############       3
  53    Future Services (optional)                        5 hrs                5      ############          3/1/2003 15:00     3                   2
  54    3. Products & Services                            5 days               0      ############          3/7/2003 12:30
  55    Service Description                               5 hrs               11      ############          3/4/2003 12:30     5                                                                               6
  56    Competitive comparison                            10 hrs              15      3/4/2003 12:30        3/6/2003 12:30     8                                                                               7
  57    Technology                                        5 hrs                7      3/6/2003 12:30        3/7/2003 12:30     5                                                                               2
  58    4. Market Analysis                                12 days              0      3/7/2003 12:30        ############
  59    The overall market                                15 hrs              26      3/7/2003 12:30        ############       4                   22
  60    Market segments                                   6 hrs               13      ############          ############       1                   12
  61    Target market and customers                       10 hrs              15      ############          ############       3                   12
  62    Competitive Analysis                              6.5 days             0      ############          ############
  63    Industry Overview and Opportunities               8 hrs               8.5     ############          ############       1                                       2                    2.5                3
  64    Competition and Buying Patterns                   10 hrs               0      ############          ############
  65    Threats and risks                                 5 hrs                2      ############          ############                                                                                       2
  66    Main competition                                  6 hrs                0      ############          ############
  67    5. Strategy and Implementation                    12 days              0      ############          ############
  68    Competitive Edge                                  5 hrs                5      ############          ############       3                                                                               2
  69    Marketing strategy                                5.31 days            0      ############          4/2/2003 15:30
  70     Positioning Statement                            8 hrs                5      ############          ############       3                                                                               2
  71     Pricing Strategy                                 10 hrs               4      ############          ############       4
  72     Promotion Strategy                               10 hrs               1      ############          4/2/2003 15:30                                                                                     1
  73    Sales Strategy                                    15 hrs              18      4/2/2003 15:30        4/5/2003 15:30     17                                                                              1
  74    Operation Strategy                                3.5 days             0      4/5/2003 15:30        ############
  75    Key personnel                                     2 hrs                0      4/5/2003 15:30        4/8/2003 12:30
  76    Organizational structure                          10 hrs               1      4/8/2003 12:30        ############                                                                                       1
  77    Milestones                                        5 hrs                2      4/5/2003 15:30        4/8/2003 15:30     2
  78    6. Financial Plan                                 16.33 days           0      ############          5/2/2003 15:36
  79    Important Assumptions                             8 hrs                0      ############          ############                   0.15
  80    Key Financial Indicators (optional)               0.1 hrs              0      ############          ############
  81    Break-even Analysis                               15 hrs               0      ############          ############                   0.15
  82    Projected Profit and Loss                         15 hrs               0      ############          ############                   0.15
  83    Projected Cash Flow                               15 hrs               2      ############          ############                   0.15                                                                2
  84    Projected Balance Sheet                           15 hrs               0      ############          ############                   0.15
  85    Business Ratios Analysis                          15 hrs               0      ############          5/2/2003 15:36                 0.15
  86    Business Start-up Analysis Report                 50 hrs               2      5/2/2003 15:36        ############                   0.15                                                                2
  87    Business Start-up Analysis Approval               0 hrs                0      ############          ############                   0.15
  88    Validation Study                                  5 days               0      ############          ############
  89    Establish validation objectives                   2.5 hrs              1      ############          ############                                               1
  90    Establish validation criteria                     2.5 hrs              0      ############          ############
  91    Document the next steps for Validation Study      20 hrs              28      ############          ############                                              11.5                  16.5
  92    Final EEMP Capstone Project Report Preparation    50 hrs              12      ############          6/6/2003 15:36                                             6                     6
  93    Final EEMP Capstone Project Report Presentation   0 days               0       6/6/2003 8:00          6/6/2003 8:00

                                                                             505.25                                           124          13.2   82.75         5     99.25         10     113.25     8       86           16




                                                                                         3808db0b-d63d-4bc8-bb1f-0439d8c24306.xls                                                                           Page 2 of 5
Central Team
Project Hours                                                                    Not Included in Reporting
Revision 12-16-02




                                                                                                                                                                                                ny
                                                                                                                                                            y




                                                                                                                                                                                                                   on
                                                                                                                                          ex




                                                                                                                                                         or




                                                                                                                                                                               m




                                                                                                                                                                                              To




                                                                                                                                                                                                                  Tr
                                                                                                                                        Al




                                                                                                                                                        C




                                                                                                                                                                             Ji
 Task                                                                             Task Running                                    Task       Admin   Task     Admin   Task         Admin   Task   Admin    Task         Admin
  #     Task Name                                                    Duration        Totals    Start             Finish           Time        Time   Time      Time   Time          Time   Time    Time    Time          Time
  26    Case Study                                                  75.56 days          0      11/6/2002 8:00    ############
  27    Brainstorm                                                    5 days            0      11/6/2002 8:00    ############
  28    Brainstorm Methodologies                                         20           15.5     11/6/2002 8:00    ############      3.5                                 2             1      7        4       3           0.5
  29    Determine Methodologies for Review                               5              5      ############      ############       1                 1                1                    1                1
  30    Teleconference #1                                                5              5      ############      ############       1                 1                1                    1                1
  31    Assign Methodologies for in Depth Study                         2.5           1.25     ############      ############     0.25               0.25             0.25           2     0.25             0.25
  32    Research Criteria and Research Activities                    28 days            0      ############      ############
  33    Establish deliverables (criteria) for methodologies study        15           7.25     ############      ############      3           1     0.25             0.25           1     0.25             3.5
  34    Research Methodologies per establish criteria                    70            63      ############      ############      16                 8         1      8             2      11              20           4.5
  35    Write Report for each Methodology                                15            20      ############      ############      3                  7                6                    1                3
  36    Present Individuals findings on each Methodology                 5             15      ############      ############      3                  3                3                    3                3
  37    Compile Team Reports                                           10 hrs                  ############      ############
  38    Develop Continuous Improvement Methodology                   43 days            0      ############      ############
  39    Analyze each methodology and determine best practices          5 hrs            0      ############      ############
  40    Compile best practices and formulate our own CIM               50 hrs           0      ############      ############
  41    Determine the most appropriate communication method            10 hrs           0      ############      ############
  42    Complete final Case Study document                            100 hrs           0      ############      ############
  43    Case Study Approval                                            0 hrs            0      ############      ############

                                                      TOTALS          137.5            132                                        30.75        1     20.5       1     21.5           6     24.5      4     34.75          5
                                                    Difference         5.5       Positive Variance




                                                                                     As of Progress Report #1




                                                                                                  3808db0b-d63d-4bc8-bb1f-0439d8c24306.xls                                                                Page 3 of 5
Project Hours                                                                    Not Included in Reporting
Revision 03-03-03                                                                Completed and Closed out Activity




                                                                                                                                                                                                       ny
                                                                                                                                                                y




                                                                                                                                                                                                                         on
                                                                                                                                              ex




                                                                                                                                                              or




                                                                                                                                                                                    m




                                                                                                                                                                                                     To




                                                                                                                                                                                                                        Tr
                                                                                                                                            Al




                                                                                                                                                             C




                                                                                                                                                                                  Ji
 Task                                                                             Task Running                                        Task     Admin    Task       Admin   Task         Admin   Task    Admin    Task         Admin
  #     Task Name                                                    Duration        Totals    Start                 Finish           Time      Time    Time        Time   Time          Time   Time     Time    Time          Time
  26    Case Study                                                  75.56 days          0      11/6/2002 8:00        ############
  27    Brainstorm                                                    5 days            0      11/6/2002 8:00        ############
  28    Brainstorm Methodologies                                         20           15.5     11/6/2002 8:00        ############      3.5                                  2             1      7          4      3           0.5
  29    Determine Methodologies for Review                               5              5      ############          ############       1                1                  1                    1                 1
  30    Teleconference #1                                                5              5      ############          ############       1                1                  1                    1                 1
  31    Assign Methodologies for in Depth Study                         2.5           1.25     ############          ############     0.25              0.25               0.25           2     0.25              0.25
  32    Research Criteria and Research Activities                    28 days            0      ############          ############
  33    Establish deliverables (criteria) for methodologies study        15           7.25     ############          ############      3           1    0.25               0.25           1     0.25              3.5
  34    Research Methodologies per establish criteria                    70            63      ############          ############      16                8           1      8             2      11               20           4.5
  35    Write Report for each Methodology                                15            20      ############          ############      3                 7                  6                    1                 3
  36    Present Individuals findings on each Methodology                 5             15      ############          ############      3                 3                  3                    3                 3
  37    Compile Team Reports                                             10             5      ############          ############      1                 1                  1                    1                 1
  38    Develop Continuous Improvement Methodology                   43 days            0      ############          ############
  39    Analyze each methodology and determine best practices            5             15      ############          ############      3                 3                  3                    3                 3
  40    Compile best practices and formulate our own CIM                 50            29      ############          ############      12          2     6                                                         11           7
  41    Determine the most appropriate communication method              10           1.25     ############          ############     0.25         3    0.25               0.25                 0.25              0.25
  42    Complete final Case Study document                              100            93      ############          ############                  4                 4      45            4      48         4                   4
  43    Case Study Approval                                              0              0      ############          ############
  44    Business Start-up Analysis                                  59.83 days          0      ############          ############
  45    1. Executive Summary                                         2.5 days           0      ############          ############
  46    Business Concept Objectives                                      3              3      ############          ############      3
  47    Mission                                                          3              0      ############          ############
  48    Keys to Success                                                  3              0      ############          ############
  49    2. Company Summary                                           1.5 days           0      ############          3/1/2003 15:00
  50    Company Ownership                                                1              5      ############          ############      1                 4
  51    Start-up Summary                                                 4              4      ############          ############      4           2
  52    Company Locations and Facilities                                 3              3      2/28/2003 8:00        ############      3
  53    Future Services (optional)                                       5              2      ############          3/1/2003 15:00                      2
  54    3. Products & Services                                        5 days            0      ############          3/7/2003 12:30
  55    Service Description                                            5 hrs            4      ############          3/4/2003 12:30                                                                                4
  56    Competitive comparison                                        10 hrs            2      3/4/2003 12:30        3/6/2003 12:30                                                                                2
  57    Technology                                                     5 hrs            0      3/6/2003 12:30        3/7/2003 12:30
  58    4. Market Analysis                                           12 days            0      3/7/2003 12:30        ############
  59    The overall market                                            15 hrs            9      3/7/2003 12:30        ############                        9
  60    Market segments                                                6 hrs            0      ############          ############
  61    Target market and customers                                   10 hrs            0      ############          ############

                                                      TOTALS          334.5           307.25                                           58          12   45.75        5     70.75         10     76.75       8     56           16
                                                    Difference        27.25




                              As of Progress Report #2



                                                                                                  3808db0b-d63d-4bc8-bb1f-0439d8c24306.xls                                                                      Page 4 of 5
Central Team
Project Hours
Revision 04-15-03


         Project Time     Time
            Totals        (hrs)                                  Project Time Distribution
             Alex          124
             Cory         82.75
              Jim         99.25
             Tony        113.25
             Tron          86

                                                                             Tron
                                                                                         Alex
                                                                             17%
                                                                                         25%

                                                                          Tony
                                                                          22%              Cory
                                                                                           16%
                                                                                   Jim
                                                                                   20%




                                                                  Alex     Cory     Jim     Tony    Tron



        Administrative   Time
         Time Totals     (hrs)
            Alex          13.2
            Cory            5
             Jim           10
            Tony            8
            Tron           16




                                                              Administrative Time Distribution




                                                                            Tron          Alex
                                                                            31%           25%


                                                                             Tony                  Cory
                                                                             15%     Jim           10%
                                                                                     19%




                                                                   Alex     Cory    Jim     Tony    Tron




                                  3808db0b-d63d-4bc8-bb1f-0439d8c24306.xls                                 Page 5 of 5

				
DOCUMENT INFO
Description: Cim Marketing Research Proposal document sample