Problem 1 (20 points) Workers Scheduling file page 670 Develop an appropriate objective function that corresponds to the weekly payroll (10 points) Minimize the objective function with Solver to obtain the optimal number of workers. (10 points) Is the previous optimal solution still optimal? Compare your solution of this problem with the solution provided in the example in the textbook which was 23 employees. (5 points) Problem 13 (35 points) Transportation file page 692 A) Would it help to have 100 more units of capacity at plant 1? (2 points) Why? (4 points) There are at least two ways to approach this problem. The most obvious is to increase the capacity of plant 1 by 100 and then run Solver to see if the total cost is decreased at all. If it helps to increase the capacity, you need to explain what changes in your shipping plan occurred once the extra capacity is in place. For example, a costly route that was used before the change may no longer be optimal and could be replaced by a lower cost route. Another way to see if there are any benefits of increasing the capacity of plant 1 is by looking at the shadow price in the sensitivity analysis. B) What is the most Grand Prix would be willing to pay for this extra capacity? (5 points) The answer to this question is equal to the reduction in the total cost after the new capacity is in place. C) Answer the same questions assuming that the capacity of Plant 2 is increased by 100. (12 points) D) Answer the same questions assuming that the capacity of Plant 3 is increased by 100. (12 points) Problem 37 (15 points) Investing file page 713 (after section 14-6) Replace the "Maximum per investment" with a "Minimum investment" (you could use 50,000 for each investment. Modify the constraint so that "Dollars invested" is greater than "Minimum Investment" Run Solver and provide new value of "Final cash"

Transcribed Image Text:

Problem 1 (20 points) Workers Scheduling file page 670 Develop an appropriate objective function that corresponds to the weekly payroll (10 points) Minimize the objective function with Solver to obtain the optimal number of workers. (10 points) Is the previous optimal solution still optimal? Compare your solution of this problem with the solution provided in the example in the textbook which was 23 employees. (5 points) Problem 13 (35 points) Transportation file page 692 A) Would it help to have 100 more units of capacity at plant 1? (2 points) Why? (4 points) There are at least two ways to approach this problem. The most obvious is to increase the capacity of plant 1 by 100 and then run Solver to see if the total cost is decreased at all. If it helps to increase the capacity, you need to explain what changes in your shipping plan occurred once the extra capacity is in place. For example, a costly route that was used before the change may no longer be optimal and could be replaced by a lower cost route. Another way to see if there are any benefits of increasing the capacity of plant 1 is by looking at the shadow price in the sensitivity analysis. B) What is the most Grand Prix would be willing to pay for this extra capacity? (5 points) The answer to this question is equal to the reduction in the total cost after the new capacity is in place. C) Answer the same questions assuming that the capacity of Plant 2 is increased by 100. (12 points) D) Answer the same questions assuming that the capacity of Plant 3 is increased by 100. (12 points) Problem 37 (15 points) Investing file page 713 (after section 14-6) Replace the "Maximum per investment" with a "Minimum investment" (you could use 50,000 for each investment. (5 points) Modify the constraint so that "Dollars invested" is greater than "Minimum Investment" (5 points) Run Solver and provide new value of "Final cash" (5 points) Problem 1 (20 points) Workers Scheduling file page 670 Develop an appropriate objective function that corresponds to the weekly payroll (10 points) Minimize the objective function with Solver to obtain the optimal number of workers. (10 points) Is the previous optimal solution still optimal? Compare your solution of this problem with the solution provided in the example in the textbook which was 23 employees. (5 points) Problem 13 (35 points) Transportation file page 692 A) Would it help to have 100 more units of capacity at plant 1? (2 points) Why? (4 points) There are at least two ways to approach this problem. The most obvious is to increase the capacity of plant 1 by 100 and then run Solver to see if the total cost is decreased at all. If it helps to increase the capacity, you need to explain what changes in your shipping plan occurred once the extra capacity is in place. For example, a costly route that was used before the change may no longer be optimal and could be replaced by a lower cost route. Another way to see if there are any benefits of increasing the capacity of plant 1 is by looking at the shadow price in the sensitivity analysis. B) What is the most Grand Prix would be willing to pay for this extra capacity? (5 points) The answer to this question is equal to the reduction in the total cost after the new capacity is in place. C) Answer the same questions assuming that the capacity of Plant 2 is increased by 100. (12 points) D) Answer the same questions assuming that the capacity of Plant 3 is increased by 100. (12 points) Problem 37 (15 points) Investing file page 713 (after section 14-6) Replace the "Maximum per investment" with a "Minimum investment" (you could use 50,000 for each investment. (5 points) Modify the constraint so that "Dollars invested" is greater than "Minimum Investment" (5 points) Run Solver and provide new value of "Final cash" (5 points)