Monday, 14 October 2013

Final Process of Cashier Management

Name      : Chhorn Bros

NIM        : 49012076

TMD      : Technology Media Digital 
                                                 
                                                                  Cashier Management


1. Background

Cashiers in a store are employees who specialize in determining a customer’s bill and taking payment. In most modern stores, this job involves entering items into a computerized register system through either scanning bar codes or entering product codes. These computerized systems add up the amount owed after applying the appropriate taxes, and also tell the Cashier what change to give when payment is received. A few stores do not use these modern systems, relying on the math skills of their employees to properly add up the bill, apply applicable taxes, take payment, and make change. Moreover, Cashier must be able to accurately count money and other forms of currency. A Cashier who accidentally takes too much or too little payment from a customer creates a serious problem for the business, and may be responsible for making up any losses
Almost in the 21st century, technology has become very important to our society. Computers are becoming more affordable and are depended upon by many people to help them in their daily lives, what benefits do our business receive from technology? There are many ways that technology can benefit business, and other ways such as for Students, Medical, Army, etc... They need the new technology to help for working faster. So after researching, we decided to make an application to sell in Mini Mart. Because so many people in west Java at Indonesia, they need to live faster as well as working, we respected that it will be help for employees to work faster in a short moment of time in the Mini Market when they use this application. 

Currently, we saw many companies, they use many applications to store the Data by Offline Server, but is not on the Web Hosting that is more secure. On another hand when the users or manger want to see the Data, and make reports, it can’t do, because it is stores by Offline Server, it is not by the World Wide Web. So, we hope that this application, it will be help users very well in their field of work. Moreover, it will be more secure of data, and it will be not lost of the record by other ways. Because it is store by the server of Web Hosting. 
2. Requirement of Software
Program is the comprehensive process that leads from an original formulation of a computing problem to executable programs.
        1. JQuery
        2. Adobe Dreamweaver CS4,
        3. JavaScript
        4. FileZilla used to Uploading File to the Server of Web Hosting
        5. Databases: Wampserver Apache 2.2.6 
3. Requirement of Hardware
Hardware and software specifications that can be used in this system are as follows.
  1. CPU: 1.87GHz
  2. Windows 7
  3. RAM: 2GB
  4. Storage: 500 MB Storage
  5. Web Hosting of ITB, Domain name (minimartms.lskk.ee.itb.ac.id)

4. Diagram of DFD

The block diagram is a concise statement of the image, from the combined cause and effect between the Insert and the Output of a system. The block diagram depicted with boxes to indicate the name of the element or process, and the arrows indicate flow the direction of information. The following block diagram illustrating a data storage system in isolated storage database.
                                          
                                                  Figure 1: Data Flow diagram of Cashier.
                                           

Figure 2: Data Flow diagram of Level 1.3.1

5. Description of Flow Chart
Flowchart is a series of symbols that describe the flow of data and processes that exist in a computer program. Flowchart begins with the acceptance of the input and output ends with the appearance. Here's a picture that represents the flowchart in isolated storage database system. Also this flow charting explain about our processing.
 - After the first time we have to login correctly it will be loading the home page, if we login Data can’t correct, it will be loading to login again.
  - After loading home page has four menus (Home, Sell, Report and Search) and get users one by one.

5.1 Selling Menu
We clicked on menu sell, it will include home page sell, and then user scan record will be check the record in the Data has or does not has. If doesn’t have it will be refresh the home page sell again, but if it has the record it will be check quantity again, if quantity have only one value or multiple values, it is going to the next step then it will be check duplication in table sell reserve and then if check equal null it will be insert to database, but we have duplicate record it will be loading to page sell again, and the next step if we click print will print invoice then end statement.

5.2 Reporting Menu
We clicked on menu Report, it will be include home page report, and then user want to print report just search by Day, Month and Year click print report then It will be check print report if it doesn’t report it will be loading to page report, but it has record it will be print the report.

5.3 Searching Menu
We clicked on menu Search, it will be include search page, and then if user want to search report, they just input product name or barcode or ID then click on search  button, then it will be check. If it has recode it will be does but if doesn’t have, it will be loading searching page again.
                   
                                                                  Figure 3: Flow Chart of Cashier.          

6. Uploading File to Server
FileZilla Server is a server that supports FTP and FTP over SSL/TLS which provides secure encrypted connections to the server.
FileZilla supports SSL, the same level of encryption supported by your web browser, to protect your data. When using SSL your data is encrypted so that prying eyes cannot see it, and your confidential information is protected. It also supports on-the-fly data compression, which can improve the transfer rates.
Unfortunately, the compression setting can have mixed results, so it is advised to use it with care. It is possible for files that are already compressed to be transferred over the network using more than their original data size.

Figure 4: Uploading File by Filezilla
                                                                                                     
7. Backup Database to Server
SQLyog has an ability to format the SQL displayed in the active QUERY tab. We may format a single query only or the complete content of a QUERY tab. Formatting will help us to understand the structure of a complex query. If we have been working on a query (editing and copying) it will not always be well-formed. That we can correct with a single click. This is also useful if we want to save a query (as file or 'favorite') or if we want to use the query in an application.


