--%>
Assignment Help - homework help

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 : How does preemptive right secure

    How does a preemptive right secure the interests of present stockholders? A preemptive right secure the interests of existing stockholders through giving them the chance to preempt other investors into the purchase of new shares. If these right

    		•
  • Q : Describe the Hirfindahl-Hirschman Index

    Describe the Hirfindahl-Hirschman Index?The Hirfindahl-Hirschman Index, or HHI, is the standard measure employed by economists to evaluate market concentration. The greater the level of concentration amongst competitors, the higher the HHI. The

    		•
  • Q : Reducing payroll costs It is likely

    It is likely that in the next few years, employers will face incresing pressures to reduce their payroll costs. critically evaluate the range of ways by which payroll costs can be reduced whilst taking into account the need to maintain a focus on the

    		•
  • Q : What is Department Department: The

    Department: The governmental organization, generally belonging to the third level of the state organizational hierarchy as stated in the Uniform Codes Manual.

    		•
  • Q : Explain Supplement-Schedule 7A

    Supplement (Schedule 7A): In such documents, for precedent year, authorized positions symbolize the number of real positions filled for that year. For present year, authorized positions comprise all regular ongoing positions accepted in the Budget Act

    		•
  • Q : Describe the fact of common

    Normal 0 false false

  • Q : Define Cash Basis of Accounting Cash

    Cash Basis of Accounting: The base of accounting in which expenditures and revenues are recorded whenever cash is received or distributed.

    		•
  • Q : Define Revolving Fund Revolving Fund :

    Revolving Fund: Usually refers to a cash account termed as an office revolving fund (ORF). This is not a fund however an advance from an appropriation. The agencies might use the cash advance to pay out ORF checks for instant requirements, as specifie

    		•
  • Q : Describe the P-E valuation method

    Describe the P/E valuation method. Under what conditions a stock should be valued by using this method?The P/E ratio denotes how much investors are keen to pay for each dollar of a stock's earnings. A high P/E ratio denotes that investors belie

    		•
  • Q : Have mergers influenced competition

    Have mergers influenced competition?Federal Reserve data illustrates that measured on the local level, where competition takes place; markets have in fact experienced more banking competition, not less, in the past decade.

    		•