Introduction to Fixed Asset Management

There are obvious benefits from implementing and maintaining a record and control over assets. Savings can be obtained from being able to both see current asset deployment and thenby maximizing their use. Monitoring assets will reduce unauthorized use or misappropriation and insure employees leaving a firm return assets under their control. In some cases a system is mandated by government regulations, terms of lending, public grant terms, insurance terms etc. One person can maintain and manage all fixed assets of a business if they have software to assist them. Computer systems and software available reduce complexity, save time and prevent mistakes. Why use an asset management software program?

While paper and pencil methods can be used, software programs assist in the recording, maintenance and auditing of assets. This saves time and gives a clear picture of assets since sorting and viewing in different ways is quick and easy.

The most basic 'solution' would be using a spreadsheet program such as excel. Even after migrating to software specifically designed for asset management there are times that a spreadsheet program may continue to be useful.

What is an Asset?

What you call an asset often depends upon your business activities. The first thing that comes to mind is fixed assets such as computers, production equipment, office furnishings etc. You might even wish to consider employees as assets or even service and maintenance contracts. A flexible asset management software program can provide a way to track many things most of us would not consider to be assets.

What are my first steps in setting up a system or 'solution'?

1: Decide what assets will be managed.

The more assets the more work in setting up your system. Limiting assets to only those over a certain dollar value is a good idea.

2: Deciding what characteristics of assets it is important to record within the software.

Your choices will not only have an effect upon the amount of work required but also the amount to which you can manipulate and view asset information by sorting on asset information field or combination of fields.

For example if you setup a field for 'location' then you can sort data to see what assets are in each location. If you also have a field for 'type' or 'class' then you could further sort and display to show only certain types of assets such as computers at one or more location.

As in every aspect of life one has to make tough choices between what is ideal and what is feasible. Your choices will have an effect upon data data when new assets arrive as well as collecting information about existing assets. Choices you make will also have a bearing upon your choice of software since some may not handle everything you want. One such a limitation is found within the AssetTrakker Pro software program. TrackitSoftware does not provide a method of tracking depreciation because it was felt this added too much complexity requiring the collecting and maintaining of a lot more data. Additionally, they felt, handling depreciation requires superior knowledge of government rules and regulations beyond the expertise of the very people that stand to benefit most from asset management. Accounting departments already calculate and account for depreciation. * Some software does promote depreciation calculation but only limited functionality that in most cases is not the way regulations demand.

Some help!

Below is a listing of Asset Attributes 'fields' for your consideration. You will not want to use all of them for your own 'solution' and may well have additional ones you need.

Asset #: The key identification reference used to track assets. They can be straight numbers or a number with an alphabet prefix. (0001 or A001). This number is used for audit purposes and for cross-reference.

Make: Manufacturer

Model: Use when arranging service or buying parts. Use as allowed grouping by model type.

Serial #: Specific asset identification. Needed when making warranty or insurance claims.

Cost to Repl .: Estimate the cost of replacing an asset. Useful for planning, risk assessment and insurance.

Cross Ref. #: Reference other asset number or tie together group of assets.

Type: Can be used for general grouping such as furniture, computer, shipping, etc.

Condition: Helpful to see what is likely to require replacement or decide on service needs.

Description: Other detail in addition to make, model, and serial number.

Memo: Additional information about the asset. If a computer you might want to list details of the hardware configuration or even the programs installed on it.

Department: This is helpful for sorting assets by department to assist in auditing.

Location: Good field to have so that a search / sort can give you a clear view of where assets are located.

Used by: Necessary if you have assets in the personal possession of an employee and / or assets off business concessions.

Date Assigned: Useful if assets are moved around or for telling how long an asset has been at its current location.

Expected EOL: The anticipated date when the asset will no longer be useful.

Funded by: Source of funds if provided by Bond Issue, or outside funds (loan) or a grant.

Cost: Total cost of acquiring an asset.

Date Acquired: Helps give some idea when replacement may be required.

Disposed: Indicates an asset has been disposed of.

Disposed Date: Date asset was disposed of.

Business Use%: Used if an asset is not used full time by the business to break down asset use. Not for everyone, but a field that imagination might find an indispensable use for.

OUT: Used for Tool / Equipment Tracking,

Taken By / In From: Used for Tool / Equipment Tracking to indicate who is taking or returning item.

Date Due: Used for Tool / Equipment Tracking to show when an asset is due back.

Recovered Value: Net proceeds of the disposal of an asset.

Disposed Detail: Notes on how and where an asset was treated of.

Warranty: Indicates if asset is covered by a warranty or could be used if covered by a service / maintenance contract.

Warranty Expiry: It is useful to see what expiries are approaching for tracking maintenance or service agreements. Helps prevent paying for service covered by warranty as well as prompting the repair of items before expiration.

Image: Can assist in asset identification or where 'look' is an important feature. Useful if insurance claim ever made.

Value: Could be amount the asset is insured for. Risk exposure control.

Leased: Helps keep track of Leased vs Owned assets.

Lease End: Used to warn when assets have to be replaced or the lease has to be renewed according to the terms of the lease.

Lease Start: Commencement date of lease on leased equipment.

Lease Co: The name of the company from which an asset is leased.

Audit Date: This column records the date the batch scans of assets were made for audit purposes.

Auditor: Record the name of the person who performed the audit.

What next?

By now you have a good idea of ​​what asset information you want to track. Before looking at the various software packages available you should consider how many people will be entering data and how many will be accessing the data. For a smaller organization it is likely that just one person will be involved but in larger firms despite a number will wish to participate. Your situation could require purchasing more than one software license and the software must support multiple users.

Use a Barcode Scanner?

