I need help getting the gross profit

A newly formed firm must decide on a plant location. There are two alternatives under consideration: locate near the major raw materials or locate near the major customers. Locating near the raw materials will result in lower fixed and variable costs compared to locating near the market, but the owners believe there would be a loss in sales volume because customers tend to favor local suppliers. Revenue per unit will be $176 in either case Cliak here for the Excel Data File Using the above information, determine which location would produce the greater profit