Order Quantity-Cycle Inventory-Safety Inventory

Consider the following data pertaining to a distribution center. 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
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 :Frequency Distribution What is

What is Frequency Distribution? Compare Categorical Frequency Distribution, Ungrouped Frequency Distribution, Grouped Frequency Distribution?

• ##### Q :Price Earning ratio Define the term

Define the term Price Earning ratio and how it is calculated?

• ##### Q :Make mutual and stockholder-owned

Compare and make mutual and stockholder-owned savings and associations of loan.
Some savings and loan associations are owned through stockholders, just as commercial banks and other corporations are owned through their stockholders.  Other

• ##### Q :Define Appropriations Limit

Appropriations Limit, State (SAL): The constitutional limit on the expansion of some appropriations from tax proceeds usually set to the level of the previous year's appropriation limit as adjusted for modifications in cost of living

• ##### Q :Shares Assignment Mina Patel has seen

Assignment Mina Patel has seen attractive advertisements for Dixons Retail plc and its UK-based brands. She is also aware of the intense competition between retailers of electronic and electrical goods, at a time of global economic uncertainty. Mina has recently inherited several thousand pound

• ##### Q :How do mergers influence consumers How

How do mergers influence consumers?
The effects mergers have on consumers differ widely. There may be some inconvenience and anxiety while a customer's bank or branch is obtained. The issuance of new account numbers and new checks is a familiar h

• ##### Q :Describe Form 22 Form 22 : It’s a

Form 22: It’s a department’s request to transfer money to the Architectural Revolving Fund (example, for building enhancements), reviewed by the Department of Finance.

• ##### Q :What is Debt Service Debt Service : The

Debt Service: The amount (sum) of money needed to pay interest on exceptional bonds and the principal of maturing bonds.