A barcode scanner can be used to speed data entry and auditing. This will add to the cost and most lower priced software packages offer limited support for barcode scanners. If properly incorporated into software a scanner can provide excellent value and save a lot of time, particularly for annual audit purposes.

Below are outlined the types of barcode scanners used with asset management software.

A 'dumb' tethered ccd scanner is cheapest and purchased for around $ 70. This can only be used when plugged into the computer and acts just to a keyboard in that you scan a barcode and it is put into whatever cell or space you are in.

A 'laser' tethered scanner is more money but will be able to scan smaller barcodes and sometimes have a defect field of view (easier to scan a barcode quickly).

A ccd or laser scanner which has built in memory so scans can be made and then the scanner can be brought back and plugged into a computer, and those scans uploaded. This is extremely useful for audit purposes. For maximum utility your software should be optimized to take advantage of this 'batch' memory capability. A capable unit can be obtained for around $ 150.

A laser scanner with internal memory, as well as an input screen and keys, means that after scanning a barcode you can add additional information. These are more expensive and again their use has to be integrated into your management software. While prices are coming down you are looking at units in the pocket pc price range plus scanner cost. It is usual for software utilizing these units to also, for some reason, be priced higher.

Asset Management Software

The range of prices for asset management software is $ 200 to $ 10,000 and all require you to do the entry of existing asset data as well as some setting up for your requirements. Some offer telephone advice at additional cost but hands on assistance only comes with expensive packages (this level of software requires expensive sales force and marketing expense so possibly their price, for the features provided, may seem high).

Purchasing Criteria a lot of people seem to use. You may have more.

1: Price 2: Ease of implementation of system 3: Ease of use 4: Ability to fit the business 5: Functionality 6: Potential to handle growth

What you can obtain for a reasonable price

A program with full relational database, such as MS SQL Server Express, or open source database. Today there is no reason to set for less power or quality. Microsoft provides their SQL 2005 'Express' DB version at no cost.

A program that allows you to attach images of assets. While not necessary for everyone it is something that someday you might want to use.

A program that integrates the use of inexpensive 'batch' memory barcode scanners because, if not now, at some point in the future such an accessory will save time and money. Used in auditing it assures an asset was actually seen as barcode had to be scanned.

A program that will permit the management of 10,000+ assets. With decent memory in your computer and a fast full relational database engine there is not much of a limitation anymore and while certain functions may slow down a bit even a low cost program should handle over 10,000 assets.

A program that is flexible so you can take advantage of features later instead of having to implement everything at once.

* If more than one person is to be given access to the database then you should ensure that different levels of access can be set for different users to prevent unauthorized changes to data.

What you can get but not cheaply.

A program that integrates directly into your current accounting system.

A program that has full professional depreciation calculations.

