Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for an Employee Scheduling problem (a problem where you try to meet your staffing requirements without wasting money). When it comes to filling out Solver, which solution method should be used? G H Sat. 6 Sun. 7 B D E 1 Post Office Scheduling Problem 2 3 Starting day of 5-day shift Mon. Tue Wed. Thurs. Fri. 5 Number starting 1 2 3 4 5 B Number working on 7 each day 23 21 19 17 15 8 Relation Minimal number 9 required each day 17 13 15 19 14 10 Total employees 28 11 Scheduled 20 17 16 11 Simplex LP GRG Nonlinear Evolutionary c B Nowlin Plastics Parameters Manufacturing Fixed Cost Manufacturing Variable Cost per Unit $234,000.00 $2.00 Outsourcing Cost per Unit $3.50 Model Quantity 10,000 5 Total Cost to Produce $254.000.00 1 5 Total Cost to Outsource $35.000.00 6 7 Savings due to Outsourcing S219,000.00 9 use Goal Seek to determine what the Order Quantity must be for the Savings Due to Outsourcing to be -16,000. If necessary, round your answer to the nearest whole unit. Your Answer: Answer Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a standard Transportation Planning problem. Which of the following relation symbols should go in range B31:D31? G H Demand 950 831.25 2373 393.75 1187.5 1543.75 + B D 1 Aggie Power 2 Distribution Costs 3 Los Angeles Tulsa Seattle 4 Seattle $ 356.25$ 593.75 $ 59.38 5 Portland $ 356.25$ 593.75 $ 178.13 6 San Francisco $ 178.13 $ 475.00 $ 296.88 7 Boise $ 336.25 $ 475.00 $ 296.88 12 Flagstaff $ 178. 13 S 475.00 $ 593.75 13 Durango $ 356.25 $ 296.88 $ 593.75 14 15 Supply Available 3000 3000 3000 16 17 Distribution Plan 18 Los Angeles Tulsa Seattle 19 Seattle 950 00 0.00 0.00 20 Portland 831.25 0.00 0.00 21 San Francisco 1218.75 1156.25 0.00 22 Boise 0.00 593.73 0.00 27 Flagstaff 0.00 1187.50 0.00 28 Durango 0.00 62 50 1481 25 29 30 Total 300000 3000.00 148123 3 Relatihan 32. Supply Available 3000 3000 3000 30 Bota Cost | SB3.0196 Total 950.00 831 23 2375.00 393.75 1187 30 1543 75 Relation Demand 950 831.25 2375 593.75 11875 134375 AU. V.V UU HV 593.75 1187.50 62.50 0.00 0.00 1481.25 593.75 1187.50 1543.75 ALIELU 22 Boise 0.00 27 Flagstaff 0.00 28 Durango 0.00 29 30 Total 3000.00 31 Relation 32 Supply Available 3000 33 34 Total Cost 53.145.019.53 3000.00 1481.25 3000 3000 None of the above: leave it blank Question 12 (2 points) Consider the following table of Constraints and their Slack values: Constraint: 1 2 3 4. Slack Value: 00 4. 6 Check the box below next to each constraint that is binding. Constraint 1 Constraint 2 Constraint 3 constraint 4 Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for an Employee Scheduling problem (a problem where you try to meet your staffing requirements without wasting money). When it comes to filling out Solver, which solution method should be used? G H Sat. 6 Sun. 7 B D E 1 Post Office Scheduling Problem 2 3 Starting day of 5-day shift Mon. Tue Wed. Thurs. Fri. 5 Number starting 1 2 3 4 5 B Number working on 7 each day 23 21 19 17 15 8 Relation Minimal number 9 required each day 17 13 15 19 14 10 Total employees 28 11 Scheduled 20 17 16 11 Simplex LP GRG Nonlinear Evolutionary c B Nowlin Plastics Parameters Manufacturing Fixed Cost Manufacturing Variable Cost per Unit $234,000.00 $2.00 Outsourcing Cost per Unit $3.50 Model Quantity 10,000 5 Total Cost to Produce $254.000.00 1 5 Total Cost to Outsource $35.000.00 6 7 Savings due to Outsourcing S219,000.00 9 use Goal Seek to determine what the Order Quantity must be for the Savings Due to Outsourcing to be -16,000. If necessary, round your answer to the nearest whole unit. Your Answer: Answer Consider the screenshot below (if it doesn't display properly, you can download the source spreadsheet from this link) which shows a potential solution for a standard Transportation Planning problem. Which of the following relation symbols should go in range B31:D31? G H Demand 950 831.25 2373 393.75 1187.5 1543.75 + B D 1 Aggie Power 2 Distribution Costs 3 Los Angeles Tulsa Seattle 4 Seattle $ 356.25$ 593.75 $ 59.38 5 Portland $ 356.25$ 593.75 $ 178.13 6 San Francisco $ 178.13 $ 475.00 $ 296.88 7 Boise $ 336.25 $ 475.00 $ 296.88 12 Flagstaff $ 178. 13 S 475.00 $ 593.75 13 Durango $ 356.25 $ 296.88 $ 593.75 14 15 Supply Available 3000 3000 3000 16 17 Distribution Plan 18 Los Angeles Tulsa Seattle 19 Seattle 950 00 0.00 0.00 20 Portland 831.25 0.00 0.00 21 San Francisco 1218.75 1156.25 0.00 22 Boise 0.00 593.73 0.00 27 Flagstaff 0.00 1187.50 0.00 28 Durango 0.00 62 50 1481 25 29 30 Total 300000 3000.00 148123 3 Relatihan 32. Supply Available 3000 3000 3000 30 Bota Cost | SB3.0196 Total 950.00 831 23 2375.00 393.75 1187 30 1543 75 Relation Demand 950 831.25 2375 593.75 11875 134375 AU. V.V UU HV 593.75 1187.50 62.50 0.00 0.00 1481.25 593.75 1187.50 1543.75 ALIELU 22 Boise 0.00 27 Flagstaff 0.00 28 Durango 0.00 29 30 Total 3000.00 31 Relation 32 Supply Available 3000 33 34 Total Cost 53.145.019.53 3000.00 1481.25 3000 3000 None of the above: leave it blank Question 12 (2 points) Consider the following table of Constraints and their Slack values: Constraint: 1 2 3 4. Slack Value: 00 4. 6 Check the box below next to each constraint that is binding. Constraint 1 Constraint 2 Constraint 3 constraint 4