--%>
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 : Association of net present value to

    Normal 0 false false

    		•
  • Q : Question based on consolidated balance

    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 : Why accounting profits and cash flows

    Normal 0 false false

    		•
  • Q : Question based on multiplier Normal 0

    Normal 0 false false

  • Q : Why too little debt is as unwanted as

    If an optimal capital structure exists, describe reasons why too little debt is as unwanted as is too much debt? Too little debt may be as unwanted as too much debt since if a firm contains a very conservative capital structures it may be losing

    		•
  • Q : Define Fund Balance Fund Balance : For

    Fund Balance: For accounting aims, the excess of a fund’s assets over its liabilities. And for budgeting aims, the surplus of a fund’s resources over its expenses.

    		•
  • 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 : Describe Schedule 10 Schedule 10 :

    Schedule 10: (Supplementary Schedule of Appropriations): The Department of Finance control document listing all the appropriations and allocations of funds accessible for expenditure throughout the past, present, and budget years. Such documents are s

    		•
  • Q : Describe factors which common

    Describe some factors which common stockholders consider while deciding how much, if any, cash dividends they want from the corporation wherein they have invested? Common stockholders would assume the company's investment opportunity, their requ

    		•