A program that runs directly off your company server (lower cost software runs off workstations and while a central database can be located on your server and accessed by individual workstations this is not the same as complete software being server based with applets on workstations.

Hand holding and in house training to get your system up and running. There are firms that will sit down with you and ask you all the right questions, set up your software, audit and list all your assets and then train your staff how to operate and maintain your 'solution'. Most, to my knowledge, will recommend a mid to high priced software because it is easier to sell (commission higher as well) and easier for them to install due to their familiarity with it.

Nuts and Bolts

Gathering your Asset Information How you perform this step depends upon your situation. In our discussion below we assume you do not have existing asset information, in an existing excel spreadsheet or other format. If you do then you would save work by exporting / importing that data into your asset management software.

Starting your Asset Listing and Numbering from Scratch

This is an advantage because you are not limited by inherited constraints. Of course it is more work, as you can not just load in existing asset information but have to collect everything yourself.

Collecting asset information is time consuming. Getting this information accurately, with as little work as possible is important. Thinking about how to do the job and planning will help make this big job easier.

The following is how I suggest doing this but you may have your own, sometimes better plan.

Create data entry sheets that you will have people write in information about assets under their control. Your asset management software may create these or you could make up an excel spreadsheet to obtain them.

Try and obtain some 'buy in' from the department or location manager with control over assets. The closer to the asset you can allocate some responsibility the better that asset will be controlled. 'It's my department's asset' is more powerful an incentive than 'it's IT Dept's asset'.

Final steps

After entering data, that your co-operative managers helped you obtain, it is time to work with that data within your asset management software. It should not take long to become familiar with how it can present information to you on screen and in reports.

Now sit back and enjoy how easy it is to manage your assets.

Posted in general | Comments Off on Introduction to Fixed Asset Management

The Importance Of Excel In The Workplace

Excel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.

Outside the workplace, Excel is in broad use for everyday problem solving.

Let’s say you have a home office. You can use Excel to calculate sales tax on a purchase, calculate the cost of a trip by car, create a temperature converter, calculate the price of pizza per square inch and do analysis of inputted data. You can track your debt, income and assets, determine your debt to income ratio, calculate your net worth, and use this information to prepare for the process of applying for a mortgage on a new house. The personal uses for Excel are almost as endless as the business uses for this software – and an Excel tutorial delves into the practical uses of the program for personal and business use.

The use of spreadsheets on computers is not new. Spreadsheets, in electronic form, have been in existence since before the introduction of the personal computer. Forerunners to Excel and Lotus 1-2-3 were packages such as VisiCalc, developed and modeled on the accountant’s financial ledger. Since 1987, spreadsheet programs have been impacting the business world. Along the way, computerized spreadsheets have become a pervasive and increasingly effective tool for comparative data analysis throughout the world.

Today, end users employ Excel to create and modify spreadsheets as well as to author web pages with links and complex formatting specifications. They create macros and scripts. While some of these programs are small, one-shot calculations, many are much more critical and affect significant financial decisions and business transactions.

Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become a staple of end users and business professionals.

The beauty of Excel is that it can be used as a receiver of workplace or business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation. Excel can create a chart or graph, operate in conjunction with Mail Merge functions, import data from the Internet, create a concept map and sequentially rank information by importance.

Excel offers new data analysis and visualization tools that assist in analyzing information, spotting trends and accessing information more easily than in the past. Using conditional formatting with rich data display schemes, you can evaluate and illustrate important trends and highlight exceptions with colored gradients, data bars and icons.

Indeed, Excel can be customized to perform such a wide variety of functions that many businesses can’t operate without it. Excel training has become mandatory in many workplaces; in fact, computer software training is a must for any workplace trying to keep up with the times.

Let’s say you’re an employer with 97 workers, 17 of whom called in sick today, and you want to know the percentage represented by absentees. Excel can do that. You can learn Excel and use it to determine the ratio of male to female employees, the percentage of minorities on the payroll, and the ranking of each worker by compensation package amount, including the percentages of that package according to pay and benefits. You can use Excel to keep track of production by department, information that may assist you in future development plans. You can create additional spreadsheets to track data on vendors and customers while maintaining an ongoing inventory of product stock.

Let’s say you want to know your business production versus cost. You don’t have to be a math wiz – you just have to learn Excel. Excel allows you to input all of the data, analyze it, sort it according to your customized format, and display the results with color, shading, backgrounds, icons and other gimmicks that offer time-saving assistance in later locating precisely the information desired. If this spreadsheet is for presentation purposes, Excel helps you put it together in such a visually appealing way that the data may seem to pop and sparkle.

The single most important thing an employer may do is learn Excel – it is one of the most essential tools of the workplace.

Excel and Microsoft are trademarks of Microsoft Corporation, registered in the U.S. and other countries. Lotus is a registered trademark of International Business Machines Corporation in the U.S. and/or other countries.

Posted in general | Comments Off on The Importance Of Excel In The Workplace

Strengths and Weaknesses of Waterfall Approach for Software Development

One of the most famous and widely used approaches for software development is the waterfall model. Waterfall approach is an old technique that has been in use for quite some time, but in modern times agile approach is gaining prominence.

Waterfall approach, as is evident from the name, refers to a systematic approach where one step comes after the other. It cannot go the other way round. The process works like the waterfall effect that flows in one direction, which is from up to down.

In this process the life cycle of the development process is predetermined. All the steps are defined before the start of the project. The approach is predictive, where the team is well aware of the order of each step and therefore works accordingly. It starts from the requirement analysis, the design phase and then proceeds on to the implementation, testing and the maintenance phases.

The waterfall approach can be quite beneficial for those who are quite clear on their requirements. A planned approach works for them because they want fixed processes and budget. Where fixed processes are beneficial, at the same time they can be inconvenient at times. In cases where the client is not clear on the requirements and finds in the middle of the project that he/she wants to change course, this approach can prove to be quite problematic.

Another point of the waterfall approach is that the requirement analysis and design of architectural structure can consume a lot of time. Extensive research is done initially as the next phases depend completely on the planning strategy. However, the good thing is that everything is thoroughly worked out and each aspect is studied beforehand. The developers in such cases know what is expected of them.

A waterfall approach works in a systematic order, with one step following the other and the testing phase comes in the end. If there are any big problems encountered in the testing phase, it means a long process to make the amends. The process can consume extra time and money.

We cannot conclude that one approach is better than the other, as every method would have its own strengths and weaknesses. The determination of success for each method depends on how it is being used and whether the approach suits the scope of work being undertaken. While one approach may be suitable for a particular project, it might become totally useless under different circumstances. For example, some believe that agile methods are not well suited for offshore development, as they require a closer contact and communication that is not possible in an offshore project.

Posted in general | Comments Off on Strengths and Weaknesses of Waterfall Approach for Software Development

Effective Job Numbering And Cost Code Systems

Overview

Many companies have a sequential job numbering system, but have you considered the possibility of altering the numbering sequence so you can pull reports for a certain type of project or projects by year and the informational reports that could be generated?

And, are your cost codes sufficient to cover the details you need to see in your reports? Do you lump all site related travel and subsistence into one code, or do you have the details of hotels vs. Housing and meals vs. Subsistence?

Not all software programs are sophisticated enough to allow for customized job type numbering sequences; However, even the basic job cost software systems can be adapted to allow for an advanced numbering system.

Specific Job Numbering Sequences

Advanced reporting techniques can yield a wealth of information. How jobs are numbered so ease the reporting burden so projects of a certain type and / or year can be easily excluded from the software. Samples of numbering sequences could be based on the following criteria:

· Year project was awarded

· Public vs. Private works

· Commercial vs. Residential

· Construction vs. Service

· Division (s) of the Company

If your software allows, you may start the job number with the year awarded, followed by the job type and then a sequential number. Management may request a report for gross revenue on all the commercial contractor improvement projects in 2013. If you have a numbering sequence, this would be an easy report to pull, rather than go through all your 2013 projects and manually add the numbers to obtain the Results.

The job cost master file is another good source of information if all fields are completed and there is a common usage of custom fields that can be used to pull reports.

Cost Codes – Too few or Too Many?

Often we see cost code lists that spill onto multiple pages. Most job cost software programs allow for use of one cost code for multiple categories (Labor, Materials, Direct Job Expense, etc.).

A good source to use for establishing a cost code list is the bid recap and detail sheets used when bidding projects. This will yield the different stages of labor, types of materials to install associated with that labor, the different types of equipment to be rented, categories of subcontractors and the details of direct job costs to be incurred.

These activities can be "numbered" to establish a list of cost codes. If the software allows for use of one code across multiple categories, give thought to not duplicating descriptions, but arranging codes together by "type" of work being performed, rented equipment, direct job expenses, work typically contracted out, etc.

Keeping your cost codes consistent will then allow even more sophisticated reporting – management can now ask for all commercial contractor improvement projects in 2013 and the total cost of crane rentals for the year on those specific projects.

Why Go Through These Steps?

History is a great source of information when anticipating the future. Cost details can be analyzed for specific types of jobs when preparing to bid a similar project. Historical information can be analyzed for margins on certain types of projects or a division of the company to make decisions on whether or not a certain type of work is profitable.

If fields are available in the job cost master file, reports can be declined not only by type and year but by project manager as well to look at performance and estimate vs. Actual results.

Conclusion

When developing any numbering system, consistency is important in order to maximize the reporting results. Management should determine the information they wish to see and develop job numbers and cost codes that will allow for advanced reporting not only to themselves but provide useful information to estimating, project managers and accounting as well.

Posted in general | Comments Off on Effective Job Numbering And Cost Code Systems

How to Fix an Error Accessing the System Registry Easily

The system registry is an important component to practically every computer, and it would actually be considered a pile of electronics if the system registry was not included. It is essential for computers based on Windows, since it is the storage location for the hardware, software, and pretty much everything that makes the computer run.

Changes and updates go directly through the system registry for storage, but sometimes things do not always go as smoothly as we wish. Not many know what to do about an error accessing the system registry, but it must be fixed in order to keep your computer running.

An error accessing the system registry is not very uncommon, and it usually occurs when old files or updates are still located within the registry. The error can occur when new updates are downloaded, new programs installed, or even when new software is being added to your computer. A window will usually pop up stating “error accessing the system registry” and not much can be done until the error is fixed.

It can result from old updates being left in the system, or even old files that were not deleted when a download or installation was incomplete. The best way to get rid of the error accessing the system registry is to find out the problem, get rid of old files, and start fresh with new updates and software to keep your computer running smooth.

Because the error accessing the system registry can occur for a number of different reasons, it can sometimes be hard to locate the specific problem. The first step is to determine what exactly triggered the error, such as a new download, new software being installed, or updates occurring to current software on the computer.

The error is most common when updates occur or when updated software is installed, since most likely older versions are still being kept within the registry. In this case, the error accessing the system registry can be easily correct. First off, the installation or update needs to be stopped. Then the system registry can be accessed by the computer owner, and software can be purchased or downloaded to fix this problem.

One of the best options for getting rid of an error accessing the system registry is a registry fix program, since it goes in and does all of the work for you. Rather than trying to find the damaged files and delete them yourself, the program knows exactly what to look for and get rid of for the error to go away.

Not only will a registry fix help to get rid of the problem occurring now, it can even help to get rid of any files and old updates that may cause problems in the future. It is beneficial for clearing your computer of any unnecessary files or programs that may be causing it to run slow, and can even prevent an error accessing the system registry in the future.

A registry fix program can either be downloaded online or purchased at an electronics store, and is a great way to fix an error accessing the system registry. It does all of the work for you, and can even improve the overall performance of your computer. It can get rid of old files, partial updates, or even programs that are no longer needed, and is perfect for fixing your error accessing the system registry.

Posted in general | Comments Off on How to Fix an Error Accessing the System Registry Easily

Top 4 Benefits of Demand Planning Software

In today’s dynamically changing business environment, organizations have to be agile and quick in responding to market changes and internal factors to minimize losses and leverage opportunities. Demand Planning Software is essential to gauge customer demand and market changes in real time and pass on the information to the supply chain. It creates the perfect balance between market demand and supply. However, these are not the only benefits that a demand planning software offers. It has many other benefits and some of them are listed here.

It Helps in Accurate Revenue Forecasting: A good demand planning software help in accurate revenue forecasting by correctly analyzing the market demand and forecast results based on that. Without proper information and software to process that information, organizations bring products by guessing the customer’s demand. Some even take sub-par data that has not been properly processed to reach conclusions. Being a result of guesswork, this information or data does not always deliver favorable results. This software helps in analyzing data properly and then forecasting the revenue accordingly.

It Assists in Aligning Inventory Levels: When there is a huge demand in the market, a business can lose out on the opportunity of fulfilling it on its own if it not prepared with the right inventory. By knowing about the possible future rise or fall in the demand for a product, they can align the inventory levels to make sure that they reap the benefits and their customers are satisfied.

It Enhances the Profitability for a Product: If there is low demand for a product, a company may or may not decide to carry on with it. However, if it is bound to bring bigger profit margins despite low sales, it is worth investing time and money in. Using the Demand Planning Software, businesses can find out how to enhance the profitability of a product.

It Allows for Re-planning Based on Given Data: It is important to keep an eye on the market during the production and marketing lifecycle of a product. And the simple reason behind it is the need to re-plan or alter strategies to get maximum attention and beat the competition. By looking at the changes, decision makers can make amendments to the approach as well as the strategy to meet their business goals.

Their cloud platform mPower supports various aspects of businesses such as demand planning, retail planning, business integration management, supply chain planning, etc. The platform’s design allows business to do smart resource management and make intelligent business decisions.

Posted in general | Comments Off on Top 4 Benefits of Demand Planning Software

Define Computer Hardware

It is quite well known that the working of the computer is dropped by hardware and software. One can define computer hardware as the electronic, magnetic, and electric devices that carry out the computing functions. Hardware is the physical components of the computer like microprocessor, hard disks, RAM, and motherboard. The peripheral devices such as monitor, mouse, keyboard, printer, and speakers can also be included in the list of hardware parts. The programs that run on the computers like Windows, C ++, and Photoshop are the software parts of the computer. A good example for an easy understanding of hardware-software definition is music CDs. The actual compact disk is the hardware, while the songs and music in the CD are the software parts.

There is another way to define computer hardware. Hardware devices are the executors of the commands provided by software applications. For example, let us see what happens when you click the print button of the web browsing software. The software application provides a command to the processor, which is the central part of all computer hardware. Processor in turn checks for an attached printer. If the printer is ready, the software will get a positive response from the processor. Then the software application provides instruction to the printer via the processor to print the web page. In that sense, hardware parts are the foot soldiers and software applications are the commanders in the digital operation that takes place within a computer.

The main player of computer hardware is unduly the microprocessor. It is the sun in the solar system of computer hardware devices. It is the central component and all other components work around it. It is an integrated chip on which a number of functions are incorporated. Two specifications determine its efficiency. One is its processing speed, which is measured in gigahertz. The other is its bit rate. Commonly available processors are 32 bit and 64 bit. The bit rate is a measure of the efficiency of a processor to carry out multiple operations at the same time.

One can not define computer hardware without mentioning the two types of memory used in computers. One is permanent memory. It refers to the magnetic storage capacity of hard disk. It is measured in gigabytes. The second is RAM or random access memory. This memory is able to store data only when the computer is switched on. The memory will lose all the data when the computer is switched off.

Another important product that one should mention when one defines computer hardware is motherboard. It is the electric and electronic circuit board on which all the other components are inserted. There are several other kinds of products such as sound card, video card, network card, and modem that complete the hardware spectrum.

Posted in general | Comments Off on Define Computer Hardware

Wide Area Network (WAN)

Types and Characteristics of WANs

What is a WAN?

There are two prevailing definitions of a Wide Area Network (WAN). The book definition of a WAN is a network that spans large geographical locations, typically to interconnect multiple Local Area Networks (LANs). The practical definition of a WAN is a network that traverses a public network or commercial carrier, using one of several WAN technologies

What are its Main Components?

The main components for a WAN are routers, switches and modems. These components are described below in the hardware section.

CPE – Devices on the subscriber contracts are called customer premises equipment (CPE).
The subscriber owns the CPE or leases the CPE from the service provider. A copper or fiber cable connects the CPE to the service provider's nearest exchange or central office. This cabling is often called the local loop, or "last-mile".

DTE / DCE – Devices that put data on the local loop are called data circuit-terminating equipment, or data communications equipment (DCE). The customer devices that pass the data to the DCE are called data terminal equipment (DTE). The DCE primarily provides an interface for the DTE into the communication link on the WAN cloud.

Hardware

In a WAN you will need various types of hardware components for it to function. The typical items of hardware that you will need in a WAN are:

Router – An electronic device that connects a local area network (LAN) to a wide area network (WAN) and handles the task of routing messages between the two networks. Operates at layer 3, and makes decisions using IP addresses.

Switch – A switch is a network device that selects a path or circuit for sending a unit of data to its next destination. Operates at layer 2, and uses MAC addresses to send data to correct destination.

Modem – Short for modulator / demodulator, a modem that enables a computer to communicate with other computers over telephone lines. Operates at layer 1, where signals are converted from digital to analogue and vice versa for transmission and receiving.

Wan Standards

WANs operate within the OSI model using layer 1 and layer 2 levels. The data link layer and the physical layer. The physical layer protocols describe how to provide electrical, mechanical and functional connections to the services provided by the ISP. The data link layer defines how data is encapsulated for transmission to remote sites.

Encapsulation

Encapsulation is the wrapping of data in a particular protocol header. Remember that WANs operate at the physical layer and the data link layer of the osi model and that higher layer protocols such as IP are encapsulated when sent across the WAN link. Serial interfaces support a wide range of WAN encapsulation types, which must be manually specified. These types include SDLC, PPP, Frame delay etc. Regardless of WAN encapsulation used it must be identical on both sides of the point to point link.

Packet and Circuit Switching

Circuit switching and packet switching are both used in high-capacity networks.
The majority of switched networks today get data across the network
Through packet switching.

Circuit-switching is more reliable than packet-switching. Circuit switching is old and expensive, packet switching is more modern.

General Routing Issues

What is a Routing Protocol?

A routing protocol is a protocol that specifies how routers communicate and exchange information on a network. Each router has prior knowledge of its immediate neighbors and knows the structure of the network topology. The routers know this because the routing protocol shares this information.

Protocol

RIP (Routing Information Protocol) was one of the most commonly used protocols on internal networks. Routers use RIP to dynamically adapt changes to the network connections and communicate information about which networks routers can reach and the distance between them. RIP is sometimes said to stand for Rest in Pieces in reference to the reputation that RIP has for breaking unexpectedly and rendering a network unable to function.

Routing Algorithms

Distance Vector

This type of routing protocol requires that each router simply inform its neighbors of its routing table. The distance vector protocol is also known as the bellman-ford algorithm.

Link State

This type of routing protocol requires that each router maintain a partial map of the network. The link state algorithm is also know as Dijkstra's algorithm.

IGRP

IGRP is a type of distance vector routing protocol invented by cisco used to exchange routing data in a autonomous system. Distance vector protocols measure distances and compare routes. Routers that use distance vector must send all or a portion of their routing table in a routing update message at regular intervals to each neighbor router.

Addressing and Routing

What does routing mean?

Routing is the process of deciding how to move packets from one network to another.
The directions also known as routes can be learned by a router using a routing protocol then the information is passed from router to router along the route of the destination.

IP Address's

Every machine connected to the internet is assigned an IP address. An example of an IP address would be 192.168.0.1. IP addresses are displayed in decimal format to make it easier for humans to understand but computers communicate in binary form. The four numbers that separate an IP address are called Octets. Each position consists of eight bits. When added to together you get 32 ​​bit address. The purpose of each octet in an IP address is to create classes of IP addresses that can be assigned within a network. There are three main classes that we deal with Class A, B and C. The octets of an IP address are split into two parts Network and Host. In a class A address the first octet is the network portion, this determinates which network the computer belongs to, the last octets of the address are the hosts that belong to the network.

Sub netting

Sub netting allows you to create multiple networks within a class A, B or C address. The subnet address is the address used by your LAN. In a Class C network address you would have a subnet mask of 255.255.255.0. A subnet mask identifies which portion is network and which is host. For example 192.168.6.15 the first octet three octets are the Network address and the last octet being the host (Workstation). It is important to subnet a network because gateways need to forward packets to other LANS. By giving each NIC on the gateway an IP address and a Subnet mask it allows the gateways to route packets from LAN to LAN. Once the packet arrives at its destination, the gateway then uses the bits of the subnet portion of the IP address to decide which LAN to send the packets.

Circuit Switched Leased Lines

A circuit switched network is one that establishes a dedicated circuit (or channel) between nodes and terminals before the users may communicate. Here are some terminologies associated with a Circuit switched network.

Frame relay is a telecommunication service designed for cost-efficient data transmission between local area networks (LANs)

Basic rate interference is a service used by small business for internet connectivity. An ISDN BRI provides two 64 Kbps digital channels to the user.
Primary rate interface (PRI) is a telecommunications standard for carrying voice and data transmissions between two locations
All data and voice channels are ISDN and operate at 64kbit / s

Packet Switching

Http://www.raduniversity.com/networks/2004/PacketSwitching/main.htm – _Toc80455261

Packet switching refers to protocols in which messages are broken up into small packets before they are sent. Each packet is then transmitted over the Internet. At the destination the packages are reassembled into the original message. Packet switching main difference from Circuit Switching is that that the communication lines are not dedicated to passing messages from the source to the destination. In Packet Switching, different messages can use the same network resources within the same time period.

Http://en.wikipedia.org/wiki/Asynchronous_Transfer_Mode

Asynchronous Transfer Mode (ATM) is a cell relay, packet switching network and protocolwhich encodes data into small fixed-sized cells.

ISDN is used to carry voice, data, video and images across a telephone network. ISDN stands for integrated services Digital Network. Isdn also provides users with a 128kbps bandwidth. This is done through frame relay. Frame relay complements and provides a service between ISDN, which offers bandwidth at 128 Kbps and Asynchronous Transfer Mode which operates in somewhat similar fashion to frame relay but at speeds from 155.520 Mbps or 622.080 Mbps. Frame relay is based on the older X.25 packet switching technology and is used to transmit analogue signals such as telephone conversations.

PSDN stands for packet switched data network and is a data communication network. Packet switched networks do not establish a physical communication signal like the public telephone circuit (circuit switched network) Packets are sent on a fixed length basis and assigned with a source and a destination address. The packages then explicitly on the routers to read the address and route the packets through the network.

Mobile and Broadband Services

Digital Subscriber Line (DSL) is mainly used to bring high bandwidth connections to homes and small business's over a copper wire telephone line. This is can only be achieved if you stay within the range of the telephone exchange. DSL offers download rates of up to 6mbps allowing continuous transmission of video, audio and 3D effects. DSL is set to replace ISDN and compete with the cable modem in providing multimedia to homes. DSL works by connecting your telephone line to the telephone office over copper wires that are twisted together.

Asymmetric Digital Subscribers Line is most commonly used for home users. It provides a high download speed but a lower upload speed. Using ADSL, up to 6.1 megabits per second of data can be sent downstream and up to 640 Kbps upstream.

Http://en.wikipedia.org/wiki/Symmetric_Digital_Subscriber_Line

Symmetric Digital Subscriber Line is a digital subcriber line which runs over one pair of copper wires. The main difference between ADSL and SDSL is the difference in upload and download speeds. SDSL allows the same upstream data rate and downstream data rate as ADSL upstream can be very slow.

[Http://searchnetworking.techtarget.com/sDefinition/0],,sid7_gci558545,00.html

HDSL High bit-rate Digital Subscriber Line, one of the earliest forms of DSL, is used for wideband digital transmission within a corporate site and between the telephone company and a customer. The main characteristic of HDSL is that that provides equal bandwidth in both directions.

IDSL is a system in which data is transmitted at 128 Kbps on a regular copper telephone line from a user to a destination using digital transmission.

The Local Loop enables operators to connect directly to the consumer via copper local loops and then add their own equipment to offer broadband and other services. This process involves operators accessing local exchange buildings to connect to a network of copper lines which connect them to homes and businesses. BT is an Example of a Local Exchange. The local loop connecting the telephone exchange to most subscribers is capable of carrying frequencies well beyond the 3.4 kHz upper limit.

Benefits of using DSL

DSL can provide a virtual instantaneous transmission of voice, data and video over ordinary copper phone lines. A DSL connection can eliminate delays while waiting to download information and graphics from the Internet. It provides users with a cost effective high speed Internet connection. Another benefit is that a DSL connection is always on-line (like a LAN connection) with no waiting time for dialing or connecting.

There are now more than 10 million broadband connections in the UK. By December 2005 there were 9.792 million broadband connections in the UK and the average broadband take up rate during the three months to December was more than 70,000 per week.

Posted in general | Comments Off on Wide Area Network (WAN)

What Is The Difference Between ERP And Enterprise System?

Enterprise system and Enterprise Resource Planning System terms are similar but there is difference between an enterprise system and an ERP system. An ES or enterprise system is a large scale system which includes packages like ERP and CRM. ERP is a subset of Enterprise System or it can be said that ES is a superset of ERP. It contains a variety of solutions. ES contains applications and packaged solutions which can be directly used in an enterprise. On the other hand ERP system is the automation of the business processes and the solutions are in the form of modules which are designed according to the client’s requirements.

The functions are customized according to the client’s business environment. Enterprise system does not include architecture of other solutions whereas an ERP implementation automates systems using technical aspects. ERP system includes architectures and databases and is client server architecture. The system is server based therefore the consultant needs to be aware of the technical aspect too.

Another difference between an ES and an ERP system is that the ERP is aimed at improving the functionalities of the organization whereas the ES helps to improve the overall maintenance and accuracy. It provides for better solutions and aids in decision making. ES is difficult to implement compared to Enterprise resource planning and even the timeframe needed for implementation maybe more. The overall impact is high but so are the risks involved. If the ES is not implemented in the right manner, it can cause business failure and if implemented properly it can increase the efficiency and profits of the business organization. It is normally required when there is a big drawback in the current procedures and methodologies in the organization and need to be corrected. The company going in for enterprise system needs to be careful while choosing the software and the vendors due to the risk of failure involved.

The difference between an enterprise system and an ERP system is that ERP is mostly used for medium scale companies to big companies and ES is restricted to the big companies. There are many complex functions involved in big companies which cannot be provided solutions for alone by ERP. The role of ERP is restricted when compared to enterprise system because it does not include customer relationship or vendor management.

These applications are needed when the business process is complex and on a big scale. Therefore bigger organizations need to go with ES instead of enterprise resource planning alone. ERP is also an important system to streamline the internal processes but it does not provide for taking care of the external processes. Enterprise system takes care of the end to end business process of organization since it involves other applications also like SCM and CRM. There is quite a lot of difference between an enterprise system and an ERP and it depends on the company whether it wants to go with an ES to streamline the entire process starting from supplying, production and customer or whether he wants to go with an ERP system to streamline the internal process.

Posted in general | Comments Off on What Is The Difference Between ERP And Enterprise System?

Review of Takeoff Software for Estimating Construction

So often people want to rush out and buy estimating software or takeoff software without first trying to define their internal estimating processes. Once the estimating process is clearly defined, then and only then, can you actually try to compartmentalize the process into segments. So often the segment is really quantity takeoff. Takeoff of what you may wonder? That is like the million dollar question. This article will speak about the takeoff software process which usually associated with estimating software processes. The takeoff software process can often be takeoff of materials for some folks, and to many others, the takeoff process of scoped systems to create estimates or proposals. This review or comparison will not try to explain the estimating software process but bring to you valid quantity takeoff thinking among estimators in a quest to find which product thinks the way you do. These are the opinions of the author.

I will review and compare 3 types of measuring takeoff products:

It is extremely important to note that these are ONLY measuring takeoff programs, NOT estimating programs.

1) Planswift

2) On-Screen Takeoff by On Center Software

