Need help with Part B. Please show in Excel.

7.19. Aberdeen Computer Corp. (ACC) is located in Aberdeen, the retail channel. In particular, five different retailers currently Washington. The company has developed Jeeves, a voice-activated sell Jeeves-Sears, Best Buy, Fry's, Walmart, and Office Depot. Internet assistant for the home. This product is manufactured at ACC makes weekly shipments to the main warehouses of these four plants, located in Atlanta, Kansas City, Aberdeen, and Aus- five retailers. The shipping cost from each plant to each waretin. After production, the units are shipped to three warehouses, house, along with the production cost and weekly production located in Nashville, San Jose, and Houston. ACC sells through capacity at each plant, are given in the table below. a. Formulate and solve a linear programming model b. Now suppose that ACC is considering saving money in a spreadsheet to determine the plan for weekly by closing some of its production facilities and/or production and distribution of Jeeves from the vari warehouses. Suppose there is a fixed cost to operate ous plants, through the warehouses, to the customeach plant and each warehouse as indicated in the following tables. Add binary variables to your model ers that will minimize total costs