--%>
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 : Value $100 is received at the beginning

    $100 is received at the beginning of year 1, $200 is received at the beginning of year 2, and $300 is received at the beginning of year 3. If these cash flows are deposited at 12 percent, their combined future value at the end of year 3 is

    		•
  • Q : What is the Character of Expenditure

    Character of Expenditure: A classification recognizing the major purpose of expenditure, like State Operations, Local Assistance, Capital Outlay, or Unclassified.

    		•
  • Q : Assignments i want to write final state

    i want to write final state report. My state is Texas. You can use the resources that i attached, also you can use another resources to cover the outlines.

    		•
  • Q : Production possibilities curve based

    Given is a production possibilities table for consumer goods (automobiles) and capital goods (forklifts): Illustrates these data graphica

    		•
  • Q : Bonds and coupon rate Staind, Inc., has

    Staind, Inc., has 8 percent coupon bonds on the market that have 15 years left to maturity. The bonds make annual payments. If the YTM on these bonds is 9 percent, what is the current bond price?

    		•
  • Q : Explain Legislative Information System

    Legislative Information System (LIS): An on-line system formed and employed by the Department of Finance to maintain existing information regarding all bills introduced in the Assembly and Senate for the current 2-year session, and fo

    		•
  • Q : Making capital structure decisions In a

    In a perfect capital market, what advice would you give a corporate financial manager on making capital structure decisions? Justify your advice. How and why would your advice change as real world capital market imperfections are introduced?

    Q : Four-Tranche Sequential-Pay Structure

    1. How would you fund the tranche Z of the example in the securitization manual? 2. What reinvestment rate from the excess spread will guarantee that there will be sufficient money to pay0ff creditors of tranche Z? 3. When tranche Z creditors will get

    		•
  • Q : Define Organization Code Organization

    Organization Code: The four-digit code allotted to each state governmental entity (and at times to exclusive budgetary programs) for fiscal system aims. The organization code is the initial segment of the budget item or appropriation

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

    		•