Safety Stock and Reorder Point Calculations
Not what you're looking for?
Based on the following 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. (Note: All items are independent demand items.)
• 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%).
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
Purchase this Solution
Solution Summary
The solution provides formulas for calculating safety stock and reorder point. It also presents how to do what-if analysis using Data Tables functionality in Excel.
Solution Preview
Hi,
Please find attached file with the help provided on the question. The file contains formulas ...
Purchase this Solution
Free BrainMass Quizzes
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.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Introduction to Finance
This quiz test introductory finance topics.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.