Port Based Support Program
If users use Item Categories to track things like phone sets, station ports and trunk ports, reference these item category totals in the support pricing calculations by using SUMIF calculations.
Formula:
=SUMIF(Item,”StationPorts”,ItemTotal)*$10
would calculate support pricing by taking the total number of station ports and multiplying them by $10.
Total Price-Based Support Program
Support pricing under this approach can be calculated by referencing the TotalListPrice or TotalSellPrice range names within formulas.
Formula:
=TotalListPrice*10%
would calculate support pricing at 10% of the total list price.
Total Equipment Price-Based Support Program
Support pricing is calculated by referencing the EquipMSRP or EquipSell range names within formulas.
Formula:
=EquipMSRP*15%
would calculate support pricing at 15% of the total list price for equipment.
Component-Based Support Program
Under the Component-Based approach, set up support part numbers for each type of item that to be supported, along with associated support pricing.
Create a SVC-PHONE part number with an associated support pricing of $0.50 per month.