3) Electronic Plan Takeoff Software

All three products have their strengths, however, Planswift and On-Screen Takeoff are stand-alone products and Electronic Plan Takeoff is actually dynamically integrated live with Microsoft Excel which means that it starts and finishes and saves in Excel. They all integrate with Excel, however, you will have to evaluate your thought process and decide which of the three products work-flow think along the lines of how you think. For instance, what is the first thing you do when you get a set of plans? Typically, you start flipping through the plans to see how involved the project is and what type of work do you see that is attractive for your company. Then when you decide you are going to estimate this job, more often than not, you start like 80% of companies in the world of construction estimating by opening your takeoff master template Excel spreadsheet. You rename your spreadsheet to the new job or project and off you go performing takeoff. This is where the differences are:

In Planswift, you decide what drawing you are on and then you perform the measuring of an item you want to perform takeoff on the plan. Unfortunately, that is not exactly how an estimator thinks. Planswift does give you the ability to add a type of takeoff item on the fly by naming it and then perform takeoff of it; somewhat of a very manual and slow process. They also provide you with the ability of applying a type of assembly to a takeoff to aggregate quantities of items in that assembly. Not quite the way an estimator thinks. It forces you to jump to different screens which slows down the process. Typically, the main start of anyone’s takeoff process, or some may think of it as a checklist approach, is to start with your own spreadsheet of YOUR items. Those items can be material items or can be scoped assembly system items. Either way, by starting with a master spreadsheet say in Excel for example, many estimators think of this as a risk reducer, not to forget things they normally takeoff. Being that Planswift is a stand-alone takeoff program, it typically saves your takeoff images in Planswift instead of your estimate in Excel, if Excel is your estimating system. If you are using Excel, you have to manually save your takeoff measurement numbers in Excel and your takeoff images in Planswift or elsewhere, just not in Excel where the takeoff quantity resides. Again, if you want to integrate with Excel, they force you to either export or import takeoff items from Excel rather than being dynamically integrated live to Excel. They do however have the ability to dump the measured quantity from Planswift into any Excel spreadsheet or Word document. The main purpose or the primary focus of this program is measuring, therefore it does a good job at that function. Most of the other functions require you to jump around different screens, and essentially, you loose your thought of where you are. There are some features that attempt to address the estimating process, however, there are many features that are missing for Planswift to be a full fledged estimating system; it is NOT one. Planswift does integrate with the leading estimating system Sage Timberline, but the integration is weak. Since Timberline’s power is in assembly takeoff and where most estimators reside in Timberline, Planswift does not give the estimator the ability to add quantities of miscellaneous Timberline items or one-time items that need to added on the fly to an assembly while they are in Planswift at the Timberline interview screen, and while being in the measuring phase. Planswift does allow the deleting of assembly generated items as well adjusting assembly item quantities in a different screen. Again, to perform all that, you are forced to jump around to different screens. No assembly is ever perfect in any estimating system since project conditions are always uniquely different, therefore, having to add items to an assembly is extremely important. That adding of items and associated quantities is an absolute requirement any estimator typically has to do during the takeoff measuring and estimating phase; something that Planswift struggles with as related to Timberline Estimating. Planswift does allow the direct send of measurements to Timberline Estimating items and assemblies while in Timberline Estimating, just as you would do with the old digitizer measuring boards. Training, support and maintenance are extra for Planswift. On-Screen Takeoff by On Center Software, and Planswift charge their annual maintenance and support fees per license (mandatory) which costs the end user more expense annually especially if a customer has more than one license.

