Improvement Opportunity Calculator 2.jpg

 

Return to Webpage

                   
                 
      Improvement Opportunity Calculator      
    Indicator Current State Inputs Definitions    
    Annual Revenue ($)        
    Direct Materials ($)      
    Cost of Goods Manufactured          
    Beginning - Ending Inventory($)          
    Average Inventory ($)          
    Utilities ($)          
    Outside Services          
    Scrap and rework ($)          
    Premium Freight ($)          
    Average Receivables ($)          
    On-Time Deliveries %          
    Machine Hours Avail per year          
    Machine Hrs Running per year          
    Schedule Bumping %          
    Annual Employee Turnover %          
    Average Work week in Hours          
    # of Hourly Employees          
    # of Salary Employees          
    Average Hourly Pay ($)          
                 
         
   
    Calculated Metrics   brown = outputs, calculated cells    
    Labor and Overhead      
    Gross Profit and Gross Margin %    
    Inventory Turns      
    Value-Added      
    Scrap and rework      
    Days receivables      
    Available Hrs % Year      
    Run Hours % Available      
    Total hours per week for Hourly Employees      
    Hours for Salary Employees      
    FTE Total Hrs (H&S)    
    Value Added per FTE    
         
       
       
       
       
       
    Key Performance Indicator Current State Improved Future State Annual Benefit One Time Conversion To Cash    
    Days Receivables (Days)    
    Employee Turnover %      
    Inventory Turns    
    Machine Uptime Hrs Avail(%) 0.00%      
    On-Time Delivery (%) 0.00%      
    Premium Freight ($)      
    Schedule Bumping %      
    Scrap and Rework (%)      
    Utilities ($)      
      Summed Benefits      
                 
                 
      Current State   Future State      
    Income Statement      
    Annual Revenue Note: this model assumes no change in Annual Revenue. Reset the model and run again with new Annual Revenue estimates for what-if scenarios.      
    Cost of Goods Manufactured Annual Benefit    
    Operating Margin    
    Operating Margin %    
    Balance Sheet     One-Time Benefit    
    Average Inventory    
    Receivables    
          Sum of one-time benefit      
               
                 
    For your records when printing     Need Help or wish to improve this tool Please Contact me:      
    Input by:   Joe Boyle      
    Company:   JBoyle Engineering      
    For Business Unit:   (906) 228 - 8085      
    Time Period:   joeboyle@jboyleengineering.com    
    Date/Rev:          
    Scenario:          
     
   
   
     
         

Return to Webpage