Please include defining decision variables, formulatiny objective function $($including min or max$),$ formulating constraints $($correct number of constraints, correct formulation in each contraint$),$ solving the model using excel solver. Include all of these in the excel spreadsheet and attach screenshot of excel spreadsheet indluding all steps please!

Chapter $11$ Supply Chain Management

$($Heizer and Render,

Operations Management, Eleventh Edition$)$

Formulate a linear programming model for this make$-$or$-$buy application $(100$ points$).$ Use Excel Solver to solve the model $(10$ bonus points$),$ which is optional.

Frandec Company manufactures, assembles, and rebuilds material handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and three metal straps. Frandec's production schedule calls for $2,000$ Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown.

$\backslash$table$[[$Component$,$Manufacturing Cost,Purchase Cost$],[$Frame$,$$$38\mathrm{.}00,$$$51\mathrm{.}00$