q4 solve using lingo only( not excel solver) or send me constraints and ill do it myself. thank you so much.

4. (25 marks) There are eight communities located along the Trans-Canada Highway, with community 1 being the most westerly, and community 8 being the most easterly. Currently, none of the eight communities has a fast-food restaurant. A fast-food restaurant chain is considering opening up to four restaurants in the eight communities (no more than one restaurant per community). They believe that they will capture 30% of the market in those communities in which a restaurant is constructed. Furthermore, they believe that they will capture 15% of the market in any community which does not have its own restaurant but which is contiguous to a community (on either or both sides) which does have a restaurant. Each restaurant would have an annual overhead cost of $200,000. Each customer would give an annual contribution to profit of $50. The population of each community is: R= number of restaurants built. N1 = population (in thousands) of communities with a restaurant. N2 = population (in thousands) of communities without a restaurant of their own but which are contiguous to a community which does have a restaurant. Yi={10arestaurantisbuiltincommunityiotherwise}i=1,,8 Zi=100arestaurantisnotbuiltincommunityi,butarestaurantisbuiltinacontiguouscommunityotherwisei=1,,8 (a) Using the variables as defined above, write the objective function and the constraints for this problem in LINGO or Excel. (For this question only, this file does not have to have the variables written out). (b) Solve the model using LINGO or the Excel Solver. (c) State the solution in words