--%>
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 : Factors affecting option of maximum

    Describe the factors affecting the alternative of a maximum cash balance amount. The maximum cash balance amount is finding out by obtainable investment opportunities, the expected return on investments, and the transaction cost of making invest

    		•
  • Q : How do mergers influence communities

    How do mergers influence communities?While a locally controlled bank is merged into a bank headquartered elsewhere (an out-of-market merger), some of the apprehension regarding the institution's future commitment to the local community is bound

    		•
  • Q : What is Sunset Clause Sunset Clause :

    Sunset Clause: The language contained in a law which states the expiration (termination) date for that statute.

    		•
  • 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 : Present value influenced by change in

    Normal 0 false false

  • Q : What is FERA FERA stands for The

    FERA stands for The Federal Emergency Relief Administration. The program was renamed as a direct relief operation in Roosevelt Administration. It was a form of an unemployment insurance.

    		•
  • Q : Government requirements imposed on

    Describe some of the government requirements imposed onto a public corporation which are not imposed on a private, intimately held corporation? Public corporations ought to submit audited financial statements to the government for release to the

    		•
  • Q : What is Proposition 98 Proposition 98 :

    Proposition 98: An initiative passed in the year November 1988, and amended in the year June 1990 election, which provides a minimum funding guarantee for school districts, community college districts, and other state agencies which give direct elemen

    		•
  • Q : Changes in equilibrium GDP caused by

    Normal 0 false false

  • Q : What is Debt Financing Debt Financing :

    Debt Financing: Whenever a firm raises money for the working capital or capital expenses by selling bonds, bills, or notes to individual and or institutional investors. In return for lending money, the individuals or institutions become creditors and

    		•