--%>

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 : Analysis On Financial Indices On a

    On a weekly basis, starting from week ending on 18/1, you need to produce a weekly performance report of the major indices around the world following this structure:  Currencies a. USD vs Yen, vs GBP(GBP/USD), vs. Swiss Franc (USD/CHF) b. Euro vs USD, Y

  • Q : Summer Co. is expected to pay a

    Summer Co. is expected to pay a dividend or $4.00 per share out of earnings of $7.50 per share. If the required rate of return on the stock is 15% and dividends are growing at a current rate of 10% per year, calculate the present value of the growth opportunity for the stock (PVGO)

  • 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 : What is Revenue Revenue : Any adding up

    Revenue: Any adding up to cash or other current assets which does not raise any liability or reserve and does not symbolize the reduction or recovery of expenditure (example, reimbursements or abatements). Revenues are a kind of receipt usually derive

  • 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 : Define Performance Budget Performance

    Performance Budget: A budget in which proposed expenditures are prepared and tracked mainly by measurable performance objectives for actions or work programs. The performance budget might also incorporate other bases of expenditure categorization, lik

  • Q : Explain Administratively Established

    Administratively Established Positions: The positions authorized by the Department of Finance throughout a fiscal year that were not comprised in the Budget and are essential for workload or administrative reasons. These positions fin

  • Q : Advantages and disadvantages of working

    Describe the advantages and disadvantages of the aggressive working capital financing approach? An aggressive working capital financing approach generally results in a lower cost of funds for a firm however a higher level of risk.

  • Q : Define the term Baseline Adjustment or

    Define the term Baseline Adjustment or  Baseline Budget: Baseline Adjustment: Also termed to as Workload Budget Adjustment.

    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