Supply chain optimized to cut CO2 with Excel Solver.

SCM540 Operations and Supply Chain Management

Answered

Task:

Need to use solver in Excel to find solution.

Description of Assignment: Through the use Excel Solver, students will optimize a supply chain with the objective of lower CO2 emissions.

Students will develop two models in which the CFO of the company limits the available budget to run the given Supply Chain to CNY 3 billion, and then will run a model proving that an increase of 10% in the budget would result in a more efficient supply chain with regards to a lesser impact on CO2.

Students aiming for excellence should develop at will other % increases in the budget until they find a balanced supply chain model that is cost-efficient for the company while also more environmentally friendly for China and the worldwide society.

Instructions: - Read the given problematic in this business casePreview the document.

Prepare an optimized supply chain limited to a budget of CNY 3 billion.

Increase the budget to 10% and assess how much lower the CO2 emissions would be, for such a supply chain.

Highly desirable: Run a sensitivity analysis, by building other scenarios of lower and higher budget than CNY 3 billion.

What is the impact on CO2?

Prepare and submit a written report, between 600 and 800 words long, with a clear recommendation to the leadership team of the TV Screens company of which supply chain to run and why.

Be sure to consider the following:

Financial implications - CO2 implications

Why are you recommending such a supply chain

PR/Consumer Awareness Risks (and mitigation plans) and Opportunities

Cite, and analyze/compare, one example of a company that had similar dilemmas (choosing between cutting/increasing cost against increasing/decreasing CO2 emissions), what they did, and what happened as a result of that.

Submit a word document and your excel workbook with all the scenarios you ran.

Get instant help from 5000+ experts for