Sunday, July 30, 2017

Business Intelligence Analytics Project Forecast and Prediction

-->
Bright Arinaitwe_BIA 4.2 Project (Forecast & Prediction)

1.  Forecast Analysis 

In 2001, Uganda’s leading newspaper, New Vision was selling 34,000 copies daily while their competitor, Monitor was selling 21,000. Many reasons were invented to explain Monitor’s poor performance – notably among them was accusing New Vision’s CEO, William Pike, of playing dirty tricks. New Vision was denigrated as a ‘government run newspaper’, just spreading government propaganda yet it’s sales kept growing while Monitor’s sales kept shrinking. By end of 2003, Monitor was technically bankrupt.  Monitor’s passionate readers could not save them from collapse. Monitor management asked themselves why Ugandan readers were pushing them into bankruptcy while buying a government owned newspaper (New Vision) that did not advance the values of the common Ugandan.

New Vision’s CEO Pike, possibly understood that New Vision as a state-owned newspaper – could never beat Monitor on independence and boldness. He also figured that not all readers are as passionate about such emotive issues of liberty, freedom, accountability and human rights. He also possibly did what in modern business strategy is called `the strategic canvas’. He strengthened New Vision’s coverage of functional things like sports news, exchange rates, community news, jobs, gossip and features on health and environment.
In search for excellence and beyond content, Pike improved the copy’s layout and design to grow customer loyalty. New vision hired a newspaper from London, UK to execute this strategy. He also ensured that by 6:00 am, the New Vision was in every major town of Uganda from the remotest town in Uganda’s North to South and East to West.

In 2004, Monitor hired a new CEO with vast experience in marketing and sales. When the new CEO - Conrad came to Monitor, he upheld the newspaper’s independence and boldness. But he also fixed many of the issues in the other issues Monitor was struggling with. By July 2006, Monitor had overtaken New Vision as Uganda’s leading daily with over 32,000 daily sales compared to New Vision’s 25,000 daily sales.







2. Risk Avoidance
Monitor was weak in all these areas and had to address all these issues or fail and drop out of market altogether. For example, they would deliver their newspaper in nearby towns at 3:00 pm when readers already made newspaper purchases and gone home. The Monitor’s design and layout was poor and printing quality horrible. Monitor’s sense of self-righteousness could not compensate for these weaknesses. It is not that Monitor was wrong to stand for democracy, accountability and liberty. They did not realize that passion was necessary but not sufficient to achieve market leadership. Monitor’s missionary attitude created a problem in how they approached the market. It led them to misunderstand the diverse interests of readers. They held onto their most committed readers who passionately cared for the values Monitor stood but lost those readers who were less passionate.

3.  Total Quality Control (TQC)

Deming’s 14 Points are as follows:

1.     Create constancy of purpose for improving products and services.
Simply put, companies should think long-term. Today’s business course should be determined with tomorrow in mind.

2.     Adopt the new philosophy.
Contingent plan to adopt to rapidly changing technology should be put in place. Companies that fail to improve constantly and innovate will eventually find themselves out of business. Adopting means predicting customers' needs.

3.     Cease dependence on inspection to achieve quality.
This eliminates the need for inspection on a mass basis by building quality into the product in the first place. Relevant content that appeals to customers is critical for survival. Thinking long-term is important. Setting up the course today to be in business tomorrow should be paramount. Knowing what to do and doing best leads to constant improvement of quality.

4.     End the practice of awarding business on price alone; instead, minimize total cost by working with a single supplier.
Ending the practice of awarding business based on price tag is important. Instead, minimizing total cost and moving toward a single supplier for any one item on a long-term relationship of loyalty and trust should be considered. Price tag doesn't always tell the whole story.

5.     Improve constantly and forever every process for planning, production and service.
Improving company systems constantly leads to higher production and service output. Deming says, "Don't blame the individual, fix the system for them." Improving quality and productivity only comes by improving the system.



6.     Institute training on the job.
Management should not be busy for the employees. They should not view training as an expense or view employees as commodities but rather as assets. One person should be responsible for teaching everyone the same skill. If this is not done, mistakes are passed down the line because each time one employee teaches the next more is lost through communication breakdown.

7.     Adopt and institute leadership.
According to Deming, a leader should have a theory and vision of how to transform his company. He is practical and understands why the transformation would bring gains to his organization and to all the people that his organization deals with.

8.     Drive out fear.
To paraphrase President Franklin D Roosevelt’s words, the first thing to fear is fear itself. When employees are threatened with being fired if they do not produce a certain number of units, their goal will be to produce the numbers but not quality. This only leads to losses are more defects will be the company’s loss. Management must create a work environment where workers can take pride and joy in their work. Blaming individuals only works to demotivate them - fixing the system for them would help them become more productive.

9.     Break down barriers between staff areas.
Departments should work together at all production stages. Everyone must share knowledge in a cooperative and not competitive effort. For example, people in research, design, sales, and production must work as a team to achieve a coherent process in a print house. Teamwork helps employees to work for a common goal. It also helps achieve a smooth integration of all production stages to achieve a final quality product.

10.  Eliminate slogans, exhortations and targets for the workforce.
Slogans, unrealistic targets and asking for an achievable goal like zero defects only work to derail workers. When these unrealistic goals are demanded from workers, it works as a motivation to produce low quality work. Expectations should be outlined and people should be praised face-to-face. Once workers are looked at valuable part of the company and their contribution appreciated, they offer the best they can thus, high productivity.


11.  Eliminate numerical quotas for the workforce and numerical goals for management.
Deming argues that production target encourages high output and low quality. Support and resources should be provided so that production levels and quality are high and achievable.

12.  Remove barriers that rob people of pride of workmanship, and eliminate the annual rating or merit system.
When everyone’s contribution to the company appreciated without comparing them to their colleagues, their pride goes up over time, the quality system will naturally raise the level of everyone's work to an equally high level.


13.  Institute a vigorous program of education and self-improvement for everyone.
People’s current skills should be improved through retraining to meet future changes and challenges. This will make your workforce more adaptable to change, and better able to find and achieve improvements.

14.  Put everybody in the company to work accomplishing the transformation.
Everyone in the company should work toward its transformation. Transformation must start with top management, for they have the most leverage and influence. Once the decision has been made, middle management, supervisors and workers must come on board.



4.  Six Sigma is a method that provides organizations tools to improve the capability of their 
business processes. This increase in performance and decrease in process variation lead to defect reduction and improvement in profits, employee morale, and quality of products or services.


5.  Process Analysis 
This is step-by-step breakdown of the phases of a process, used to convey the inputs, outputs, and operations that take place during each phase.

The benefits of Business Process Analysis in a business include identifying process flaws in existing workflows and analyzing them for improvement; Suggesting ideas on reducing or eliminating the redundancies found in the processes and documenting process data and using it as reference for future decisions. This eventually, helps organizations make the most of their limited resources, cut costs, and offer better values to their products and customers.



Sunday, July 23, 2017

Bright Arinaitwe BIA 3.2 Project (Decision Making at CEO Level)

Growth Analysis:
Many business owners are concerned with changes in their company’s nominal revenue, referred to generally as growth. Nominal revenue growth includes changes due to new business, as well as increases or decreases in pricing or changes in costs of goods sold.
If the company increases the price of services or products, this causes a percentage change in revenues that would show up as a nominal revenue increase. Likewise, if pricing decreases the nominal revenue would decrease in turn. The nominal change in revenues only provides partial information as the effect of pricing is not factored into the equation; there is no quick way to know what the real change in services or products provided by the company is.
If revenues for the year are up 15% but you increased the overall pricing by 5%, the nominal increase is 15%. The real revenue increase, however, is the 15% nominal change minus the 5% price increase, or 10%. The real revenue increase of 10% is the actual “temperature” or growth with which we are concerned. 
Put another way. If nominal revenue growth is up 10% and the overall price increase is 15%, the nominal revenue growth would be 10%. The real revenue growth analysis, however, would show a decline of 5%.
-->
Assuming the nominal revenue growth comes in for the year at -10% and the prices were increased by 5%. The real revenue growth would be a -10% minus the +5% price increases resulting in a real decrease of 15%.
--> Personnel Analysis
-->
 To begin with, develop a concrete vision for the company. Perhaps you have already established a company mission statement, or you have a general idea of the direction the company is going. It is crucial to the development of a human resource strategy to have a clear vision for the company. Knowing where the company is headed will give guidance to how human resources can assist the company in reaching its goals. Communicating those goals to the human resource department will help provide concrete methods that the HR strategy can use. By solidifying the company’s short and long term goals, the HR strategy can be tailored to best help meet those goals.

-->

For example,
If the organization has social responsibility as one of its key goals, the HR strategy should promote that through the hiring process.
The tech company may desire programmers who personally embrace social responsibility, but may only need a few to meet their current programming need. The health food store may be gearing up for a busy season when people are more likely to turn to healthy living, such as at the beginning of a new year, and need a dozen temporary employees. Understanding not only the company’s products/services, but their overall vision will ensure that the HR strategy promotes the company’s vision.
If your HR strategy included the objective of ‘Fulfill hiring needs of company’ it would be difficult to determine if that goal had been met. By changing the objective to read ‘Filling 5 vacancies with qualified individuals to meet the needs of the sales department’, you have established a base-line for success and it is easy to quantify the success or failure of the objective.
Generalized objectives aren’t useful because they are difficult to manage and evaluate. For example, ‘increase safety measures’ is a valid goal, but impossible to qualify. Do the new fire extinguishers that were installed count? If you replace the batteries in the smoke detector have you increased safety measures? ‘Develop safety awareness through staff training program that all employees will complete by their employment anniversary date’ is both specific and measurable.
Constant evaluation of success is imperative to a comprehensive HR strategy. With that regular need for evaluation, there is need to consider potential for change. Suppose sales figures indicate a need for increased staff. The HR department puts considerable effort into hiring the extra dozen people needed, and begins their staff training. When the company gets trouble making the payroll and it is revealed that sales figures were overstated the HR strategy will need to make rapid changes. Monitoring legal requirements and regulations can also necessitate change through the implementation of new laws or mandates that affect business. An increase in minimum wage may affect the budget and staffing needs of a company, requiring the company to make changes accordingly.

-->
Operation Analysis

-->
This is the study of operational systems with the aim of identifying opportunities for improvement.  It has many guises and is sometimes called Operational Research or Industrial Engineering.  The discipline dates to the Second World War.


1. Audit
Periodically auditing your practices and procedures will help weed out the ones that are no longer working. It will also help improve those that are working but could be more efficient. It can be frustrating for employees to be handed a procedure that they will have to utilize everyday with no ability to comment on its effectiveness or potential improvements. Ensuring the procedures put in place will help employees be more efficient and ask for their feedback on the process is critical. The people with the hands-on experience are the ones that can help you determine what will make things faster and easier.
2. Document Control
The ability to find necessary documents as easily as possible is a crucial part of operational efficiency. Finding the most current variation of any piece of paperwork- contracts to drawings to specifications- can help keep you on your critical path. Keeping your business is organized is key!
Document revisions can also be important, depending on your type of business. If you sell services or goods that will require service in the future, knowing exactly what the final product the client ended up with is important when supporting them later. Procedures for document control start from the top down. Set a good example and document control will be easy!
3. Consistent Procedures
Consistency makes for efficiency. Creating and maintaining consistent procedures throughout your small business operations will help keep everyone on the same page, cutting down on confusion and rework. A simple plan of how to properly dispose of information properly, is an example of how to keep consistent procedures. When procedures are consistent across the board, training employees is easier and assessing performance is a snap.
4. Small Steps
Nothing is going to be perfect right away. Small, thoughtful steps in the right direction will get your business up to its optimal operational efficiency. As technology evolves and becomes more applicable to your small business, you may be inclined to rush into upgrading and swapping all your systems over right away but taking small steps to ensure efficient integration of these technologies will likely be better for your company in the long run. Adequate training on new systems with enough time for cross training is an important part of implementing new processes.
5. Schedule
A clear schedule will keep you and your employees aware of the expectations you have for how they spend their time. Keeping a schedule will help make sure your bills are paid on time and your customers’ needs are taken care of. It will help forecast resources you may need as well as allow you to help schedule your personal life- everyone needs a vacation!
6. Maintenance
Maintaining your small business’s assets is important. Whether its equipment used to manufacture your product or simply the printer/copier used by the office staff, keeping these items operational is critical to business running smoothly. A little time and money now will help keep costs down in the long run- it’s better to maintain equipment as you go than pay for a complete breakdown when things finally fail. 
7. Culture
The small business culture leans toward more relaxed office spaces and less pressure from management. Keeping a positive work environment alive will help with your operational efficiency. Happy workers are productive workers. If your employees feel like they can make suggestions for helping the business run smoothly, they will keep an eye out for these opportunities.
Cash Flow Analysis                                
A cash flow statement is one of the most important financial statements for a project or business. The statement can be as simple as a one page analysis or may involve several schedules that feed information into a central statement. A cash flow statement is a listing of the flows of cash into and out of the business or project. Think of it as your checking account at the bank. Deposits are the cash inflow and withdrawals (checks) are the cash outflows. The balance in your checking account is your net cash flow at a specific point in time. A cash flow statement is a listing of cash flows that occurred during the past accounting period. A projection of future flows of cash is called a cash flow budget. You can think of a cash flow budget as a projection of the future deposits and withdrawals to your checking account.
-->
A cash flow statement is not only concerned with the amount of the cash flows but also the timing of the flows. Many cash flows are constructed with multiple time periods. For example, it may list monthly cash inflows and outflows over a year’s time.  It not only projects the cash balance remaining at the end of the year but also the cash balance for each month. Working capital is an important part of a cash flow analysis. It is defined as the amount of money needed to facilitate business operations and transactions, and is calculated as current assets (cash or near cash assets) less current liabilities (liabilities due during the upcoming accounting period). Computing the amount of working capital gives you a quick analysis of the liquidity of the business over the future accounting period. If working capital appears to be sufficient, developing a cash flow budget may not be critical. But if working capital appears to be insufficient, a cash flow budget may highlight liquidity problems that may occur during the coming year.

Sales Analysis 
-->
A sales analysis report shows the trends that occur in a company's sales volume over time. In its most basic form, a sales analysis report shows whether sales are increasing or declining. At any time during the fiscal year, sales managers may analyze the trends in the report to determine the best course of action. Managers often use sales analysis reports to identify market opportunities and areas where they could increase volume. For instance, a customer may show a history of increased sales during certain periods. This data can be used to ask for additional business during these peak periods.

-->
Image Source: https://www.template.net/business/analysis-templates/sales-analysis/#


Risk Analysis
-->
Risk analysis is the process of defining and analyzing the dangers to individuals, businesses and government agencies posed by potential natural and human-caused adverse events.