Figure 5: Connected Database by SQLyog

8. Testing System
In our system we have login system, when Cashier login it will be log one by one.
8.1  Login System
Display when the application first runs, to update the database that begins by entering longitude and  value then the application will make the process of downloading the data from the database server.

Figure 6: Login System.
8.2 Home Page
The first time after login, it will be loading this page and it will catch user Username that have been login the system. Also it will be show time, menus and total money all day then show on the menu.
                                
                                                                                          Figure 7: Home Page Cashier.
8.3 Selling Page
Cashier can sell products just typed ID or Barcode into the Text Box then click button scan it will be query from table stock to add and total automatically. Moreover, if Cashier typed Character It will be show the Message (You add Number). It can save after Cashier scanned products on button click save or prints invoice.
                        
Figure 8: Selling Products System.
8.4 Printing Recipe
When cashier click button print, it will be loading this page then converted to file .PDF and also it will count, select and total products automatically for costumers then it will be print invoice automatically. 

Figure 9: Print Invoice.

8.5 Searching Report
Cashier can click on Combo box and selected on Day, Month and Year, then we can click on button search or print, it will be search or print and total report automatically      
Figure 10: Searching Report

8.6 Selling Report
When Cashier click button print it will be loading this page and selected from Database to make the report then convert file to .PDF and total report  by Daily or Monthly and Yearly.
                                         
Figure 11: Report for Daily or Monthly
8.7 Searching Product
This page just type Id, Barcode or products name, it will be searching automatically from stock then will be show on the form.
                                                    
Figure 12: Searching products page
9. Video
This video that talking about my hold project (Cashier Management).
                                           













Sunday, 13 October 2013

Final Process of Purchasing Management

Name : Tan Phirum
NIM  : 49012082
E-MAIL : phirumtan@gmail.com



I Purchasing Management
Purchasing Management is a department in an organization responsible for purchasing activities and also covers the areas of outsourcing and in-sourcing and is the management of purchasing process, and related aspects in an organization. Because of production companies purchase nowadays about 70% of their turnover, and service companies purchase approximately 40% of their turnover. 
The purchasing management department ensures that all goods, supplies and inventory needed to operate the business are ordered and kept in stock. It is also responsible for controlling the cost of the goods ordered, controlling inventory levels and building strong relationships with suppliers.

II Objective of Purchasing Management
To purchase the required material at minimum possible price by follow the company policies and the purpose of this system is provided convenience to the users:
1.      Easy to create commercial documents.
2.      Easy to create Purchase Order
3.      Easy to create Goods Receive
4.      Easy to create Purchase Bill
5.      Easy to create Purchase Payment
6.      Support with the global browsers.

III System Deployment Life Cycle (SDLC)
According to the book, System Analysis and Design, Sixth Edition, ISBN 0-13-127323-X's KENDALL and KENDY said about the stages of the Information System Development Project was held way of a so-called System Development Life Cycle (SDLC). SDLC is a solution in the analysis and project To create a new system in the subsequent stage using a specific way And the active participation of the user. SDLC theory in the creation of a system to be successful needs it is divided into 10 stages as follows:


SDLC Processes

IV Languages used for software
  1.  PHP (Hypertext Preprocessor)
  2. JQuery
  3. HTML (HyperText Markup Language)
  4. MySQL

V Data Flow Diagram (DFD)
A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system, modeling its process aspects. Often they are a preliminary step used to create an overview of the system which can later be elaborated. DFDs can also be used for the visualization of data processing (structured design).
A DFD shows what kinds of information will be input to and output from the system, where the data will come from and go to, and where the data will be stored. It does not show information about the timing of processes, or information about whether processes will operate in sequence or in parallel (which is shown on a flowchart).


DFD of Purchasing Management

VI Flow Chart
Flowchart is a series of symbols that describe the flow of data and processes that exist in a computer program. Flowchart begins with the acceptance of the input and output ends with the appearance. Here's a picture that represents the flowchart in isolated storage database system.

Flow Chart

VII Data Relationship

Data Relationship

VIII Conclusion
Depending on study the purchasing management system we observed that really there are strong link between theory and previous study and practice in the society actually it is. On the other hand this study provides a creative general knowledge and experience combined with other related work in social widely purchasing management system, especially on web online.
Purchasing management system is modify the negative points and lack of system can’t fill with what the users want to quick and easy and useful manage to better.

IX VIDEO DEMO






LPBD Mini market Management System

Mini Market Management System is a standalone system that helps the owners of mini market to manage the data and information of their mini market. It provides the solution for replacing the manual work done to manage the daily records of mini market. A full-featured management system is needed for mini market to manage all the stored data and information systematically and efficiently. Mini Market Management System application is developed for mini market to manage manager, Inventory, Purchase, Cashier, and Accounting. 

Schedule of task 


Friday, 13 September 2013

Functions of Management.

