Safety Stock and Reorder Point

profileHomework

Consider the following data.

Inventory ItemAverage Demand (Annual)Sigma (Std. Dev.) of Demand During Lead TimeItem Unit Cost
F-1100115,000100$250.00
K-12002100,000300$2.00
L-13003250,000200$0.20
N-14004300,000400$1.00
P-2100150,00060$125.00
S-2200280,00075$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

    blurred-text
    NOT RATED
    • attachment
      safety_stock_and_reorder_point.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      safety_stock_and_reorder_point.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      business_-_806497786.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mgt4059_week_2_assignment_2_problems.zip

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      safety_stock_and_reorder_point.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      safety_stock_and_reorder_point.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mgt4059_week_2_assignment_2_problems_safety_stock_and_reorder_point.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      adv_operations_mgmt_w2a2.xls
    Bids(0)