-- MySQL dump 10.14  Distrib 5.5.60-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: task_db
-- ------------------------------------------------------
-- Server version	5.5.60-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbl_company`
--

DROP TABLE IF EXISTS `tbl_company`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_company` (
  `cid` int(10) NOT NULL AUTO_INCREMENT,
  `cname` varchar(40) NOT NULL,
  `cpass` varchar(40) NOT NULL,
  `address` varchar(200) NOT NULL,
  `email` varchar(30) NOT NULL,
  `c_mobile` varchar(15) NOT NULL,
  `date_time` datetime NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_company`
--

LOCK TABLES `tbl_company` WRITE;
/*!40000 ALTER TABLE `tbl_company` DISABLE KEYS */;
INSERT INTO `tbl_company` VALUES (1,'MRP-I','Password0987)(*&','SF No.62/6A,  Kavaraipettai, Sathyavedu Road, Kuruthanamedu, New Gummidipoondi post, Tiruvallur Dist, Tamilnadu','Jayaram@mrpltd.biz','9962439696','2010-11-27 12:55:39'),(4,'MRP-II','Password0987)(*&','Pollachi Main Road, Malumachampatti, Coimbatore, Tamilnadu - 641050','rajasukumar@drpindia.com','9894388255','2011-02-02 23:52:36'),(5,'MRP-III','Password0987)(*&','Pollachi Main Road, Malumachampatti, Coimbatore, Tamilnadu - 641050','vasu@mrpltd.in','9363311421','2011-02-03 07:45:47'),(6,'MRP-IV','Password0987)(*&','Pollachi Main Road, Malumachampatti, Coimbatore, Tamilnadu - 641050','vikas@mrpltd.in','9043043344','2012-02-05 17:34:38'),(10,'UDL','Password0987)(*&','Pollachi Main Road,\r\nMalumachcampatti Post\r\nCoimbatore','vasu@mrpltd.in','9363311421','2019-02-04 10:41:50'),(9,'UHE','Password0987)(*&','Pollachi main road\r\nMalumachampatti \r\ncoimbatore','gopalakrishnank@uniheat.com','9003548089','2019-02-03 10:58:25'),(11,'APMUG','Password0987)(*&','UHE, POLACHI MAIN ROAD, MALUPACHAPATI POST','nsunil@apmug.com','9944472012','2019-03-11 17:59:31'),(13,'TRANSITECH','Password0987)(*&','cbe','jothikumar@freightx.in','7339445277','2019-05-31 12:41:43');
/*!40000 ALTER TABLE `tbl_company` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_employee`
--

DROP TABLE IF EXISTS `tbl_employee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_employee` (
  `eid` int(10) NOT NULL AUTO_INCREMENT,
  `ename` varchar(40) NOT NULL,
  `epass` varchar(40) NOT NULL,
  `address` varchar(200) NOT NULL,
  `email` varchar(40) NOT NULL,
  `e_mobile` varchar(20) NOT NULL,
  `date_time` datetime NOT NULL,
  `possition` text,
  PRIMARY KEY (`eid`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_employee`
--

LOCK TABLES `tbl_employee` WRITE;
/*!40000 ALTER TABLE `tbl_employee` DISABLE KEYS */;
INSERT INTO `tbl_employee` VALUES (6,'Jayaram singh','js@789','Gummidipoondi','jayaram@mrpltd.biz','9962439696','2011-02-02 23:36:51','UH'),(5,'Rajasukumar','raja$741','Malumachampatti, coimbatore','rajasukumar@drpindia.com','9894388255','2011-02-02 23:36:09','UH'),(4,'Vasu','vasu@852','Malumachampatti, coimbatore','vasu@mrpltd.in','9363311421','2011-02-02 23:15:20','UH'),(7,'Vikas','vikas500080','Malumachcampatti Post','vikas@mrpltd.in','9043043344','2018-09-19 14:29:42','UH'),(8,'Gopalakrishnan K','kgk$456','SF 296, Pollachi Main Road,\r\nMalumachcampatti Post\r\nCoimbatore - 641050','Gopalakrishnank@uniheat.com','9003548089','2019-02-04 10:03:40','UH'),(9,'Ashok S','ashok#123','UHE Building, SF 296, Pollachi Main Road,\r\nMalumachcampatti Post\r\nCoimbatore','ashok@apmug.com','7200090715','2019-02-04 10:57:25',NULL),(10,'Balasundaram E S','esb@123','UHE Building, SF 296, Pollachi Main Road,\r\nMalumachcampatti Post\r\nCoimbatore','esb@apmug.com','9942245800','2019-02-04 11:37:06',NULL),(11,'Pramod Kumar','pramod@512','Pollachi road,Malumachampatti Post,Coimbatore - 641 050','accounts@uniheat.com','9443720530','2019-02-27 16:13:33',NULL),(12,'NIKHIL SUNIL','pwdnikhil','UHE, POLACHI MAIN ROAD, MALUPACHAPATI POST','nsunil@apmug.com','9944472012','2019-03-11 17:45:31','UH'),(13,'MRK','mrk1009','Coimbatore','mrk@uniheat.com','9942484462','2019-04-04 18:49:09',NULL),(14,'palani','palani@qa','Chennai','palani.qa@mrpltd.biz','7200053586','2019-04-11 16:14:47',NULL),(15,'GKK','GKK','Chennai','gkkrishna@mrpltd.biz','9360780808','2019-04-26 15:22:15',NULL),(16,'JK','jkfreightx','cbe','jothikumar@freightx.in','7339445277','2019-05-31 12:42:51',NULL);
/*!40000 ALTER TABLE `tbl_employee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_plans`
--

DROP TABLE IF EXISTS `tbl_plans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_plans` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cid` int(10) NOT NULL,
  `plans` varchar(255) NOT NULL,
  `amt` double NOT NULL,
  `plan_date` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_plans`
--

LOCK TABLES `tbl_plans` WRITE;
/*!40000 ALTER TABLE `tbl_plans` DISABLE KEYS */;
INSERT INTO `tbl_plans` VALUES (3,5,'Basic Plan, Music Plan, ',0,'13'),(4,6,'Basic Plan, ',120,'05'),(5,1,'',0,'25');
/*!40000 ALTER TABLE `tbl_plans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_supplier`
--

DROP TABLE IF EXISTS `tbl_supplier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_supplier` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(40) NOT NULL,
  `spass` varchar(40) NOT NULL,
  `address` varchar(200) NOT NULL,
  `email` varchar(40) NOT NULL,
  `s_mobile` varchar(15) NOT NULL,
  `date_time` datetime NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_supplier`
--

LOCK TABLES `tbl_supplier` WRITE;
/*!40000 ALTER TABLE `tbl_supplier` DISABLE KEYS */;
INSERT INTO `tbl_supplier` VALUES (1,'maryam afifa','marry123','290, shani peth, pune','maryam.afifa@gmail.com','9987876765','2010-11-27 17:29:05');
/*!40000 ALTER TABLE `tbl_supplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_task`
--

DROP TABLE IF EXISTS `tbl_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_task` (
  `tid` int(10) NOT NULL AUTO_INCREMENT,
  `com_id` int(10) NOT NULL,
  `com_name` varchar(40) NOT NULL,
  `task_type` varchar(40) NOT NULL,
  `task_title` varchar(200) NOT NULL,
  `task_desc` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `emp_id` int(10) NOT NULL,
  `emp_name` varchar(40) NOT NULL,
  `emp_comment` varchar(2000) NOT NULL,
  `admin_comment` text NOT NULL,
  `attempt` int(10) NOT NULL,
  `create_date` date NOT NULL,
  `target_date` date DEFAULT NULL,
  `close_date` date DEFAULT NULL,
  `fpath` text,
  `follow_comment` text NOT NULL,
  PRIMARY KEY (`tid`)
) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_task`
--

LOCK TABLES `tbl_task` WRITE;
/*!40000 ALTER TABLE `tbl_task` DISABLE KEYS */;
INSERT INTO `tbl_task` VALUES (4,6,'MRP-IV','production','TAFE parts','look at TAFE parts to MRP VI','re-open',7,'Vikas','My team is working on the feasibility study. Pradeep has to invest on welding machine and arrange manpower as well. We are planning to close this by August end with few parts to start of with @plant 6...','I shall close the task after we achieve the target.',1,'2019-02-26','2019-03-15','2019-06-24','',''),(3,6,'MRP-IV','development','Training','Plan for Training staff - IMARQ and Personal Development','validate',10,'Balasundaram E S','Sir IMarq already plant qualified. You meant to say VSME? Personality training not recommended by the plant head.','',1,'2019-02-26','2019-03-31','2019-10-08','',''),(5,1,'MRP-I','production','Vendor tools','Tools vendor showing favoritism issue','working',10,'Balasundaram E S','Sir, Ledger collected from Plant I, will review and confirm. Need to check with Toolroom also if required.','',1,'2019-02-26','2019-03-08',NULL,NULL,''),(6,1,'MRP-I','finance','ROI','Extra Cost required to complete the Surian along with the ROI from the increased business','close',6,'Jayaram singh','Will Work out with Mr. Varadharajan for Volumes, Tool Cost Mr. Somasekar,  Costing Mr. Lokesh, Followup Mr. Jeeva & Mr. Devaraj. by 8th Pl.\r\n\r\nUPDATED ON 27/03/2019\r\nTODAY Mr. LOKESH LEAVE, GRANDMOTHER PASSED AWAY, WILL UPDATE BY WEEK END. 30/03/2019 PL.\r\n\r\nUpdated, Forwarded by Mr. Lokesh. Can Discuss if Time Avail during Your Visit, or Mail to You Pl.','',1,'2019-02-26','2019-03-08','2019-06-24','',''),(7,1,'MRP-I','development','Meeting with TAFE MDU','Meeting with TAFE MDU - For schedule communication','close',6,'Jayaram singh','Tafe Feels due to Meager Volumes Confusion, \r\nDBR & Madurai will Declare, Tomorrow or Week End.\r\nMay be During Regular Can Plan. Not the Right Time\r\n\r\n UPDATED ON 27/03/2019.\r\nDBR SCHEDULE IS 4,600 TRACTORS, & MADURAI 3,100 ONLY. MAY BE CAN IMPROVE FURTHER IN MAY , JUNE DBR TO SHOOT UPTO 6,000 AROUND, MADURAI MAX 4,000 TO 4,500 ONLY.  WILL PLAN MID OF APRIL PL.\r\n\r\nMonth End Only Fixed due to Election, Other Activities. But They are Clear only June Possible. Report already Indicates 80% DR Achieved due to Variations. Pl See Mr. Sigamani Mail.','',1,'2019-02-26','2019-03-08','2019-06-24','',''),(8,4,'MRP-II','finance','Availability of free cash','Calculation of availability of free cash','re-open',9,'Ashok S','As on 8th march 2019 bank statements,no surplus cash available.','I would like this to be monitored and reported on a monthly basis and I will close the task when I can see it reported during MRP II monthly reviews.',1,'2019-02-27','2019-03-08','2019-04-02',NULL,''),(9,9,'UHE','development','VUHE','Duty benefit to be passed on to VUHE','re-open',8,'Gopalakrishnan K','Completed\r\nEstimated cost savings spreadsheet mailed to MD and Chairman','The working of arbitrary 4% is not convincing. The number should have some logic with respect to the actuals. There was no explanantion available.\r\n\r\nPls workout the actual details and send the sheet.',1,'2019-02-27','2019-03-28','2019-04-02',NULL,''),(11,5,'MRP-III','development','Plan for rejections','MRP 3 action plan for rejections','close',4,'Vasu','Completed.  Document sent by mail.','',1,'2019-02-27','2019-03-08','2019-04-02',NULL,''),(12,5,'MRP-III','development','New BTS order','New BTS order execution plan by Mar 2019','close',4,'Vasu','Work going as per the plan','',1,'2019-02-27','2019-03-15','2019-04-03',NULL,''),(13,5,'MRP-III','development','Monitoring process - Tool','Tool Monitoring  process','close',4,'Vasu','Tool monitoring under control - Presented during the meeting on 07.05.19','',1,'2019-02-27','2019-03-12','2019-06-24','',''),(14,5,'MRP-III','development','Monitoring process - Consumable','Consumable Monitoring process','close',4,'Vasu','Consumable usage monitoring for Cylinders, FCR & piston presented during the meeting held on 07.05.19','',1,'2019-02-27','2019-03-12','2019-06-24','',''),(15,5,'MRP-III','development','Monitoring process - Labour','Labour charges monitoring process','close',4,'Vasu','Labour charges monitoring for Cylinders, FCR & Piston presented during the meeting held on 07.05.19','',1,'2019-02-27','2019-03-12','2019-06-24','',''),(16,5,'MRP-III','development','Monitering Process - RM','RM monitoring Process','working',4,'Vasu','Under process','',1,'2019-02-27','2019-03-12',NULL,NULL,''),(17,5,'MRP-III','finance','P & L ( FY 18 - 19 )','Costing  P&L  vs  Actual P&L for FY 18 - 19','working',4,'Vasu','Nine Parts completed. Other under process-- Few more parts are to be completed as on 17.04.19','',1,'2019-02-27','2019-03-12',NULL,NULL,''),(18,1,'MRP-I','development','Working day plan','Max working day plan','close',6,'Jayaram singh','Dear Sir,   Planned 5 to 6 Days OFF During Feb, Of Course RE, AL Run.\r\nMarch Planning Around 15 Days, But 15 Days without Salary May be problem. Discussed with Mr. GK, If can Declare 15 Days, But Salary Cut 5 Days / Month for 3 Months. \r\n\r\nUPDATED ON 27/03/2019\r\nALREADY CLEARED, DISCUSSED. SALARY CUT ALONE TO BALANCE CANNOT CUT FOR 13 DAYS TOGETHER. Mr.GK & GROUP HR WORKING TO BALANCE 3 DAYS / MONTH. WILL FINALSIE.','',1,'2019-02-27','2019-03-01','2019-04-17','',''),(19,1,'MRP-I','development','Breakup','Inventory value every month with breakup','close',6,'Jayaram singh','Sir, Need to Work on it, Will Update as Indicated.\r\nDatas Avail, But due to PSA, CII, Audits Continously May need to Consolidate, & Forward. By 8th can Be Possible.\r\n\r\nUPDATED ON 27/03/2019\r\nALREADY UPDATED, SENT. ANY CLARIFICATION PL. UPDATE.','',1,'2019-02-27','2019-03-08','2019-06-24','',''),(20,4,'MRP-II','finance','Labour cost','Analyze labor cost / month ? Why is it high ?','close',5,'Rajasukumar','Kindly amend the target date as 2019-03-06\r\nDate: 2019-03-06:\r\nLabour cost details have been worked out. A separate mail attaching the relevant data is being sent to MD-Secretary.','',1,'2019-02-27','2019-03-06','2019-04-02',NULL,''),(21,1,'MRP-I','development','LEAN','LEAN - Grill ideal plan on paper','close',6,'Jayaram singh','Grill Trials On, By Fri Sat will have Datas.\r\nOil Sump, Limping, To Take Off with Vigor. Next Phase Pl.\r\n\r\nUPDATED ON 27/03/2019\r\nON FAST TRACK. GRILL ALMOST COMPLETED.\r\nOIL SUMP CLOSER, TO REFINE.\r\nOTHER LINES ALSO PREPARING.\r\nBY WEEK END 30/03/2019 WILL UPDATE & MAIL STATUS PL. DIRECT BY TEAM.','',1,'2019-02-27','2019-03-08','2019-06-24','',''),(22,1,'MRP-I','finance','Budget','Budget for all the departments','re-open',6,'Jayaram singh','Will Further get Delayed, Refining in Progress. \r\nMay be During This Closing Period can Spend Time & Consolidate. Around Mid March.\r\n\r\nUPDATED ON 27/03/2019\r\nAS DISCUSSED ALMOST COMPLETED. Mr. GK MEETING EACH HODs, TO CONSOLIDATE REFINE, & WILL BE MADE AVAIL BY 10th APRIL.\r\n\r\nToday (17/4/19) Submitted, Brake up after Clarification during Your Visit, & will Submit Final by May 1st Week','Has this task been completed??\r\nCan we include budget in PMS and evaluate against target monthly\r\n?',1,'2019-02-27','2019-03-01','2019-06-24','',''),(23,5,'MRP-III','development','Monitoring  process','Monitoring the business against the signed off figure with the foundry','working',4,'Vasu','Under process','',1,'2019-02-27','2019-03-31',NULL,NULL,''),(24,5,'MRP-III','finance','Turnover','Scheduled turnover loss mentioned  daily','re-open',4,'Vasu','Completed.  Document will sent through mail.','This report to be sent on daily basis via email.',1,'2019-02-27','2019-03-08','2019-04-02',NULL,''),(25,9,'UHE','finance','Vessco - Projects','Vessco  jobs working for all projects','close',11,'Pramod Kumar','Completed','',1,'2019-02-27','2019-03-01','2019-03-30',NULL,''),(26,9,'UHE','finance','COX Quotation (New)','COX Quotation (New)','close',8,'Gopalakrishnan K','Offer submitted','',1,'2019-02-28','2019-03-08','2019-03-19',NULL,''),(27,6,'MRP-IV','development','PMS Data - MRP 4','PMS data across for MRP4','close',10,'Balasundaram E S','Sir, Audit to be completed by 15.03.2019.  FY 19-19 completed and benefit also granted.','',1,'2019-02-28','2019-03-08','2019-07-02','',''),(28,4,'MRP-II','development','Highway land staus','Highway land staus','re-open',10,'Balasundaram E S','Sir\r\nSF No 293 Deccan submitted. SF No 296 documents ready, will be submitted on 4.07.2019','We shall close the task after all the documents are submitted.',1,'2019-02-28','2019-03-01','2019-07-02','',''),(29,4,'MRP-II','development','PMS Rollout','PMS Roll out','re-open',10,'Balasundaram E S','We will intiate from April 2019','Will close this task after \r\n\r\n1. Finalized increments for last year.\r\n2. Targets signed off for FY20 and monthly display of the status in the plants is started.\r\n3. O3 meeting between Unit Head and HODs happen regularly to improve performance.',1,'2019-02-28','2019-03-20','2019-04-02',NULL,''),(30,1,'MRP-I','development','Specific Data - P1,P3,P4,P5','specific data for PMS closing, Appraisal,increment calculation & disbursement P1,P3,P4,P5 \r\n\r\n(Note : I need 4 datas for each plant )','re-open',10,'Balasundaram E S','Will be submitted end of April 2019','Will close when the increments are finalised for all plants.',1,'2019-02-28','2019-03-08','2019-04-02',NULL,''),(31,1,'MRP-I','development','Appraisal','Appraisal form to have ( 1 - 10 ) rating subject','re-open',10,'Balasundaram E S','Mail circulated on 29.03.2019 with target dates','Clarify on the Rating scale and the need for it.',1,'2019-02-28','2019-03-08','2019-04-02',NULL,''),(32,6,'MRP-IV','development','ELGI business','Status of ELGI business','close',7,'Vikas','email for producing 2 variants has been received from ELGI, proto also build awaiting inspection from ELGI. Vendor code also has been created .','',1,'2019-02-28','2019-03-15','2019-06-24','',''),(33,5,'MRP-III','development','Requriement','Helper requirement analysis : Mr. Kannan','close',4,'Vasu','Completed.  Document will sent to you through mail.','',1,'2019-02-28','2019-03-08','2019-03-30',NULL,''),(34,6,'MRP-IV','development','Capacity enhancement','Capacity enhancement chairman','close',7,'Vikas','already discussed and closed.','',1,'2019-03-01','2019-03-15','2019-06-24','',''),(35,9,'UHE','development','Verify landed cost for KOREA ( whether includes duty or not for COX )','Verify landed cost for KOREA ( whether includes duty or not for COX )','close',8,'Gopalakrishnan K','Duties not included.\r\nImport licence charges considered for export.','',1,'2019-03-11','2019-03-12','2019-03-19',NULL,''),(36,9,'UHE','development','Vessco offer for parts (vessels)','Vessco offer for parts (vessels)','close',8,'Gopalakrishnan K','Offer submitted on 5th April 2019','',1,'2019-03-11','2019-03-15','2019-06-24','',''),(37,11,'APMUG','development','Task - updated verification','Task Completion updated verification','close',12,'NIKHIL SUNIL','I am updating the verification','',1,'2019-03-11','2019-03-12','2019-06-18','',''),(38,11,'APMUG','development','Vessco  71K','Vessco 71K ,whether includes transport','close',12,'NIKHIL SUNIL','Yes it includes transport, communicated to GOPAL','',1,'2019-03-11','2019-03-13','2019-06-18','',''),(39,11,'APMUG','development','RIMTEX','RIMTEX can for Mill owner','close',12,'NIKHIL SUNIL','Vasu and Team Organising it...So closing it.','',1,'2019-03-11','2019-03-15','2019-06-18','',''),(40,5,'MRP-III','finance','Fund Requirement','Fund Requirement projection for MRP III','close',4,'Vasu','Under Progress. Detailed working forwarded to DGM Finance throguh mail','',1,'2019-03-11','2019-03-15','2019-04-02',NULL,''),(41,9,'UHE','development','UHE board meeting con call','Schedule next board meeting con call date for UHE','re-open',11,'Pramod Kumar','Board meeting conducted as per schedule','',1,'2019-03-11','2019-03-15','2019-03-18',NULL,''),(42,1,'MRP-I','development','Travel Policy','Travel Policy Completion','re-open',10,'Balasundaram E S','Sir\r\nNew Travel policy is attached for your review','As discussed, combine the Stay and Food per day for international travel and release the document. \r\n\r\nDomestic I hope it is OK, dont have a sense at costs.',1,'2019-03-11','2019-03-15','2019-06-18','42-Travel Policy Domestic and Internatation 2019.pdf',''),(43,9,'UHE','development','UHE board meeting con call','Schedule next board meeting con call date for UHE','re-open',11,'Pramod Kumar','Probably between 15 to 20th of April 2019.\r\nPlease confirm the date of availability.','Why do we have to have it again in April 2019?? \r\nSchedule for end of Q1 FY 2020. Maybe a date in July 2019 to review Q1?',2,'2019-03-18','2019-03-19','2019-03-19',NULL,''),(44,9,'UHE','development','UHE board meeting con call','Schedule next board meeting con call date for UHE','re-open',11,'Pramod Kumar','We will conduct the board meeting in  between April 16 to April 20. Please confirm the date.','Why do we have to have it again in April 2019?? \r\nSchedule for end of Q1 FY 2020. Maybe a date in July 2019 to review Q1?',3,'2019-03-19','2019-03-22','2019-03-30',NULL,''),(45,4,'MRP-II','development','IREPS','IREPS  Railway  Registration','close',5,'Rajasukumar','Registration under MRP-II name is being worked out.\r\nA certificate has to be obtained from GST Cell. It will take\r\ntwo days. Hence the registration can be completed by \r\n25-03-19\r\nRegistration has been completed successfully on 22-03-2019. Information has been passed on to Mr. Anand Dwivedi along with necessary documental proof.','',1,'2019-03-20','2019-03-22','2019-04-01',NULL,''),(46,4,'MRP-II','development','GEM','GEM Registration','close',5,'Rajasukumar','Work is in progress.\r\nThe form has been filled in. There is a clarification needed from the Finance Department. Once that is clarified, the form can be up-loaded.\r\n\r\n02-04-2019\r\nThere is problem in the GeM portal as the PIN code given in the portal is old. This has to be corrected by the team. This will have after 48 hours. We expect this to be completed by 5th April \'19\r\n22-04-2019.\r\nAt present, the PIN code of Malumachampatti has to be added to the list of PIN codes. Till date, this has not taken place even though. According to the concerned person, this process of PIN code addition will take time to implement. This is being continuously followed.\r\n\r\n02-05-2019\r\nGeM registration has been successfully completed.','',1,'2019-03-20','2019-03-22','2019-06-24','',''),(47,5,'MRP-III','development','BTS & YCS  : FY 2020','Projection for textiles ( BTS & YCS )  Sales for FY 2020','close',4,'Vasu','Mr.Padmakumar is on the job.  Few more details to be received to conclude.\r\nAs such based on the feed back form market we can reach 300 lakhs provided the quality of the product and erection workmen ship should be good. Discussing with the concerned departments to plan to strengthen the team.\r\nupdated on 11.0519.BASED ON THE DISCUSSION WE HAVE FREEZED THE TARGET FOR TEXTILE RS.300 LAKHS. UPDATED ON 14.06.19','',1,'2019-03-20','2019-04-15','2019-06-24','',''),(48,5,'MRP-III','development','Actuals  Vs Costing','Actuals  Vs Costing monitoring to be established and reported regulerly','working',4,'Vasu','Established for Cylinders,  FCR & Piston- others under progress','',1,'2019-03-20','2019-03-26',NULL,NULL,''),(49,5,'MRP-III','development','Top 3 heads > than costing P & L','Top 3 heads >  than costing P & L to be analyzed   for Feb\'19 . Date & Plan for improvement to be given by','working',4,'Vasu','Under profress','',1,'2019-03-20','2019-03-26',NULL,NULL,''),(50,5,'MRP-III','development','Top 3 products','Top 3 products ( contribution wise ) to be tracked and reported for control with respect to costing','working',4,'Vasu','Under progress..Details submitted in the meeting','',1,'2019-03-20','2019-03-26',NULL,NULL,''),(51,5,'MRP-III','development','MOU','Dedicated person to manage MOU line','validate',4,'Vasu','Assigned the job with existing TAFE contractor and it is going well','',1,'2019-03-20','2019-03-31','2020-02-03','',''),(52,4,'MRP-II','finance','Initial projection - Mr.Venkat','Venkat to workout higher in expenses with respect to initial projection','close',9,'Ashok S','initial projection difference has been uploaded.','',1,'2019-03-20','2019-03-25','2019-06-24','52-CFS Increase of 78 lacs-reasons.xlsx',''),(53,4,'MRP-II','development','Booking order beyond OCT 2019','Booking order beyond OCT 2019','validate',5,'Rajasukumar','Several areaVF- other components.\r\n\r\ns are being worked out. This might go beyond April 2019.\r\nFollowing areas are bring focused\r\n\r\n\r\n06-08-2019\r\nT-72 Water Radiator RH assemblies Supply Order is likely to take a month before MRP-II could get the hard copy of the order.\r\n2. DLW.\r\n3. BEML, Oil Coolers.\r\n4. DLF, Marhowrah, Bihar.\r\n5. Depots\r\n6. CLW.\r\n7. Zonal Railway workshops.\r\nActions have been initiated to obtain orders from the above customers. This will take a few more months.\r\n20-05-19\r\nWe are trying to contact Zonal Railways. So far there is no positive response from the Zonal Railways. We continuing our efforts. This can be reviewed by July 2019.\r\n31-05-19.\r\nEfforts are being made to get some orders from Zonal Railways.\r\n\r\n08-07-2019\r\n1. We have received Tender inquiry for T-72 Water Radiators - RH assemblies - Qty 639 nos. There is good scope to get this order. There will be 2 suppliers for this LT.\r\n2. Further, an inquiry is expe \r\n21-11-2019\r\n1. Orders are expected from HVF by end Dec 19 for the following items.\r\n a) T-72 Water Radiator - RH assembly 639 nos.   \r\n b) T-72 Cooler Oil - Type \'B 746 Nos\r\n c) T-72 Cooler Oil - Type C 224 nos.','',1,'2019-03-20','2019-04-30','2020-02-04','',''),(54,1,'MRP-I','development','Report','Each HOD ,employee one level below should be responsible for reputing some information on a daily ,weekly , monthly basis. This needs to be desinged','working',10,'Balasundaram E S','Sir will be organized with VP and other HODs in first week of April 2019.','',1,'2019-03-20','2019-04-30',NULL,NULL,''),(55,1,'MRP-I','development','Varadharaj to give note on areas for improvement','Varadharaj to give note on areas for improvement','close',6,'Jayaram singh','UPDATED ON 27/03/2019\r\nMr. NATARAJAN HAS UPDATED, ALSO SUBMITTED TO AL HOSUR. WERE TO MEET TODAY. WILL FORWARD BY 01/04/2019 WITH DATAS UPTO MARCH UPDATED, PL.','',1,'2019-03-20','2019-03-25','2019-06-24','',''),(56,9,'UHE','development','UHE board meeting con call','Schedule next board meeting con call date for UHE','open',11,'Pramod Kumar','','Why do we have to have it again in April 2019?? \r\nSchedule for end of Q1 FY 2020. Maybe a date in July 2019 to review Q1?',4,'2019-03-30',NULL,NULL,NULL,''),(57,4,'MRP-II','development','PMS Rollout','PMS Roll out','validate',10,'Balasundaram E S','Sir FY 2019 completed','Will close this task after \r\n\r\n1. Finalized increments for last year.\r\n2. Targets signed off for FY20 and monthly display of the status in the plants is started.\r\n3. O3 meeting between Unit Head and HODs happen regularly to improve performance.',2,'2019-04-02','2019-05-31','2019-10-08','',''),(58,1,'MRP-I','development','Specific Data - P1,P3,P4,P5','specific data for PMS closing, Appraisal,increment calculation & disbursement P1,P3,P4,P5 \r\n\r\n(Note : I need 4 datas for each plant )','validate',10,'Balasundaram E S','Sir FY 2019 is completed','Will close when the increments are finalised for all plants.',2,'2019-04-02','2019-05-31','2019-10-08','',''),(59,1,'MRP-I','development','Appraisal','Appraisal form to have ( 1 - 10 ) rating subject','validate',10,'Balasundaram E S','Sir\r\nFor FY 2019 is completed','Clarify on the Rating scale and the need for it.',2,'2019-04-02','2019-04-15','2019-10-08','',''),(60,4,'MRP-II','finance','Availability of free cash','Calculation of availability of free cash','re-open',9,'Ashok S','As on 9th May, the cash credit overdrawn request given for 25 lacs to be regularised by month end on receipt delhi depo order receipt. Hence there is no surplus cash available.','I would like this to be monitored and reported on a monthly basis and I will close the task when I can see it reported during MRP II monthly reviews.',2,'2019-04-02','2019-04-19','2019-06-24','',''),(61,9,'UHE','development','VUHE','Duty benefit to be passed on to VUHE','open',8,'Gopalakrishnan K','','The working of arbitrary 4% is not convincing. The number should have some logic with respect to the actuals. There was no explanantion available.\r\n\r\nPls workout the actual details and send the sheet.',2,'2019-04-02',NULL,NULL,NULL,''),(62,5,'MRP-III','finance','Turnover','Scheduled turnover loss mentioned  daily','open',4,'Vasu','','This report to be sent on daily basis via email.',2,'2019-04-02',NULL,NULL,NULL,''),(63,4,'MRP-II','development','Bihar Plant','GE - Bihar plant - Potential for business','validate',5,'Rajasukumar','An appointment has been sought with the concerned officer. and this is expected to happen towards the end of April \'19\r\n22-04-2019\r\n\r\n\r\n\r\n06-08-2019\r\nPlanning to visit Pune after couple of weeks as the rain situation is bad at Pune..\r\n\r\n08-07-2019\r\nWill be trying to meet with the concerned person when visiting Pune depot during the month of July \'19\r\n20-05-19.\r\nBefore the end of May \'19, a visit to their Office at Pune will be made\r\nTrying for a meeting with Mr. Vikas Nath Singh, Commercial Manager. This is likely to happen during the 1st week of May.\r\n03-05-2019\r\nAwaiting to get some payments for traveling to Pune.\r\n31-05-19\r\nHas to make a visit to Pune to meet the concerne\r\n\r\n\r\n11-11-2019.\r\nVisited Pune on 7/8th November \'19. In spite of several attempts to contact the concerned person, there was no response. Even when tried from different numbers, there was no response. It looks that they are not looking for new supplier at present. \r\nThis will not materialize during this financial ','',1,'2019-04-02','2019-04-30','2019-11-11','',''),(64,4,'MRP-II','development','OFMK','OFMK New order details / information','working',5,'Rajasukumar','There are no clear details available. We need to explore the possibility of further orders.\r\n22-04-2019\r\nPlanning for a meeting with Mr. Krishnamoorthy, AGM-\r\n\r\n04-02-2020.\r\nQuotation for the following items are being submitted.\r\n1. BMP Cooling System - 56 nos.\r\n2. GB Oil Cooler - 250 nos\r\n3. Lube Oil Coolers - 863.\r\nOFMK shortly. Issues will have more clarity after the \r\nmeeting\r\n20-05-19.\r\nWaiting for funds to make a visit to OFMK.\r\n03-05-2019\r\nAwaiting a response from OFMK for a meeting request.\r\n31-05-19.\r\nPlanning a visit to OFMK during the middle of June \'19\r\n\r\n08-07-2019\r\nVisited OFMK on the 19th June 2019. The following opportunities are there.\r\n1. Oil Cooler Tenders are going to be released as the supplier who was L1 in the previous two Tenders was not supplying any items.\r\n2. There is a likelihood of Cooling System requirements to the extent of 148 nos. The Army has to release the indent for the same. It is awaited. This is likely to \r\nhappen in the next 3 to 4 months.\r\n3. OFMK will be shortly releasing various items they are interested in having local suppliers. MRP-II can pick up items that fall within its scope of production.\r\n\r\nUpdate on 21-11-2019\r\n1. BMP Cooling system Tender inquiry is expected to be released during Dec 2019. This will the requirement for the year 2020-21.\r\n2. Lube OilCooler Tender inquiry is also expected druing December 2019..\r\nThese orders will cover the production capacity for the period 2020-21\r\n\r\n04-02-2020\r\nQuotations are being submitted on 5th , 6th and 7th of Feb 2020.\r\n1. BMP Cooling System - 56 nos.\r\n2. GB Oil Cooler - 250 nos.\r\n3. Lube Oil Cooler - 853 nos.\r\nBy 10th of Feb \'20, the results will be known.\r\n\r\n07-02-2020\r\n1. MRP-2 is L2 in BMP Cooling System\r\n2. MRP-2 is L2 in BMP GB oil Cooler.','',1,'2019-04-02','2019-04-15',NULL,NULL,''),(65,4,'MRP-II','development','Enquries  - other product','Kirku,Pune  - Enquries for other products','validate',5,'Rajasukumar','List of items that can be supplied by MRP-II is being prepared. This will happen before 15th April \'19.\r\n22-04-2019.\r\nThe list is under preparation. This will be sent to the\r\n\r\n26-06-19\r\nThe quote is being given for Pipe assembly, a new inquiry from OFMK.\r\nThe quote is being arranged for Heat core to be supplied to Mr. Ragavan.\r\n \r\nCommandant before 27-04-2019\r\n20-05-19.\r\nThis list of items that can be supplied by MRP-II will be discussed during the proposed meeting by the end of May \'19.\r\n03-05-2019.\r\nThe list has been sent to the Commandant, CAVFD, Kirkee, Pune. When the Marketing Manager goes to deliver the Water Radiator consignment he would follow up with the concerned persons.\r\n31-05-19\r\nWill be discussing with the concerned persons when visiting Pune during the middle of June \'19\r\n\r\n08-07-2019.\r\n1. Once MRP-II gets the approval of the cooling system, there is a lot of scopes to get orders for other items.\r\n2. Whenever MRP-II visits the Depot at Pune, efforts will be made to get','',1,'2019-04-02','2019-04-15','2019-11-19','',''),(66,5,'MRP-III','development','Textile Projection','Textile Projection for FY 20','close',4,'Vasu','TASK DUPLICATED','',1,'2019-04-02','2019-04-15','2019-06-24','',''),(67,5,'MRP-III','finance','Meeting @ MRP- III ,10 :00 AM','Cylinder  line actuals for Mar 2019,Meeting @ MRP- III ,10 :00 AM','close',4,'Vasu','under process','',1,'2019-04-02','2019-04-04','2019-06-24','',''),(68,5,'MRP-III','development','Lucky mills','Lucky mills,decision on how to move forward','close',4,'Vasu','Will revert back in consultation with the team - Got appointment with the Lucky mill business head to discuss about the future plan-- can be updated the status after the meeting','',1,'2019-04-02','2019-04-06','2019-06-24','',''),(69,5,'MRP-III','finance','P & L','Costing P& L â†” Actual P & L  â†’ Plant to achieve  Costing P & L\r\n\r\nVariable Cost :\r\n\r\nFixed OH :\r\n\r\nOther Expenses :','working',4,'Vasu','Under process','',1,'2019-04-02','2019-04-22',NULL,NULL,''),(70,5,'MRP-III','finance','Fixed OH','Fixed OH  âˆ’  staff what are they doing ? Report.','working',4,'Vasu','Under process','',1,'2019-04-02','2019-04-22',NULL,NULL,''),(71,5,'MRP-III','finance','Projected cost for chairman','Compare Current  price with projected cost for Chairman','working',4,'Vasu','completed','',1,'2019-04-02','2019-04-22',NULL,NULL,''),(72,9,'UHE','development','Transportation  Invoice to  UHE from VUHE','Cancelling of Transportation  Invoice to  to UHE from VUHE updating of GST details for returns','close',11,'Pramod Kumar','Task Completed','',1,'2019-04-02','2019-04-15','2019-04-13','72-',''),(73,1,'MRP-I','finance','Monthly P & L','Projected monthly P & L for MRP I','close',6,'Jayaram singh','Will Work Out, getting Closer. When in Chennai can Discuss. Will be Ready. Will Mail.\r\n\r\nSUBMITTED, CORRECTIONS TO BE UPDATED & WILL RESUBMIT  ON 30.04.2019','',1,'2019-04-02','2019-04-15','2019-06-24','',''),(74,4,'MRP-II','development','DLW','DLW - New Order','validate',5,'Rajasukumar','This is being followed with Mr. Anand Dwivedi. This will take some time.\r\n22-04-2019\r\nMr. Anand Dwivedi is expected during the first week of\r\n2019. This issue will be discussed with him\r\n03-05-2019\r\nAccording to Mr. Anand, any inquiry can be expected only after the Parliamentary elections are over.\r\n20-05-2019.\r\nOnce the funds are available, Planning to visit Varanasi to explore the possibility of getting further orders.\r\n31-05-2019\r\nNot much progress has been made. Once the funds are available will make a visit to Varanasi to find out the status.\r\n\r\n08-07-2019\r\n\r\n\r\n\r\n\r\nSo for there has been no communication with Mr. Anand Dwivedi. No response to any number of phone calls or emails. \r\nNeed to discuss with MD on future course of action.\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n06-08-2019\r\nThere has been no response from Mr. Anand regarding further business with DLW. After discussing with MD, a  new strategy has to be worked out.\r\n\r\n04-10-2019.\r\nInquiry has been received for 199 nos of Modified After Cooler. We n','',1,'2019-04-03','2019-04-15','2019-11-11','',''),(75,6,'MRP-IV','development','China Trip','China trip to planned and finalized','close',7,'Vikas','Plan to visit after May 16th. Meanwhile pls share your passport scanned copy for arranging invitation. Awaiting your scanned passport copy.','',1,'2019-04-04','2019-04-22','2019-06-24','',''),(76,6,'MRP-IV','development','Off site planning : FY 20','Off site planning session  for FY 20, Date to be desided','assigned',7,'Vikas','','',1,'2019-04-04','2019-04-22',NULL,NULL,''),(77,6,'MRP-IV','development','Powder coating','Powder coating expansion of capacity.','close',7,'Vikas','Final quote received , i am traveling to chennai next week to scrutinize the PC guns. PO can be released by month end.','',1,'2019-04-04','2019-04-15','2019-06-24','',''),(78,5,'MRP-III','development','Feb 2019 Ratios','MRP - III Upto Feb 2019 Ratios ,and projected FY 20 ratios.What needs to changed / improved to achive result mention target values','re-open',9,'Ashok S','Target values projected PL is attached. The consumable and labour charges are monitored and to be achieved as per departmental and projected budget to achieve the desired result','Pls compare the projections with actuals.\r\nDiscuss with Vasu so he understands and agrees as well. I will close task after I see it regularly in the monthly meeting. THANKS',1,'2019-04-04','2019-04-12','2019-07-24','78-MRP-3 Projected PL 19-20 09.05.18.xlsx',''),(79,5,'MRP-III','development','MRP - III planning session','Pre planning for MRP - III planning session','assigned',12,'NIKHIL SUNIL','','',1,'2019-04-04','2019-04-11',NULL,NULL,''),(80,11,'APMUG','development','standardize the A/C software,','Study how we can standardize the A/C software,\r\noption of software avalible','close',9,'Ashok S','Study completed and preliminary work started at plant-2.','',1,'2019-04-04','2019-04-16','2019-06-24','',''),(81,11,'APMUG','development','ERP software','Study how we can have common ERP software option ?','close',13,'MRK','Sir, \r\nMyself and Mr.Ashok discussed with Mr.Jebanesh regarding centralised ERP system and the details is attached.','',1,'2019-04-04','2019-04-16','2019-06-24','',''),(82,1,'MRP-I','production','MRP5 & 1  for DBR / MDU in requirement report','No .of parts plant wise ( MRP5 & 1) for DBR / MDU in requirement report  % of parts in DR ,Our NPS for the DR parts.\r\nSIGAMANI REPORT DAILY','close',6,'Jayaram singh','Will Follow & Update by Target Date.\r\n\r\nFORWARDED BY Mr. SIGAMANI','',1,'2019-04-11','2019-04-15','2019-06-24','',''),(83,1,'MRP-I','production','FENDER and TANK','Plan for checking all child parts against dwg for FENDER and TANK','close',14,'palani','As Per Dwg Layout inspection ongoing','',1,'2019-04-11','2019-04-12','2019-04-16','83-Fender child part Dim Reports.zip',''),(84,1,'MRP-I','production','Reputing process for FENDER and TANK','Plan for reputing process adhere all process for  FENDER and TANK','re-open',14,'palani','Tank dimension report process to be done','I am reopening the task. \r\nJust giving me a inspection report does not close this task. I want a plan by which all aspects of the Fender and TANK will be adhered to in the process.\r\nThanks',1,'2019-04-11','2019-04-19','2019-06-24','84-Fuel Tank LOI.zip',''),(85,1,'MRP-I','finance','Structure for review mtg','Structure for review mtg with MD during his visit .','close',6,'Jayaram singh','Year Consolidation Report with HODs & Indicate targets for This Year.  \r\nLean in Details as We have Understood, Some Refining with Each Team.\r\nDBR Project Status, Steps of Implementing with Plan\r\nBudget Review.\r\nAny Other Agenda in Particular. Since Lean may take Time.','Send me a sample presentation with April data, and then we can close this task.',1,'2019-04-11','2019-04-12','2019-05-09','',''),(86,5,'MRP-III','development','cost of cylinder','Direct labor and Indirect Labor utilization / available Vs requirement  .\r\n\r\nMONITORING DAILY','close',4,'Vasu','Details of usage of Direct Labour and Indirect labour presented during the meeting held on 07.05.19.\r\nSummary sent by mail by Mr.Kannan / Mr.Manoj on 11.05.19','',1,'2019-04-11','2019-04-12','2019-06-24','',''),(87,5,'MRP-III','production','FCR & Piston family','FCR & Piston family for cost monitoring daily','close',4,'Vasu','Presented during the meeting held on  07.05.19','',1,'2019-04-11','2019-04-12','2019-06-24','',''),(88,5,'MRP-III','production','Chairman pricing','MRP - III Chairman pricing to check and make a plan to meet with TAFE','close',4,'Vasu','Noted. Pricing details prepared by chairman to be received. Spread sheet given by Chairman need some correction in connection with Price correction by customer. Things got up dated and the spread sheet for April and May  forwarded to chairman on 15.06.19.','',1,'2019-04-11','2019-04-22','2019-06-24','',''),(89,5,'MRP-III','development','Cost of cylinder - 1035,375,245','Daily monitoring of cost of cylinder - 1035,375,245','working',4,'Vasu','Completed. presented in the meeting.','',1,'2019-04-11','2019-04-12',NULL,NULL,''),(90,1,'MRP-I','development','Reward system','Presentation by Albert to explain reward system to unit heads for 2019 - 2020','re-open',10,'Balasundaram E S','Sir, Mr Albert is under going a training at Bangalore staring from 17 to 22.04.2019. He tried to skip the first day, they are not allowed. It is a paid programme.\r\n I am suggesting to have a meeting with MRP1 at Chennai and remining plants at CBE along with MD in a convenient date after 23rd April.','Noted. Will close the task after the presentation is completed.',1,'2019-04-11','2019-04-17','2019-04-13','',''),(91,1,'MRP-I','finance','MRP - I Data for FY 19 - sample format','MRP - I Data for FY 19 entered in sample format sent','close',9,'Ashok S','Monthly plant-1 data uploaded and sent by mail.','',1,'2019-04-11','2019-04-15','2019-06-24','91-Financial_Import_-_Monthly.xlsx',''),(92,1,'MRP-I','production','Plan to Implement ...','Why is new part PPM high Analysis of the root cause and plan to implement the corrective action','open',0,'','','',1,'2019-04-11',NULL,NULL,NULL,''),(93,1,'MRP-I','development','Reward system','Presentation by Albert to explain reward system to unit heads for 2019 - 2020','open',10,'Balasundaram E S','','Noted. Will close the task after the presentation is completed.',2,'2019-04-13',NULL,NULL,NULL,''),(94,1,'MRP-I','development','Monthly meeting reporting format','Monthly meeting reporting format','assigned',12,'NIKHIL SUNIL','','',1,'2019-04-23','2019-04-30',NULL,NULL,''),(95,5,'MRP-III','development','TAFE strategy','Meet with MRP III team to discuss TAFE strategy.','working',4,'Vasu','','',1,'2019-04-23','2019-04-26',NULL,NULL,''),(96,1,'MRP-I','development','Technology for defence and Railways','Look All Technology for defence and Railways .\r\nCost of the equipment','assigned',12,'NIKHIL SUNIL','','',1,'2019-04-23','2019-09-01',NULL,NULL,''),(97,1,'MRP-I','development','Status of SKID order from Vessco for VUHE ?','Status of SKID order from Vessco for VUHE ?','close',12,'NIKHIL SUNIL','The order looks doubtful.','',1,'2019-04-23','2019-04-30','2019-07-02','',''),(98,5,'MRP-III','development','YCS','YCS storage location finilisation','close',4,'Vasu','TASK DUPLICATED.','',1,'2019-04-23','2019-05-15','2019-06-24','',''),(99,5,'MRP-III','finance','KONE,TAFE,BBL components','OH cost from costing for entire FY\'19 for KONE,TAFE,BBL components','working',4,'Vasu','under progress','',1,'2019-04-23','2019-04-26',NULL,NULL,''),(100,1,'MRP-I','development','WEBSITE - MRP','MRP Website to be completed','re-open',7,'Vikas','90% completed, final draft to  be presented to MD on 16th.','Pls dont close the task if it is not completed. \r\n\r\nLet us review the web site and then you can close the task when the web site is launched.',1,'2019-04-23','2019-05-30','2019-06-24','',''),(101,1,'MRP-I','production','Transfer all Email ID\'s to mrpltd.in','Transfer all Email ID\'s to mrpltd.in','validate',13,'MRK','Sir,  mrpltd.in domain migration process completed from zoho to gmail on 27-12-2019.','',1,'2019-04-23','2019-05-30','2019-12-30','',''),(102,4,'MRP-II','finance','P & L for FY\'20','Costing based P & L for FY\'20 based on monthly plan .Compare this with projected P & L  for FY\'20.Analyse the difference with explantion','working',5,'Rajasukumar','The work is in progress and this may take a few more days. The report can be submitted by 2nd May 2019.\r\nThe calculations are still being done. Expected to be completed by end July 2019.\r\n20-05-19.\r\nFurther to the detailed discussion with MD, the target date is fixed as Last week of June \'19.\r\n31-05-19.\r\nMachine hr working is in progress. The total exercise will be completed by end June \'19.\r\n\r\n04-02-2020.\r\nNew cost sheets are being prepared and sent to the DGM. This exercise will be completed by 3rd week of Feb 2020.\r\n\r\n07-02-2020.\r\nAll cost sheets pertaining to the models being manufactured by MRP-2 have been on 06-02-2020 sent to DGM Fin for preparing the required P&L statement based on cost sheets.','',1,'2019-04-23','2019-04-26',NULL,NULL,''),(103,6,'MRP-IV','finance','Excise pending payment to be cleared','Excise pending payment to be cleared','re-open',7,'Vikas','out of 17 lakhs , 7 lakhs  payment made last week. Balance 10 lakhs will be cleared within July 19.','Pls close the task when the payment has been made fully.',1,'2019-04-23','2019-07-30','2019-06-24','',''),(104,1,'MRP-I','finance','P & L','Individual plan for improvement in % for the selected P & L head / parameters .How is it going to be achieved ?','assigned',15,'GKK','','',1,'2019-04-26','2019-04-30',NULL,NULL,''),(105,5,'MRP-III','development','YCS Spares requirement','YCS Spares requirement to be decide ,options ?','re-open',4,'Vasu','As the concerned person is not available in station not able to discuss and conclude- require few more days to take a decision - \r\nUpdated on 11.05.19','Status of this?? I am reopening the task. Pls do not close the task if it is not completed. I will be forced to reopen it.',1,'2019-04-26','2019-05-15','2019-06-24','',''),(106,5,'MRP-III','development','Lucky situations to be addressed and solved','Lucky situations to be addressed and solved','working',4,'Vasu','AS DISCUSSED WORK IS GOING ON- two group work completed - under observation- for third group  required some fabricated parts to be discussed with Engineering team on 13.05.19 to take    Up dated on 11.05.19. Group I and II is running fine. One of our staff is deputed at the mill to monitor the performance. Till now it is working good. As per the information we have stop furhter work and took back balance material','',1,'2019-04-26','2019-05-15',NULL,NULL,''),(107,5,'MRP-III','development','KONE reference for new powder coating both - HDLV','KONE reference for new powder coating both - HDLV','working',4,'Vasu','DISCUSSED WITH MR.SATHEESH OF KONE. HE WILL REVERT BACK IN CONSULTATION WITH THE PAINT SHOP INCHARGE.\r\nyet to receive the feed back - updated on 11.05.19','',1,'2019-04-26','2019-05-06',NULL,NULL,''),(108,5,'MRP-III','development','Tallying and justifying the debit notes to rejection to be correct','Tallying and justifying the debit notes to rejection to be correct','close',4,'Vasu','WORK OVER. CAN BE PRESENTED IN THE MEETING ON 07.05.2019.','',1,'2019-04-26','2019-04-30','2019-05-31','',''),(109,6,'MRP-IV','development','ROI for capex in powder coating','ROI for capex in powder coating','re-open',7,'Vikas','Already submitted. Proposal cleared by management','Noted. Lets us close this task, after we have a live tracking sheet which will be used to track the ROI recovery month on month.\r\nThanks',1,'2019-04-26','2019-05-03','2019-05-31','',''),(110,9,'UHE','development','O3 mtg with HOD - 1 Cycle','O3 mtg with HOD\'s - 1 Cycle','close',8,'Gopalakrishnan K','Started from 24 07 2019.\r\nUpdated comments in register at my Cabin.\r\nIt is continuous process and task cannot be closed.','',1,'2019-05-08','2019-05-30','2019-08-29','',''),(111,9,'UHE','development','Operational update mtg','Operational update mtg - Biweekly - Structure / Agenda','close',8,'Gopalakrishnan K','Discussed with the Team Heads\r\nSample ppt will be discussed on Wednesday the 15th May 2019.\r\nMeeting proposed on Wednesday of first week of every month.','',1,'2019-05-08','2019-05-10','2019-07-24','',''),(112,9,'UHE','development','SKID presentation potential','SKID presentation potential','close',8,'Gopalakrishnan K','Completed.\r\nThe ppt. Mailed to Chairman and Managing Director','',1,'2019-05-08','2019-05-17','2019-06-24','',''),(113,9,'UHE','development','Process flow for - Gamesa','Process flow for - Gamesa','close',8,'Gopalakrishnan K','Mailed Project Manager and Process Flow Chart to MD and Chairman','',1,'2019-05-08','2019-05-30','2019-07-24','',''),(114,9,'UHE','development','Rectangular Tanks offer   - UHE','Rectangular Tanks offer   - UHE','close',8,'Gopalakrishnan K','Offer sent','',1,'2019-05-08','2019-05-10','2019-07-24','',''),(115,5,'MRP-III','development','Document MRP -  III staff feedback','Document MRP -  III staff feedback','assigned',12,'NIKHIL SUNIL','','',1,'2019-05-15','2019-05-31',NULL,NULL,''),(116,5,'MRP-III','development','MRP III Kone components at MRP II sheaving m/c','MRP III Kone components at MRP II sheaving m/c ?','close',4,'Vasu','Discussed with MRP II. Thickness is constraint for them. Negotiation is under progress with Kone based on the process route given by MRP IV','',1,'2019-05-15','2019-05-31','2019-06-18','',''),(117,5,'MRP-III','production','250/- /hr Fixed cost revenue high,please reverify','Rs.250/- /hr Fixed cost revenue high,please reverify','close',4,'Vasu','Under process. Can be completed by 07th June 2019. Worke completed. Can be presented during the meeting on 11.06.19\r\nPresented in the meeting on 11.06.19','',1,'2019-05-15','2019-05-21','2019-06-18','',''),(118,5,'MRP-III','production','Out of 6400 hr, for machine ,how much was used in April 2019','Out of 6400 hr, for machine ,how much was used in April 2019','re-open',4,'Vasu','Required one more week time to close it as all are busy in locating alternate source for grinding and frequent visit of customers.Work completed can be presented during the meeting on 10.06.19','What was the final figure for April 2019? I shall close the task after I receive the value.',1,'2019-05-15','2019-05-31','2019-06-18','',''),(119,5,'MRP-III','development','All parts costing tracking Vs. customer cost','All parts costing tracking Vs. customer cost','re-open',4,'Vasu','For Cylinders, Pistonn & FCR status presented in the meeting. For all parts costing work completed and monitoring  Actual vs setimate for all parts started from 01.06.19','The task is not completed yet.',1,'2019-05-15','2019-06-01','2019-06-18','',''),(120,5,'MRP-III','development','Replace execution team in service for BTS','Replace execution team in service for BTS','open',0,'','','',1,'2019-05-15',NULL,NULL,NULL,''),(121,5,'MRP-III','development','Talk to santosh about BTS loss of order','Talk to santosh about BTS loss of order','assigned',12,'NIKHIL SUNIL','','',1,'2019-05-15','2019-05-31',NULL,NULL,''),(122,5,'MRP-III','production','Textile division under ISO by July 2019 . Q1 data should follow ISO','Textile division under ISO by July 2019 . Q1 data should follow ISO','working',4,'Vasu','','',1,'2019-05-15','2019-07-01',NULL,NULL,''),(123,1,'MRP-I','development','MRP-I  to submit details required by chairman monthly basis','MRP-I  to submit details required by chairman monthly basis','re-open',6,'Jayaram singh','Consolidate, Working on It. Will be Completed as Assigned. May Share & Clarify During Visit.\r\n\r\nDURING YOUR VISIT SHARED ALL DETAILS. DO I NEED TO ATTACH ALL OR MAIL ALL PL','I think the wrong file is attached to this task. Pls attach the correct file and update the task.',1,'2019-05-15','2019-05-31','2019-06-18','123-ROI cost saving.zip',''),(124,1,'MRP-I','development','In - house rejection to include rework costs wherever applicable ( Monthly financial Review )','In - house rejection to include rework costs wherever applicable ( Monthly financial Review )','re-open',6,'Jayaram singh','Working on it, Will be Arranged.\r\n\r\nAGAIN DATAS AVAIL, WILL ATTACH & MAIL.','Good work. There is a lot of data. Request you summarise and present during the monthly financial review meeting.\r\n\r\nI will close the task when the details are presented during the next meeting.',1,'2019-05-15','2019-05-31','2019-06-24','124-QA Doc.zip',''),(125,1,'MRP-I','development','Stock boosting to be reduced month on month .plan to be submitted and monitored  actuals monthly','Stock boosting to be reduced month on month .plan to be submitted and monitored  actuals monthly','re-open',15,'GKK','We have planned to reduce Rs.20.00 lakhs per month, totalling Rs.2.20 crores.  If the profitability increases, we may have to reduce the stock considerably in consideration with MD','Noted the plan. I will close task after you present the plan and status against plan monthly during during our group financial review.',1,'2019-05-15','2019-06-13','2019-06-24','',''),(126,6,'MRP-IV','production','Calculation of potential penalty + interest for excine duty late payment','Calculation of potential penalty + interest for excine duty late payment','assigned',7,'Vikas','','',1,'2019-05-15','2019-06-06',NULL,NULL,''),(127,1,'MRP-I','development','Daily sheet monitering for goal buddy','Daily sheet monitering for goal buddy','close',12,'NIKHIL SUNIL','Complete end of last month.','',1,'2019-05-16','2019-05-20','2019-07-02','',''),(128,5,'MRP-III','development','Replace Execution team is service for BTS','Replace Execution team is service for BTS','working',4,'Vasu','Looking for alternative person to take a call. REDUCED THE EXPENSES OF ONE ERECTOR BY 50%','',1,'2019-05-16','2019-06-16',NULL,NULL,''),(129,6,'MRP-IV','development','ROI for capex in powder coating','ROI for capex in powder coating','assigned',7,'Vikas','','Noted. Lets us close this task, after we have a live tracking sheet which will be used to track the ROI recovery month on month.\r\nThanks',2,'2019-05-31','2019-06-15',NULL,NULL,''),(130,1,'MRP-I','production','MD customer visit plan to be made for  Q2,Q3,Q4','MD customer visit plan to be made for  Q2,Q3,Q4','assigned',7,'Vikas','','',1,'2019-05-31','2019-06-15',NULL,NULL,''),(131,4,'MRP-II','development','Architect for MRP II building repairs','Architect for MRP II building repairs','assigned',12,'NIKHIL SUNIL','','',1,'2019-05-31','2019-06-30',NULL,NULL,''),(132,6,'MRP-IV','development','EBITDA & T/O target for MRP IV to be set band chairman details','EBITDA & T/O target for MRP IV to be set band chairman details','assigned',12,'NIKHIL SUNIL','','',1,'2019-05-31','2019-06-10',NULL,NULL,''),(133,13,'TRANSITECH','production','HRJ payment details to be mailed to Jaishankar','HRJ payment details to be mailed to Jaishankar','close',16,'JK','Today(03.06.19) morning HRJ Payment details mailed to Jaishankar .\r\nHRJ committed to release our due 12Lak on this month middle.','',1,'2019-05-31','2019-06-03','2019-06-18','133-HRJ _Sales & Collection_18 05 19-1.xlsx',''),(134,1,'MRP-I','finance','LTC ( Leave Travel concession ) can we start that for our employees','LTC ( Leave Travel concession ) can we start that for our employees','validate',10,'Balasundaram E S','Sir, I Agreed. It can be start initially for the Plant Heads. 2018-2021 is Block period as per IT. They can avail one journey in this period. For LTC the leave is compulsory, we need to clarify the leaves from Existing EL/CL or we will provide additional Paid leave for LTC.  Policy to be drafted for the same.','',1,'2019-05-31','2019-06-15','2019-10-08','',''),(135,1,'MRP-I','production','MRP I MAPL allowances','MRP I MAPL allowances','close',10,'Balasundaram E S','Sir Plant I MAPL is reviewed and some of  the deviations were approved by you.','',1,'2019-05-31','2019-06-10','2019-07-02','',''),(136,1,'MRP-I','production','ROI sheet to include the person responsible and regular communicates','ROI sheet to include the person responsible and regular communicates','close',6,'Jayaram singh','Will be Corrected & Updated Pl.','',1,'2019-05-31','2019-06-10','2019-06-18','136-ROI Summary-1.xls',''),(137,1,'MRP-I','development','Contribution loss for not meeting schedule along with person , reason to be incorporated','Contribution loss for not meeting schedule along with person , reason to be incorporated','re-open',6,'Jayaram singh','Already Included & being Circulated, Need to get Action Plan from Them','What is being circulated is the turnover loss. I am looking for the next step of calculating the contribution (Sales - Direct Costs) loss that is being caused because of non supply of items. Thanks',1,'2019-05-31','2019-06-17','2019-07-24','137-Day Wise Plan vs Actual-JUNE\'2019(New).xlsx',''),(138,1,'MRP-I','development','Plan to improve productivity in PRESS SHOP','Plan to improve productivity in PRESS SHOP','validate',6,'Jayaram singh','Discussions on with Mr. Devaraj, Mr. Murugaraj.\r\n\r\nMr. Natarajan given Spl Assignment, & 2 DMEs Planned to Note Idle Time in Each Shift. \r\nNew Safety System Cheaper, But 200% Safe Found in DBR, Hosur are being Planned, Since Safety is taking More Time. To Check, Review.\r\n\r\nUPDATED ON 26 JUNE     DATAS ARE GETTING COMPILED , WILL PLAN MONTH END. FEW PRESSES INHOUSE WITH PIECE RATE UNDER DISCUSSION, ELIMINATION OF SMALL HYD PRESS, REPLACING BY MECH. WILL BE SETTLED.','',1,'2019-05-31','2019-06-17','2019-11-14','',''),(139,1,'MRP-I','development','Hire an additional person for toolroom','Hire an additional person for toolroom','re-open',6,'Jayaram singh','Already in Progress, Joining 5th June. \r\n\r\nJunior Tool Person Already Joined, Replacement of One Left Person.\r\n\r\nUPDATED ON 26 JUNE  The Staff has Joined & Working in Tool Room. Not Updated Pl. Sorry.','I will close the task after the person is hired. \r\n\r\nPlease update the status. \r\n\r\nThanks',1,'2019-05-31','2019-06-17','2019-07-24','',''),(140,1,'MRP-I','production','All major part  #s , child parts and sub - assemblies ,layout inspection,dimension w.r.t dwgs .plan','All major part  #s , child parts and sub - assemblies ,layout inspection,dimension w.r.t dwgs .plan for correction to be made','working',6,'Jayaram singh','First Phase Planned in Fenders, Will Finalise Cost, Target Date, Plan by Mon, \r\nSince Mr. Sathya is Coming Daily not able to Spend Time, Focus. Will be done.\r\n\r\nUPDATED ON 26 JUNE In Progress, will be Completed by July End in a Phased Manner.','',1,'2019-05-31','2019-06-30',NULL,NULL,''),(141,1,'MRP-I','finance','Why - Why analysis for weekly loss in T?O by respective HOD\'s','Why - Why analysis for weekly loss in T/O by respective HOD\'s','validate',6,'Jayaram singh','To Plan & Start Off. Will Initiate.\r\n\r\nUPDATED 14/11 EXTREMELY SORRY FOR THE DELAY.\r\nALL ISSUES CLOSED, RATING IMPROVED,  ALSO ASN CLOSED. WILL ENSURE.LEAN HAS ALSO SUPPORTED A LOT.','',1,'2019-05-31','2019-06-17','2019-11-14','',''),(142,5,'MRP-III','development','Study organisation chart for MRP III','Study organisation chart for MRP III','working',4,'Vasu','Noted','',1,'2019-05-31','2019-06-17',NULL,NULL,''),(143,5,'MRP-III','production','Evaluate all HOD\'s in MRP III against minimum requirement','Evaluate all HOD\'s in MRP III against minimum requirement','working',4,'Vasu','P M S UNDER PROGRESS','',1,'2019-05-31','2019-06-30',NULL,NULL,''),(144,4,'MRP-II','production','JV for MRP II Al.technology project','JV for MRP II Al.technology project','assigned',12,'NIKHIL SUNIL','','',1,'2019-06-01','2019-06-30',NULL,NULL,''),(145,4,'MRP-II','production','MRP II cash flow to be kindly moniterd','MRP II cash flow to be kindly moniterd','assigned',12,'NIKHIL SUNIL','','',1,'2019-06-01','2019-06-03',NULL,NULL,''),(146,1,'MRP-I','development','DAILY WORK  - Checklist  template for MRP I  3 levels','DAILY WORK  - Checklist  template for MRP I  3 levels','assigned',10,'Balasundaram E S','','',1,'2019-06-03','2019-06-08',NULL,NULL,''),(147,1,'MRP-I','development','Travel Policy','Travel Policy Completion','close',10,'Balasundaram E S','Sir\r\nPolicy approved by you in hard copy. Hence need to close.','As discussed, combine the Stay and Food per day for international travel and release the document. \r\n\r\nDomestic I hope it is OK, dont have a sense at costs.',2,'2019-06-18','1970-01-01','2019-07-02','',''),(148,5,'MRP-III','production','Out of 6400 hr, for machine ,how much was used in April 2019','Out of 6400 hr, for machine ,how much was used in April 2019','working',4,'Vasu','','What was the final figure for April 2019? I shall close the task after I receive the value.',2,'2019-06-18','2019-06-21',NULL,NULL,''),(149,5,'MRP-III','development','All parts costing tracking Vs. customer cost','All parts costing tracking Vs. customer cost','working',4,'Vasu','','The task is not completed yet.',2,'2019-06-18','1970-01-01',NULL,NULL,''),(150,1,'MRP-I','development','MRP-I  to submit details required by chairman monthly basis','MRP-I  to submit details required by chairman monthly basis','close',6,'Jayaram singh','','I think the wrong file is attached to this task. Pls attach the correct file and update the task.',2,'2019-06-18','2019-06-21','2019-07-01','150-MD Mrp1MonthlyReviewTemplateMay19.xls',''),(151,1,'MRP-I','development','In - house rejection to include rework costs wherever applicable ( Monthly financial Review )','In - house rejection to include rework costs wherever applicable ( Monthly financial Review )','working',6,'Jayaram singh','Rework % is Recorded, Circulated.\r\nCost need to be Checked.','Good work. There is a lot of data. Request you summarise and present during the monthly financial review meeting.\r\n\r\nI will close the task when the details are presented during the next meeting.',2,'2019-06-24','2019-07-19',NULL,NULL,''),(152,1,'MRP-I','development','Stock boosting to be reduced month on month .plan to be submitted and monitored  actuals monthly','Stock boosting to be reduced month on month .plan to be submitted and monitored  actuals monthly','assigned',15,'GKK','','Noted the plan. I will close task after you present the plan and status against plan monthly during during our group financial review.',2,'2019-06-24','2019-07-19',NULL,NULL,''),(153,5,'MRP-III','development','YCS Spares requirement','YCS Spares requirement to be decide ,options ?','working',4,'Vasu','DUPLICATE TASK','Status of this?? I am reopening the task. Pls do not close the task if it is not completed. I will be forced to reopen it.',2,'2019-06-24','2019-07-09',NULL,NULL,''),(154,1,'MRP-I','development','WEBSITE - MRP','MRP Website to be completed','assigned',7,'Vikas','','Pls dont close the task if it is not completed. \r\n\r\nLet us review the web site and then you can close the task when the web site is launched.',2,'2019-06-24','2019-07-04',NULL,NULL,''),(155,6,'MRP-IV','finance','Excise pending payment to be cleared','Excise pending payment to be cleared','assigned',7,'Vikas','','Pls close the task when the payment has been made fully.',2,'2019-06-24','2019-07-31',NULL,NULL,''),(156,1,'MRP-I','production','Reputing process for FENDER and TANK','Plan for reputing process adhere all process for  FENDER and TANK','assigned',14,'palani','','I am reopening the task. \r\nJust giving me a inspection report does not close this task. I want a plan by which all aspects of the Fender and TANK will be adhered to in the process.\r\nThanks',2,'2019-06-24','2019-07-12',NULL,NULL,''),(157,4,'MRP-II','finance','Availability of free cash','Calculation of availability of free cash','close',9,'Ashok S','As per cash flow as on July and August 2019 are negative balances with maximum of 20 lacs shortfall.','I would like this to be monitored and reported on a monthly basis and I will close the task when I can see it reported during MRP II monthly reviews.',3,'2019-06-24','2019-07-19','2019-07-24','',''),(158,1,'MRP-I','finance','Budget','Budget for all the departments','working',6,'Jayaram singh','ALMOST FREEZED. TO PLAN, MONITOR. SCHEDULES STILL NOT SO CLEAR, SUDDEN DOWN FALL DURING PEAKS.','Has this task been completed??\r\nCan we include budget in PMS and evaluate against target monthly\r\n?',2,'2019-06-24','2019-06-29',NULL,NULL,''),(159,6,'MRP-IV','production','TAFE parts','look at TAFE parts to MRP VI','assigned',7,'Vikas','','I shall close the task after we achieve the target.',2,'2019-06-24','2019-08-31',NULL,NULL,''),(160,6,'MRP-IV','production','GVR Quality issue in power caoting','GVR Quality issue in power caoting','assigned',7,'Vikas','','',1,'2019-06-25','2019-06-30',NULL,NULL,''),(161,1,'MRP-I','development','Compensation for DBR transport amount to be obtained when import all in fully consumed ( Plant )  Ho','Compensation for DBR transport amount to be obtained when import all in fully consumed ( Plant 7 ) \r\nHow long it will expect to finish this task ?','working',6,'Jayaram singh','Same Task Repeated if I am Right or Understood Wrongly.','',1,'2019-06-25','2019-08-30',NULL,NULL,''),(162,1,'MRP-I','development','DBR transport ( Plant 7 ) cost that is reduced to be monitired on a monthly basis ans value used dur','DBR transport ( Plant 7 ) cost that is reduced to be monitored on a monthly basis ans value used during RM import price compensation. \r\n\r\nHow long it will expect to finish this task ?','validate',6,'Jayaram singh','Imported Material will get Consumed only Aug, to Claim for Imported Material. Accepted.\r\nDBR Transport needs to be Moniotred, Recorded, will be Compensated again Aug Only, Still not Started DBR Operations. This is the Cost Reduction Planned by them for New Packaging, which is Less, now getting More than That. Will be Compensated. Committed.\r\n\r\nNOW CLEARED PL.','',1,'2019-06-25','2019-06-30','2019-11-14','','Have we started monitoring the transportation and compensation for the RM import?'),(163,4,'MRP-II','development','Highway land staus','Highway land staus','validate',10,'Balasundaram E S','Sir, Fund not alloted to them, work also stagnated by the contractor. Will get updated by following with SDRO','We shall close the task after all the documents are submitted.',2,'2019-07-02','2019-07-15','2019-10-08','',''),(164,1,'MRP-I','development','Contribution loss for not meeting schedule along with person , reason to be incorporated','Contribution loss for not meeting schedule along with person , reason to be incorporated','working',6,'Jayaram singh','NOW SITUATION IMPROVED, WITH 1 DAYS STOCK ON HAND FINISHED GOODS.\r\nUNLESS CRISIS, SUDDED CHANGE NOT SO. SUDDEN CHANGE ONLY IN AL DUE TO CRISIS.','What is being circulated is the turnover loss. I am looking for the next step of calculating the contribution (Sales - Direct Costs) loss that is being caused because of non supply of items. Thanks',2,'2019-07-24','2019-07-31',NULL,NULL,''),(165,1,'MRP-I','development','Hire an additional person for toolroom','Hire an additional person for toolroom','validate',6,'Jayaram singh','Already Filled, and in Work. Observed, & he is Settling Fast.','I will close the task after the person is hired. \r\n\r\nPlease update the status. \r\n\r\nThanks',2,'2019-07-24','2019-07-29','2019-11-14','',''),(166,5,'MRP-III','development','Feb 2019 Ratios','MRP - III Upto Feb 2019 Ratios ,and projected FY 20 ratios.What needs to changed / improved to achive result mention target values','validate',9,'Ashok S','During the year loss has incurred due to return of textile materials and unabsorbed  depreciation.','Pls compare the projections with actuals.\r\nDiscuss with Vasu so he understands and agrees as well. I will close task after I see it regularly in the monthly meeting. THANKS',2,'2019-07-24','2019-07-30','2020-01-27','',''),(167,9,'UHE','development','GNEE steel can do pressure parts ,check with them','GNEE steel can do pressure parts ,check with them','assigned',12,'NIKHIL SUNIL','','',1,'2019-08-30','2019-09-30',NULL,NULL,''),(168,9,'UHE','production','TRUST read up','TRUST read up','assigned',12,'NIKHIL SUNIL','','',1,'2019-08-30','2019-09-06',NULL,NULL,''),(169,1,'MRP-I','production','Meeting with UH (plant 2,3,4,1) for ERP implementation','Meeting with UH (plant 2,3,4,1) for ERP implementation','validate',13,'MRK','Meeting with Unit Head Held on 09/09/2019 and concluded, ERP start from MRP-III  and  the Cost of ERP will share Equally by each unit.','',1,'2019-08-30','2019-09-06','2019-09-10','',''),(170,1,'MRP-I','finance','( Revenue - RM ) - Yearly for past 5 years (PLOT) - MRP I','( Revenue - RM ) - Yearly for past 5 years (PLOT) - MRP I','validate',9,'Ashok S','Pfa the Plant-1 Sales-RM','',1,'2019-08-30','2019-09-04','2019-09-08','170-P1-Sales-RM consumption.xlsx',''),(171,5,'MRP-III','finance','( Revenue - RM ) - Yearly for past 5 years (PLOT) - MRP III','( Revenue - RM ) - Yearly for past 5 years (PLOT) - MRP III','validate',9,'Ashok S','Pfa  Plant-3 Sales-RM','',1,'2019-08-30','2019-09-04','2019-09-08','171-P3-Sales-RM consumption.xlsx',''),(172,1,'MRP-I','development','Revenue data from the ERP system directly and not excel','Revenue data from the ERP system directly and not excel','working',6,'Jayaram singh','MR. SANTHOSH & MR. GK WORKING ON IT.\r\nFEW ACHIEVED, AND WILL BE CLEARED.','',1,'2019-08-30','2019-09-13',NULL,NULL,''),(173,1,'MRP-I','production','Analyze of the RM consumption for last 4 months for MRP 1 & 5','Analyze of the RM consumption for last 4 months for MRP 1 & 5','assigned',6,'Jayaram singh','','',1,'2019-08-30','2019-09-10',NULL,NULL,''),(174,1,'MRP-I','finance','New Bank limit take over','New Bank limit take over','validate',9,'Ashok S','The new proposal with Hdfc is in the stage of review by regional office,\r\nreview at cbe office is completed. In regional office their decision is delayed\r\ndue to down trend in automobile industry they are delaying the sanction.\r\n\r\nSenthil has told the reason and we had spoken to Mr.Palanisamy (Officer Credit limits)\r\nin cbe office and explained to him the customer base at MRP and we are supplying to TAFE,\r\nAL and RE. No car company is being supplied and explained to him the past history\r\nof repayment. He was little concerned about current year repayment due to continued\r\nlosses and we have told there will not be operational losses and we will be infusing funds on sale land.\r\nHence,we requested to consider and he is convinced and if necessary we told we can give\r\na letter regarding the subject.\r\n\r\nSenthil is closely following with bank.He is also arranging with two more alternate banks for the\r\nproposal. He will again update by tuesday or wednesday.','',1,'2019-08-30','2019-09-30','2019-09-05','',''),(175,1,'MRP-I','development','Reduction in In - house rejection - Action plan','Reduction in In - house rejection - Action plan','assigned',6,'Jayaram singh','','',1,'2019-08-30','2019-09-15',NULL,NULL,''),(176,4,'MRP-II','finance','Cash flow crunch','Cash flow crunch','validate',5,'Rajasukumar','04-10-2019\r\nTemporary enhancement of Rs.10.0 lakhs was obtained to pay for the duty and the immediate requirements.\r\nOFMK payment is expected at any time.\r\n\r\n09-10-2019\r\nOFMK payment is delayed. Hope to receive the payment by end of this week (12-10-2019)\r\n\r\n11-11-2019.\r\nInterim assistance of Rs.80.0 lakhs has been sought from the Management. As first installment Rs. 40.00 lakhs received. The balance will be received by 3/4th week of November 2019.\r\nBy the time the customer payments will be received and the same will be rotated in the cash flow.. As per the cash flow statement, by January \'20 funds should be available in surpluss.','',1,'2019-08-30','2019-09-06','2019-11-11','',''),(177,4,'MRP-II','finance','C form letter for OFMK','C form letter for OFMK','working',5,'Rajasukumar','04-10-2019\r\nFollow up continues with OFMK officers. So far no one has given any useful data. The matter has been referred to Ordnance Board for response and the same is awaited.\r\n\r\n11-11-2019\r\n\"C\" form follow up is continuing. So far there has been no positive reponse from OFMK.\r\n\r\n21-11-2019.\r\n1. Reviewed the situation with Mr. Ravi Singh on Thursday the 21st Nov 2019.. He suggested having a personal meeting to meet the senior-level people for concluding this issue.\r\n\r\n04-02-2020\r\nOFMK is still waiting for a response from Ordnance Factory Board in this regard. According to Mr. Ravi Singh, Jt.GM, a personal messenger has been sent to the board to obtain a response. This should be known in next few days. It will be again followed up on 10th Feb 2020.','',1,'2019-08-30','2019-09-06',NULL,NULL,''),(178,5,'MRP-III','production','Tracking of customers satisfaction for textiles - monthly','Tracking of customers satisfaction for textiles - monthly','working',4,'Vasu','AT present there is no business in textile not able to tracking customer satisfaction monthly. But we are having regular contact with our existing customer and extending service support wherever necessary.\r\nup dated on 02.02.2020','',1,'2019-08-30','2019-09-15',NULL,NULL,''),(179,5,'MRP-III','finance','Payment for lucky mills','Payment for lucky mills','working',4,'Vasu','Installation work completed and balance material took back from Lucky. Regarding closing of commercial activity Mr.Padmakumar is discussing with the Mill. Hope fully it can be closed by the end of this month. Up dated on 04.11.19. As per the information from Padmakumar Lucky MD is back from outstation and we will get firm commitment for the payment by this week end. updated on 03.02.2020','',1,'2019-08-30','2019-09-15',NULL,NULL,''),(180,5,'MRP-III','development','Lucky mill - 50% will be taken back,Net profit/loss','Lucky mill - 50% will be taken back,Net profit /  loss','working',4,'Vasu','work is under progress. can be presented during the next meeting.\r\n\r\nup dated on 05.11.19 Presented to MD . Can be closed after getting the commitment for payment..  up dated on 03.02.2020','',1,'2019-08-30','2019-09-15',NULL,NULL,''),(181,5,'MRP-III','development','stores getting it in order','stores getting it in order','working',4,'Vasu','Vendor stock & Record verified and found. Internal auditor certified\r\nBought out items and consumables stocked customer wise with name Tag.\r\nNon Moving Items moved out.\r\nMaterial stored in the stock room is getting segregated by the production team .. can be completed on or before 15.02.2020','',1,'2019-08-30','2019-09-30',NULL,NULL,''),(182,5,'MRP-III','production','8 lakhs cash flow deficit in operations - solution','8 lakhs cash flow deficit in operations - solution','working',4,'Vasu','As per the current operation generating Rs. 8 lakhs is difficult. The refund of customs duty (around Rs,6 lakhs) can be used for this purpose','',1,'2019-08-30','2019-09-06',NULL,NULL,''),(183,5,'MRP-III','development','KONE CMM investment , Net result / Benfit for the project','KONE CMM investment , Net result / Benfit for the project.','working',4,'Vasu','Detailed report forwarded to MD for verification','',1,'2019-08-30','2019-09-06',NULL,NULL,''),(184,5,'MRP-III','production','Tex orders booking,result of the mktg / analysis in 2 months','Tex orders booking,result of the mktg / analysis in 2 months','working',4,'Vasu','Due to  negative marketing existing Agents are not working as required\r\nLocated a new party to support us in marketing activity. Discussion is under progress','',1,'2019-08-30','2019-10-30',NULL,NULL,'');
/*!40000 ALTER TABLE `tbl_task` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-02-21 16:00:01
