CMM JUSTIFICATION WORKSHEET

This worksheet is provided as a guide only. No responsibility for accuracy is implied or will be accepted. No information  is; or can be; retained by using this worksheet.
If you prefer to use an Excel spreadsheet please click email to request a copy.

Please enter your Monthly Hours, Costs, Parts, Values, in the corresponding boxes.
Use your right mouse button and click refresh to start-over. Browser back button to exit. Browser print to copy.

REDUCED INSPECTION TIME
	X		X		=		X	.25	0
Hours to Inspect an average part		£.00 Internal Labour Rate per Hour		Parts per Month		£ Cost to Inspect Parts		Est. 25% Increased Efficiency per Month	£ Labour Savings with CMM Per Month
	X		X		=	0	X	1	0
Hours to Generate Inspection Report		£.00 Internal Labour Rate per Hour		Parts per Month		£ Cost to Generate Reports		100% Efficiency - Reports are Automated	£ Labour Savings with CMM Per Month
REDUCED PRODUCTION MACHINE DOWNTIME
	X		X		=	0	X	.25	0
Machines Hours downtime  waiting part inspection		£.00 Internal Labour Rate per Hour		Parts per Month		£ Cost of Idle Labour per Month		25% Est. Reduction in Idle Labour per Month	£ Labour Savings with CMM Per Month
		X						.25	0
Monthly Cost of Lost Production (due to machine downtime)								25% Est. Reduction in Lost Production Costs per Months	£ Labour Savings with CMM Per Month
REDUCED SCRAP & REWORK
		X						.05	0
Monthly cost of scrap (Improved inspection reduces costs)								5% Est. Reduction in Scrap rate	£ Savings by Reducing Scrap with CMM
		X						.20	0
Monthly cost of  Rework (improved inspection reduces Rework)								20% Est. Reduction in Rework rate	£ Savings by Reducing Rework with CMM
£ Total Savings Per Month									0
Payback in Months  =	Cost of CMM Total Savings per month							0	0
						Cost of CMM		Total Savings Per Month	Months to payback