Order for development

February 1, 2013

Printing firm

Development of software for accounting of services, materials and components in a printing enterprise. The difficulty lies in the fact that every order is tailored and the resulting product is unique. This makes the catalogue swell. Instead of enlarging the catalogue the software describes end products using a limited number of technological processes, consumables and spent resources. The order input automatically calculates its cost and issues an invoice for payment. Payments are used to calculate sales managers' commissions.

Requirements specification

Manufacturing and sales accounting task.

	01	There is a directory of materials where all materials are gathered: product materials and other materials.
	02	There are procedures which result in the creation of end products from materials.
	03	The end product is created in the desired amount according to the ManufacturingOrder document.
	04	The ManufacturingOrder serves as a basis for the removal of the necessary amount of material from storage. At the same time the cost price and the price of the product are calculated.
	05	The ManufacturingOrder document contains information about product materials and the procedures they must undergo.
	06	Product materials can be both single-unit (a pen or pendant) or measured in other units (a roll or sheet of paper).
	07	The process of product manufacture can include several procedures.
	08	A procedure contains information about the amount of resources, consumables and other materials to be taken from stock for the manufacture of one product item.
	09	Support for a procedure which uses a fixed amount of resources regardless of the amount of required product.
	10	The procedure contains the description of types of materials. When an order is drawn up the exact materials to be issued for use in its productions (paint colour, paper density) is specified.
	11	Product material can be measured as a single piece or by other means.
	12	To bring product material into compliance with unit measurements it will be necessary to implement a division procedure.
	13	Most procedures presuppose excessive consumption of materials on cut-offs. There must be an indicator ensuring that the excess consumption of a material doesn't exceed 30%.
	14	The price of the product and cost are calculated according to price lists.
	15	There is a correspondence table of price and amount of product manufactured (not always linear).
	16	Prices can also be set by a manager.
	17	A price list is stored in the procedure in the form of a table containing ranges of amounts, with corresponding prices for every range.
	18	Every manager should be assigned a warehouse of final products to get an overall picture of sales for each of the managers.
	19	Manufacturing orders also have indicators for completion of manufacture and order payment.
	20	Orders can be paid for incrementally.
	21	Besides sales managers an executive and a manufacturing and company administrator work with the database.
	22	The role of the executive is to analyse sales manager reports and conduct salary calculations.
	23	The role of the administrator is to enter information about completed orders and payments into the database, recording which orders have been paid for and fulfilled.
	24	Managers should be able to see, but not edit, this information. Managers inform customers that products are ready for collection.
	25	Product material should contain a picture of a fixed size and format.
	26	Fulfilling the calculation of each manager's salary.
	27	In case of mismatch of an order and leftover material in the warehouse the order should be marked.
	28	The materials directory can be changed and expanded with the possibility of barring some managers from using the function.
	29	Managers can mark some orders for deletion, but only an administrator can delete orders.
	30	Managers can view all orders in the program but can only change their own.
	31	Managers have a right to forcibly change cost price, but a notification will be automatically created. If there is not enough of a required material in stock a manager can buy it elsewhere, enter it into the stock and expense it.