Hii, I am expert in MIS as currently daily and monthly i have to make the MIS for office. Please refer the below data made by me. its looking similar what you have given in excel file. i can do this in very projective way.
WARRANTY SUPPLY WARRANTY RETURN
BOUGH OUT MANUFACTURING TRADED Grand Total BOUGHTOUT SPARES MANUFACTURING SPARES TRADED Total Return
BRANCH A CLASS C CLASS A CLASS C CLASS A CLASS C CLASS A CLASS C CLASS
AHM 1,50,746 28,546 57,563 3,857 60,745 3,01,458 0
BAN 1,25,666 28,204 26,482 629 7,678 1,88,659 -
BHU 4,237 1,262 5,498 -
CHA 36,711 7,024 12,081 235 56,051 -
CHE 93,003 17,869 364 1,11,236 -
COC 90,076 90,076 -
DEL 8,834 11,756 70,343 1,899 92,833 643818 6,43,818
HYD 1,47,058 11,398 140 41,593 2,00,188 -
IND 26,833 14,438 29,500 1,008 71,779 -
JAI 35,848 7,256 16,431 59,535 -
KOL 47,739 7,984 8,572 54 64,350 38,513 38,513
LUC 25,802 3,658 29,459 -
MUM 2,68,667 59,725 10,070 1,037 19,072 3,58,571 -
PUN 12,411 19,898 93,260 2,182 53,630 1,81,381 -
VIS 1,615 1,615
Grand Total 10,69,395 2,23,607 3,07,871 11,295 2,00,522 18,12,690 6,82,331 - - - - 6,82,331