based on - (Ellet, W. (2007). The case study handbook: How to read, discuss, and write persuasively about cases. Boston, MA: Harvard Business Publishing. Sharma, J. R. (2012). Location planning at A.B. Corp. Ivey Publishing). ,,,,,

write and do the following -

1. Compute the best possible central location for the warehouse using the center of gravity method.
2. Calculate the load distance factor for the different CWH options using the formulae below.
3. Convert the load distance values to be used as scores in the factor rating method.
4. Compute the factor scores and final values of various warehouses and suggest the best option.
5. What other qualitative factors should be taken into consideration by A.B. Corp. before they decide on the best CWH location? Explain.

Calculations not in excel PLZZ

show full steps