a. Which of the unit shipping costs given in Table 3.9 e has the smallest margin...

Transcribed Image Text:

a. Which of the unit shipping costs given in Table 3.9 e has the smallest margin for error without invalidating the optimal solution given in Figure 3.10 9 ? Where should the greatest effort be placed in estimating the unit shipping costs? TABLE 3.9 Some Data for the Big M Company Distribution-Network Problem Shipping Cost for Each Lathe To Customer 1 Customer 2 Customer 3 Output From Factory 1 $700 $900 $800 12 lathes Factory 2 800 900 700 15 lathes Order size 10 lathes 8 lathes 9 lathes Shiping Cost (per Lathe) Report Created: 2020-02-14 9:43:05 AM Customer 1 Customer 2 Customer 3 Factory 1 700 900 800 Variable Cells Factory 2 800 900 700 Final Reduced Objective Allowable Allowable Total Cell Name Value Cost Coefficient Increase Decrease Units Shipped Customer 1 Customer 2 Customer 3 Shipped Output $L$9 Factory 1 Customer 1 10 700 100 1E+30 Factory 1 10 2 12 12 $M$9 Factory 1 Customer 2 2 900 100 100 Factory 2 6. 9 15 15 Factory 1 Customer 3 Factory 2 Customer 1 Factory 2 Customer 2 Factory 2 Customer 3 $N$9 100 800 1E+30 100 Total to Customer 10 $L$10 100 800 1E+30 100 Total Cost $M$10 6 900 100 100 Order Size 10 8 $20,500.00 $N$10 9. 700 100 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $L$11 Total to Customer Customer 1 10 700 10 10 $M$11 Total to Customer Customer 2 8 900 8 2 $N$11 Total to Customer Customer 3 700 9 2 $O$9 Factory 1 Total Shipped Factory 2 Total Shipped 12 12 1E+30 $O$10 15 15 2 a. Which of the unit shipping costs given in Table 3.9 e has the smallest margin for error without invalidating the optimal solution given in Figure 3.10 9 ? Where should the greatest effort be placed in estimating the unit shipping costs? TABLE 3.9 Some Data for the Big M Company Distribution-Network Problem Shipping Cost for Each Lathe To Customer 1 Customer 2 Customer 3 Output From Factory 1 $700 $900 $800 12 lathes Factory 2 800 900 700 15 lathes Order size 10 lathes 8 lathes 9 lathes Shiping Cost (per Lathe) Report Created: 2020-02-14 9:43:05 AM Customer 1 Customer 2 Customer 3 Factory 1 700 900 800 Variable Cells Factory 2 800 900 700 Final Reduced Objective Allowable Allowable Total Cell Name Value Cost Coefficient Increase Decrease Units Shipped Customer 1 Customer 2 Customer 3 Shipped Output $L$9 Factory 1 Customer 1 10 700 100 1E+30 Factory 1 10 2 12 12 $M$9 Factory 1 Customer 2 2 900 100 100 Factory 2 6. 9 15 15 Factory 1 Customer 3 Factory 2 Customer 1 Factory 2 Customer 2 Factory 2 Customer 3 $N$9 100 800 1E+30 100 Total to Customer 10 $L$10 100 800 1E+30 100 Total Cost $M$10 6 900 100 100 Order Size 10 8 $20,500.00 $N$10 9. 700 100 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $L$11 Total to Customer Customer 1 10 700 10 10 $M$11 Total to Customer Customer 2 8 900 8 2 $N$11 Total to Customer Customer 3 700 9 2 $O$9 Factory 1 Total Shipped Factory 2 Total Shipped 12 12 1E+30 $O$10 15 15 2

Answer rating: 100% (QA)

a The unit shipping cost that has the smallest margin ... View the full answer