Safety Stock and Reorder Point
HomeworkConsider 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%).
Support your responses with examples.
Cite any sources in APA format.
Submission Details
Name your document SU_MGT4059_W2_A2_LastName_FirstInitial.xlsx.
Submit your document to the W2 Assignment 2 Dropbox by Tuesday, November 19, 2013.
Assignment 2 Grading Criteria | Maximum Points |
Developed a table showing the safety stocks, and inventory costs associated with the safety stocks, for each product at each service level. | 30 |
Developed a table showing the reorder points for each product at a 90% service level (assuming a two month lead time). | 15 |
Used correct spelling, grammar, and professional vocabulary. Cited all sources using APA format. | 5 |
Total: | 50 |
- 10 years ago
- 3
Answer(8)
Purchase the answer to view it
NOT RATED
- safety_stock_and_reorder_point.xls
Purchase the answer to view it
NOT RATED
- safety_stock_and_reorder_point.xls
Purchase the answer to view it
NOT RATED
- business_-_806497786.xlsx
Purchase the answer to view it
NOT RATED
- mgt4059_week_2_assignment_2_problems.zip
Purchase the answer to view it
NOT RATED
- safety_stock_and_reorder_point.xls
Purchase the answer to view it
NOT RATED
- safety_stock_and_reorder_point.xls
Purchase the answer to view it
NOT RATED
- mgt4059_week_2_assignment_2_problems_safety_stock_and_reorder_point.xls
Purchase the answer to view it
NOT RATED
- adv_operations_mgmt_w2a2.xls
Bids(0)
other Questions(10)
- HCS 341 Legal, Safety, and Regulatory Requirements
- A-Plus writer
- NEED IT DONE NOW - STATS, Reliability etc MUST BE DETAILED AND QUICK
- hsm220 creating a budget
- Phase 5 Individual Project 1,500 to 2,000 words. 2 sources at least.
- Mat 118
- Tradeoffs involved in using Network Computers
- Lamia Bio lab 5
- The Wheel Deal Inc., a company that produces scooters and other wheeled non-motorized recreational equipment is considering an expansion of their...
- For Kim Only.