Tuesday, June 25, 2013

MS Project 2013

Dear C Levels,

you have tasked me with evaluating the need to purchase and implement MS Project in our department. Every year we undertake a lot of projects that sometimes fail to meet deadlines and set forth expectations. Managing people  timing, progress, budgets and changes in scope and deliverable is not an easy task especially considering the fact that out project teams are made of employees who, apart from the project participation, still have their full time day-to-day jobs. I believe that our teams would benefit from having an application that will facilitate the structure and timing of various project activities.

Let me start by briefly introducing MS Project, its functionality and cost of licensing. According to MS website and my personal experience, the application allows a user or a group of users, to effectively manage projects by tracking activities, deadlines, milestones and timing of each one of the decisions. In order to promote collaboration  users can utilize Office 365 or SharePoint functionality to work from virtually anywhere. With that in mind, we could take advantage of our SharePoint sites to facilitate user collaboration between our teams. MS Project allows users to easily plan and manage a project by focusing on what matters most, selecting most effective and efficient actions, utilizing templates that fit particular project and staying organized by being able to quickly access all related project files. It appears as though our project teams could become better organized by being able to stay in control of the project plan no matter how big the project turns out to be. We often change the scope by including more value added activities that can improve our processes. MC Project can facilitate those changes and help with planning future actions. Our planning process will benefit from the flexibility offered by the application as MC Project tools, such as Team Planner, help discover timing and availability problems and amend them before they will impact the schedule.With this software we could support our recommendations and offer immediate insight into planning, resource allocation, cost effectiveness and other details about our projects. Various graphs and reports can help us visualize our project's progress and deliver stellar presentations to the Financial Leadership Team.  Furthermore, as noted above, since this software is developed by Microsoft, we would have no problems using it with other Office products, SharePoint and Lync to enhance collaboration capabilities between project teams. Overall, based on my understanding of the features, implementing MS Project would improve the effectiveness and efficiency of our project teams. 

With regards to the cost, a single license for MS Project Professional 2013 runs at about $1,159.99, whereas the Project Standard 2013 is $589.99. We can take advantage of the Microsoft Open License Business software, which is a volume program designed for customers who order as few a five licenses. After the initial order, we can benefit from volume pricing for all licenses for the remainder of Open License Authorization. In this case we can save on estimated retail prices by placing an initial order for five or more licenses, or one server license, and save around 25% on each license. Should we decide to purchase 10 licenses for each one of our Project Management office team members, we are looking at an approximate investment of less than $10,000. Based on the review of benefits associated with the implementation of this application, I believe this is an investment that will produce immediate benefits to our teams.


In order to become more familiar with the features of the software and provide you with a first hand user experience information I started using MS Project to track the timing, requirements and milestones associated with the potential buy out of my mother's house, which was severely damaged during Hurricane Sandy. Ever since the disaster stroke I struggled with managing the documentation and deadlines associated with various Local and Federal Government requirements aimed at successful Buy Out application. Since the approval has been obtained there are a number of requirements, meetings, activities and deadlines to meet in order to comply with the project requirements and close on sale of the property to Department of Environmental Protection. I have been continuously entering various activities and timing into the software, assigning milestones and associating the sequencing of dependent activities. 


Although my use of MS Project was rather simplistic and limited, it made me realize how we can take advantage of this software in our work environment and fully capitalize on implementation of its functionality. The application made my process easier and helps me keep all activities on track while clearly mapping each requirement. The learning curve associated with the use of MS Project should not be high as the application is rather intuitive and all of our users are very familiar with all Office products. I believe we can benefit from MS Project functionality on each of our projects, and I therefore recommend purchasing 10 user licenses for each of our Project Management Office team members.

Please do not hesitate to contact me should you have any questions.
Best regards,
MKO

Sunday, June 16, 2013

Opening Pandora's Box - Reflection

Dear C-Levels,

We contracted the consulting company, Capgemini, to help us develop some ideas that would turn our revenues into profits. We are all cognizant of the fact that while our customer base is growing rapidly, we are not profitable. Please find this memo as my recommendation regarding future actions of our company.