On Center’s On-Screen Takeoff is the Grand Daddy of software takeoff products due to the fact that it has been around the longest. On Center recognizes that On-Screen Takeoff is primarily a measuring program. That is why they have a separate estimating program named QuickBid for those who want an estimating program. On Center does not try to trick you into thinking it is an estimating system. In On-Screen Takeoff, you also decide what drawing you are on and then you perform the measuring of the plan. BUT, before you start, you can load a master set styles of things you typically takeoff or measure from your own library. That process seems to be less complicated than that of Planswift. On-Screen Takeoff does give you the ability to add a type of takeoff item on the fly by naming it and then performing takeoff of it; somewhat of a manual and slow process as well. The program does come with many features that are primarily focused on simple measuring to advanced measuring issues all with attention to detail regarding easy navigation for the takeoff process. On Center does a very good job at that. However, there seems to be a disconnect of thought from an Excel spreadsheet items you may use for estimating and/or proposals. The integration to Microsoft Excel is not a dynamic live link, more like an after thought in my opinion. Yes, you can establish links to named styles to cells or ranges in Excel, somewhat rigid. But the question you will have to ask yourself, which will happen more often than not is: What do you do when you need to add things on the fly during takeoff and in an Excel spreadsheet? Again there will be manual associations you will have to establish with Excel which is another major slowdown. You have to manually save your takeoff measurement numbers in Excel and your takeoff images in On-Screen or anywhere you decide, except the takeoff images will not be saved in Excel where the takeoff quantity resides. This type of situation arises when a takeoff program is a stand-alone program. On Center’s On-Screen Takeoff has the best integration with the most widely used estimating system in the USA: Sage Timberline Estimating. It basically mimics the same interview process as you would do with the old digitizer measuring boards. By working directly with Timberline, On-Screen Takeoff allows the estimator to perform takeoff of a Timberline variable question and immediately returns back directly with the takeoff quantity in a Timberline assembly at the variable question. By virtue of this process, On-Screen Takeoff allows the estimator to continue his/her Timberline interview process in Sage Timberline Estimating by reviewing/massaging generated quantities, or adding items in a Timberline assembly as the estimator see fit. That workflow process gives full control to the estimator, good job On Center. Training, support and maintenance are extra for On-Screen Takeoff. On-Screen Takeoff by On Center Software, and Planswift charge their annual maintenance and support fees per license (mandatory) which costs the end user more expense annually especially if a customer has more than one license.

