--%>

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 cost of equity Intermediate

    Intermediate Finance   Always leave 4 decimals in the ($) numbers in your calculations (e.g. PMT = $10.8924) and, particularly, 6 decimals for interest rates (e.g. r = 0.078643 or 7.8643%). QUESTION 1:?Conlins Manufactu

  • Q : What is a Provision Provision : The

    Provision: The language in a bill or act which imposes necessities or constraints on actions or expenditures of the state. The provisions are frequently employed to constrain the expenditure of appropriations however it might also be employed to give

  • Q : Define Final Budget Summary Final

    Final Budget Summary: A document generated by the Department of Finance subsequent to enactment of the Budget Act that reflects the Budget Act, any vetoes to the language and/or appropriations, technical corrections to the Budget Act, and summing up t

  • Q : Explain Public Service Enterprise Fund

    Public Service Enterprise Funds: For legal base accounting purposes, the fund categorization which identifies funds utilized to account for the transactions of self-supporting enterprises which render goods or services for a direct charge to user (tha

  • Q : How does depreciation influence cash

    Normal 0 false false

  • Q : Revision Order #2 Hello, You folks

    Hello, You folks recently completed an order for me. I'm very impressed and much thanks in advance. I'd like to submit more problems (8 attached) if you can have the same expert work on these please? Some of the #'s were slightly modified from my previous order, so should be easier than starting

  • Q : Fin 235 Personal Finance Homework Fin

    Fin 235 Personal Finance Homework Chapter 8: Problems: 1, 3, 5, 7 1.   Most home insurance policies cover jewelry for $1,000 and silverware for $2,500 unless items are covered with additional insurance. If a family

  • Q : How management incorporated in proforma

    Describe how management aims are incorporated into proforma financial statements.Management decide a target goal, and forecasters generate proforma financial statements under the assumption that the goal will be

  • Q : Purchasing power parity of US and

    Under what condition would the U.S. dollar and the Canadian dollar said to be have achieved purchasing power parity? The U.S. dollar and the Canadian dollar would be assumed to have achieved purchasing power parity while the exchange rate reflec

  • Q : Describe Section 28.00 Section 28.00 :

    Section 28.00: It is a Control Section of Budget Act which authorizes the Director of Finance to support the augmentation or diminution of items of expenditure for the receipt of un-anticipated federal funds or other non-state funds, and which identif