Consider the following scenario and image. You are planning production of two products in your factory (Office Chairs and Dining Chairs). You have data on the component parts required to manufacture Office Chairs and Dining Chairs and how much profit each product will produce (A1:D5). There is also a Parts Availability table that lists the components you have in storage and how many there are of each (F1:G4). Using Solver, determine how many Office Chairs and Dining Chairs to make, ensuring that you make as much profit as possible, while ensuring you don't try to manufacture more of either product than you have parts for (as per the Parts Availability table). In addition, because of COVID-19 there is less demand for Dining Chairs and as such, no more than 100 need to be produced.

Your task: An image for the Solver Parameters is shown below with the necessary four parts for completion (A, B, C, D). What values should we enter in the fields (A, B, C, D) as highlighted in the figure below? For your answer, you must write the details of what you would enter into these four parts of the Solver window. You must ensure that you make clear what data goes into what part of the Solver Parameter window (for example A contains $B$4 or D contains $A$6 >=5 etc.).

D E F G H Nm Parts availability Part 1 Part 2 Part 3 1,000 1,200 450 N 6 000 Profit A B 1 Product Office Chair Dining Chair 2 Part 1 1 2 3 #parts needed Part 2 3 4 Part 3 2 0 5 Profit $ 10.00 $ 5.00 6 7 Manufacturing plan 8 Product Parts required 9 # to make # Part 1 # Part 2 # Part 3 10 Office Chair 0 0 0 11 Dining Chair 0 0 0 12 TOTALS: 0 0 0 13 14 15 16 17 18 $ $ $ = Formulas: C10 =C2*810 c11 =D2*811 C12 =SUM(C10:011) D10 =C3*B10 D11 =D3*B11 D12 =SUM(D10:011) E10=C4*810 E11 =D4*811 E12 =SUM(E10:E11) F10 =B10*C5 F11 =B11 *D5 F12 =SUM(F10:F11) 19 20 Solver Parameters Set Objective To: B O Max O Value of: Changing Variable Cells: Subject to the Constraints: Add Change D Delete Beset All Load/Save Make Unconstrained variables Non-Negative Select a Solving GR Nonlinear Options Method: Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close