Develop a table to present the inventory quantities

Assignment Help Operation Management

Reference no: EM131585579

Safety Stock and Reorder Point
Consider the following data.

Inventory Item	Average Demand (Annual)	Sigma (Std. Dev.) of Demand During Lead Time	Item Unit Cost
F-11001	15,000	100	$250.00
K-12002	100,000	300	$2.00
L-13003	250,000	200	$0.20
N-14004	300,000	400	$1.00
P-21001	50,000	60	$125.00
S-22002	80,000	75	$30.00

Note: All items are independent demand items.

Based on the above data:

Calculate the safety stock quantities and the inventory cost associated with safety stock (based on the item unit cost) for the inventory items at four different service levels (50%, 80%, 90%, and 95%).

Develop a table to present the inventory quantities and the safety stock costs at each service level.

Assuming that demand occurs at a steady pace every month (in other words, there is no seasonality or cyclical change in the level of demand), calculate the reorder point for each item assuming a lead time of two months and a service level of 90%.

Develop a table to present the reorder points for all products under these conditions (two month lead time and service level of 90%).

Reference no: EM131585579

Questions Cloud

Explain about career prospects in the health care field : If a young person asked you about career prospects in the health care field, what answer would you give? What profession or specialty would you recommend?

Write a method named swapall : Write a method named swapAll that accepts two arrays of integers as parameters and swaps their entire contents

Position of the displaced whirlpool employees : What are the arguments supporting the position of the displaced whirlpool employees?

Discuss the importance of nonrepudiation : Explain the importance of using ACLs. Discuss the importance of nonrepudiation. Identify some of the vulnerabilities that affect cryptographic systems.

Develop a table to present the inventory quantities : Develop a table to present the inventory quantities and the safety stock costs at each service level.

Find all eigenfunctions : Use separation of variables to find all eigenfunctions, i.e., all solutions of the form u(r, ?, t) = Q(r)T(?)T(t)

What is the importance of product positioning : What is the importance of product positioning? What product comes to mind for you when you think of great product positioning?

Create an access database table with the title providers : Create an Access Database table with the title: Providers. Create a second Access Database table with the title: Nurses.

Java collections framework : The user enters commands buy symbol quantity price, sell symbol quantity price (which causes the gain to be displayed), and quit.

User Account

All Pages