Calculate the target inventory level

Assignment Help Supply Chain Management
Reference no: EM131439314

ADVANCED SUPPLY CHAIN MANAGEMENT

1. Dry Ice, Inc., is a manufacturer of air conditioners that has seen its demand grow significantly.  The company anticipates nationwide demand for the next year to be 180,000 units in the South, 120,000 units in the Midwest, 110,000 units in the East, and 100,000 units in the West.  Managers at Dry Ice are designing the manufacturing network and have selected four potential sites - New York, Atlanta, Chicago, and San Diego.  Plants could have a capacity of either 200,000 or 400,000 units.  The annual fixed cost at the four locations are shown in the table below, along with the cost of producing and shipping an air conditioner to each of the four markets.  What site would be the lowest cost to operate?  The highest? What is the total cost of operating the entire system?

 

New York

Atlanta

Chicago

San Diego

Annual fixed cost of 200,000 plant

$6 million

$5.5 million

$5.6 million

$6.1 million

Annual fixed cost of 400,000 plant

$10 million

$9.2 million

$9.3 million

$10.2 million

East

$211

$232

$238

$299

South

$232

$212

$230

$280

Midwest

$240

$230

$215

$270

West

$300

$280

$270

$225

2. The following table gives the distances between Boston, Chicago, Dallas, Los Angeles, and Miami.  Each city requires 40,000 kilowatt hours (kWh) of power, and Chicago, Dallas, and Miami are capable of producing 70,000 kWh.  Assume that shipping 1000kWh over 100 miles costs $4.00.  What would be the total shipping cost?  From where should power be sent to minimize the cost of meeting each city's demand?

 

Boston

Chicago

Dallas

Los Angeles

Miami

Chicago

983

0

1205

2112

1390

Dallas

1815

1205

0

801

1332

Miami

1539

1390

1332

2757

0

3. Gray's Pharmacy uses a periodic review inventory system.  Every Friday the pharmacist reviews her inventory and determine the size of the replenishment order.  For example, she knows that demand for 500 mg metformin tablets, a drug for diabetics, is normally distributed with a mean of 6000 tablets each week with a standard deviation of 500 tablets per week.  Lead time is three weeks.  The desired cycle-service level is 95 per cent.  There are currently no outstanding orders.

a) Calculate the required safety stock.

b) Calculate the target inventory level.

c) If, when she reviews her inventory of metformin, the pharmacist finds that she currently has 19,000 tablets, calculate the appropriate replenishment order quantity. 

4. A popular spice company, Cincinnati Seasonings, located in Cincinnati, Ohio has experienced a large demand in the eastern part of the United States. The CEO has decided to set up another plant to serve its eastern market.  There are three factories that could possibly be used in Hershey, PA, Philadelphia, PA, and Baltimore, MD.  The markets are located in Bangor, Maine, Boston, MA, Providence, RI, Pittsburgh, PA and New York, NY. The coordinate location, the demand in each market, the required supply from each factory, and the shipping cost for each supply source or market is provided in the table below.  Where would an optimal factory (based upon minimal total cost) be built?  You need not provide city name only rectilinear distance (x,y) coordinates.

 

Transportation Cost per pound

Demand (in pounds)

X Coordinate

Y Coordinate

Sources

 

 

 

 

Hershey PA

$1.50

1500

650

20

Philadelphia

$1.25

1200

680

50

Baltimore

$1.10

1000

780

68

Markets

 

 

 

 

Bangor

$2.00

860

1250

1050

Boston

$2.00

1020

810

940

Providence

$2.00

980

800

900

Pittsburgh

$2.00

950

450

20

New York

$2.00

675

650

875

5. Jeff Corporation is a metalworking shop that is redesigning its layout.  The from - to matrix of the number of trips between departments is shown below.

Trips Between Departments

 

 

 

 

 

 

 

Department

A

B

C

D

E

F

A

 

10

15

 

 

50

B

 

 

 

20

10

20

C

 

 

 

45

 

10

D

 

 

 

 

 

