--%>
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 : Analysis on Financial Manangement

    Questions 1: (1) Your coin collection contains 40 1957 silver dollars. If your grandparents purchased them for their face value when they were new, how much will your collection be worth when you retire in 2040, assuming they appreciate at a 10 percent annual rate? <

    		•
  • Q : Explain State-Mandated Local Program

    State-Mandated Local Program: The state compensations to local governments for the cost of activities needed by legislative and executive acts. This reimbursement necessity was established, Statutes of 1972 (SB 90) and further approved by the adoption

    		•
  • Q : What is Change Book System Change Book

    Change Book System: The system the Department of Finance employs to record all the legislative modifications (comprising changes stated by the Administration and approved by the Legislature) made to the Governor's Budget and the last actions on the bu

    		•
  • Q : Explain Generally Accepted Accounting

    Generally Accepted Accounting Principles (GAAP): The accounting rules, principles, conventions, and procedures which are employed for accounting and financial reporting. The GAAP for governments are put by the Governmental Accounting Standards Board (

    		•
  • 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 : Explain Category Transfer Category

    Category Transfer: It is a permitted transfer between categories or functions within the similar schedule of an appropriation. These transfers are currently authorized by Control Section 26.00 of the Budget Act (and proceeding to 1996-97, by Section 6

    		•
  • Q : Explain marginal cost of capital

    Explain marginal cost of capital schedule (MCC)? Is the schedule always horizontal line? Describe. The marginal cost of capital schedule is graphic depiction of the weighted average cost of capital at distinct levels of financing. The MCC sch

    		•
  • Q : Explain Budget Bill Budget Bill : The

    Budget Bill: The legislation symbolizing the Governor’s proposal for spending authorization for the subsequent fiscal year. The Budget Bill is all set by the Department of Finance and submitted to each house of the Legislature i

    		•
  • Q : What is Statute Statute: It is a

    Statute: It is a written law enacted by the Legislature and signed by the Governor or a vetoed bill overridden by a 2/3 vote of both houses), generally referred to by its chapter number and the year in which it is passed. The statutes which modify a s

    		•
  • Q : Describe who owns a credit union

    Describe who owns a credit union? Credit unions are owned through their members. While credit union members put money in their credit union, they are not "depositing" the money technically.  In spite of, they are purchasing shares of the cr

    		•