Explore BrainMass

Supply Chain Management

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

4. Use the spreadsheet provided in the textbook's CD-ROM to answer the following questions on supply chain coordination. We say a supply chain is coordinated if it achieves the global optimal solutiong.

a) For the buy-back contract, the retail DC selects the ordering quantity depending on the buy-back price. Set the manufacturer's selling price to (cellB9) $80. Plot the retail DC's expected profit, manufacturer's profit, and the total supply chain profit as a function of the buy-back price (cell B11). Find, if it exists, a buy-back price that would coordinate this supply chain, and compare profits of the manufacturer and the distributor. If it does not exist, briefly explain.

b) Set the manufacturer's selling price to $70, and repeat the question.

c) For the revenue-sharing contract, the retail DC selects the ordering quantity depending on the whole-sale price and revenue-sharing percentage. Find, if exists, a pair of a whole-sale price (cell B9) and revenue-sharing percentage (cell B11)that would coordinate this supply chain. Can you find another pair?

Please see attachment for spreadsheet.

© BrainMass Inc. brainmass.com October 24, 2018, 5:33 pm ad1c9bdddf


Solution Preview

Hi ,
<br>I have solved this question and written the answers as a report in a doc ...

See Also This Related BrainMass Solution

ORUN inventory and supply chain management problems

See attached file.

A synopsis of the inventory and supply chain management problem(s) as you perceive them to be.

2. Using the facts of the case, as well as theories and best practices of Operations Management, prepare a short description as to what you intend to do to address each of the 5 goals above.

3. Explain how you would identify and use measures of effectiveness (identify appropriate metrics) to assess progress in resolving these issues.

View Full Posting Details