Wednesday, January 30, 2013

A Complete Inventory Management System Built With Excel

An Inventory Management System is not only about keeping records of the stocks movement in and out of a store or warehouse in an Excel spreadsheet. A simple inventory management system should be able to identify how much goods are left in the store, which products require re-order and where, when and which goods have moved in and out of the warehouse. Thus, generating accurate reports is important. But to be able to do this, the data must first be organised systematically.

Using the details, we could set up a pivot table to summarise the stocks that move in and out of the store. It will allow us to organise the report so that we could identify the stock level by product groups, product name and the locations they have moved to and from. The records could also be grouped such that we can track the stock movements by month. In our report below (refer to row above grand total), we can quickly establish that there is a net increase of 19 units of adhesives in the month of Oct, a net decrease of 3 units in the month of November, another 4 units drop in Dec, which all resulted in 12 units of adhesive left in the store.

Using the same report, we could drill down to see the movements of individual products
in the Adhesive group by month.

A Complete Inventory Management System Built With Excel

Alternatively, we could also present the quantity of stocks remaining in the store by changing the setting of the report. In our example below, we are able to know that the store is left with 4 units of "3M Command ADH Large Hook" in Nov and 1 unit in Dec. If we sort the report in descending order, we could immediately list down the products we have to top up quickly to prevent an out-of-stock situation.

And if this report is still not too relevant, we could even show the stock movements (the ins and the outs) for each month and then the stock balance for the month to better explain the stock movements for the month.

To make it easier to capture the details and improve on the accuracy of the data records, we also shared on we could set up a dropdown list that is dependent on the selection made by the user using another drop list.

The complete system helps to improve the data entered into the inventory management system and then prepare reports that help the store manager to make better quality decisions with regards to stock replenishment and stock movement in the store.

A Complete Inventory Management System Built With Excel
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Jason Khoo is the author of the website Advanced Excel Profit Centre. He hopes to share with his visitors how to simplify complicated calculations through the use of Excel. He also develop templates such as the NPV template, IRR template to help users gain a better understanding of these concepts and make it more convenient for users to derive the values. He has also developed a business solution that helps budget planners consolidate budgets in SUPER quick time. The solution is also very useful for personal budgeting and analysis.

cell phone watches Best Buy Oe Replacement Cadillac Srx Driver Side Best Buy Virginia Tech University Car Magnet Large

Saturday, January 26, 2013

The Challenges of Human Resource Management

Introduction

The role of the Human Resource Manager is evolving with the change in competitive market environment and the realization that Human Resource Management must play a more strategic role in the success of an organization. Organizations that do not put their emphasis on attracting and retaining talents may find themselves in dire consequences, as their competitors may be outplaying them in the strategic employment of their human resources.

With the increase in competition, locally or globally, organizations must become more adaptable, resilient, agile, and customer-focused to succeed. And within this change in environment, the HR professional has to evolve to become a strategic partner, an employee sponsor or advocate, and a change mentor within the organization. In order to succeed, HR must be a business driven function with a thorough understanding of the organization's big picture and be able to influence key decisions and policies. In general, the focus of today's HR Manager is on strategic personnel retention and talents development. HR professionals will be coaches, counselors, mentors, and succession planners to help motivate organization's members and their loyalty. The HR manager will also promote and fight for values, ethics, beliefs, and spirituality within their organizations, especially in the management of workplace diversity.

The Challenges of Human Resource Management

This paper will highlight on how a HR manager can meet the challenges of workplace diversity, how to motivate employees through gain-sharing and executive information system through proper planning, organizing, leading and controlling their human resources.

Workplace Diversity

According to Thomas (1992), dimensions of workplace diversity include, but are not limited to: age, ethnicity, ancestry, gender, physical abilities/qualities, race, sexual orientation, educational background, geographic location, income, marital status, military experience, religious beliefs, parental status, and work experience.

The Challenges of Workplace Diversity

The future success of any organizations relies on the ability to manage a diverse body of talent that can bring innovative ideas, perspectives and views to their work. The challenge and problems faced of workplace diversity can be turned into a strategic organizational asset if an organization is able to capitalize on this melting pot of diverse talents. With the mixture of talents of diverse cultural backgrounds, genders, ages and lifestyles, an organization can respond to business opportunities more rapidly and creatively, especially in the global arena (Cox, 1993), which must be one of the important organisational goals to be attained. More importantly, if the organizational environment does not support diversity broadly, one risks losing talent to competitors.

