--%>
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 : Explain Object of Expenditure Object of

    Object of Expenditure (Objects): It is a categorization of expenditures based on the kind of goods or services received. For illustration, the budget group of Personal Services comprises the objects of Salaries and Wages and Staff Benefits.

  • Q : Disadvantages of the Finger print

    Disadvantages of the Finger print technique: Health concerns while touching the sensor which is being touched by many number of individuals. Sometimes due to age and occupation may cause some diff

    		•
  • Q : Decision rule using internal rate of

    Describe decision rule for accepting or rejecting proposed projects while using internal rate of return? Whenever the internal rate of return is greater than or equal to the required rate of return, the hurdle rate, the project is accepted. Whi

    		•
  • Q : Market share of large bank holding

    Have the large bank holding companies enhanced their market share at the cost of smaller institutions?No. A study conducted through the Federal Reserve Bank of New York reveals that the increase in the concentration of assets is primarily becaus

    		•
  • Q : Midterm Exam for FIN 6000 Please

    Please complete the midterm exam independently.  Don't discuss it with other students in the class.  Please email me if you have any clarifying questions.  <

    		•
  • Q : How are financial trades made on a

    How are financial trades made on a planned exchange?Each of exchange listed security is traded at a particulate location on the trading floor called the post. The trading is supervised through specialists who act either as brokers (bringing toge

    		•
  • Q : Question on budget line On a Lotto

    On a Lotto Canada ticket A person won $15 at the local 7-Eleven & decided to spend all the winnings money on bags of peanuts and candy bars. The cost of candy bars= $.75 and the cost of peanuts = $1.50. a. In general, how woul

    		•
  • Q : Negative consequences of company

    Explain negative consequences of a company holding too much cash? A company holding too much cash would be giving up the chance to invest more in income generating assets

    		•
  • Q : Define the term Baseline Adjustment or

    Define the term Baseline Adjustment or  Baseline Budget: Baseline Adjustment: Also termed to as Workload Budget Adjustment.

    Q : State Section 31.00 Section 31.00 : It

    Section 31.00: It is a Control Section of Budget Act which specifies some administrative procedures. For illustration, the section subjects to the Budget Act appropriations to different sections of the Government Code, restricts the new positions a de

    		•