--%>
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 : How management incorporated in proforma

    Describe how management aims are incorporated into proforma financial statements.Management decide a target goal, and forecasters generate proforma financial statements under the assumption that the goal will be

    		•
  • Q : Domestic supply and demand diagram

    Normal 0 false false

    		•
  • Q : Explain Unscheduled Reimbursements

    Unscheduled Reimbursements: The Reimbursements collected by an agency which were not budgeted and are accounted for by an individual reimbursement class of an appropriation. To expend unscheduled reimbursements, the budget revision sh

    		•
  • Q : Recognizes and state the significance

    Normal 0 false false

  • Q : Reducing payroll costs It is likely

    It is likely that in the next few years, employers will face incresing pressures to reduce their payroll costs. critically evaluate the range of ways by which payroll costs can be reduced whilst taking into account the need to maintain a focus on the

    		•
  • Q : What is Reference Code Reference Code :

    Reference Code: A three-digit code recognizing whether the item is from the Budget Act or some other source (example, legislation), and its character (example, state operations). This is the middle segment of the budget item or appropriation number.

    		•
  • Q : Which ratios would banker is most

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

    		•
  • Q : Describe patterns of cash flows for

    Describe two patterns of cash flows for a share of common stock. How does the market find out the value of the most common cash flow pattern for common stock?Cash flows for share of common stock contain dividend payments and the price attained f

    		•
  • Q : Laffer Curveand its association to

    Normal 0 false false

  • Q : Legal factors to restrict a corporation

    Are there any legal factors which could restrict a corporation in its attempt to pay cash dividends to common stockholders? Describe. A firm may be legally limited as to the dividends it can pay through existing bond indentures or loan agreemen

    		•