What is ERP

Enterprise Resource Planning

Accounting and Operations

Bookkeeping, but more comprehensive

 

ERP = Enterprise Resource Planning. A comprehensive suite of applications to manage planning and operational functions requiring massive information processing in the business environment

MSInc fills a broad set of IS and IT needs from network support for small businesses with Quickbooks™, Peachtree™, or MS200/500™ accounting modules, as well as customized solutions. We provide network planning, tuning, and connectivity as well as email, web design, PC repair, PC support, and custom MySQL customer service databases. We also provide our own ERP Solution using Thoroughbred™, PVX™, and Basis BBX™ BB8 based accounting and operations systems. Our solutions support a full ERP backbone for manufacturing clients with up to 500 employees. For SaaS or “Software as a Service”, see our new Vehicle Dispatch system, available in lease and purchase license forms. Our lease model leads the way in SOA, or Service Oriented Architecture. Also available for standardized and custom ERP, MRP, CRM, and Financials models in fully normalized designs. Because of our breadth of services, from highly secure financial information, to password accessible customer service portals, through to highly visible and optimized web-sites, we are highly skilled at managing the various security requirements of your company.

Outsourcing, Eastern metro Atlanta. Small and Medium Sized Business.

Purchase Price Variance

Standard costing techniques in ERP

 

In absorption accounting, the measurement of the inflation or deflation of prices on raw material is measured with purchase price variance. A unit of raw material is assigned a standard cost for the year and the variation in landed cost for deliveries is tracked not with a complicated scheme of tracking on a lifo or fifo basis where each molecule of raw material can be allocated to a product that reaches the consumer, but a standard periodic cost is assigned to a unit of purchased goods. For example, if we choose to fix the cost of a #8-32 1/2″ Stainless round slotted head machine screw at $.15 for the year, the portion of the final cost of a product that uses this purchased item need not change just because the landed price for one million screws that week was $.149900 each.

We freeze the standard cost for the screw at $.15 and book a purchase price variance, favorable, of a hundred bucks. The mechanics require an accounting discipline and business logic in the purchasing and accounts payable departments of recording the landed price vs the standard. When an invoice is received from a vendor on the raw material account, the first thing we want to ascertain is that the material was received and that our vendor deserves to be paid for goods that were delivered and accepted for inventory. This means that a given purchase order receipt, which was a debit to inventory on hand for a given part number should be matched up with the invoice. This receipt is marked then as paid and the accounts payable can be processed with no shoe leather put to waste by either the purchasing or accounting departments.

A register of vouchers accepted for a given day then can be generated with the landed cost put against the standard cost to determine the favorable or unfavorable purchase price variance for raw material acquisition.

ERP LAMP

LAMP is an acronym for an arrangement of Open-Source technologies that fit together with great synergy to provide working database driven systems and database maintaining systems. By definition, wordpress and most shopping cart packages that you can install on a web-server are a LAMP application. Because of the inclusion of Apache in the recipe, LAMP is by definition, internet or intranet related, and these applications would use a browser for GUI purposes.

Modern ERP and CRM applications, even those with heavy internal firewalling and proprietary GUI software have worked for years developing a seperation between the business logic layer and the client interface. For example, the complex liturgy of calculated taxes and deductions related to the gross and net amount of a New York paycheck are the business logic segment of an ERP or accounting program. The pretty looking check on the screen of your Quickbooks program is a graphical representation of the underlying data and calculations. Once upon a time, a programming language shouldered the burden of both tasks.

In the LAMP philosophy, the PHP layer, sometimes also called the Perl layer, can be subdivided again to achieve this result. The Smarty Template system is a convenient way to do this. In the Smarty Template framework, visual elements are written in a high level html with css using only a tag to invoke business logic elements where needed. For example, the gross calculation from payroll hours, which may be the product of regular time, overtime, holiday time, vacation pay, etc. and the series of tax deductions, retirement contrbutions and health plan participation costs may be embedded in the very display of the paycheck with a single tag that instructs a web-page, before formatting the html, to invokde the gross to net.

