A. Given a budget of CN¥ 3.3 billion, what is the optimal shipping plan that minimizes total carbon emissions? - Please show work via LINGO

B. Conduct a sensitivity analysis by varying percentage increases in the budget. Investigate its effect on the emission of CO2

Transcribed Image Text:

CO2 Emission in Kg per Ton-Km shipped Product - ODM LCD42" ODM1 LCD42" ODM2 LCD42" ODM3 LCD42" ODM4 LCD42" ODM5 LCD42" ODM6 LCD42" ODM7 LCD32" ODM1 LCD32" ODM2 Distance TV Unit to DC in Kms 2508 1553 1380 2150 30 Product Weight in Metric Ton LCD42" 0.022 LCD32" 0.0165 690 686 2508 1553 Production Cost CNY 1,983.40 2,254.00 2,582.40 1,976.10 2,711.30 2,704.80 2,125.20 1,818.00 1,996.40 Regular Air 1.44 Regular Air 64,400 115,920 Exhibit 1 DATA SHEET 103,040 64,400 X 135,240 103,040 64,400 115,920 Units to be shipped 920,000 530,000 Air Express Road Road LTL 0.0613 0.0613 1.44 Air Express Road-Network 0.0613 Shipping Cost per Metric Ton CNY Road Road LTL Road- 5,216.40 70,840 6,182.40 127,512 7,084.00 5,796.00 5,796.00 113,344 7,084.00 70,840 6,182.40 5,280.80 X 9,660.00 9,016.00 148,120 X X 7,084 5,796 6,182.40 5,216.40 7,084 112,700 70,840 127,512 5,796 Network Rail 4,830.00 4,250.40 5,667.20 5,667.20 5,216.40 4,250.40 8,694.00 X X X 5,538.40 5,860,40 5,667.20 Rail Water 0.0285 0.007 Supply Chain Production and Shipping Constraints Minimum production of LCD42" (ditto for LCD32") at any manufacturing ODM Maximum production of LCD42" at manufacturing OEM (ditto for LCD32") at manufacturing ODM Minimum number of units of LCD42" (LCD32") to be shipped by Regular Air or Air Express Minimum number of units of LCD42" (LCD32") to be shipped by Road or Road LTL or Road Network Minimum number of units of LCD42" (LCD32") to be shipped by Rail Water 3,091.20 5,7960 2,704.80 5,7960 3,284.40 3,091.20 X 4,830 4,250.40 3,091.20 5,796 2,704.80 3,413.20 2,769.20 200,000 units 600,000 units 46,000 (53,000) 92,000 (79,500) 138,000 (79,500) CO2 Emission in Kg per Ton-Km shipped Product - ODM LCD42" ODM1 LCD42" ODM2 LCD42" ODM3 LCD42" ODM4 LCD42" ODM5 LCD42" ODM6 LCD42" ODM7 LCD32" ODM1 LCD32" ODM2 Distance TV Unit to DC in Kms 2508 1553 1380 2150 30 Product Weight in Metric Ton LCD42" 0.022 LCD32" 0.0165 690 686 2508 1553 Production Cost CNY 1,983.40 2,254.00 2,582.40 1,976.10 2,711.30 2,704.80 2,125.20 1,818.00 1,996.40 Regular Air 1.44 Regular Air 64,400 115,920 Exhibit 1 DATA SHEET 103,040 64,400 X 135,240 103,040 64,400 115,920 Units to be shipped 920,000 530,000 Air Express Road Road LTL 0.0613 0.0613 1.44 Air Express Road-Network 0.0613 Shipping Cost per Metric Ton CNY Road Road LTL Road- 5,216.40 70,840 6,182.40 127,512 7,084.00 5,796.00 5,796.00 113,344 7,084.00 70,840 6,182.40 5,280.80 X 9,660.00 9,016.00 148,120 X X 7,084 5,796 6,182.40 5,216.40 7,084 112,700 70,840 127,512 5,796 Network Rail 4,830.00 4,250.40 5,667.20 5,667.20 5,216.40 4,250.40 8,694.00 X X X 5,538.40 5,860,40 5,667.20 Rail Water 0.0285 0.007 Supply Chain Production and Shipping Constraints Minimum production of LCD42" (ditto for LCD32") at any manufacturing ODM Maximum production of LCD42" at manufacturing OEM (ditto for LCD32") at manufacturing ODM Minimum number of units of LCD42" (LCD32") to be shipped by Regular Air or Air Express Minimum number of units of LCD42" (LCD32") to be shipped by Road or Road LTL or Road Network Minimum number of units of LCD42" (LCD32") to be shipped by Rail Water 3,091.20 5,7960 2,704.80 5,7960 3,284.40 3,091.20 X 4,830 4,250.40 3,091.20 5,796 2,704.80 3,413.20 2,769.20 200,000 units 600,000 units 46,000 (53,000) 92,000 (79,500) 138,000 (79,500)

Answer rating: 100% (QA)

I understand that you need to use LINGO to solve an optimization problem to find the optimal shipping plan that minimizes total carbon emissions while ... View the full answer