Computerised Stock Control System


The Organization Networking assignment is based on the computerised stock control system. This assignment is about how precisely to implement a fresh online e book company called "Amazing Books".

"Amazing Catalogs" company is a new online e book company that'll be selling books via a website. The website represents the books that are in the company's warehouse. In addition, it contains the information of the literature and the info provided to the clients to order the catalogs they want. It is linking with company's stock control system. The stock will be regularly recorded and updated based upon the sales record.

When a customer fills an order form, he or she must choose the items and the delivery information. When the company obtains the order, it delivered the packaged books to the local depot of the courier company.

The online reserve company also implements its computerised inventory control system in the warehouse. This technique includes order handling, recording new entrance of literature, despatching catalogs to the courier company, and flagging stock reorder levels up. So, the business will investigate web sites of stock control system as sample and implement its own one.

Besides, the business will create an area area network (LAN) for in the warehouse by using appropriate media and topology to carry out its functions well.

The company also has a plan to deliver the ordered stock items from the warehouse to the delivery company effectively by using suitable vehicles which includes hardware and software for security management.

The previous plan is to control a security control system to be able to prevent the robbery of staff themselves and regulate the stock reorder level by the time fraud occurs.

The network administrator or supervisor of the "Amazing Literature" online reserve company will be investigating the publication websites and computerised stock control system websites of other companies. He or she is also getting excited about finding the delivery management system and security management system on the web. Then he or she will be writing a report (with recommendations) how to apply theirs company in order to successfully set up.

Task 1

Amazing Catalogs Company is one which wants to manage themselves as a web based reserve sales company. They'll sell their literature via the internet. So, they would like to develop an online site which will screen information about their catalogs. Before it is developed, they look at three websites of the web publication companies that sell theirs via the internet.

The first investigated website is www. bookshopofindia. com. In home page, the pictures of some books are presented. If the pictures are doubled-clicked, the summaries of each book are exhibited. It includes other information such as authors' names, ISBN quantity, price and numbers of pages. In the left-hand side of the house page, the subject matter of the books that are sold in this excellent website are listed. The themes contain religions, arts, business, computer technology, children literature and so forth.

To order the literature, customers can send e-mails, however they can only make payment by using bank account of Corporation lender and Punjab loan provider.

The second examined website is www. boomerangbooks. com. In website, some pictures of normal books are put on the right part. In the most notable, some special ones such as catalogs for Mother's day are placed. In the center of the site, some are advertised by teaching pictures, writers' labels, and short information of them. If the pictures are double-clicked to investigate, the pictures of the literature' comforters and summaries of them with creators' names appear. ISBN, format, number of pages, web publishers, publish time frame and languages are also shown. For the right side, normal price and discount price are compared.

On the left side of the home page, the website arranges some categories to surf for books matching to publication categories, bestsellers, literature from films, and book accolades, etc. It also places book contents. In home page, it amounts a menu called "Boomerang Literature Bulletin". If a user subscribes in this form, he or she can get a $5 publication voucher and 20% discount when savings days are on.

To order the books, the site shows its contact number, e-mail address, and fax number. Thus, customers can order by mobile phone, e-mail or fax nonetheless they pays only Australian us dollars.

The third one that is observed to get showing literature information is www. cherrythitsar. org. This site is the main one where users can get e-books. On the home page, there is a list that details the categories that users can download. These categories contain Myanmar free e-books, Myanmar novels, Myanmar newspapers and so forth. If a person wants to have them, he or she has to make an account by entering customer name and password. Then they might have them.

After looking into these websites offering information for online e book selling, "Amazing Books", the online book company, is putting into action their website. At the top of the house page, the photos of the books that can be purchased for the memorial days will be presented. They'll be sold by gifting ideal discounts. For the left-hand side of the house page, the catalogues of the catalogs will be exhibited in order to search literature by the categories the clients want. The catalogues will queue the lists of the catalogs according to publication categories, bestsellers, catalogs from videos, and book honors, etc.

If the images of the literature in website are double-clicked, the summaries of the literature with books' titles, sorts of books, ISBNs, creators' names, publishers, publishing date, variety of editions, and quantity of pages, etc. will be shown.

Under the every web page of site, you will see company's address and ordering information will situate. Buying information includes phone numbers, fax figures and company's e-mail address. So, customers can order literature by buzzing a telephone call, or making order by fax, or mailing an e-mail.

To order by e-mail customers must fill up chosen items in to the shopping container that is on the right side of the house page. They have to enter their telephone numbers and addresses (including postal code). They are able to enter their loan provider accounts or charge card accounts to order.