This next system is ONLY if your estimating system or proposal generator is Microsoft Excel. Electronic Plan Takeoff Software is a plug-in for Excel. You start your spreadsheet, you perform the measuring takeoff, you may even add some more items on the fly all the while you are in the measuring phase in the Electronic Plan Takeoff program. When you are done, even if you added items on the fly, they automatically appear in your Excel spreadsheet. Excel is the control of everything. Your project is started in Excel, your takeoff is saved in Excel, the estimate or proposal is/can be produced there in Excel; one program, one place. Many takeoff programs interface with Excel somehow, but only Electronic Plan Takeoff is live linked with Excel, meaning all your Excel spreadsheet descriptions appear in the measuring takeoff program so you always know where you are in Excel. That is a huge difference in comparison to Planswift and On-Screen Takeoff. You can even change a description of a takeoff item in Electronic Plan Takeoff and it is automatically changed live, in your Excel spreadsheet. When you talk about the estimating and takeoff phase you must keep processes cleans and easy and this program does just that. There is no getting lost in this program. Just like the other reviewed programs above, the central focus of this program is takeoff measuring, and it does a GREAT job at that. The navigation within the program is really simple and easy. It is not made to work with other estimating systems, but there is a version that allows the direct send of measurements to any Microsoft Windows program awaiting a keyboard entry, just as you would do with digitizer measuring boards. There is also a version that works with digitizer boards as well. If you use Microsoft Excel for estimating, or takeoffs, or proposals, then this Electronic Plan Takeoff program for Excel would be your best choice. The integration to Excel is unmatched in Electronic Plan Takeoff compared to Planswift or On-Screen Takeoff. What is quite different in Electronic Plan Takeoff is that training, support, and maintenance are INCLUDED with a purchase, whereas training, support and maintenance are extra for Planswift and On-Screen Takeoff. Moreover, annual support and maintenance for Electronic Plan Takeoff year two and beyond is a low fee per company per year, instead of per license. On-Screen Takeoff by On Center Software, and Planswift charge their annual maintenance and support fees per license (mandatory) which costs the end user more expense annually especially if a customer has more than one license.

Microsoft and Excel are registered trademarks of Microsoft Corporation. Planswift is the registered trademark of Tech Unlimited, Inc. On-Screen Takeoff and QuickBid are registered trademarks of On Center Software, Inc. Sage Timberline Office, Sage Timberline Estimating are registered trademarks of Sage Software, Inc.

Posted in general | Comments Off on Review of Takeoff Software for Estimating Construction