--%>

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 : State time dimensions State time

    State time dimensions of the income statement, the balance sheet, and the statement of cash flows?  Describe. The income statement is such as a video: This measures a firm's profitability on a period of time (that can be a week, a

  • Q : Examples of high debt levels companies

    Give two instances of types of companies which would be best able to handle high debt levels.Companies which handle local telephone service and those which handle natural gas delivery to consumers would be assumed to comfortably be able to handl

  • 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 : Fixed Income I need solution by Tuesday

    I need solution by Tuesday evening March 18, 6 pm EST

  • Q : Production at a point outside the

    Normal 0 false false

  • Q : Describe sunk cost Describe sunk cost?

    Describe sunk cost? Is it relevant while evaluating a proposed capital budgeting project? Describe. A sunk cost is a cash flow which has already occurred, or that will take place, whether a project is accepted or discarded. It is irrelevant wh

  • Q : Define Reserve Reserve: The amount of a

    Reserve: The amount of a fund balance set sideways to give for expenditures from the unencumbered balance for ongoing appropriations, future apportionments, and economic uncertainties, pending salary or price raise appropriations, and appropriations f

  • Q : Advantages of finger prints biometric

    Advantages of finger prints biometric technique: Easy to use and very little training is used No space is required for the installation Large amounts of existing data to allow background list check Has proven effect

  • Q : Explain computing of payback period How

    How do we compute the payback period for proposed capital budgeting project? What are the basic criticisms of the payback method? We compute the payback period for proposed project through adding a project's positive cash flows, one period at t

  • Q : Define Workload Workload : The

    Workload: The measurement of rises and reduces of inputs or demands for work, and an ordinary basis for projecting related budget requires for both established and new programs. This approach to BCPs is frequently viewed as an alternative to outcome o