Please use excel and solver to solve: The Dayton Electronic Manufacturing, Inc $($DEMI$)$ company manufactures two styles of remote keyless entry systems $($the X$30$ and the X$40)$ that various auto dealers supply to customers when a new $($or used$)$ automobile is purchased. DEMI currently operates four production facilities located in Springfield OH $,$ Hartford, New Orleans, and Orlando. The manufactured items are shipped from the plants to regional distribution centers located in Trenton, Chicago and Seattle. It is from these regional locations that the product is distributed nationwide. As more automobile manufactures include keyless entry as a standard option, and DEMI finds itself locked out of the manufacturer market, demand for DEMI's products have decreased. As a result, management is contemplating closing one or more of its production facilities. Distribution facilities are not currently being considered for closing. Each production facility carries a fixed operating cost and a variable cost associated with building each of the products. Data has been compiled on production costs, resource availability, and resource usage at each of the production plants. That information is summarized in the table below. Fixed Cost per Month Production Cost $($Per X$30$ Production Cost $($Per X$40$ Production time $($hr$/100)$ X$30$ Production time $($hr$/100)$ X$40$ Available hr Per Month New Orleans The entry systems are sold nation wide at thes ame prices: $$24$ for the X$30$ and $$30$ for the X$40.$ Current monthly demand projections at each distribution center for both products are given in the following table. The transportation costs between each plant and each distribution center, which are the same for either product, are shown in the following table: Determine which of the plants to close and which to keep Determine the number of X$30$ and X$40$ to be produced at each Determine a shipping pattern from the plants to the distribution Maximize the net total monthly profits. Do not exceed the production capacities at any plant. Formulate DEMI's problem as a fixed charge, linear$/$integer program $($MIP$).$ Implement your model in Excel and solve the model to answer DEMI's questions.