Showing posts with label NamCalc. Show all posts
Showing posts with label NamCalc. Show all posts

Thursday, 28 November 2019

Delay of a price increase - Cost & Value?

(Holding back a trade price increase for Asda, the cost and value for supplier and retailer)

You need a price increase to cover rising costs but have agreed with Asda to maintain current prices for 1.5 months following the new price introduction.

What is the cost to you and the value to Asda in terms of incremental sales?

Assumptions:

Annual sales to Asda = £660k
Your Gross Margin = 43.6%
Costs rise = 8%

You have agreed an 8% price increase to restore your % Gross Margin

You have negotiated a 1.5 month delay in implementing the price increase for Asda.

What is the cost to you and the value to Asda of the delay?

NamCalc Tool 13 below, demonstrates that an 8% price rise is required to restore your % Gross Margin.

It also shows that the 1.5 month delay costs you £3,720, and you would need incremental sales of £8,525 to recover your lost gross margin.

For Asda, with a pre-tax Net Margin of 2.1%, the £3,720 is equivalent to incremental sales of £177,142, a point worth making in negotiation…?


Click to enlarge

Tuesday, 26 November 2019

Settlement Discounts: How much to pay for earlier payment in unprecedented times...?

Given the current casualty rate in retail, getting your money in faster can help.

The issue then becomes: How much to pay the customer i.e. what discount off invoice will make earlier payment attractive to the retailer?

The following screen-pull from NamCalc illustrates the calculation for a 15-day reduction in payment period. 

[The exercise proves that a 0.5% discount is equivalent to a return of 12% on the money for the retailer. We also add in the incremental sales required by supplier and retailer to recover the settlement discount amount]



Just one of the 33 calculator-tools for NAMs available in NamCalc

Monday, 25 November 2019

When a customer goes bust...

Given these unprecedented times, some customers will not succeed...

Supplier NAMs that can anticipate the inevitable, can avoid the fall-out..

One way of increasing your team's sensitivity to the signals is to calculate the cost of profit recovery following liquidation. i.e. the extra sales you need to recover lost profit.

Suppose a customer goes bust owing you £240k, and your Net Profit Before Tax is 3.4%, then via NamCalc below, you will need incremental sales of £7,058,823 to recover your lost profit!

Or would prefer to await a call from the liquidator?



Monday, 11 November 2019

Use of GMROII to demonstrate your value to Tesco

Gross Margin Return On Inventory Investment is probably one of the most valuable, yet underutilised tools in the NAM kit-bag today.

It follows that those that take the (small amount) of time to practice its use, automatically gain a competitive advantage over the competition, invaluable in these unprecedented times.

Essentially, GMROII is valuable because it links your product's Gross Margin for the Retailer, with the retailer’s stockturn of your product, instead of simply focusing on the Gross Margin.

For example, suppose the retailer sells £750k of your product per annum, enjoys a Gross Margin of 35%, and holds an average of 7 days stock of the product.

NamCalc (below) shows that the retailer is making a GMROII of 2,807% on the product. (any queries re the calculation, please let me know on bmoore@namnews.com).

Suppose the retailer is Tesco

Tesco’s latest Sales are £56.9bn, its internal Gross Margin is approx 21%, and it holds an average of 22 days stock i.e. £2.6bn in stock at any time.

Tesco’s GMROII on its total business is therefore 460%

[£56.9 x 0.21/2.6 x 100 = 460%]

Therefore your product’s GMROII of 2,807% is a significant contributor to Tesco’s business.

See details on the NamCalc screen-pull below. Each of the 32 calculator tools also has editorial detail explaining key uses/interpretations of the tool, as per the second screen-pull below.

More details here