PHP Programming Project to add utilities and tools to an existing website/customized online ERP system

This project is an add-on to an existing website and online corporate management system. There are previous projects already installed that are similar in nature to this current project. The chosen programmer will have full access to our existing systems to analyze and learn from currently running programmes to assist him/her on this current project. Implementation will be setup via a sandbox staging platform for testing purposes so current data/systems are unaffected. Project is considered complete once the sandbox version is deemed fully operational without errors or bugs.


Project fulfilment is based upon 3-parts:

i. a production portal (a form to add data)

ii. a database archive (to store collected raw data)

iii. a KPI dashboard (graphical evaluation of the raw data).

The best way to explain this project is identical in nature to the QC reporting feature already installed, i.e. a FQC form front-end and a 2-part QC archive & QC Report Dashboard back-ends. I have attached an Excel prototype that I hope makes the spec self explanatory and more convenient for execution and implementagtion..

Overall Goals of the project:

• To measure the production output of each department after every shift

• To measure the productivity and overall performance of each department

• To measure the productivity and performance of each worker in each department

• To improve management of capacity planning

• To objectively calculate output productivity against capacity & actual demand

Support Advanced Decision Making:

• To quantify if a 2nd night shift work is required to meet demand. Or when switch is required.

• To clarify if a department is currently under or over-staffed

• To accurately notify HR to hire more or reduce workers accordingly

• To inform department supervisors about their overall department performance

• To objectively establish department and worker performance matrices to support performance related bonuses

Front-End Part I:

Daily Production Output Form- a designated supervisor will enter each departments output at the end of each shift. The department, shift, number of workers and total quantity (cards) will be recorded and saved.

Notes: Offset printing, Silkscreen , Collation, Lamination & Punching departments will enter in sheet QTY, which will be automatically calculated into card QTY once the sheet layout (x-Up) is entered.

Personalization, FQC & Outsource departments when selected will just need to enter in the card QTY.

Failsafe for incorrect form fulfillment- Submit & Save buttons should not be active unless all "required entry" fields entered correctly.

Save Button is to override data already submitted to correct/update an earlier submission.

The final design should be similar to as previously produced project- QC Report, but this is flexible to account for any unique features.

Back-End Part II:

Output Portal Archive- is a database that stores entries submitted from the portal.

Notes: All raw data saved here.

The final design should be similar to as previously produced project- QC Report, but this is flexible to account for any unique features.

Back-End Part III:

KPI Dashboard- 37-point KPI view

Department and Date period (up to 12-months) selection boxes to be submitted prior to opening dashboard (as in QC report).

Notes: 21-point summary box and (up to) 16-graphical multi-line/bar charts.

Line trend charts for up to 12-month period.

Some periodic tweaks may be necessary to fine tune our equipment and labour capacity limits- if somehow add a menu to allow an adminsistrator to edit the fixed constants would be appreciated.

Minor update to QC report required- to add extra fields in the summary box.

In case there is too much graphical data it may be wise to have a selection menu so the user can choose which KPIs to be displayed

If there are any questions regarding the spec or definitions please contact me.

Our website: [url removed, login to view]

Skills: PHP, Project Management, Software Architecture, Website Management

See more: website to hire online workers, website learn programming, website for php outsource, website design outsource online, website design online work, trend offset printing, total tools, tools to design website, tools for php programming, to hire or outsource an it project, the best website to learn php, testing projects online work, systems programming, switch case c programming, staging for hire, shift planning, self programming, self learn programming, self design online, report programming, prototype making, projects online programming, project management questions, project management on demand online, programming tools

About the Employer:
( 0 reviews ) Shenzhen, China

Project ID: #4312342

2 freelancers are bidding on average $1750 for this job


Hey there, I spent the time going over your project requirements in detail. Thanks for being thorough with your specifications. Please see my private message for further details.

$2000 USD in 60 days
(13 Reviews)

We are from Michigan USA and have been in business for over 18 years with 100's clients world wide. Just opened up an office near Toronto to assist our clients in Canada. We have designed RP - CRM systems for global More

$1500 USD in 45 days
(3 Reviews)