Task 2

There a wide range of stock items which are stored in the warehouse of the "Amazing Literature" online booklet store. The stock control system in warehouse is linked with the business's website so customers can view the books that are in warehouse via the web site. If they want to order books, the will their private information including delivery addresses, postal rules and lender or credit accounts.

When customers make catalogs order via website, the business will notify the personnel of the warehouse. The warehouse staff checks the level of stock items and answer the main server. As well as the server keeps the information update and let the customers know information to the web site. Then the company will deliver the literature to a delivery team. And the courier company will deliver books in line with the customers' addresses and postal codes.

To perform these processes effectively, the book store needs a proper inventory control system. So, they gather information for stock control system by exploring web sites which represent their computerised stock control systems.

Required information for recommendations

The first and second investigated websites show their online stock control systems. They show their product information and other associated one. Customers can search and browse they want and they can order them by e-mails. The business that creates the first website is using RFID (Radio Frequency Identification) readers for documenting the new items for the stock. The company also explains its delivery service for bought items. The next website uses barcode audience. It explains their control system of balance degrees of the stock and alerting the flagging up reorder system utilizing the stock control management software.

The third and the fourth one are the websites that sell applications for computerised inventory control management system. They provide the comprehensive information of how to use their software. Both of them are produced to perform the functions of saving customers' order, purchasing, items access, auditing, receiving, shipping and delivery, transferring, confirming and security management, etc. Included in this, the ex - one is utilized with barcode audience and the last mentioned one with RFID for saving new stock items for the system. Customers can buy their software by entering their e-mail addresses, and loan provider or credit bank account quantities in these websites

Methods and hardware for saving stock entry which are in warehouse

After looking into four websites, "Amazing Catalogs" implements its computerised stock control system. First of all, they make purchasing books from a great many other sources. Then your books are put in containers that have RFID (Radio Occurrence Recognition) tags and the pots are transported by appropriate vehicles.

When they appeared to the warehouse of the business, the RFID tags are checked by RFID viewers which transfer the group of digital identities of the literature wirelessly. The label readers discover the plans or storage containers which is made up of several book items.

The RFID readers can check each whole container together and get into data in to the server computer using special stock control management software for inventory control. So, the right data in database of the server can keep updating. Being connected the server with the web site of the company, the info of the literature in web pages is automatically up to date.

(c) Methods and hardware for order processing

To order the e book items, the customers have to load the order form. In this form, the clients must load their information that contains their addresses and postal rules and delivery fees (which price ranges rely upon countries) by means of standard bank or credit account numbers. From then on, they can order catalogs via website of the business.

When the company receives requests from customers, they enroll information of customers and orders in Order record. They check concerned master and deal files to learn how many numbers of which stock items are ordered. In addition they interrogate stock levels in the warehouse using RFID visitors and make details of sending items. These data are entered in to the server to update stock information. They then screen that information in the web site that is linked with server of the company. So, customers can see whether their ordered items are delivered to them or not.

(d) Methods and hardware for recording despatched items

Their next method is to deliver the ordered books to a local courier company. Before they send, they choose books up from the warehouse and pack them into specific packages or containers which consist of RFID tags which can only help the courier firm easy to check them.

Then they deliver those to the delivery companies by appropriate vehicles. If the books appear, the courier companies check the RFID tags of packages or pots by using RFID visitors. Then they start delivering those to the customers around the world by using flights or ships or other appropriate vehicles. The delivery company company sends the things information to be able to revise data in database of the server of delivery company. They'll revise the delivery information whenever the items arrive to their braches in various countries until they reach to the places. So, the customers can view the information on the site when and where their purchased items are showed up.

(e) Flagging up and reorder degrees of stock items

After mailing the purchased item, the website needs to revise that information. To make balance for the reorder level, they use the automated flagging up system using the stock control software giving notation on the server of the warehouse. So, the business can check balance level and determine if they should reorder new literature from other sources or not.

(f) Required hardware for system

To complete the system, in addition they use some varieties of hardware devices. They use Server for the primary control operations for the stock. And they also have to use some varieties of not only security devices for the warehouse security but also special software to control the system and to prevent unauthorized access to data. It explains their balance of the stock and warn the flagging up reorder system buy using stock control software.

Task 3

To execute the computerised stock control system used in warehouse the neighborhood area network (LAN) is conducted. The major requirements of LAN network are topologies and media.

There are numerous topologies though only some are widely used. The most popular topologies are engagement ring, bus and celebrity topologies.

