Safety stock, Financial Accounting

Assignment Help:

Safety Stock

What must be the level of safety stock? In a simple condition where merely the usage rate is variable and the maximum usage rate can be given, the safety stock needed to search for total protection against stock out as:

(Maximum usage rate - Average usage rate) × Lead time

As both the lead time and usage rate vary, that is frequently the case and the range of variation is broad complete protection against stock out may need an excessively large safety stock.  For illustration, if the lead time different in between 60 days and 180 days along with an average value of 90 days and the usage rate varies in between 75 units and 125 units per day along with an average value of 100 units daily, a safety stock of 13,500 units is needed for finish protection against stock-out.  It has been worked out given as:

Maximum possible usage

-

Normal or Average usage

Maximum daily usage

X Maximum lead time

125  × 180

-

×

-

Average or Normal daily usage

Average lead time

100 × 90  = 13,500

Because inventory-carrying costs are proportional to the point of inventories carried, this rarely having sense to search for total protection against stock-out. In view of the trade-off between stock-out cost and inventory carrying cost, the optimal level of safety stock is generally much less than the level of safety stock needed to attain total protection against stock-out.

A manufacturing company will need 50,000 units of a product throughout the next year. The cost of processing a demand is Rs.20 and the carrying cost per units is 50 paise per year.  Lead-time of a demand is 5 days and the company will maintain a safety stock of two days usage.

You are needed to compute:

a. Economic Order Quantity;

b. Re-order Point;

c. Minimum Inventory; 

d. Maximum inventory and

e. Average Inventory. Here assume 250 days in a year.

Solution

a. Economic Order Quantity

EOQ = √(2RO/C)

Here R = Annual Requirements or Usage

O   =     Ordering cost per order

C   =      Carrying cost per unit per year

EOQ = √ (2 × 50,000 × Rs.20/Re .0.5)

=   √40,00,000

= 2,000 Units

b.   Re-order Point

R.O.P.  = (L× UR) + S

Where; L = Lead Time;

U = Usage Rate (50,000 ÷ 250) = 200 (units per day);

S = Safety Stock

R.O.P.  = (5 × 200) + (2 × 200)

= 1,000 + 400

= 1,400 Units

c.  Minimum Inventory

It is the Safety Stock kept by the company that is 400 units.  Minimum inventory will be zero, if there is no safety stock.

d.   Maximum Inventory

Maximum Inventory =  EOQ + Safety Stock

=  2,000 + 400

=  2,400 units.

 e. Average Inventory

 = (Maximum Inventory + Minimum Inventory)/2

= (2,400 + 400)/2

= 1,400 Units


Related Discussions:- Safety stock

Accounting adjustments to account for unpaid wages, James Bell plans to sta...

James Bell plans to stay at the Michaels Motel for one month, and he prepays his room charges. Bell arrives and begins his stay on January 21. To account for Bell's prepayment, at

What is the worst case npv and best case npv, An investment under considera...

An investment under consideration has a payback of seven years and a cost of $724,000. If the required return is 12 percent, what is the worst-case NPV? The best-case NPV? Explain.

Determine the wacc, The capital structure of Wild West Inc. is as follows: ...

The capital structure of Wild West Inc. is as follows: -     Debts: $5,000,000 (face value) bonds with coupon rate at 8.00% and current price at par -      Preferred shares:

Clean opinion in auditor''s work, Unqualified Opinion - AUDIT opinion not q...

Unqualified Opinion - AUDIT opinion not qualified for any material scope restrictions nor departures from GENERALLY ACCEPTED ACCOUNTING PRINCIPLES (GAAP). AUDITOR may issue an unqu

Currency-option bond, You have the following limited information upon which...

You have the following limited information upon which to base your decision as to which is the better of two alternative funding arrangements: Alternative 1 is to arrange fun

Prepare a surprise county construction fund balance sheet, During FY 2014, ...

During FY 2014, the voters of Surprise County approved construction of a $21 million police facility and an $11 million fire station to accommodate the county's population growth.

Quality discount and order quantity, The standard EOQ analysis is depends o...

The standard EOQ analysis is depends on the assumption which the price per unit keeps constant irrespective of the size of the order. While quantity discounts are obtainable, that

Prepare a post-closing trial balance, As a recently hired accountant for a ...

As a recently hired accountant for a small business, Bearing, Inc., you are provided with last year's balance sheet, income statement, and post-closing trial balance to familiarize

Funding the investment by an issue of ordinary shares, Funding the investme...

Funding the investment by an issue of ordinary shares could tender several advantages to Springbank plc. Gearing would drop to 47% (3·5/7·4) fewer than half of the sector average o

What is the present value index for each proposal, The net present value ha...

The net present value has been computed for Proposals A and B. proposal A proposal B invested amount 75000 125000 total present value of cash 84000 136250 net present value 9000 11

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd