--%>
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 are financial trades made in an

    How are financial trades made in an over the counter market?On the contrary to the organized exchanges that have physical locations, the over the counter market contain no fixed location, or more accurately, it is everywhere. The over the counte

    		•
  • 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 : Define Warrant Warrant : It is an order

    Warrant: It is an order drawn by the State Controller directing the State Treasurer to reimburse a particular amount, from a specific fund, to the entity or person named. A warrant usually corresponds to a blank check however is not essentially payabl

    		•
  • Q : Compare and contrast the book value and

    Compare and contrast the book value & liquidation value per share for common stock. Is one method more reliable? Describe.The Book Value of a firm's common stock is found by subtracting the value of the firm's liabilities, and preferred stoc

    		•
  • Q : Explain Expenditures by Category

    Expenditures by Category: A budget display, for each and every department, which reflects actual precedent year, estimated present year, and proposed budget year expenses presented by the character of expenditure (example, State Operations and/or Loca

    		•
  • Q : Describe security Normal 0 false false

    Normal 0 false false

    		•
  • Q : Alphas balance of payments Normal 0

    Normal 0 false false

    		•
  • Q : Microeconomics or macroeconomics Denote

    Denote whether each of statements applies to microeconomics or macroeconomics: a. In Canada, the unemployment rate was 7.0 percent in January 2005. b. A Canadian software firm d

    		•
  • Q : Define Limited-Term Position

    Limited-Term Position (LT): Any place that has been authorized only for a particular length of time with a set termination date.Limited-term positions might be authorized throughout the budget procedure or in transactions approved by the D

    		•
  • 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

    		•