First and foremost, I agree with the consultants that we need to double our advertising since among our competitor, our advertising rate is the lowest. This will allow us to double the advertising revenue. Advertising has always been the most significant revenue source for Pandora and it is only logical to capitalize on this idea.  It seams as though charging customers a fee for our services with a built-in benefit of avoiding advertisements will also bring us the much needed revenue. The consultants encourage Pandora to fight the royalty structure and advocate for a less burdensome model with a level laying field between traditional AM/FM radio and Internet and satellite alternatives. Since royalty expense is our largest variable cost, deducing it will yield greater revenue return given the large customer base. 

Secondly, I have always been a supporter of artists, especially musicians. I like the 'open mic' and 'battle of the bands' idea that the consultants presented. I would only suggest to limit this option to artists already featured on Pandora. This will ensure that the songs that appear in the contest can be accessed by our customers. I would propose to implement my idea of charging artists for the opportunity to start up their career by utilizing and reaching out to Pandora's customers. Our team works very hard and spends significant time decoding the music and assigning it the musical DNA. I believe that a nominal fee between $100-$200, depending on the number of tracks on the CD, requested from a new artist would be a fair price, especially when compared with the $350,000 charged by the labels. This option would bring us anywhere between $1,560,000 and $3,120,000 based on a conservative number of 300 CDs received from new artists each week (300 x 52 weeks in the year x $ fee per CD). Furthermore, we could incorporate the artists social media sites and the chat function discussed by the consultants into their standard information displayed when Pandora plays their song. This would promote the artist and help start their career.  

Last but not least, we need to make our service more accessible to our users. I second consultants recommendation that we need to work with system-on-chip manufacturers to embed Pandora technologies on the chips they sell to consumer electronics manufacturers like Samsung, Sony, Nokia and Panasonic to bridge the online and offline experience. We also need to expand to portable radio devices. Furthermore, I am truly convinced that automating a portion of our genome development process would yield significant benefits not only to our company but mostly to our customers. We would be able to encode the music much faster and therefore increase our music database substantially. We would be able to offer much more versatile musical menu that could appeal to a broader customer base. This option, while not necessarily needed to be applied in the short term, may be a good starting point aiming at increasing our operating effectiveness and growing our customer base. I find it particularly intriguing when contemplating the topic of globalization raised by the consulting team. I can only imagine the possibilities and the amount of work required to decode the music made by artists from other countries. While we do have some of them represented in our musical library the potential here is enormous!

We have created a great company that has a lot of potential and satisfies the musical needs of the customers. I am convinced that by implementing a few ideas described above we can grow as a company, be profitable and sustainable, as well as continue to increase our customer base by offering a more customized and versatile musical experience.

Best regards,
MKO       

Friday, June 14, 2013

Opening Pandora's Box

Problem/Issue Statement
Pandora is facing multiple issues, the essence of which appears to be the inability to turn revenue into profit. There are multiple symptoms of the problem including the fact that at the current growth rate, the company will exhaust its cash by the end of the following year. The chief strategist and founder of Pandora.com, Tim Westergren needs to decide whether the company should take a more conservative path, pull back on the growth levers such as search engine marketing (SEM) and general marketing spend, slow the headcount growth, and raise the minimal amount of new investment to reach an exit, potentially through acquisition. Or should it go full force, fan the flames of viral growth, top out SEM, hire aggressively, and take advantage of the first-mover advantage. Another symptom of the problem recognized by Westergren was the fact that the company did not have a professional manager in the second round of financing and that he did not possess the required skill set to assume that role and effectively lead the company.

Situation Assessment
Pandora emerged as a music industry phenomenon that as of 2007 attracted over 8 million customers with online hours growing at an average rate of 50% year over year. Nevertheless, the company is not producing enough revenue to sustain operational profitability. It faces substantial challenges including a serious threat on the licensing costs. Investors are viewing the company as risky and each one of them has different idea as to what direction should the company follow. Furthermore, other service providers are able to meet customer demands creating competition for Pandora. 
The scope of the problem includes the entire company, the founder’s vision, sustainability of the business model and ability to attract investment necessary for future growth.  
The advantage that Pandora has over competitors is a rapidly growing, interactive and devoted customer base. The company earned revenue in three ways: via advertising on its website, via subscription fees from consumers who wanted to opt out of advertising, and via partners who leverage Pandora’s customer base. The largest revenue contributor was advertising, which made up 93% of the total. Pandora entered into affiliate agreements with iTunes and Amazon.com according to which customers could purchase a song or an album though a link. Despite a growing customer base, by 2007 revenues began to catch up with run-rate cost for employee salaries. After all administrative and other costs associated with playing music (royalties and streaming) the gross margin that the company received per listener was approximately 0.69 cents per hour.
The new CEO, Joe Kennedy proposed a strategic change making the company a direct-to-consumer Internet radio service (Pandora.com).

