--%>

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 : What are A-pages A-pages : An ordinary

    A-pages: An ordinary reference to the Governor's Budget synopsis. The Budget highlights now contained in the Governor's Budget synopsis were just once contained in front of the Governor's Budget on pages A-1, A-2, and so on, and were,

  • Q : Pros and cons of commercial paper

    Describe pros and cons of commercial paper associated to bank loans for a company seeking short-term financing? Usually commercial paper is a cheaper source of short-term financing for a firm, compared to bank loans. Also, a larger amount of fu

  • Q : What is Final Budget Final Budget :

    Final Budget: Usually refers to the Governor’s Budget as amended by actions taken on the Budget Bill (example, legislative changes, and Governor’s vetoes). Note

  • Q : What is Department Department: The

    Department: The governmental organization, generally belonging to the third level of the state organizational hierarchy as stated in the Uniform Codes Manual.

  • Q : Why coefficient of variation is better

    Why is the coefficient of variation frequently a better risk measure while comparing different projects than the standard deviation?Whenever we desire to compare the risk of investments which have different means, we employ the coefficient of va

  • Q : Define Financial Controls Financial

    Financial Controls: Any measure of how fine a company or department controls its costs, at times stated as how far beneath or over budget it is. Financial controls are a critical portion of any financial system. They make sure that the resources are b

  • 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 : Which ratios would banker is interested

    Which ratios would banker is most interested while assuming whether to approve an application for short-term business loan? Illustrate.Bankers and other lenders employ liquidity ratios to distinguish whether to extend short-term credit to a firm

  • Q : Mergers encourage the formation of new

    Do mergers encourage the formation of new banks? Yes. The increase in the number of new banks in the second half of the 1990s coincides with a surge in merger activity in the similar period. A study conducted through the Federal Reserve Bank of

  • Q : Describe factors affecting minimum cash

    Describe the factors affecting the option of a minimum cash balance amount. The minimum cash balance amount is find out by how easy it is to increase funds when needed, how predictable the cash flows are, and how risk averse managers are.