In wedding ring topologies, computer systems are linked by cables in a group or band form. Each computer is straight connected to the next, so no termination is required. Within this topology, token passing method is utilized to transmit data in clock-wise route. So every computer can transfer data fairly. It could prevent high-traffic and time-critical applications. So it is reliable and highly secure. Nonetheless it uses fibre optic cables so cost is high and sees difficulties to install.

In bus topology all pcs are connected with a backbone, a cable portion. In bus topology, signals are dispatched as electrical power parses. If they are delivered, they travel over the cable everywhere. So, data collisions can occur when more than one computer transmit data together. Thus, occupying high-traffic is the major problem; otherwise, cheapness and ease of installation are advantages.

In celebrity topology, all components are linked by cable segments to a central device to converse one another via it. It could reveal network resources and receive and send data from the personal computers in the network all together because it grips multiple connections. So that it pays to where high traffic occurs. It supports centralized management and the central server has a whole main concern over other computer systems. But this topology takes a more involved cable tv set up and high cost. The gain access to of the entire network also loses when the central device fails.

To build a network we also need multimedia. There are two groups of media; bounded and unbounded advertising.

In bounded marketing, there are three types of cables; coaxial cable tv, twisted pair cable, and fiber-optic cable television. Coaxial cable involves two types- slim coaxial (10 Base2) and heavy coaxial (10 Platform5). A couple of two types of twisted set cables; unshielded twisted match cable (UTP) and shielded twisted match cable television (STP). The optical fiber content cable is made up of two kinds; wine glass and plastic material.

The unbounded multimedia or wireless connection technology consists of Wi-Fi, and Wi-Max connection. Wi-Fi includes 802. 11b and 802. 11g at 2. 4 GHz regularity and its speeds are between 11 Mbps and 54 Mbps, and 802. 11a and 802. 11n has 5 GHz frequency and 54 Mbps bandwidth. You will discover two types of Wi-Max connection - set Wi-Max (802. 16-2004) and mobile Wi-Max (802. 16e).

The stock levels displayed in the web site are based upon the sales figures which are in warehouse. Upgrading stock control system regularly can help the stock level. To aid the stock control system a LAN network will be created in the warehouse.

There are two types of systems; peer-to-peer one and server-based one. The server structured LAN network is chosen to implement as it can handle lots of computer systems, more recollection for a sizable database and extra peripheral devices such as printers; normally, peer-to-peer network can handle 10 or fewer workstations.

To configure a server-based network, an appropriate topology and a suitable medium are widely-used. The correct one for this network is star topology. Using central devices such as switches connected with cable sections, it helps centralized management for the entire network. It stocks resources and usage of clients simultaneously without traffic.

Unshielded twisted match cable can be used as medium. It ranges into seven categories. Included in this, category 5 is chosen since it is created for 10 Mbps Ethernet whose quickness is up to at least one 1 gigabit. It can connect even 1024 nodes and can run 100 meters distance. It also provides ease of trouble taking pictures all nodes of the network.

After configuring topology and medium, a server-based LAN is carried out. First of all, the OSs is installed in the server computer. Then Dynamic Index Service (Advertisement) is installed. So, it becomes a domain name server which can control client nodes in the workgroup.

There is a network administrator as the official consumer of the server computer. This administrator will control security, access and customer accounts of each client-computer end user. Being centralized supervised network, only server one can share resources however the client cannot. Data can only be up to date, or erased by the administrator who uses the server computer and not by the client.

Thus the administrator can check and control the databases using the information reported by clerks who provide data worried about sales characters. Therefore, this repository may offer up-to-date information for the stock control system because it is dependant on the sales characters. The computerized stock control system is being linked with the website via internet. So, regularly updating the data of the stock control system means the website shows the info package with the status of the literature items that are in ware-house. This makes customers easy to find the information they need and order books by filling up order form that shown in company's website.

Task 4

The company will advise the personnel of the warehouse about the information of the bought literature when they received confirmed orders and cost by bank or credit accounts from customers via their website. In addition they acknowledge the customers about the confirmation. The voucher numbers of the ordered literature and the DNS of the courier's website are also given.

Processing Order in Warehouse

After getting the ordered statement, the staff members in the warehouse make to deliver the stock items. First of all, they check to ensure whether the level of the stock level is complete or not. Then they put together to send them to the local delivery company. They first of all put and pack the books through ordered volume and game titles in the plans or containers. Then they fix an RFID tag which contains an electric serial amount on each container. The info of the sent items is designated through an RFID reader which can find the electronic alerts of serial amounts of the books. Then the information is moved into the server computer to update the info in database.

