Mark Lewis
21st November 2013, 10:02 AM
Hi Injection Molding online forum.
I have just joined this forum after trying for many weeks to complete a excel spreadsheet for calculating RFQ. Let me explain a little about myself first of all. Originally I am from a Quality and Production background , I have been in the plastics industry now for over 15 years. But recently due to Staff and responsibility changes , I have had to start completing RFQ for new and present customers. I have completed many formulations on excel to assist me, but after checking the calculations I end up with an incorrect selling price. I have included all the necessary points:
Tool size
Tool type
Number of cavities
Cycle time
Material cost ( masterbatch & colour % )
Weight of part
Weight of sprue
Scrap %
Profit margins.
Infact I feel I have covered everything that is needed to complete the RFQ. But I am not confident in the end figure, Also I feel that the actual "SZUM" / formulation" on the spreadsheet is not correct.
My question is
Does anyone have a standard format , that I could use to check against my Excel spreadsheet. As basically I have no references myself, to check against the "new format" so I am unable to know if I am in the right direction or the wrong direction.
I would be grateful for any feedback , as for weeks on end ( if not now 2 months) I have been trying to complete a spreadsheet/ formulation but I am rather in the dark so far,
Regards
Mark
I have just joined this forum after trying for many weeks to complete a excel spreadsheet for calculating RFQ. Let me explain a little about myself first of all. Originally I am from a Quality and Production background , I have been in the plastics industry now for over 15 years. But recently due to Staff and responsibility changes , I have had to start completing RFQ for new and present customers. I have completed many formulations on excel to assist me, but after checking the calculations I end up with an incorrect selling price. I have included all the necessary points:
Tool size
Tool type
Number of cavities
Cycle time
Material cost ( masterbatch & colour % )
Weight of part
Weight of sprue
Scrap %
Profit margins.
Infact I feel I have covered everything that is needed to complete the RFQ. But I am not confident in the end figure, Also I feel that the actual "SZUM" / formulation" on the spreadsheet is not correct.
My question is
Does anyone have a standard format , that I could use to check against my Excel spreadsheet. As basically I have no references myself, to check against the "new format" so I am unable to know if I am in the right direction or the wrong direction.
I would be grateful for any feedback , as for weeks on end ( if not now 2 months) I have been trying to complete a spreadsheet/ formulation but I am rather in the dark so far,
Regards
Mark