List of Plausible Alternative Courses of Action and Evaluation of Alternatives
People who wanted to listen to music had various options, including terrestrial radio, Internet radio stations, Satellite radio, consumer-owned collections etc. Music recommendations come from all of those sources as well as from friends, concerts, recommendation from sites such as iTunes.com, Amazon.com, or on the radio stations. As mentioned above, Pandora should utilize the subscriber advantage to increase its revenue stream. Following are some of the potential courses of action: 
  • Do not change current business model and strategy and continue with the current state - this option would not require any additional investment or risk of decreased productivity due to process changes. Nevertheless, it would also not solve the company’s problem of stagnant revenue and therefore would halter Pandora’s growth potential. This option would also fail to provide additional capital to fuel future development. In this scenario Pandora would have to seek external funding and yet again be threatened by potential changes to its vision and business model.  Due to these reasons this option does not appear to be sustainable.
  • Begin charging musicians for playing their songs on Pandora and upstarting their career.  Pandora receives hundreds of CD's per week from all sorts of artists looking to get into the business. These songs, in order to be placed in the library, need to be analyzed and decoded by Pandora's employees, who should be compensated for their effort. Let's assume that the company receives an average of 300 CD's per week (conservative interpretation of several hundred). Each analyst at Pandora spends around 30 minutes to analyze a song. If a typical album includes 14 songs, that translates to 7 working hours per analyst. If they were to be compensated, say at $25 per hour, the cost to just cover the labor would be $175 per CD. If Pandora applied this methodology to each CD and have the aspiring artist pay for the analysis, it could potentially make $2,730,000 per year (300 CD's x 52 weeks in the year x $175 per CD) to cover the labor cost of developing musical DNA. Although the stereotype presents new artists as usually lacking any funding sources, I would expect little drawback to this option as $175 per CD is a very insignificant expense when compared to $350,000 for recording, marketing and producing cost referenced by a music label. While using Pandora does not guarantee the artist's success, it is a very low price to pay for keeping their musical integrity that is often sacrificed to the cost of success. Additional funding would certainly help the company's bottom line.
  • Automate the musical DNA coding process, focus on more direct-to-consumer relationship by offering premium services, and increase advertising on free-access site. This option would allow the company to generate more revenue and partner with advertising companies that are looking to take advantage of the active and growing customer base. By pursuing this possibility Pandora could potentially evolve its customer feedback collection and make improvements to the music genome project by soliciting customer feedback on a more elaborate basis than thumbs up/down and also allow for customer suggestions in order to expand the music library. If Pandora were to charge customers $5 per month for premium service (with no advertising) although they would loose the advertising revenue, they could potentially make additional $20 million if, say, half of customer base signed up for the service. Furthermore, automating the development of musical DNA would lead to reduction in workforce. The initial cost of developing the program that would be capable of analyzing as many as 400 different attributes to determine the song's DNA would be offset by the first year's savings, and from then on, the money saved on labor would be added to the bottom line to generate profit. Pandora should consider this option carefully as potential software development costs may be significant. Furthermore, the application would probably need periodical maintenance. The downside of this option could be customer dissatisfaction with increased amount of advertising at free user level. In order to reduce the frequency of advertisements customer would need to pay a subscription fee, which can have an adverse effect in terms of subscriber growth.
                                                                        Recommendation
Based on the analysis of the alternatives mentioned above, I would suggest that Pandora pursue a mixture of option 2 and 3. I believe that some revenue should be generated from new artists as there is significant time and expense invested in decoding their music and playing it on the station. I also believe that Pandora should charge various subscription rates based on customization and end user preferences. Free access should still be offered with increased advertising and limited listening time. I see the development of an automated solution as an effective, efficient and sustainable option that will escalate the availability of various songs, including new hits and new artist work. The increased speed of assigning the song its musical DNA and being able to play it to the listener would increase the service appeal in the eyes of new artists and further substantiate the initial fee.

Presentation
In my opinion, presenting this case would need to focus on business model and strategy choices. I would therefore start with outlining the current state and SWOT analysis of the business environment. I would ensure to include all possible threats of substitutes as well as alternatives to the service offered by Pandora. I would also explore various decision criteria to be potentially considered by management when implementing a new business strategy.
Presentation of different alternatives and their effect on the bottom line would help make the decision clearer. Furthermore, analyzing the subscriber basis and segmenting it would help establish the target and future positioning of the service offered. I would utilize various analysis and market share graphs to depict the size of the market. I would also provide visual graphs depicting customer trends in music purchase (shift from CD purchase to digital albums and singles). 











Thursday, May 30, 2013

Ubuntu = Humanity to Others

Dear C-Levels,

You have assigned me with a task of evaluating Ubuntu as an option for our business. Please allow me to present my findings, assessment of risk, and recommendation pertaining to the possible migration from Windows.

Ubuntu is a Linux based operating system that is part social and part economic: free software, available free of charge to everybody on the same terms, and funded through a portfolio of services provided by Canonical, the development company. Upon download of the system or any applications, potential users are solicited with an option to voluntarily sponsor future updates by donating to the company. 

Based on my experience, Ubuntu appears to be user friendly with abundance of applications and an interface that resembles Windows. The interface looks stylish and innovative yet simple and intuitive in terms of usability. In terms of Web browsing, the operating system comes pre-installed with Firefox but one can choose other browsers, like Google Chrome from the Ubuntu Software center. With regards to office applications, Ubuntu is compatible with Microsoft office and therefore a user can open, edit and share files such as Word documents, Excel spreadsheets or PowerPoint presentations. Ubuntu has its own office application, also available for free, called LibreOffice that, although appears to have less functionality as compared to Microsoft applications, does the job just as well. Ubuntu offers applications for fast and easy communication with Thunderbird as preferred access to emails, address book and calendar.  Ubuntu users can enjoy and share music by using Ubuntu One Music store (also compatible with common portable  music players as well as Android phones and iPhones); photos by using Softwell for quick importing, organizing, editing and sharing pictures, or GIMP or Inkscape for creating professional illustrations and videos; and videos  via YouTube, BBC iPlayer and MSN Player. Ubuntu also offers Ubuntu One personal cloud with 5 GB free storage that is compatible with Windows, iOS, and Android. I was particularly impressed with the speed of the system and comprehensiveness of free software store selections.

Ubuntu appears to be targeting the corporate world with the release of Ubuntu Business Desktop Remix as a starting point for large-scale corporate desktop deployments. The company also offers Landscape, the commercial Ubuntu systems management tool from Canonical that promises IT administrators’ easy management of thousands of end-user devices across your enterprise. The first release included the Adobe Flash Plugin, vMware View, and the Open JDK 6 Java run-time environment, while removing social networking and file sharing applications, games and development/sysadmin tools. Canonical also promises low threat of viruses as almost all viruses are coded to take advantage of weaknesses in Windows and would not run on Ubuntu. I think though that it is just a matter of time before this OS will need antivirus software. 

Although the system appears to be user friendly I am expecting some push-back from users as well as inefficiencies caused by lack of familiarity with the system as compared with Windows. Let’s give it a ballpark figure based on estimated inefficiencies of 5 hours per week per week per user, considering the size of our department (200 people) and estimated time to bring users up to speed of one month.  We are looking at a 40 hour work-week for 4 weeks with 200 employees, which translate to 32,000 hours, out of which at least 4,000 would have to be lost due to user unfamiliarity with the system. At an minimum cost of $25 per hour that will translate to $100,000 for the month. If we factor in the cost of support offered by Canonical at a Standard (general business use such as email, messaging and web browsing) or Advanced level (intensive desktop usage such as work conducted by developers) as are looking at an additional cost of $105 to $165 per desktop, which in our case would cost us anywhere from $21,000 to $33,000 per month. We would then need to assess how many months of support we would require. Currently desktop support is provided by out IT team.

I approached the IT team with the idea and they brought a few interesting decision points. They first stated that out PC leases and prices already include the cost of the operating system and based on the agreements we have it would be difficult to separate that cost alone (I will attempt that anyway later on). They also talked about the server requirements and possible changes, which I cannot comment on as I do not have required expertise. Should you wish, I will investigate further. The biggest problem they brought to my attention was our specialized applications and possible interface problems we may face with the use of Ubuntu. The investigation done by the IT team could take weeks to cover all specialized applications and systems and would further add to the inefficiencies cost referenced above.

I was informed that it would be difficult to separate the OS cost from PC cost. I can go over a quick comparison of a stand-alone upgrade fee of $199.99 for Windows 8 Pro. For 200 users we are looking at an upgrade fee of about $40,000 less any applicable corporate discount we can negotiate with Microsoft. Since our IT already provides support no further costs need to be considered. Ubuntu operating system is free therefore the only cost we would incur would be the monthly support of $21,000 to $33,000. Taken that under consideration together with the lost efficiency cost I do not believe that it would be beneficial for us to consider adopting Ubuntu as our operating system. 

On a personal note, I really enjoyed my interaction and experience with this operating system. I think it would be well suited for a start-up business, small tech-oriented companies, an internet cafe, educational environment such as a computer lab, or as a temporary or permanent replacement for a crashed operating system. I am strongly convinced that Ubuntu has a future in corporate world and may stand to be a substantial competition for Windows and Mac OS. Everyone was skeptical about Apple products just a few years ago and look how far the company went now. There are few of us that do not owe some sort of an Apple product. 

I hope you will find my recommendation helpful. Should you require any additional information or further assistance, please do not hesitate to contact me.

Best regards,


MKO



Thursday, May 23, 2013

Accenture - Reflection


Dear fellow C-Levels,

In preparation for our strategy meeting and to reflect on the presentation we saw last week, I would like to provide you with my evaluation and recommendation on the subject matter.

Our organization has come a long way to create an outstanding set of values and systems to serve our customers. We are now considering implementation of a COBIT 5 governance system. I understand your concern regarding the cost and significant time that needs to be invested in training our work force. But what we need to focus on is the fact that our company employs the best people, operates based on stewardship and value creation for our clients. We are a one global network based on integrity and respect for the individual. COBIT is a complete, internationally accepted process for IT framework that supports the business, IT executives and management in achievement of goals. It delivers a comprehensive IT governance, control and assurance. The five key principles that this system was based on: meeting shareholder needs, covering the enterprise end-to-end, applying a single integrated framework, enabling a holistic approach and separating governance from management, appear to be in line with our goals.

As I mentioned before, we always ‘walked the talk’ and consistently provided the highest level of service to our customer. Our next step should be to take our service offer to the next level and strive to secure more business by getting accredited and engaging client interested in CORBIT. I looked at the benefits as well as laminations that the accreditation process carries. It is my belief that the advantages of Accenture becoming COBI 5 accredited organization outweigh the disadvantages. The framework is in line with our business objectives and forms the path for our company to be recognized as world-class, certified IT Company. It will further reinforce our commitment to quality.

I recommend that we explore this opportunity and continue the path of quality and control we set ourselves on when starting this company.

Best regards,
MKO

Monday, May 20, 2013

ZARA - Reflection


Dear fellow C-Levels,

We have seen the consultant’s presentation last week about the current state and risk associated with our outdated operating system and infrastructure. The consultants recommended that we replace out operating system and upgrade the point of sales terminals across the network of our 550 stores. They highlighted the benefits provided by the new system to include an inventory status look up, store networking, and the possibility to explore the Internet sales channel that the new system would be able to accommodate and support.

Some of you stated that “if it isn't broke, don’t fix it!” And you appear to be correct stating that we had not had any problems with the system, that it is easy to install and navigate, and that the vendor did promise not to make any changes. Nevertheless, I do not feel, and never felt, comfortable with the idea of ‘theoretical’ inventory balances. I believe we could and should do better than that! Our company experienced extreme success over the years providing customer with trendy clothing lines. I am convinced that we can capitalize on our success further and much faster, if we provide customer with inventory information at our other stores should we not have a particular garment in the store they are visiting. The Internet also appears to be a very powerful selling channel and 
I strongly believe we should pursue the option of offering our products online. Our current system does not support that and therefore I am reaffirmed in my recommendation to upgrade not only our operating system but also our point of sale terminals. I truly believe this will mitigate the business risk that we are facing.

The consultants highlighted some hidden costs that I think we failed to explore and discuss before. I understand this decision may appear costly to you, but I think it is worth it.  We should ensure that we are implementing relevant technology just as we are fashion forward in our garment offering. Out managers will be able to process orders with ease, look up other store’s inventory and devote their time to more effectively and efficiently serve our customers. I am convinced that we will quickly capitalize on this investment (much faster than the 7 years noted by the consultants).
Without further ado, please accept my vote toward the recommendation of updating our OS and POS terminals.

Best regards,
MKO

Sunday, May 19, 2013

iPads for Success

Dear Phil and Tom,

thank you for the opportunity to evaluate whether to deploy iPads for your sales force. The iPad had emerged as a real force in enterprise computing, leaving companies with a choice whether to embrace it or leave it behind. With the growing popularity of the device, many companies are now exploring the possibility of using iPads, especially as a productivity tool. As a matter of fact, Apple CEO, Tim Cook, reports that 92% of Forture 500 companies were either testing or deploying iPads, indicating that forward-thinking organizations, such as yours, understand the game-changing potential of these devices.

Based on the conversations I had with the representatives from your Sales, Finance and Marketing departments , I specified the following functional requirements the device must have in order to meet your needs and suggested some functionality and applications that will satisfy them:



According to my research, the functionality that the iPad offers will satisfy your requirements whether you decide to use it as a productivity tool that will enhance the performance of your sales team, or as a replacement for the laptop computers. I will need to meet with your IT team to discuss the technical requirement and Mobile Device Management options. Implementing MDM solutions before deploying the device will let you enforce policies, wipe lost or stolen devices of sensitive data, and push new updates that will ensure consistency in how this device is being used by your sales force at all times. I do not expect a high learning curve as the device is very intuitive and the salesmen I spoke with informed me that they are already using their personal iPads for some of their presentations. 

Once I receive the details of your current leasing agreement with the PC hardware provider, I can explore and negotiate the potential of swapping your current laptops for iPads provided that the lessor is interested in securing the business with your company. Otherwise, we will need to consider the cost of ending the lease and purchasing the devices. I will recommend that we consider iPads with Retina display in either the standard or mini version. Depending on your memory requirements, the cost of a device ranges between $499 for 16GB to $799 for 128GB (please add $200 to each option if you choose Wi-Fi + Cellular options). For a sales force of 2,500 employees, this puts us at a range between $1,247,500 and $1,997,500 (add $500,000 for Wi-Fi + Cellular) for the hardware only. Please note that we can obtain business volume purchase discounts once we set our specifications and commence negotiation with the hardware provider. We will also need some additional accessories, such as cases and screen protectors to safeguard the devices as well as cables and adapters. 

In order to give you an example how iPads can improve sales force performance I would like to reference the case of how they were employed at Daiichi-Sankyo, a global pharmaceutical company based in Japan. Before implementing iPads, the Company's representatives had to carry heavy bags with laptops and lots of brochures to the hospitals and clinics to provide all the information they needed to the doctors, similar to what your sales force does now. With the iPad, the information is available right away allowing them to work much faster. Their iPads come pre-installed with all the applications they need to ensure efficiency and ease of use. Daiichi-Sankyo developed an application for their employees that has all the information about their products with video interviews with doctors who are known authorities in specific medical fields. The application also allows them to track their performance on a daily basis. They use the iPad during their meetings making the process completely paperless. They were so satisfied with the application of Apple technology that they allowed Apple to place their testimonial on their Web site. 

The culture of mobility and convenience is changing the business world for the better and companies are more pressed than ever to identify the best practices for both leveraging the growing use of iPads and incorporating them into more aggressive business strategies. I am fully convinced that the iPad functionality will make your detailers more efficient and effective, and that you will quickly capitalize on this investment. 

Best regards, 
MKO 


References:
www.businessinsider.com
http://www.apple.com/ipad/business/profiles/daiichi-sankyo/#video-daiichi-sankyo