Transferring stock to local courier company

Then they transfer containers of catalogs to the local courier firm by taking suitable vehicles that happen to be fitted Gps navigation (Global Position Service) system to point the routes and time taken of them and acknowledge the business what time where they are really.

When the pots of books occur to the delivery team, they are checked out with RFID viewers again to recognise what time the delivery items are received. It makes ensure not only the companies are prevented by theft of staff but also they are safely arrived and if they are the correct ones or not.

Delivering companies by Courier Company

The delivery team starts off the provided items entry into their website after checking them. Across the pathways of wherever they deliver the stock until they reach to the vacation spot, they regularly upgrade information on their website. So, customers can check the delivery information via the website of the courier company if indeed they want to trail about their purchased catalogs' information.

The delivery company delivers the ordered stock items according to the customers' addresses and postal codes. In the event the addresses and postal codes indicate a customer is at local, the company uses cars to move them. Usually, they firstly send by using shipping delivery to the overseas countries where in fact the branches of their company are situated and they send with their destination addresses and postal rules at last.

Updating data

Each branch of the courier organization also reports to their main office and any office also return the info to the "Amazing Catalogs" company before ordered e book items are received by the customers. The online e book store company also updated the info in their company's repository in main server.

Being linked with the server of the courier company, the info of the books in their website is also updated. So, the customers can see where the items they may have ordered so when they will receive them by getting into the voucher amounts of them on the website of the courier company.

After the purchased books are transferred from the delivery company to the clients, the company also reports to their main office again. The main office of the company also replies to the web e book store company. And the book store renews the info in data source of the server to be able to check the balance stock levels through automatically flagging up system.

Task 5

"Amazing Literature" online reserve company helps to keep in a sizable amount of booklet items in the business's warehouse. The stock items in the warehouse are stored by workers of its. To secure the warehouse and the literature in it, a security management system is needed. This system is also required to prevent unauthorized access data of the business. The company should also take into account the theft or access data without permission done by workers of the company themselves.

(a) Solutions to prevent robbery and keep an eye on the staff

To implement the security management system of the warehouse, both hardware and software are needed. At first, the local area network (LAN) will be made out of Star topology to regulate the centralized management of the business's LAN network. Furthermore, the network administrator should also manage the precise working hours, authorized gain access to, and login passwords, etc of a person personnel. So, unauthorized gain access to that seeks getting company's important data in database of the server dishonestly can be overcome. Additionally, it may prevent the scams of personnel.

Moreover, there must be some programs to detect and prevent the theft of stock items in warehouse. The most likely thing to keep an eye on inside the warehouse is CCTV camcorders. They will let the administrator or manager watch inside the warehouse on a regular basis. He or she can immediately know if robbery is happened.

Besides, there should be some restrictions at the access and exit of the warehouse. Using retina scanning device at the entrance is an effective method. The scanner will sense the retina of every staff to split up if the person has the authorization to enter into the warehouse or not. It will make the record of each and it'll alarm if something doubtful is took place. An EAS (Electronic Article Security) should be set at the leave of the warehouse and everybody must be through when they leave the warehouse. It'll detect each individual using radio rate of recurrence technology and alarm when the personnel takes the publication items out without registering for despatched functions.

(b) Adjusting the stock levels when theft occurs

Before employing the security management system of the warehouse, the stock levels of the catalogs should be checked out to ensure that the quantity of the stock before they are simply stored in it. Once the books that happen to be bought from different sources turn up to the warehouse, these are checked out with RFID visitors. Then the information of the catalogs is transferred into the server computer as unique serial numbers of each. This event makes revise the info in database. The server then stores the info of the books which includes volume, books' game titles, and ISBN, etc.

When the books are delivered, they may be packed in storage containers which have an RFID label and are rechecked with RFID visitors again. Then checked data and data in databases of the server are in comparison to confirm. If they are not same, the administrator can know the books are thieved by personnel and she or he should review the security data.

Automatic flagging up system also alerts when the quantity of literature are less to acknowledge the administrator. So the administrator can check the balance degree of the shares and reorder new literature from sources if possible.

Task 6

The article is stated in order to spell it out the suggestions of how to set up the computerised stock control system of the "Amazing Catalogs" online books company. The summarising reviews for every procedure are the following:

Reviewing Task 1

The company investigates three online books websites via internet. They analyze the features of web sites in details, i. e, the presentations of the literature, offering and order information, delivery information, and discount information, etc. They will put into practice their own by using the facts which are based on the advice.

