Problem 1 (10 pts): Construct a mathematical model (define your variables, write an objective function and constraints).
Problem 2 (10 pts): Use Excel's Solver tool to determine the optimal solution that will maximize profit. Summarize your results. In the Solver toolbox, choose "Simplex LP".
Problem 3 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the profit on a small table increases to $12. In the Solver toolbox, rchoose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.
Problem 4 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the profit on a large table decreases to $30. In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.
Problem 5 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the orders for the rocking chairs are canceled (and the cancellation came before the rocking chairs went into production). In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.
Problem 6 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the orders for the chaise lounges are increased to 300. In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.
Problem 7 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the available hours in the assembly department are increased to 3300. In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.
Problem 8 (10 pts): Discuss the effect on the optimal solution in Problem 2 if the available hours in the fabrication department are increased to 2800. In the Solver toolbox, choose "Simplex LP". In the Solver toolbox, choose "Simplex LP". If you Copy/Paste from Problem 2, you will have to re-set all parameters in the Solver toolbox.
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Problem 1 (10 pts): Construct a mathematical model (define your variables, write an objective function and...
O/ Write an appropriate mathematical model for this problem including Decision Variables and their description, Objective Function, & Constraints. XAMPLE 4.3 AGGREGATE PLANNING AT SURESTEP uring the next four months the SureStep Company must meet (on time) the fol lowing demands for pairs of shoes: 3000 in month 1 5000 in month 2; 2000 in month 3; and 1000 in month 4. At the beginning of month 1, 500 pairs of shoes are on hand, and SureStep has 100 workers....
Your problem will have exactly two variables (an X1 and an X2) and will incorporate a maximization (either profit or revenue) objective. You will include at least four constraints (not including the X1 ≥ 0 and X2 ≥ 0 [i.e., the “Non-negativity” or “Duh!”] constraints). At least one of these four must be a “≤” constraint, and at least one other must be a “≥” constraint; do not include any “= only” constraints. You must have a unique Optimal Solution...
Answer the problem 2 only please. Also if you could upload the excel sheet as well will be very appreciated. thanks OPR 3450 - Fall 2019 Assignment 1 due 09/09/19 page 1 of 1 Assignment 1 This is due in class on multiple dates. Check each Part. Each person must submit his/her own answer. If anyone submits a copy of an assignment, everyone with that submission will get a zero on the assignment. I will not accept e-mail assignments. Each...
First, read the article on "The Delphi Method for Graduate Research." ------ Article is posted below Include each of the following in your answer (if applicable – explain in a paragraph) Research problem: what do you want to solve using Delphi? Sample: who will participate and why? (answer in 5 -10 sentences) Round one questionnaire: include 5 hypothetical questions you would like to ask Discuss: what are possible outcomes of the findings from your study? Hint: this is the conclusion....