This is especially true for multinational companies (MNCs) who have operations on a global scale and employ people of different countries, ethical and cultural backgrounds. Thus, a HR manager needs to be mindful and may employ a 'Think Global, Act Local' approach in most circumstances. The challenge of workplace diversity is also prevalent amongst Singapore's Small and Medium Enterprises (SMEs). With a population of only four million people and the nation's strive towards high technology and knowledge-based economy; foreign talents are lured to share their expertise in these areas. Thus, many local HR managers have to undergo cultural-based Human Resource Management training to further their abilities to motivate a group of professional that are highly qualified but culturally diverse. Furthermore, the HR professional must assure the local professionals that these foreign talents are not a threat to their career advancement (Toh, 1993). In many ways, the effectiveness of workplace diversity management is dependent on the skilful balancing act of the HR manager.

One of the main reasons for ineffective workplace diversity management is the predisposition to pigeonhole employees, placing them in a different silo based on their diversity profile (Thomas, 1992). In the real world, diversity cannot be easily categorized and those organizations that respond to human complexity by leveraging the talents of a broad workforce will be the most effective in growing their businesses and their customer base.

The Management of Workplace Diversity

In order to effectively manage workplace diversity, Cox (1993) suggests that a HR Manager needs to change from an ethnocentric view ("our way is the best way") to a culturally relative perspective ("let's take the best of a variety of ways"). This shift in philosophy has to be ingrained in the managerial framework of the HR Manager in his/her planning, organizing, leading and controlling of organizational resources.

As suggested by Thomas (1992) and Cox (1993), there are several best practices that a HR manager can adopt in ensuring effective management of workplace diversity in order to attain organizational goals. They are:

Planning a Mentoring Program-

One of the best ways to handle workplace diversity issues is through initiating a Diversity Mentoring Program. This could entail involving different departmental managers in a mentoring program to coach and provide feedback to employees who are different from them. In order for the program to run successfully, it is wise to provide practical training for these managers or seek help from consultants and experts in this field. Usually, such a program will encourage organization's members to air their opinions and learn how to resolve conflicts due to their diversity. More importantly, the purpose of a Diversity Mentoring Program seeks to encourage members to move beyond their own cultural frame of reference to recognize and take full advantage of the productivity potential inherent in a diverse population.

Organizing Talents Strategically-

