--%>
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 : Example-implicitly-weighed marginal

    Cite three example of recent decisions which you made in which you, at least implicitly, weighed marginal costs & marginal benefits.

    		•
  • 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 : What is Prior Year Adjustment Prior

    Prior Year Adjustment: An adjustment for the difference among prior year accruals and real expenditures or revenues. The previous year adjustment amount is usually comprised in the Fund Condition Statements as an adjustment to realign the starting fun

    		•
  • Q : What is Special Items of Expense

    Special Items of Expense: It is an expenditure category which covers nonrecurring big expenditures or special aim expenditures which usually need a separate appropriation (or else need separation for clarity).

    		•
  • Q : Describe Treasury bill Describe

    Describe Treasury bill? How risky is it?Treasury bills are short term debt instruments issued through the U.S. Treasury which are sold at a discount and pay face value at maturity.  They are very close to risk-free as they are backed throug

    		•
  • Q : Make out this new balance sheet Normal

    Normal 0 false false

  • 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 : Advantages of corporation in countries

    Describe some primary advantages while a corporation has operations in countries other than its home country? Explain risks? Foreign operations may decrease a company's labour or material costs, and may raise its sales. Risks comprise possible

    		•
  • Q : Define Bill Bill : It is a draft of

    Bill: It is a draft of proposed law represented to the Legislature for performance. (A bill has bigger legal formality and standing than a resolution.) OR An invoice, or document statement, of an amount owing for s

    		•
  • Q : Production possibilities curve based

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

    		•