--%>

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 : What is the efficiency factor Normal 0

    Normal 0 false false

  • Q : Explain Department of Finance

    Department of Finance (Finance): The Director of Finance functions as the Governor’s chief fiscal policy advisor with the emphasis on financial integrity of the state. Finance is delegated the accountability for preparation of the Governor's Bud

  • Q : Describe working capital Describe

    Describe working capital? Working capital contains the current assets of the firm.

  • Q : Which insurance company takes on the

    Which kind of insurance company usually takes on the greater risks: a life insurance company or a property and casualty insurance company? The risks sheltered against by property and casualty companies are much less predictable than are the risk

  • Q : Which ratios would long-term bond

    Which ratios would a potential long-term bond investor is most interested in? Describe. Current & potential lenders of long-term funds, such like banks & bondholders, are interested in debt ratios. While a business's debt ratios rise sig

  • Q : What are Staff Benefits Staff Benefits

    Staff Benefits: It is an object of expenditure symbolizing the state costs of contributions for employee’s retirement, health benefits, OASDI, and non-industrial disability leave advantages.

  • Q : Creative destruction Normal 0 false

    Normal 0 false false

  • Q : Define Augmentation Augmentation : An

    Augmentation: An authorized raise to a formerly authorized appropriation or allotment. This augment can be authorized by the Budget Act provisional language, control sections, or other legislation. Generally a Budget Revision or an Ex

  • Q : What are Governmental Cost Funds

    Governmental Cost Funds: For lawful basis accounting and budgeting aims, funds which derive revenue from the taxes, licenses, and fees.

  • Q : Define Budget Budget : It is a plan of

    Budget: It is a plan of operation stated in terms of financial or other resource necessities for a particular period of time.