Margin recovery

[Caly]

Hi I have items that have sales and margin dollar information year over year for 12 months. The data shows either higher sales with lower margins compared to last year or lower sales and also lower margins compared to last year. Of those items, the price changed but how can I show the margin recovery? Is below accurate?

Would margin dollar recovery be the new price times qty Minus cost times qty as shown in last column below?

A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Product	Sales last year	Sales this year	Sales change	Qty last year	Qty this year	Sales margin last year	Sales margin this year	Sales margin change	Cost	Current price	Current margin	Current ext cost … cost multiples by qty	New price	New margin	Ext sales change recovery (new price times qty minus current price times qty)	Margin dollar recovery (new price times qty minus cost times qty)
2	Apple	25,000	55,000	30,000	17	36	3,000	-1,400	-4,400	1,700	1,500	-13.33%	61,200	1900	10.53%	13,400	7,200
3	Pear	6,000	1,000	-5,000	18	4	3,000	700	-2,300	144	300	52%	576	341	57.77%	364	788