Functions of Management
Management in some form or another is an integral part of living and is essential wherever human efforts are to be undertaken to achieve desired objectives. The basic ingredients of management are always at play, whether we manage our lives or business. Management is a set of principles relating to the functions of planning, organizing, directing, and controlling, and the applications of these principles in harnessing physical, financial, human and informational resources efficiently and effectively to achieve organizational goals.
Management is essential for organized life and necessary to run all types of organizations. Managing life means getting things done to achieve life’s objectives and managing an organization means getting things done with and through other people to achieve its objectives.
There are basically five primary functions of management. These are:
1. Planning
2. Organizing
3. Staffing
4. Directing
5. Controlling

The controlling function comprises co-ordination, reporting and budgeting, and hence the controlling function can be broken into these three separate functions. Based upon these seven functions, Luther Guelick coined the word POSDCORB, which generally represents the initials of these seven functions i.e. P stands for Planning, O for Organizing, S for Staffing, D for Directing, Co for Co-ordination, R for reporting & B for Budgeting.
But, Planning, Organizing, Staffing, Directing and Controlling are widely recognized functions of management.

Planning
Planning is future oriented and determines an organization’s direction. It is a rational and systematic way of making decisions today that will affect the future of the company. It is a kind of organized foresight as well as corrective hindsight. It involves the predicting of the future as well as attempting to control the events. It involves the ability to foresee the effects of current actions in the long run in the future.
Peter Drucker has defined planning as follows:
“Planning is the continuous process of making present entrepreneurial decisions systematically and with best possible knowledge of their futurity, organizing systematically the efforts needed to carry out these decisions and measuring the results of these decisions against the expectations through organized and systematic feedback”.
An effective planning program incorporates the effect of both external as well as internal factors. The external factors are shortages of resources; both capital and material, general economic trend as far as interest rates and inflation are concerned, dynamic technological advancements, increased governmental regulation regarding community interests, unstable international political environments, etc.
The internal factors that affect planning are limited growth opportunities due to saturation requiring diversification, changing patterns of work force, more complex organizational structures, decentralization etc
Organizing
Organizing requires a formal structure of authority and the direction and flow of such authority through which work subdivisions are defined, arranged and co-ordinated so that each part relates to the other part in a united and coherent manner so as to attain the prescribed objectives.
According to Henry Fayol, “To organize a business is to provide it with everything useful or its functioning i.e. raw material, tools, capital and personnel’s”.

Thus the function of organizing involves the determination of activities that need to be done in order to reach the company goals, assigning these activities to the proper personnel, and delegating the necessary authority to carry out these activities in a coordinated and cohesive manner. It follows, therefore, that the function of organizing is concerned with:
1.      Identifying the tasks that must be performed and grouping them whenever necessary
2.      Assigning these tasks to the personnel while defining their authority and responsibility.
3.      Delegating this authority to these employees
4.      Establishing a relationship between authority and responsibility
5.      Coordinating these activities
Staffing
Staffing is the function of hiring and retaining a suitable work-force for the enterprise both at managerial as well as non-managerial levels. It involves the process of recruiting, training, developing, compensating and evaluating employees, and maintaining this workforce with proper incentives and motivations. Since the human element is the most vital factor in the process of management, it is important to recruit the right personnel.
According to Kootz & O’Donell, “Managerial function of staffing involves manning the organization structure through proper and effective selection, appraisal & development of personnel to fill the roles designed in the structure”.
This function is even more critically important since people differ in their intelligence, knowledge, skills, experience, physical condition, age and attitudes, and this complicates the function. Hence, management must understand, in addition to the technical and operational competence, the sociological and psychological structure of the workforce.
Directing
The directing function is concerned with leadership, communication, motivation and supervision so that the employees perform their activities in the most efficient manner possible, in order to achieve the desired goals.
The leadership element involves issuing of instructions and guiding the subordinates about procedures and methods.
The communication must be open both ways so that the information can be passed on to the subordinates and the feedback received from them.
Motivation is very important, since highly motivated people show excellent performance with less direction from superiors.
Supervising subordinates would lead to continuous progress reports as well as assure the superiors that the directions are being properly carried out.
Controlling
The function of control consists of those activities that are undertaken to ensure that the events do not deviate from the per-arranged plans. The activities consist of establishing standards for work performance, measuring performance and comparing it to these set standards and taking corrective actions as and when needed, to correct any deviations.
According to Koontz & O’Donell, “Controlling is the measurement & correction of performance activities of subordinates in order to make sure that the enterprise objectives and plans desired to obtain them as being accomplished”.
The controlling function involves:
a.Establishment of standard performance.
b.Measurement of actual performance.
c.Measuring actual performance with the pre-determined standard and finding out the deviations.
d.Taking corrective action.
All these five functions of management are closely interrelated. However, these functions are highly indistinguishable and virtually unrecognizable on the job. It is necessary, though, to put each function separately into focus and deal with it.
expr:href=”data:post.url” send=”true” show_faces=”true” width=”450” height=”35” font=”arial“>