--%>
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 : Formula for the payment required for a

    Normal 0 false false

    		•
  • Q : Supply and demand 1. Albert Jones went

    1. Albert Jones went to his local department store to purchase a pair of Levi s. He thought that the style of Levi that he wanted would sell for about $30 a pair. When he got to the store, he saw a sign which said, Levi s, all styles, $18 a pair. Albert bought three pairs of Levi s. The behavior of

    		•
  • Q : Define operating leverage effect and

    Define operating leverage effect and what causes it? Describe potential benefits and negative consequences of high operating leverage? The operating leverage effect is the phenomenon where a small change in sales triggers a comparatively large

    		•
  • Q : Production at a point outside the

    Normal 0 false false

  • Q : Define Price Increase Price Increase :

    Price Increase: Budget adjustment to reflect the inflation factors for particular operating expenses constant with the budget instructions from the Department of Finance.

    		•
  • Q : Determine per unit cost of production

    Normal 0 false false

  • Q : Describe the benefits of paying late

    Describe the benefits of "paying late" (but not too late) and how do companies try to do this? Since money has time value, the later cash is paid, but not too late, the better. Companies employ remote disbursement banks to facilitate holding at

    		•
  • Q : Define Workload Workload : The

    Workload: The measurement of rises and reduces of inputs or demands for work, and an ordinary basis for projecting related budget requires for both established and new programs. This approach to BCPs is frequently viewed as an alternative to outcome o

    		•
  • Q : Cyclical unemployment Suppose that in a

    Suppose that in a specific year the natural rate of unemployment is 5 percent and the actual rate of unemployment is 9 percent. Employ Okun's law to fin out the size of the GDP gap in percentage-point terms. If the nominal GDP is $500 billion in that year, how much ou

    		•
  • 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.  <

    		•