Page 16 - Customize-Project-Plan-by-tailoring-Smartsheet
P. 16

Customize your Project Plan
                                                                                                            
                                                                               by tailoring Smartsheet


                   6.3. Example Scenario / Case Study


               Because this subject about licenses, permissions and roles, is of theoretical art and sounds often more
               confusing than helping, I would like to give you rather a practical example.

               Let's assume we are a company, called Top Equip Automotive Ltd. We have 800 employees at our sites,
               and we develop and manufacture parts for the automotive industry.

               A few months ago, a major project failed terribly, the most important customer complained, and the
               CEO got mad. They brought in some consultants to interrogate the situation. They found out that at
               R&D was already a "Process" defined how to handle projects. It was a plain Work-Breakdown-Structure
               (WBS), but mainly for the reason just to show at audits. In truth, the project teams just went ahead on
               gut-feeling because they said they have already enough experience to know how to proceed. The con-
               sultants were not happy with this kind of "Culture", how to handle project management. Concerning
               "IT-Tools", it turned out that all project managers had the outdated Microsoft Project 2010 installed
               on the hard drives of their computers, but it was not in high regard because they had never been
               trained about. Concerning on-going projects, it turned out that there were thirty-seven current pro-
               jects, handled by seven project managers. On a whiteboard was the staff in an org-chart visualized.
               Here is the picture.


                      Customer:                                                          CEO / Senior Manage-
                      Project Manager                                                    ment

                                                Sales               Product Designer
                        Customer:                         Project Manager
                        Purchasing                                           Prototype Shop
                                        Cost Estimator

                         Customer:
                         Quality                        Logistics              AQP Advanced Quality Planning
                                    Controlling                  Manufacturing
                       Customer:                                                         SQE Supplier Quality
                       Logistics
                                              Process Engineer                           Engineer
                                                                          Purchasing
                                                           Material Disposition


                                                    Supplier(s)


               There was then a discussion about the requirements for a modern software. The demands were, to
               have an easy-to-handle project management tracking software tool available. There were pros and
               cons about Microsoft Project versus Smartsheet. Senior Management as well the consultants opted in
               the end for Smartsheet, because it was kind of spreadsheet looking and formulas could be easily built
               up. Not the many features counted, but rather if it seemed to handle it without difficulties.

               Now it was time to talk about plans and licenses. As plan was picked "Business". The pricing for a
               license was $19 per month. First, there was some confusion at Senior Management. They were con-
               cerned about their projects, stored in Microsoft Project 2010. Main question was: "Can we transfer



               © Hans Porzel, 10/2025 | CAPM® (PMI), PSM I® (Scrum.org), Smartsheet Prod. Cert® 2020                                             Page 16 / 209 pages
   11   12   13   14   15   16   17   18   19   20   21