Labour intensive manufacturing software

More details: What are the specific tasks or functions that you would like the software to automate? Inventory management, Production scheduling, Worker Wise production performance and salary calculation How many users will be accessing the software simultaneously? 1-10 Which software interaction mode do you prefer? Desktop application REPORTS REQUIRED 1) Wage Sheet Calculation worker wise department wise daily 2) Perfume Stock – diluted and concentrate separately 3) Dipped Batti Stock perfume wise along with cost must be visible at any given point of time 4) Pouched batti Stock along with cost must be visible at any given point of time 5) GST Report – Refund Application Made, Refund Application Pending and Blocked GST 6) Final Cost per SKU with breakup variable cost and fixed costs per unit. 7) Month Wise Production and Sales Report of each SKU 8) Worker wise – SKU wise – performance, which worker is better suited to which SKU 9) Estimated count report of batti per kg 10) Debtor Ageing, Creditor Ageing, Inventory Ageing 11) Other standard reports Process described - Sorting Department - Must capture the following – Type of Batti, Size of Batti, Supplier, Lot No, Each worker is paid on the quantity sorted by the worker. Rejection percent is calculated and finally arriving at the sorted batti cost. Dipping Department Perfume comes in Concentrate form and is diluted with DEP as per the ratio for each brand. Batch name is given on each inward of perfume concentrate. This is called the blending date, a sample of the manual blending report will be provided. As per production plan dipping supervisor dips the sorted agarbatti in perfume. Perfume absorption is variable and normally remains within a range. A sample manual report will be provided. (Target Absorption is specified). Dipped Batti is stored in crates. And stock is maintained in kg for raw agarbatti dipped. Perfume wise. The workers are paid on the quantity of raw batti dipped on a contractual rate. If workers dont reach a minimum wage by working contractually (set by us) then they are paid on a daily basis depending on supervisor discretion. This daily basis rate depends on worker to workers. The amount of perfume absorbed by the agarbatti is deducted from the diluted perfume stock. Perfume stock is in two forms (diluted and concentrate) Dipping Date is assigned to each batch in order to maintain traceability both in terms of cost and material origin Pouching Department This Department has two types of machines. 2 head and 4 head. Depending on the SKU the supervisor chooses which type to Pouch the batti in. Currently there are 8 machines 4 - four head, 4- two head. These are counting and packing machines. A sample manual report being maintained in excel format will be shared. Each Worker is paid on the pouched quantity in RB quantity ( not dipped quantity ) one worker per machine. Wage is calculated on a contractual rate decided as per SKU, if workers dont reach a minimum wage it is supervisor decision to give minimum daily wage or not. Stock of pouched batti is required. In kgs. The amount of batti pouched is deducted from dipped batti stock. Sku wise roll is used and as per roll used, roll rejected, the roll stock is also maintained. Further pouching date is important which is linked with dipping date to arrive at the inner pouche cost. Packing Department - Each box/pouch is packed manually. Worker is paid on contractual basis depending on production. If worker does reach minimum wage then supervisor decision to give daily wage or not. Boxes/ Pouches are packed in outer cover, which again paid contractually. Pouches need to be band sealed with machine, again paid contractually. Then there are support workers who are paid on a daily basis who pack the master carton, bags, put strap on the carton. Batch wise costing - (dipping date , pouching date wise (fifo method) to be used to arrive at the final variable cost of packed cartons. Over and above this are fixed costs each departments supervisor, electricity cost, spare part cost, accountants cost. When new SKU is created the Information Required - - SKU Name - Size of Batti # 8" or 9" - Type of batti - black / white / dhuna/ color - In sticks or in gms. - If in sticks , how many sticks - If in gms, how many gms. - Outer Pouch packing/Box Packing - Each Box or Pouch contain how many inner pouches. No. Of inner pouches = No Of perfumes in that SKU - No. Of perfumes , name of perfume in the brand. Ratio of dilution in the brand. - Roll Size used for packing inner pouches. - Outer cover - yes/No. If yes, how many boxes in the outer cover. - Bags used - yes/no. If yes, how many Outer Cover in each Box. - CFC - how many Outer Cover / Bags in each CFC Obviously, standard accounting functions like sale invoicing, purchase, debtor, creditor, etc are required. Inventory Ageing etc