Hi there I am trying to calculate our On Time Delivery. I want this as a simple percentage of jobs. I have got this running in the following way: Column M - Estimated Delivery dates Column N - Actual Delivery dates Column O - =IF(SUM(M2-N2)>0,1,0) Then I have calculated On Time Delivery as: =SUM((SUM(O2:O252))/(COUNTA(N2:N252))) This seems to work fine. My problem is, if we enter a date in Estimated without a corresponding Actual date, the formula for Column O fills out anyway and improves our On Time Delivery Percentage. How can I set this up so that the formula doesn't calculate if there is no data in Column N? Any help much appreciated Thanks, James. I am trying to figure out how to write a formula to figure out production cycle time.
Production Planning and Scheduling using Excel spreadsheets. Download free production planning tools & templates for planning and scheduling systems. There are production scheduling tools as well to design even more advanced production scheduling templates. Event production schedule templates are very much needed.
We will be building 8 'widgets' a day. We will work 10 hours a day.
There is a 20 minute break at 9:20 am. Production shuts down for lunch 30 minutes for lunch at 12:30. Edirol Virtual Sound Canvas Vst 4 more. Production starts at 6:00 am. Here is what I can do.
Production cycle time = (10*60)-30/8 or 71.25 minutes If we start at 6:00 am, the first scheduled cycle completion time =TIME(6,0,0+) My problem is when I am trying to use a logical 'IF' statement to account for the 20 minute break or lunch and still calculate the end of each cycle time through the day I receive a number of error messages. This is the formula I am trying to make work. I have the cell the formula is in, formatted with a 'mm,ss' format. =(IF(D4+G1/1440>9:20,(D4+G1)/24,(D4+G1+15)/1440)) I have included an attachment to help (a picture is worth a thousand words). Any help will be greatly appreciated. I have bought a number of books in an attempt to figure this out, and I am still stumped.