The fields with the red border are required.
              Base Disc. Total Proposed Discounts:  
    Purchases Total Disc%>
    Purchases 100.00%
    Paint Mfg. Net Liq.purch>
    Allied Net Allied purch>
    Total Net (of Discounts) Purchases
    Net Total purch>
    Paint Mfg. Percent of Total Discount >
    Mfg. Split of disc. above base%
      Contact us for More Information.       Net Jobber Share ofTotal  Discount >  
    What if purcahses are:
    Net disc to Shop
    Net Purch to Shop
    Calc Verified
    Disc from Jobber
    Disc from Piant Mfg
    Net Disc
    Calc Verified
      Enter Liquid (Paint Mfg.) assumed percentage of purchases (initial 70%)        
      Enter Desired Purchase amount (initial $12,500)          
      Enter any percentage(s) totals discount.            
      Sheet will calculate Paint Mfg. portion(50%) of discount (above base percentage set at 15%)    
      Sheet Will Calculate Jobbers Net Discount % after Paint Mfg. contribution.        
      Enter Portion if Discount % that Paint Mfg. will contribute to pnt.mfg purchases above base discount%  
    Copyright © 2013 J.Hunter & Associates. All Rights Reserved.