retail management- range plan

Please refer to this excel file.