--%>
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 : What do you mean by the term Year of

    Year of Appropriation (YOA): It refers to the initial year of an appropriation.

    		•
  • Q : What is Appropriation Schedule

    Appropriation Schedule: The detail of an appropriation (example, in the Budget Act), exhibiting the distribution of the appropriation to each of the class, programs, or projects thereof.

    		•
  • Q : What is Statute Statute: It is a

    Statute: It is a written law enacted by the Legislature and signed by the Governor or a vetoed bill overridden by a 2/3 vote of both houses), generally referred to by its chapter number and the year in which it is passed. The statutes which modify a s

    		•
  • Q : What is Out-of-State Travel blanket

    Out-of-State Travel (OST) blanket: The request by a state agency for Governor’s Office approval of the proposed out-of-state trips to be taken by that agency’s personnel throughout the fiscal year.

    		•
  • Q : Determine the new per unit cost of

    Normal 0 false false

  • Q : Financial crisis during 1997-1998

    Describe the Financial crisis during the time period of 1997-1998 ?

    		•
  • Q : Conditions in which warrants value high

    Under what conditions is a warrant's value high? Describe. A warrant's value would be great when the stock price, time to expiration, and/or expected stock price volatility is great.

    		•
  • Q : Describe Form 9 Form 9 : It is the

    Form 9: It is the request by department for space planning services (example, new or extra space lease extensions, or renewals in non-institutional) and also evaluated by the Department of Finance.

    		•
  • Q : Define Obligations Obligations : The

    Obligations: The amounts that a governmental unit might legally be needed to pay out of its resources. Budgetary authority should be obtainable before obligations can be formed. For budgetary aims, obligations comprise payables for goods or services r

    		•
  • Q : Can a corporation contain too much

    Can a corporation contain too much working capital? Describe. A firm can contain too much working capital if this is losing the chance to invest in high returning fixed assets and if this goes beyond the amount of working capital required for r

    		•