--%>
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 : Describe why measure projects risk as

    Describe why we measure a project's risk as the change in the CV.We measure a project's risk since the change in the coefficient of variation since this focuses on the change in the riskiness of the firm's existing portfolio.

    		•
  • Q : Would there be positive interest rates

    Normal 0 false false

    		•
  • Q : What is Legislative Analysts Office

    Legislative Analyst’s Office (LAO): A non-partisan organization which gives advice to the Legislature on the fiscal and policy matters. For illustration, the LAO annually publishes a full analysis of the Governor's Budget and this document becom

    		•
  • Q : Law of rising opportunity costs Normal

    Normal 0 false false

  • 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 : Selection of board of directors of

    How are the members of the board of directors of corporation selected and to whom do these board members owe their prime allegiance? Members of corporation's board of directors are chosen by the common stockholders and owe their allegiance to th

    		•
  • Q : What is Budget Act Budget Act (BA): The

    Budget Act (BA): The annual statute authorizing state departments to use up appropriated funds for the aims stated in the Governor's Budget and improved by the Legislature.

    		•
  • Q : Reimbursement Warrant or Revenue

    Reimbursement Warrant (or Revenue Anticipation Warrant): A warrant which has been sold by the State Controller’s Office, as an outcome of a cash shortage in th

    		•
  • Q : Define Cost-of-Living Adjustments

    Cost-of-Living Adjustments (COLA): Increases offered in state-funded programs which comprise periodic adjustments predetermined in state law (statutory, like K-12 education apportionments), or established at optional levels (that is discretionary) by

    		•
  • Q : What is Continuing Appropriation

    Continuing Appropriation: This is an appropriation for the set amount which is obtainable for more than 1-year.

    		•