For Example;

<head><title>Paycheck for employee {{dv_emp_id}} – {{dv_emp_name}}</title></head>
<body>{{bl_pr_gross_to_net dv_emp_id}}

Would start creating a web page (I forget to define the source for the css) but invoke business logic from the payroll modules called gross_to_net for the employee number contained in the dynamic variable dv_emp_id before creating the body of the web browser document.

LAMP ERP

Linux based open source software packages offer the richest and most rapidly evolving applications.

ERP or Enterprise Resource Planning also entails the normal accounting operations required in a small and medium sized business, the integration between the post-mortem analysis functions, planning procedures and the basic data collection and organizational functions required for a backbone business information system leave business planners wanting an integrated package of data processing functions to interface with the planning procedures.

Linux based open source software packages offer the richest and most rapidly evolving applications. That Redmond Washington vendor can enter a market and abandon it in a matter of a few years, leaving users with unsupported application software. While the life cycle for a release of a desktop operating system may be less than five years, many ERP implementation last two decades or more. Elements of major million dollar ERP software packages contain business logic with roots in the Fortran and Cobol of the 1960’s.

Certain SQL based packages lack much business logic entirely and the relatively new, but robust procedural language of the Oracle flavor, Plsql is developing and creating an inventory of business logic. But licensing costs drive information system specialists to continue to use applications based on the Unix operating system and the known source code model. These models rely on vendors like Redhat and Novell to maintain expertise at a lower cost while providing the option to ‘go it alone’ that indeed major banks and telecoms exercise.

Linux, Apache, MySql and PhP combine to provide applications for the business community, and with the use of Perl banking providers like Paypal provide incredibly robust and yet secure micro application environments that employ technology in innovative and profitable ways. But businesses that merely outgrow the Quickbooks model, which lacks the aforementioned integration desires that forward thinking business owners seek leave small manufacturers for example to look at packages of the next tier such as Peachtree, MAS-90 and even the Redmond solutions.

However, businesses might come across three very innovative vendors that use Linux as a basis, yet provide compatibility with Windows and Macinstosh for the most part. Linux in the previously mentioned telecom operations provides the least downtime, and many times Oracle has used Linux to set world records in the database transaction processing arena. For more information on visit www.pqwee.com for more information on open source modeled and Linux based LAMP ERP solutions.

ERP

Enterprise Resource Planning

Open Source is a software movement where developers regain the costs of creating a software product through alternate revenue streams to the traditional proprietary software approach. The added costs of creating a proprietary niche include the use of dongles and complex activation code schemas that are abandoned by using the open source model. Revenues are typically found in annual support agreements and consulting fees instead of attempting to control the installation with added levels of complexity that are needed to achieve the standard proprietary approach.

Linux is a fundamental building block of much of the open source movement. Started by Linus Torvalds, popular Linux variants include Ubuntu, Debian and Gentoo, however commercial Linux and Unix probably are more likely to be based on Solaris, Redhat or SUSE from Novell. Consulting and support agreements with Novell, Redhat and Oracle involve investments that rival but fall short of the costs of commercial server solutions like Microsoft’s Windows Server but their stability and usability for the professionals well indoctrinated in the use of Bash, Cron and ssh are paramount.

Use of a solid Linux foundation is also available as a service by such large players in the rental server market like Amazon.com and Rackspace. Database layers like MySQL and PostgresSQL are widely supported and offer an alternative to the expensive Oracle and SQL server layers, and are more than adequate for databases of less than 10 gigabytes which is sufficient for most SMB applications.

Open Source ERP and CRM

The entire Linux operating system including source code can be downloaded from the internet.

In the open source world the most famous piece of software is Linux.  The entire Linux operating system including source code can be downloaded from the internet.  The Apache web server that is responsible for serving up a substantial amount of internet web pages is normally layered on top of the Linux operating system.

