--%>
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 Baseline Adjustment or

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

    Q : What is State Operations State

    State Operations (SO): It is a character of expenditure symbolizing expenditures for the support of state government, exclusive of capital investments and expenses for the local assistance actions.

    		•
  • Q : Expected rate of return Normal 0 false

    Normal 0 false false

    		•
  • 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 : Short run and long run influence Normal

    Normal 0 false false

  • Q : Describe Schedule 10R Schedule 10R

    Schedule 10R (Supplementary Schedule of Revenues and Transfers): The Department of Finance control document replicating information for transfers, revenues, and inter-fund loans for the past, present, and budget years. Schedule 10Rs i

    		•
  • Q : Define Trigger Trigger : An event which

    Trigger: An event which causes an action or actions. The triggers can be active (like pressing the update key to validate input to a database) or passive (like a tickler file to repeat of an activity). For illustration, budget "trigger" mechanisms hav

    		•
  • 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 : 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 : Describe the primary variables in EOQ

    Describe the primary variables being balanced in the EOQ inventory model? Clarify In the EOQ model the primary variables being balanced are carrying costs and ordering costs. The more frequent orders are placed the lower the firm's carrying co

    		•