Reviewing Task 2

The company explores four computerised stock control system websites. They set up their own computerised inventory control system in the large warehouse of the business.

First of most, they will record the stock information by using RFID viewers when the securities occur to the warehouse. Then they will transfer that information to the databases of the server of the warehouse to be able to update the info. The information in website will also keep updating because it is associated with the server of the company.

When customers want to order books via website, they have to fill up the order varieties which contain the info deal with their addresses, postal rules, and loan company or bank card account amount.

Then they'll transfer the shares to local courier company by appropriate vehicles. From then on, they will upgrade the info of books supplied in data source of the server again.

In the warehouse of the business, you will see an automatically flagging up system. They will fix this system to car check the balance level and level of the stock. It'll alert the company when the new companies should be reordered.

Reviewing Process 3

As the 3rd step to execute the company's stock control system, they'll create a local area network (LAN) in the warehouse using appropriate media and topology. The LAN will be setup as a server based one to be able to centralized manage the whole network. The website of the business will be associated with the server therefore the information in website will continue to keep updating.

Reviewing Activity 4

After obtaining the containers which contain catalogs, the courier company will check companies' RFID tags with RFID visitors and make data the catalogs information. This information will be moved into their company's server computer to upgrade data in databases. As it is also associated with the website of the company, the delivery information will also upgrade.

The delivery company will usually upgrade the delivery information whenever the stocks arrive to their branches that happen to be in international country. They will keep upgrading until they reach to their destination addresses. Customers can view what time at where their bought literature are via the website of the courier company.

Reviewing Activity 5

There may also be a plan to avoid thefts done by personnel as the company is establishing their online publication retailing system and computerised stock control system. To prevent those events, the administrator will screen the personnel by using CCTV cams. He or she will also use retina scanning device at the entrance and EAS (Electronic Article Monitoring) system at the exit of the warehouse. To prevent unauthorized access, the administrator will deal with the precise working hours, approved gain access to, and login passwords, etc of each employee.

The stock levels are record by RFID viewers when they reached to the warehouse. That information will be moved into server of the warehouse. When the books are delivered to the deliver organization, they may be rechecked with RFID readers again and moved into server to be able to update the info of stock levels. There will be an programmed flagging up system to alarm to acknowledge the administrator. So the administrator can check the balance degree of the stocks and options and reorder new literature from resources.



http://www. bookshopofindia. com

http://www. boomerangbooks. com

http://www. cherrythirsar. org

http://www. isisasset. com

http://www. trakersystems. com

http://www. controlelectronic. com

http://www. rfid-library. com

http://www. dhl. com


Title Guide to Networking Essentials

ISBN 14188-3718-0

Author Name Greg Tomsho, Ed Tittel, David Johnson

  • More than 7000 students trust us to do their work
  • 90% of customers place more than 5 orders with us
place an order

Latest posts

Read more informative topics on our blog
The Educational Curriculum INSIDE THE Philippines Education Essay
Education The educational curriculum in the Philippines is low in comparison to other countries. Other countries are able to find out more advanced...
The Ecotourism In Scotland Travel and leisure Essay
Tourism Hospitality and travel and leisure are very closely linked; every time a tourist comes to Scotland there are lots of restaurant and hotels to...
Corporate Social Responsibility: Targets and Concepts
Business Abstract Corporate Social Responsibility is a management principle whereby companies integrate social and environmental concerns in their...
A Personal Reflection AROUND THE ITM Information Technology Essay
Information Technology I have been in information technology industry for a long time. I have first-hand information technology experience especially in...
The Theory Of Mcdonaldization Commerce Essay
Commerce McDonaldization is the process where the concepts of the junk food industry have come to dominate an increasing variety of organizations in...
The Interpretation Of Life Quotes
Philosophy As you all know most of us are here in this planet for a while only and our life or being blessed as a individuals is a gift irrespective of...
The Sex Appeal In Advertising Mass media Essay
Media Through the years we have found a diversity advertising resources for offering products which were calling the attention of the costumers, to be...
Impacts of Tourism Deregulation and National Security
Marketing National security is definitely an issue going out with back to as early as when man started out arranging himself in contemporary society....
Homogeneous And Differentiated Product In Microeconomics Economics Essay
Economics The economic issue in this observation involves the concept of homogeneous and differentiated product in microeconomics According to Lindeman...
Check the price
for your assignment
we accept
  • Visa payment system
  • MasterCard payment system
  • Payoneer payment system
  • PayPal payment system
Money back
100% quality
Plagiarism free writing service