Apache may be available for Windows, kind of like Eva Gabor riding in the back of a 1948 Dodge pickup truck, and that may be where the average user most often interacts with the open source side of software.  A further note to understand in the open source software world is the notion in free as in open vs free as in beer.  If you get a free beer you do not have to pay for it, but open source software usually requires a costly agreement with the consultants and engineers that have the knowledge to work with the complex code in an open source application.

Open Source ERP is not a free software concept.  These complex business databases could in theory be used without the computer scientists and engineers that know their inner workings, but the costs of acquiring and maintaining the highly educated workers reqiuired to do this is greater than the cost of a service agreement.

In the Linux market, two examples of open source knowledge suppliers are Redhat and Novell.  Some may argue that other examples inclide Sun and IBM.

Solutions

Manufacturing, Service, and Distribution Solutions for Business Applications.

MSInc provides services and consulting in all areas of small and medium size business computing.

Network and centralized database operations are exploited to handle accounting and operations resource planning and execution for manufacturers, distributors, and service companies.

Manufacturing, Service, and Distribution Solutions for Business Applications. Data recovery, exploit protection, on-line backup services, portals, secure login internet collaboration tools. Linux PHP, PERL, APACHE, bash, crontab, sendmail. Ninja class database normalization.

Our modern focus on cloud computing and software as a service has led us to be a leader in browser based database systems. Sometimes called web applications, we use a lean approach compatible with firefox, opera, safari, ie and chrome. Our approach yields 20-40 percent savings in IT over conventional windows applications. In a broad sense, Facebook is a comparable to our approach, and AOL is the old Windows IT approach.

While we won’t replace all internal applications, our implementation speed is unmatched in operational areas of service and manufacturing enterprises.
Examples of cloud applications include dispatching, vehicle and crew recording, booking, document management, build to order, capacity planning, eBusiness, eCommerce.

Examples of features available in cloud applications include user tracking and usage logging, user privileges and application access security, entry forms in modern html format, surveys, search, email interfaces and automation, PDF generation.

Benefits of database and business logic implementation of the cloud include inherent multi-site access, lean IT, email triggers, central upgrade, mobile access, real time data and updates, daily email reports, server-less offices, excel compatible reporting, open source platforms. We can implement and maintain all client to client or client server environments for customers in the Atlanta Metropolitan area, including but not limited to Rockdale County, Dekalb County, Newton County, Conyers, Lithonia, Covington, Oxford and surrounding areas. BBX Thoroughbred Providex Business Basic IDOL-IV Database Customization, installation, configuration, maintenance, sales. MRP, ERP, CRM, Demand Flow, Financial, Accounts Payable, Accounts Receivable, Purchasing, Inventory Control, Production Control Sales Order.

Quickbooks Pricing

15 Users – $ 6,000

Server stack – Dell/Intel/Redhat/Postgres – $ 1,500
Serverless – workstation PostgresSQL install – $250

Includes access to support, pdf report writer, service packs, and choice of Postgres Plus Advanced Server or Oracle Standard Edition

Quickbooks Enterprise – free trial – yes, server required – no.

5 Users – $ 3,000 (per year for updates)

30 Users – $ 8,000 (per year for updates)

Freshbooks

QuickBooks alternatives, cloud invoicing

Freshbooks

MSInc is not affilliated with FreshBooks, but is providing this information for those that may need an alternative to old fashioned PC and Server based billing programs like Quickbooks, Peachtree or MAS-90.

Freshbooks is a billing oriented package that uses cloud database technologies to automatically manage the storage, security and backup of data, eliminating IT costs associated with maintaining company and departmental servers to store and manage data.

  • Invoicing
  • Tablet and phone capable
  • Time Billing
  • Recurring Invoices, subscription billing
  • Paypal Integration
  • No server required, cloud based
  • Sales Tax accounting
  • Expense Tracking
  • Time tracking
  • Export to Excel