Renegade Consulting, Inc. - Solution - Collaborative Tooling Cost Reduction (CTCR) (Fixtures/Gauges)

Home |

Solution - Collaborative Tooling Cost Reduction (CTCR) (Fixtures/Gauges)

Solutions Page
Solutions List – Condensed
Solutions List – Detailed

End Client:	DaimlerChrysler
Project:	Collaborative Tooling Cost Reduction (CTCR) (Fixtures/Gauges)
Technologies:	Microsoft Access, Microsoft Excel, Microsoft PowerPoint, PDF, SQL (Structured Query Language)
Description:	Renegade staff designed, programmed, and managed all the data involved with a Fixtures and Gauges tooling survey initiative. Data collected, via a Microsoft Excel form, was uploaded into an Access database, organized, and exported to a data model. From the data model, the end client could determine "should" tooling costs for similar parts. Armed with this information, the end client was better informed and could negotiate for lower tooling costs on new parts similar to those in the survey. Applications written to accomplish the goals of this initiative included: Automated email programs Unique request for proposal (RFP) generation based on the parts provided by each individual supplier RFP upload, from Excel templates, and reporting database/tools Supplier feedback and other report exports to Excel, PDF, and Microsoft PowerPoint formats