Pleasanton Manufacturing assembles some equipment used in Amazon distribution centers. One product is called Master. The assembly of the Master is made up of four components: a frame, a motor, two supports, and a metal strap. The motors are purchased from an outside vendor, but the frames, supports, and straps may be made by the company or purchased from an outside supplier. The production of the Runningmaster calls for at least 5,000 to be made next month. The manufacturing and purchase costs per unit are as shown: Component Cost of Manufacturing Cost of Purchasing Frame $39 $55 Support $13.5 $15 Strap $6.8 $7.9 Multiple departments at Livermore Manufacturing are involved in the production process of the components. The time (in minutes per unit) necessary to process in each department and the available (in hourl) for these departments are as follow: Component Frame Department Cutting Milling Shaping 3.1 2.5 3.1 Support 1.5 1.8 2.5 Strap .8 1.9 Capacity (hours) 360 435 685 are as follow: Component Department Cutting Milling Shaping 3.1 2.5 3.1 Frame Support 1.5 1.8 2.5 Strap .8 1.9 Capacity (hours) 360 435 685 Use Excel and Solver to formulate your model and solve the problem. Don't forget to convert hours to minutes on the RHS of the manufacturing constraints. Write your response to the questions in the space provided. Be sure to include the Excel spreadsheet and sensitivity report with your paperwork upload. Questions: 1. How many of each component (frame, support, and strap) should be made, and how many purchased? You are solving for 6 variables. 2. What is the total cost of the manufacturing and purchasing of the components? 3. Based on the information found in the sensitivity report, what are the range of optimality for frames made and straps made? 4. If the company is able to produce an additional frame, what is the $ increase/decrease to the value of the objective function