20

E

 

 

 

 

 

 

F

 

 

 

 

 

 

The current layout is shown below. Propose a new layout based upon the finding of your calculations.

A

B

C

D

E

F

Hint; Calculate load distance requirements for travel between departments for both existing and proposed layouts.  Use 1 for distance between adjacent blocks (i.e., A -> B = 1; A -> C = 2)

Reference no: EM131439314

Questions Cloud

Compelling topics learned in course : What were the most compelling topics learned in this course? How did participating in discussions help your understanding of the subject matter? Is anything still unclear that could be clarified?
Compute the break-even point for the given data : Assuming Sales Price per unit = $15, develop a spreadsheet model to calculate the break-even point using the above. Design your spreadsheet using effective spreadsheet-engineering principles.
What have you learned that can be used in dissertation work : ORG-812: What have you learned that can be used in your dissertation work? Have you learned something that has made you change your topic or reinforced your topic choice?
Rational database design : You are tasked to develop a database design for a retail company that involves shipping orders to customers.  Order data includes an order date, a ship date, and one or more items on each order should be identified by a unique ID.
Calculate the target inventory level : Gray's Pharmacy uses a periodic review inventory system.  Every Friday the pharmacist reviews her inventory and determine the size of the replenishment order. Calculate the target inventory level
Take pictures of your license plate : Should computers be able to take pictures of your license plate and issue you a ticket for violations such as going through a toll without paying, or speeding?
Tcp-ip core protocols : Explain in your own words the TCP/IP core protocols? Describe each layer, what each layers function is, and what protocols exist at each layer.
Compare your personal ethics with the literature on ethics : LDR-800: Compare your personal ethics with the literature on ethics. What are the most significant similarities and differences you observe? Why are these significant?
Acceptance of new or replacement technology : The technology acceptance model (TAM) is a two-factor model that describes user acceptance of new or replacement technology solutions (Davis, 1989). This evaluation model has withstood the test of time and is widely used. The model is based upon p..

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Explain technologies to integrate supply chain processes

Discuss the use of information technologies to integrate supply chain processes, and discuss other trends in process management

  Explain logistics management in your company

How does 'lead time' impact on the major objectives of logistics management in your company

  Evaluate theories of managing in a cross-cultural context

Promote a professional and ethical approach to organisations and Enhance and apply planning, organising, decision-making and time management skills appropriate for use in an organisational context.

  What is the probability that the project will be completed

Using PERT, a project team was able to determine that the expected project completion time for construction of a building is 21 months and the project variance is 4. Hint: By definition, the probability that the project team will complete the project..

  Compute the average cost of gas in your local area

Create a supply curve for gasoline. Create a demand curve for gasoline. Calculate the average cost of gas in your local area. Calculate the standard deviation.

  Is there a best way to implement lean

Is there a best way to implement lean and are all organisations suitable for lean implementation - structured approach and should be prepared and presented as a professional business report. You should undertake a relevant literature review that he..

  Adoption of trade promotion synergies

What is your opinion on the adoption of trade promotion synergies amongst companies in the same industry? Wordcount should be 300 Harvard referencing/citation and a minimum of three

  Breach of contract as general partnership

If you were sued for a breach of contract as a general partnership what defense would you used to avoid responsibility?

  Laser optics rather than on electronic binary bits

Lambda Computer Products competed for and won a contract to produce two prototype units of a new type of computer that is based on laser optics rather than on electronic binary bits. Lambda was asked to present a bid for 10 additional units as soon a..

  Find a problem in managing global supply chains

MGMT 4337 - Team Case Analysis Find a problem in managing global supply chains from the real business world and identify specific SCM concepts/tools that can be applied to the problem

  Explain what is the battleground region

In your own words, explain what is the "Battleground Region" and how does this region can change America's supply chain logistics. In addition, describe an example of a single company

  How can co-operation and trust be fostered

How can co-operation and trust be fostered between partners in the supply chain? Please discuss in context of a industry.Backup your write up with real life situation from well know companies.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd