Use Excel’s solver and Tableau Dashboard solve questions related to the DHL case.

I’m stuck on a Excel question and need an explanation.

The degradation of the environment has led many governments and customers to pressure businesses to make their operations more environmentally friendly. The case illustrates how a small budget increase can drastically C02 emission in the transportation of LCD TV’s from their manufacturing bases to distribution center (DC).

Find attached the DHL Supply Chain – Case Study Word file and the related Excel file

Please, summit:

– a Word/PDF file with screenshots of your excel that you explain

– your excel file

Problem 1: Mini-Case(50%)

  • Complete the provided excel template to demonstrate how the original supply chain was optimized on a budget CNY 3 billion.
  • Evaluate the extent of the reduction in CO2 emission if the budget were increased by 10 per cent to CNY 3.3 billion.
  • Sensitivity analyses: repeat question 2 for other possible percentage increases in the budget

Problem 2: Tableau Software(50%)

Based on the mini case data, provide a Tableau Dashboard showing how the carbon emission could be optimized (please submit the twbx file)