--%>

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 : Legal factors to restrict a corporation

    Are there any legal factors which could restrict a corporation in its attempt to pay cash dividends to common stockholders? Describe. A firm may be legally limited as to the dividends it can pay through existing bond indentures or loan agreemen

  • Q : Explain Encumbrance Encumbrance : The

    Encumbrance: The commitment of all or portion of an appropriation for future expenses. The Encumbrances symbolize commitments associated to unfilled purchase orders or unfulfilled contracts. Exceptional encumbrances are recognized as budgetary expense

  • Q : Cause-and-effect chain Normal 0 false

    Normal 0 false false

  • Q : Define Legislative Counsel Digest

    Legislative Counsel Digest: The summary of what a legislative measure does contrasting the existing law and the proposed change. This summary emerges on the first page of the bill.

  • Q : Explain Generally Accepted Accounting

    Generally Accepted Accounting Principles (GAAP): The accounting rules, principles, conventions, and procedures which are employed for accounting and financial reporting. The GAAP for governments are put by the Governmental Accounting Standards Board (

  • Q : What is an Agency Agency: It is a legal

    Agency: It is a legal or official reference to a government association at any level in the state organizational hierarchy. Or Government organizations belong to the highest sta

  • Q : Increased common stock cash dividend

    Do you trust an increased common stock cash dividend can send any signal to the common stockholders? If so, what signal might it send? An increase in cash dividends is frequently seen as a positive signal. A company would be unlikely to raise

  • Q : Gateways for biometric The different

    The different Gateways for biometric are as following: Transaction security: this is to secure customers transactions and so to protect their privacy both remotely and onsite.

  • Q : Illustrate a market of fictitious

    Illustrate a market wherein the equilibrium dollar price of one unit of fictitious currency Zee is $5 (the exchange rate is $5 = Z1). Then illustrates on your diagram a decline in the demand for Zee. a. Referring to this diagram, d

  • Q : What is Debt Service Debt Service : The

    Debt Service: The amount (sum) of money needed to pay interest on exceptional bonds and the principal of maturing bonds.