$7.$ Linear Program. Make vs$.$ Buy as an LP$.$ The Electro$-$Poly Corporation manufactures slip rings. A slip ring is an electrical coupling device that allows electrical current to pass through a spinning or rotating connection such as a gun turret on a ship, aircraft or tank$.$ The company makes three different models of slip rings. However, there have been times when an order has exceeded the company$$s ability to produce a volume of slip rings by a given delivery date. To address this, the company has developed a subcontracting relationship with a $$sister company$$ located in Canada whereby it can buy slip rings at a given discounted price to then sell to its customers. As a result, it can, at times, be advantageous to buy slip rings as well as manufacture them.

The make vs$.$ buy costs and total demand are given in the tables in your Final$\_$Project.xlsx worksheet $(7.$ Linear Program$).$ Construct an LP and use Solver to determine how many of each slip ring model to make and$/$or buy to meet demand. What are the total costs incurred? $($fill in table below$).$

$($Operations Management Class$)$