--%>

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 Availability Period

    Availability Period: The time period throughout which an appropriation might be encumbered (that is, committed for expenditure), generally specified by the law making the appropriation. When no particular time is given in financial legislation, the pe

  • Q : What is Financial Restructuring

    Financial Restructuring: It is the reorganizing of a business' liabilities and assets. The procedure is frequently related with corporate restructuring where an organization's on the whole structure and its processes are refurbished. Though companies

  • Q : Explain Administration Program Costs

    Administration Program Costs: It is the indirect cost of a program, usually a share of the costs of the administrative units serving the whole department (example, the Director's Office, Personnel, Legal, Accounting, and Business Serv

  • Q : Fiscal policy Normal 0 false false

    Normal 0 false false

  • Q : Explain State-Mandated Local Program

    State-Mandated Local Program: The state compensations to local governments for the cost of activities needed by legislative and executive acts. This reimbursement necessity was established, Statutes of 1972 (SB 90) and further approved by the adoption

  • Q : What are Federal Funds Federal Funds :

    Federal Funds: For legal basis budgeting purposes, categorization of funds into which the money received in trust from an agency of the federal government will be deposited and finished by a state department in accordance with state and/or federal rul

  • Q : Define the term Program Cost Accounting

    Program Cost Accounting (PCA): The level of accounting which identifies costs by activities executed in achievement of a purpose in contrast to the traditional line-item format. The aim of accounting at this level is to generate cost data adequately a

  • 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 : Laffer Curveand its association to

    Normal 0 false false

  • Q : What are Feeder Funds Feeder Funds :

    Feeder Funds: For lawful basis accounting purposes, funds into which some taxes or fees are deposited on collection. In some situations administrative costs, collection expenses, and refunds are paid. The balance of such funds is transferable at any t