Simon Manufacturing produces 3 products: Product 1, Product 2 and Produ has been discontinued. The assembly diagrams show the makeup of each p of subassemblies and components. Products are indicated by number, sub color, and parts by letter. For example, Product 1 is made up of two blue su and one red subassembly. Each blue subassembly has one part A and one red subassembly has two part A and two part C. Product one can be comp minutes. Maximize prot by building the optimal quantity of each product. least 20 of each because it doesn't make sense to setup for a lower product can only sell whole products. Current Inventory: Part A: 500 Part B: 350 Part C: 230 Part D: 200 Labor: 100 hours available Prot Margins: Product 1: $3? Product 2: $55 Product 4: $?2 Question 1: Write out the objective, the decision variables, and the constra problem as separate sentences {you don't need to include the constraint to: here}. Question 2: Build a spreadsheet model and use Solver to determine the op' levels for Product 1, 2 and 4. Question 3: Based on the sensitivity analysis, which part would be most prc the inventory