--%>
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 : Define the term Chapter Chapter : The

    Chapter: The reference allotted by the Secretary of State to an enacted bill, numbered in sequence in order of enactment each calendar year. The enacted bill is then termed to by this "chapter" number and the year in which it became law. For illustrat

    		•
  • Q : What is a Provision Provision : The

    Provision: The language in a bill or act which imposes necessities or constraints on actions or expenditures of the state. The provisions are frequently employed to constrain the expenditure of appropriations however it might also be employed to give

    		•
  • Q : Explain Plan of Financial Adjustment

    Plan of Financial Adjustment (PFA): This is the plan proposed by a department, accepted by the Department of Finance, and acknowledged by the State Controller's Office (SCO), to allow the SCO to assign costs paid from one item to one

    		•
  • 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 : Describe present value of the firms

    Describe the term "present value of the firm's operations" (also known as Enterprise Value). What does this number expose? The current value of the company's free cash flows reveals the market value of the firm's core income generating operatio

    		•
  • Q : How would the market price of a bond be

    All other things held constant, how would the market price of a bond be influenced if coupon interest payments were made semiannually rather than annually?Most of bonds issued in the United States pay interest semiannually (twice per year). Alo

    		•
  • 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 : 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 : Explain Conference Committee Conference

    Conference Committee: It is a committee of three members (that is two from the majority party and one from the minority party) from each house, appointed to gather and resolve differences among versions of a bill (example, when one house of the Legisl

    		•
  • Q : Define the term Unencumbered Balance

    Define the term Unencumbered Balance: It is the balance of an appropriation not so far committed for particular purposes.

    		•