Purchase Solution

Supply Chain Management

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Preview

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

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Introduction to Finance

This quiz test introductory finance topics.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

View More Free Quizzes
Related BrainMass Solutions

  • Supply Chain Relationship

    606707 Supply Chain Relationship What is the general relationship that supply chain management has to any type of business operations and what do you feel could be some of the concerns with supply chain management when managing global business operations

  • Sustainable supply chain management

    on future directions for global supply chain management over the next several years.

  • Lean Supply Chain Management

    633285 Lean Supply Chain Management What is lean supply chain management? How does that figure into the future of supply chain management?

  • Logistics in the Business Organization

    Sell Supply Chain Management Upward Answer 1 Supply Chain Management Issues Supply chain management process is an important process for an organization.

  • The Organization's Supply Chain and Its Financial Chain

    The Supply chain 3. What do we mean by "supply chain management" and is this concept relevant to the financial supply chain? What is the set of relationships here? How do the relationships impact ERP design, implementation and management?

  • Interfacing with Supply Chain

    Several processes in supply chain management become possible with the utilization of Internet in supply chain management.

  • Benefits of supply chain management

    477881 Benefits of supply chain management Discuss the benefits of supply chain management. How does the implementation of supply chain management result in enhanced customer value?

  • Wal-Mart strategic supply chain model Problem

    Before writing about supply chain model, it is good for us to know about supply chain management.

  • supply chain management

    335110 Factors that contribute to the successful implementation of supply chain management What are the salient factors that contribute to the successful implementation of a supply chain management initiative?

  • E-Commerce

    of 'Supply Chain Management' more crease free. // Role of E- Business in Global Supply Chain Past hiccups in supply chain management like high transactional cost, poor availability of information, management of interface between functional organizations

View More Related Solutions