Please answer ALL questions and include ALL workings + Excel workings where necessary. Thank you.

a. A manufacturing company preparing to bulld a new plant is considering three potential locations for it. The fixed and variable costs for the three alternative locations are presented in the table below. 1. Indicate over what range, each of the alternatives A,B,C is the low-cost choice. 110 marks] b. A larger and more modern post office is to be constructed at a new location in Solly Soring Georgia. Growing suburbs caused a shift in the population density from where it was 30 years ago when the current faclity was built. Andy Browne, the postmaster asked his assatants to draw a grid map of the seven points where mail is picked up and delvered in bulk. The cooedinates and trips per day to and from the seven mail source points and the current main post office are shown in the table halnu 1. Cakulate the centre of gravity as a possible location for the new ficility. [10 marks] c. A chothing chain is cortidering two diflerent locations foe a new metell eullet The arganiration has identifiod the four factons listed in the following table as the bacis for evaluation and it has assigned weights as stown. The managre has rated each locution on eadh tactore ce a 100 -point basib (higher soores are better) as shawal under the rmpective columns for Blanclay and Clobler