You can use the formula provided below to calculate the sensitivity analysis and its percentage. Sensitivity analysis external purchase cost formula is defined as (S) = (E -(B + C)) - (D - A) and its percentage is given as (S / C) x 100. It is calculated based on the ultimate selling price for in-house products, cost of making in house products, ultimate selling price for buy in Re-Badge Product, external purchase cost and cost of buy in Re-Badge Product.
Sensitivity analysis external purchase cost formula is given for both to find sensitivity analysis and its percentage. First step is to add Cost of Buy in Re-Badge Product and its External purchase Cost. Second step is to subtract making cost from Ultimate Selling Price for making in house products. Subtract the first step from ultimate Selling Price for Buy in Re-Badge Product and subtract the resultant value from second step. Similarly to find the sensitivity analysis percentage, divide the Sensitivity Analysis resultant value from the External purchase Cost For Buy in Re-Badge Product. Then multiply the resultant value with 100. You can use the procedures mentioned to find the sensitivity analysis and its percentage value manually.