Iam doing my academic project on production planning and control...pls clear my doubt based on that....!!?

This project production planning and control is just like an inventory.. so i want to do some what different than inventory.. my project is about that.. client may order bulk of some product then i need to purchase raw material needed for the productivity of that paticular project..


Then there is stock department,quality checking department,sales department.. this my overall project..





To make this project different what modules i can add to this..?How i can make it as different ?





Can i add like bidding..? Please help me immediatelyIam doing my academic project on production planning and control...pls clear my doubt based on that....!!?
I am not a hundred percent certain what you are asking for, but I'll take a stab at it.





what you want is a database backend with tables for the following:


- product table (key being productid)


- a raw materials table (the rows here tie to a product key, but also has a raw material key)


- an inventory table that shows how much raw material you have (goes to a raw material key)


- a quote table to provide bids on the cost of the raw material (goes to raw material key)





then you need a front end GUI that accesses this information in an organized format..


- an inventory screen of what materials are in house


- item ordering screen (shows what products a buyer can order)


- an order fullfillment screen that shows if you have enough raw materials to make your product, and if not make a purchase order to order the materials from a vendor.


- some sort of quote/bid screen that is for that order's materials, time, etc.





Does that help you point to a right direction?