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.