please use excel

Problem 1: Mudsock Shopping Complex Assignment Model - Binary The town of Mudsock has seen tremendous growth in both population and prosperity following the COVID quarantine. People have flocked to the unassuming suburb to avoid the high cost of living and other issues in the "big city", traditional residents have swarmed to public areas and gatherings, and the town has a reputation as a good mix of progressiveness and silliness. The Mudsock council recently agreed to renovate a large shopping complex to better meet the needs of the community, and hopefully increase local revenue. The town planner, Ty Phipps, hired FET1, a local development company, to help plan and construct the complex. FET1 has extensive experience in developing community master plans and the Mudsock council asked the firm to identify the right stores and mix of services for the complex. Reynalda Morgan, president of FET1, is tasked with assisting Ty in deciding which stores to locate in the 32,000 available square feet of the complex. Reynalda and Ty are confident that there is sufficient market interest to quickly fill the shopping center with whatever allocation plan they select. Reynalda has developed a list of 20 stores for consideration. The table below lists the stores in alphabetical order and provides required floor space, annual sales, and renovation costs for each store. The leasing agreement, developed by FET1, requires each store to pay Mudsock the annual rent for the allotted space. Mudsock council mandates that the total rent payments each year must be sufficient to cover the annual fixed cost of maintenance of the complex. The cost, which includes security, janitorial services, maintenance, and utilities, is estimated to be $500,000 annually. The Mudsock council also specifies that the total renovation costs cannot exceed 60% of the total annual rent to be collected. FET1 proposes that Mudsock also receive a fixed percentage of total annual sales generated by the stores. FET1 has found that a proper mix of stores will make the shopping complex attractive to a broad range of customers. Juniper Xu, the marketing coordinator for FET1, recommends that the complex include at least two units each for apparel, food, and specialty stores, and at least one unit each of housewares and service stores. Juniper also recommends no more than three stores of any one type and that the total number of restaurants and service stores should not exceed the total number of units of the other three types of stores. Mudsock has tasked your group to identify the proper mixture of the stores that will maximize the total annual sales of the stores.Area Needed Renovation Costs Store Store Type (sq ft) Annual Rent Annual Sales Arcade Service 6000 $ 70,000 $ 1,250,000 40,000 Bath & Body Products 2000 35,000 $ 650,000 40,000 Specialty Children's Clothing Apparel 4800 $ 70,000 $ 1,750,000 $ 35,000 Chinese Fast Food Food 2400 40,000 $ 800,000 $ 27,000 Electronics Store Specialty 6400 $ 80,000 $ 1,300,000 $ 75,000 Hair Salon Service 3000 $ 50,000 500,000 35,000 Hardware Store Housewares 7200 $ 95,000 1,200,000 55,000 Hobby Store Specialty 3600 $ 50,000 550,000 $ 29,000 Ice Cream Store Food 1600 30,000 $ 500,000 20,000 Kitchen Store Housewares 3400 $ 80,000 900,000 $ 42,000 Lingerie Store Apparel 3600 $ 55,000 $ 1,250,000 $ 30,000 Luggage Store Housewares 4000 $ 70,000 $ 650,000 34,000 Men's Clothing Apparel 7000 $ 100,000 $ 2,000,000 40,000 Pizza Retaurant Food 4800 $ 62,000 $ 1,200,000 31,000 Shoe Store Apparel 4800 $ 60,000 $ 1,400,000 $ 40,000 Sports Bar Food 4000 $ 80,000 $ 1,300,000 $ 50,000 Tex-Mex Fast Food Food 2400 35,000 $ 1 100,000 $ 35,000 Toy Store Specialty 4800 $ 70,000 1,000,000 $ 50,000 Travel Agency Service 2000 $ 30,000 $ 400,000 $ 15,000 Women's Clothing Apparel 7000 $ 120,000 $ 2,250,000 $ 65,000A B C D E F G H Mudsock Shopping Complex N Decision Decision w Variable 1 Variable 2 A X2 5 Optimal Solution 6 Objective Function 7 Contraints LHS RHS 8 Constraint 1 9 Constraint 2 10 11 12 13 14