--%>

Order Quantity-Cycle Inventory-Safety Inventory

Consider the following data pertaining to a distribution center.

2446_distribution centre.jpg

Ordering cost: $50 /order
Holding cost: $4 /unit /week.
Cycle service level: 97%

Summary:

The question is related to cost accounting in finance. It deals with measures such as Order Quantity, Cycle Inventory, Safety Inventory, Reorder Level, Annual Inventory Holding, Annual Ordering Cost, etc. All these measures are calculated according to given cost and time.

E

Expert

Verified

Consider the following data pertaining to a distribution center.

Mean Weekly Demand(d): 100
Standard Deviation  of Weekly Demand(Sd): 30
Lead Time(L): 2 Weeks
No. of weeks in year: 50


Ordering cost (Cp): $50 /order
Holding cost (Ch): $4 /unit /week.
Cycle service level: 97%  
Z – value for service level 97 % = 1.89
Annual demand (D) = d * No. of weeks = 100 * 50 = 5000 units
Standard deviation of weekly demand during lead time =SL = sqrt( sum of squares of ‘Sd’ during the ‘L’ number of weeks) = sqrt( 302 + 302) = 42.42 units

Order Quantity = Q = sqrt( (2 * D * Cp)/Ch) 
              = sqrt((2* 5000 * 50)/4)
              = 353.55 units
              =354 units approx

Cycle inventory = Q/2 
    = 353.55/2 
    = 176.775 units
    = 177 units approx

Safety inventory = z* SL 
     = 1.89 * 42.42 
    = 80.18 units
    = 80 units approx

Re-Order Level = d*L + z* SL
     = 100*2 + 1.89*42.42
    = 280 units approx

Annual Inv Holding Cost = (Q/2)*Ch
      = 353.55/2 * 4
      = $ 707 approx

number of orders per year
= D/Q
= 5000/353.55
=14.14

Annual ordering cost = (D/Q) * Cp
              = 5000/353.55 * 50
              =$ 707 approx

   Related Questions in Finance Basics

  • Q : Computing the amount of excess reserves

    Normal 0 false false

  • Q : Have mergers influenced competition

    Have mergers influenced competition?Federal Reserve data illustrates that measured on the local level, where competition takes place; markets have in fact experienced more banking competition, not less, in the past decade.

  • Q : Describe present value of the firms

    Describe the term "present value of the firm's operations" (also known as Enterprise Value). What does this number expose? The current value of the company's free cash flows reveals the market value of the firm's core income generating operatio

  • Q : Explain Merit Salary Adjustment Merit

    Merit Salary Adjustment (MSA): The cost factor resultant from the periodic raise in salaries paid to the personnel occupying authorized positions. The personnel usually receive a salary raise of 5 percent per year up to the upper sala

  • Q : Define Warrant Warrant : It is an order

    Warrant: It is an order drawn by the State Controller directing the State Treasurer to reimburse a particular amount, from a specific fund, to the entity or person named. A warrant usually corresponds to a blank check however is not essentially payabl

  • Q : How does depreciation influence cash

    Normal 0 false false

  • Q : Influence of opportunity costs How do

    How do opportunity costs influence the capital budgeting decision-making procedure? Opportunity costs reflect the foregone benefits of alternative not selected when a capital budgeting project is chosen. Any decrease in the cash flows of the fi

  • Q : Price Earning ratio Define the term

    Define the term Price Earning ratio and how it is calculated?

  • Q : Explain working of accounts receivable

    Explain working of accounts receivable factoring? And describe benefits to the two parties involved and risks? Factoring is while one firm sells accounts receivable (AR) to another. The purchasing firm is termed as a factor. The factor earns

  • Q : What is Special Fund for Economic

    Special Fund for Economic Uncertainties: It is a fund in the General Fund (that is, a similar reserve is involved in each special fund) authorized by the statute and Budget Act Control Section 12.30 to offer for emergency situations.