Purchase Solution

supply chain-02

Not what you're looking for?

Ask Custom Question

Refer to the HCEC case. My solution spreadsheet is attached.

ALL I NEED IS AN ANSWER TO BELOW QUESTIONS. THE SOLUTION IS ALREADY ATTACHED FOR THE MAIN QUESTIONS.

Assume the Mexican Company charges $62.00, including their markup. HCEC must pay the transportation cost directly. (The spreadsheet determines breakeven prices using this assumption.)

(a) Explain, in detail, the calculation for premium shipment savings (F34 in Premium Shipment worksheet). Use formulas. Explain both components of the 0.502 (0.348 and 0.153)

(b) What happens if the probability of stock-out is changed from 0.004 to 0.05, to (i) Safety stock, (ii) Transport cost, and (iii) the net advantage that CMI has over the Mexican plant? Give numbers and explain the reasoning, briefly.

Purchase this Solution

Solution Preview

a)Explanation:
<br>
<br>.348 is calculated by: Safety stock of (Regular- Premium)*(Cost/unit +transportation cost/unit)*(carrying cost rate))/(mean annual demand)
<br> = ((166.05-36.75)*(64+3.40)*.30)/(30*250).
<br>
<br>.153 is calculated as :(Difference between mean Regular and Premium Lead time/(no of days in a year))*cost/unit*carrying cost.
<br> = ...

Purchase this Solution


Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Introduction to Finance

This quiz test introductory finance topics.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.