Many companies are now realizing the advantages of a diverse workplace. As more and more companies are going global in their market expansions either physically or virtually (for example, E-commerce-related companies), there is a necessity to employ diverse talents to understand the various niches of the market. For example, when China was opening up its markets and exporting their products globally in the late 1980s, the Chinese companies (such as China's electronic giants such as Haier) were seeking the marketing expertise of Singaporeans. This is because Singapore's marketing talents were able to understand the local China markets relatively well (almost 75% of Singaporeans are of Chinese descent) and as well as being attuned to the markets in the West due to Singapore's open economic policies and English language abilities. (Toh, R, 1993)

With this trend in place, a HR Manager must be able to organize the pool of diverse talents strategically for the organization. He/She must consider how a diverse workforce can enable the company to attain new markets and other organizational goals in order to harness the full potential of workplace diversity.

An organization that sees the existence of a diverse workforce as an organizational asset rather than a liability would indirectly help the organization to positively take in its stride some of the less positive aspects of workforce diversity.

Leading the Talk-

A HR Manager needs to advocate a diverse workforce by making diversity evident at all organizational levels. Otherwise, some employees will quickly conclude that there is no future for them in the company. As the HR Manager, it is pertinent to show respect for diversity issues and promote clear and positive responses to them. He/She must also show a high level of commitment and be able to resolve issues of workplace diversity in an ethical and responsible manner.

Control and Measure Results-

A HR Manager must conduct regular organizational assessments on issues like pay, benefits, work environment, management and promotional opportunities to assess the progress over the long term. There is also a need to develop appropriate measuring tools to measure the impact of diversity initiatives at the organization through organization-wide feedback surveys and other methods. Without proper control and evaluation, some of these diversity initiatives may just fizzle out, without resolving any real problems that may surface due to workplace diversity.

Motivational Approaches

Workplace motivation can be defined as the influence that makes us do things to achieve organizational goals: this is a result of our individual needs being satisfied (or met) so that we are motivated to complete organizational tasks effectively. As these needs vary from person to person, an organization must be able to utilize different motivational tools to encourage their employees to put in the required effort and increase productivity for the company.

Why do we need motivated employees? The answer is survival (Smith, 1994). In our changing workplace and competitive market environments, motivated employees and their contributions are the necessary currency for an organization's survival and success. Motivational factors in an organizational context include working environment, job characteristics, appropriate organizational reward system and so on.

The development of an appropriate organizational reward system is probably one of the strongest motivational factors. This can influence both job satisfaction and employee motivation. The reward system affects job satisfaction by making the employee more comfortable and contented as a result of the rewards received. The reward system influences motivation primarily through the perceived value of the rewards and their contingency on performance (Hickins, 1998).

To be effective, an organizational reward system should be based on sound understanding of the motivation of people at work. In this paper, I will be touching on the one of the more popular methods of reward systems, gain-sharing.

Gain-sharing:

Gain-sharing programs generally refer to incentive plans that involve employees in a common effort to improve organizational performance, and are based on the concept that the resulting incremental economic gains are shared among employees and the company.

In most cases, workers voluntarily participate in management to accept responsibility for major reforms. This type of pay is based on factors directly under a worker's control (i.e., productivity or costs). Gains are measured and distributions are made frequently through a predetermined formula. Because this pay is only implemented when gains are achieved, gain-sharing plans do not adversely affect company costs (Paulsen, 1991).

Managing Gain-sharing

In order for a gain-sharing program that meets the minimum requirements for success to be in place, Paulsen (1991) and Boyett (1988) have suggested a few pointers in the effective management of a gain-sharing program. They are as follows:

A HR manager must ensure that the people who will be participating in the plan are influencing the performance measured by the gain-sharing formula in a significant way by changes in their day-to-day behavior. The main idea of the gain sharing is to motivate members to increase productivity through their behavioral changes and working attitudes. If the increase in the performance measurement was due to external factors, then it would have defeated the purpose of having a gain-sharing program. An effective manager must ensure that the gain-sharing targets are challenging but legitimate and attainable. In addition, the targets should be specific and challenging but reasonable and justifiable given the historical performance, the business strategy and the competitive environment. If the gain-sharing participants perceive the target as an impossibility and are not motivated at all, the whole program will be a disaster. A manager must provide useful feedback as a guidance to the gain-sharing participants concerning how they need to change their behavior(s) to realize gain-sharing payouts The feedback should be frequent, objective and clearly based on the members' performance in relation to the gain-sharing target. A manager must have an effective mechanism in place to allow gain-sharing participants to initiate changes in work procedures and methods and/or requesting new or additional resources such as new technology to improve performance and realize gains. Though a manager must have a tight control of company's resources, reasonable and justifiable requests for additional resources and/or changes in work methods from gain-sharing participants should be considered.

Executive Information Systems

Executive Information System (EIS) is the most common term used for the unified collections of computer hardware and software that track the essential data of a business' daily performance and present it to managers as an aid to their planning and decision-making (Choo, 1991). With an EIS in place, a company can track inventory, sales, and receivables, compare today's data with historical patterns. In addition, an EIS will aid in spotting significant variations from "normal" trends almost as soon as it develops, giving the company the maximum amount of time to make decisions and implement required changes to put your business back on the right track. This would enable EIS to be a useful tool in an organization's strategic planning, as well as day-to-day management (Laudon, K and Laudon, J, 2003).

Managing EIS

As information is the basis of decision-making in an organization, there lies a great need for effective managerial control. A good control system would ensure the communication of the right information at the right time and relayed to the right people to take prompt actions.

When managing an Executive Information System, a HR manager must first find out exactly what information decision-makers would like to have available in the field of human resource management, and then to include it in the EIS. This is because having people simply use an EIS that lacks critical information is of no value-add to the organization. In addition, the manager must ensure that the use of information technology has to be brought into alignment with strategic business goals (Laudon, K and Laudon, J, 2003).

Conclusion

The role of the HR manager must parallel the needs of the changing organization. Successful organizations are becoming more adaptable, resilient, quick to change directions, and customer-centered. Within this environment, the HR professional must learn how to manage effectively through planning, organizing, leading and controlling the human resource and be knowledgeable of emerging trends in training and employee development.

The Challenges of Human Resource Management
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Dr.Alvin Chan is a Senior Research Consultant at a research think-tank in Asia.

alvinchan@firstquatermain.com

watches mobile phone Best Offer Lund 18536 Interceptor Clear Hood Shield

Wednesday, January 23, 2013

Cash Management - How to Prepare a Daily Cash Position Report - Part 1

As I have mentioned earlier, cash flow report is a very important report that every business owner or entrepreneur must be able to analyze so that they can plan for their next move in business. Almost all business gurus and academicians have stress on the importance of preparing cash flow report but unfortunately none of them give specific guide lines on how to prepare it. Cash flow report that we mentioned here is a dynamic cash flow report where it will show us the cash position at any point of time and at the same time can act as a powerful tools to enable us to make as much money as we can by investing the surplus fund in a very short term investment such as money market placement. Cash flow statement that every accounting text book recommended is cash flow report generated from Balance Sheet and Profit & Loss Account and will give depth analysis on net cash flow recorded from operating, investing or financing activities.

First and foremost, if we have only one bank, the opening balance for our cash position for that month must be the closing balance for the preceding month. This can be derived from the Balance Sheet section under current asset which will state the closing balance of the bank balance for the preceding month. If for any reason the enterprise could not be able to produce their company's account such as P&L and Balance sheet due to their company's size, they can obtain the closing balance from their cash book as this is the basic information that they have to prepare if they still have not set up the accounting system for their business.

If you have only one bank for your business, it is advisable to prepare your payment according to the payment categories in your cash flow statement. For example, if you have decided that your payment categories are for payment of taxes, utilities bills, subcontractors, suppliers, petty cash and others, you should compile all your invoices and bills according to their respective categories. Once you start preparing your payment, you should write the cheques according to their serial number. For example, if your cheque start from no 000001, and you intend to prepare 20 pieces of cheques for suppliers payment, the serial no for the cheques prepared must be from 000001 to 000020.Subsequently, if you want to prepare 10 pieces of cheques for subcontractors, the serial numbers should be from 000021 till 000030.You can continue using the same technique to other payment as well. Whether you prepare payment manually or by using special printed cheque, you should follow the same technique.

Cash Management - How to Prepare a Daily Cash Position Report - Part 1

The same concept applies when we received incoming cheques from your clients and customers. By following the same technique, if you have some major clients that normally total up for almost 80% of your income, you are strongly advisable to classify all the major clients in your income categories. Other income that normally consist about 20% from your income, you can simply specify them under others categories.

Cash Management - How to Prepare a Daily Cash Position Report - Part 1
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

I have just finished my ebook named "Now Everyone Can Prepare Daily Cash Flow Report". This is a comprehensive tutorial where almost everybody can prepare their business daily cash flow report by leveraging my 14 years solid experience in business cash management.

Selling only USD 9.90 in PDF format since I have to match the price in my undergoing Amazon Kindle and iPad format. E mail now at kamarulzamanbaharom@gmail.com to claim the priceless sample chapter of the book.

watch mobile phone Best Buy Pac Strapping 5830116B36 5 8 X Best Buy Virginia Tech University Car Magnet Large Best Buy Oe Replacement Cadillac Srx Driver Side

Monday, January 21, 2013

Project Management: History and Evolution

Project management, as we know it at present began to stretch its branches only a few decades ago, yet it was mounting around civilization from the beginning of history.

With an objective of maximum productivity with minimum participation, and to breed imagination into realism, human need for an optimal management system that can trigger workforce efficiency to yield product, that is predetermined and objectified was outlining a management system within the growth of human perception though out its evolution.

This stream of development in its respective path also had marked its course from its source, and events in its voyages were observed and registered in the pages of history.

Project Management: History and Evolution

Turning these pages, today we witness a simple endeavor to illustrate and analyze tasks through simple bar charts cultivated seed yesterday, and within a short span of time, it had grown to a gigantic tree of the project management industry we witness at present.

"Henry Gantt" is considered to be the forefather of project management, as his planning and organizing methods with the use of the "bar charts" as a project management tool recognizes him as the foremost precursor for contemporary project management practices employed today.

However, civilization was practicing an anonymous management system for accomplishing tasks carried out by them since the beginning of civilization; as today we can witness Pyramids, Roman structures, etc as one of most exceptional achievements human workforces had ever delivered.

To consider these massive project missions without any proper management scheme would be an unjust platform to write about today for our ancestors. The conception of project management was there in the womb of our civilization from the beginning, but its name is coined and structure is fabricated by our modern world.

As a discipline, project management has evolved from numerous diverse fields, including engineering, construction, military projects, etc. If we have to mark the date of identification for this management system then we need to start not before the industrial revolution, as this revolution sprouted a complex need of organizational management and interaction. The need of budget management, workforce utilization, demand and supply scaling, compels to develop the management system that was methodological and goal oriented.

Frederick Taylor, who introduced a scientific approach for understanding productivity measurement through performance leveling, led him as the father of scientific approaches in organizational management systems.

Moreover, his associate Henry Gantt's use of the bar diagram as a gauging process for planning and controlling, acknowledged him as a father of project management tools.

But the 1950's was marked as a date for the beginning of modern project management; as before the 50's projects were managed only with the popular use of Gantt charts and informal tools and statistics.

Furthermore, the immediate launch of the Polaris submarine missile project to fulfill the need of the missile gap with Russia; the US Army systemized a "Program Evaluation and Review Technique" or PERT devised by Willard Fazar and the use of the "Critical Path Method" (CPM) a mathematical technique for management of complex projects, drives project management systems further with advances in scientific approaches.

In 1969, the Project Management Institute (PMI) was formed to professionalize and modernize through formalizing project management tools and techniques.

In addition, today with rapid technological advancement, thriving IT industries, and globalization, project management solutions are in demand throughout the world as a fundamental force to complete projects within a defined scope, time, and within cost constraints.

Management tasks, where few individuals use to manage and memorize before; now require advance systems and methodological approaches for organization decision-making and planning implementation.

At present ultra modern project management systems deliver innovative solutions and its management process possesses the latest tools and techniques, systems and schemes with scientific evidences and statistical explanations.

Project Management: History and Evolution
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

Author: Bharat Bista

Resource and Reference:

Surrex Project Management [http://www.surrex-project-management.com/] - Project Management Solutions [http://www.surrex-project-management.com/project-management-solutions.html] - Project Management Tools [http://www.surrex-project-management.com/]

watches mobile phone Best Buy Pac Strapping 5830116B36 5 8 X Special Price Luxe Amendoim 4 5 X 48

Monday, January 7, 2013

6 Characteristics of Total Quality Management

TQM is a new method of quality management involving many levels and processes of different functions, but requiring an integrated cooperation. Characteristics of TQM can be listed as follows:

1. Target:

In TQM, the most important target to achieve is Quality; Quality policy must be set toward customer. Meeting customer's needs mean satisfying every customer requirement but not trying to reach some quality standards set before. Never stop innovating - never stop perfecting the quality is one of the most important principles of TQM.

6 Characteristics of Total Quality Management

2. Scope:

To ensure the quality of service and product, TQM system requires the extending of production process to suppliers and sub-contractors. Normally, the trading of material in production may account for 70% of final product cost (depend on types of product). Therefore, to ensure the quality of the input material, it is necessary to set up specific standards for each type of material to control its quality. It is also necessary to change the method of placing order to make it suitable with the production process.

3. Form:

In stead of controlling the quality of the finished product (after production), TQM sets up plans and programs to supervise and prevent problems right before the production process. Statistical tools are used to supervise, quantitatively analyze the results as well as factors affecting the quality, consider the reasons and take appropriate prevention methods.

4. Basis of TQM system:

The basis of TQM practice in the company is Human. Talking about quality, people usually think about the product quality. But it is the quality of employees that is the main concern of TQM. Of the three factors of Business, which are hard factor (machines, equipments, money...), Soft factor (methods, secrets, information...) and Human factor, Human is of the first concern to TQM.

The basic principle for implementation of TQM is that the qualification of employees is developed fully and integratedly through training, delegation and assignment.

5. Organization:

TQM system is cross organized and functioned in order to manage, integratedly corporate with different activities of the system and facilitate group working. The implementation of TQM requires the participation of high and middle level managers. A proper organization will help duties to be assigned clearly. Thus, TQM needs new management model, with different characteristics from the previous model.

6. Management skills and tools:

Methods to implement must be based on the principle "do correctly at the very beginning", in researching and designing to minimize economic cost. Strictly apply DEMMING circle (PDCA) to make foundation for the continuous quality improvement.

6 Characteristics of Total Quality Management
Check For The New Release in Health, Fitness & Dieting Category of Books NOW!
Check What Are The Top Cooking Books in Last 90 Days Best Cheap Deal!
Check For Cookbooks Best Sellers 2012 Discount OFFER!
Check for Top 100 Most Popular Books People Are Buying Daily Price Update!
Check For 100 New Release & BestSeller Books For Your Collection

I am a author of quality assurance management articles at http://qualitymanagement.hrvinet.com. You can find all templates, form, procedures of quality management, ISO...at: ISO 9001 procedures.

watch mobile phone Special Price Progressive Automations Linear Actuator Stroke Size