--%>
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 : Why do analysts compute financial ratios

    Why do analysts compute financial ratios? Ratios are comparative measures.  Since the ratio illustrates relative value, they let financial analysts to compare information which could not be compared in its raw form.  For instance, rati

    		•
  • Q : What is Fiscal Year Fiscal Year (FY):

    Fiscal Year (FY): Twelve-month periods throughout which income is earned and received, compulsions are incurred, encumbrances are prepared, appropriations are expended, and for which the other fiscal transactions are recorded. In Cali

    		•
  • Q : Assignments i want to write final state

    i want to write final state report. My state is Texas.

    		•
  • Q : What do you mean by Authorized What do

    What do you mean by Authorized: Provided the force of law (example, by statute). For certain action or quantity to be authorized, it should be possible to recognize the enabling source and date of approval.

    		•
  • Q : What is Capital Outlay Capital Outlay

    Capital Outlay (CO): A character of expenses of funds to obtain land, plan and build new buildings, expand or transform existing buildings, and/or purchase tools associated to such construction.

    		•
  • Q : Why warrants are hardly exercised

    Describe why warrants are hardly ever exercised unless the time to maturity is small? Warrants are hardly ever exercised until the time to expiration is small since the market price of the warrant is higher than the exercise value. The holder o

    		•
  • Q : What is Abolishment of Fund Abolishment

    Abolishment of Fund: It is a closure of fund pursuant to the operation of law. The funds might also be administratively eliminated by the Department of Finance with the concurrence of the State Controller’s Office. Whenever a sp

    		•
  • Q : What is Proposition 98 Proposition 98 :

    Proposition 98: An initiative passed in the year November 1988, and amended in the year June 1990 election, which provides a minimum funding guarantee for school districts, community college districts, and other state agencies which give direct elemen

    		•
  • 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 : What is Amendment Amendment : A

    Amendment: A proposed or customary change to a bill in the Legislature, the California Constitution, acts passed by the Legislature, or ballot initiative.

    		•