Showing posts with label Stock Level Formulas. Show all posts
Showing posts with label Stock Level Formulas. Show all posts

Monday, 8 February 2016

Stock Turnover Formula

Stock Turnover Formula

Stock Turnover formula has been given below; this formula has been explained with an example.

Stock Turnover =      Cost of Sales during the Year              .   
                               Closing Inventory or Average Inventory


Stock Turnover is calculated to show how many times inventory sold during the year. It is pertinent to mention that stock turnover vary industry to industry, some industries have low stock turnover (Like Tires, Cloths), other industry has high turnover (food industry).

Stock Turnover Formula Example


Cost of Sales = 90,000
Inventory = 15,000
Calculate Stock Turnover

Solution

Stock Turnover =     Cost of Sales    
                                Inventory
= 90,000/15,000
= 6 (times sold)

Significance of Stock Turnover Calculation

Stock turnover calculation simply shows that how many times stock sold during the year. This information is a tool for controlling the performance of sales department. Stock turnover information of different periods is compared to evaluate performance of sales department. Stock turnover information is also compared with stock turnover of the industry.

High Stock Turnover

High stock turnover level is normally show good performance of the sales teams. High turnover is also preferred, because it reduces the risk of obsoletes. In some industries high stock turnover helps in designing customer specific product.

Low Stock Turnover

Low stock turnover shows the poor performance of the sales team. Furthermore, low stock turnover reflect the overstocking of the inventory which is not recommended, because stock holding involves a number of costs.

 Stock Turnover Formula Practice Question


Cost of Sales of Company = 120,000
Closing Inventory = 25,000
Calculate Stock Turnover







Stock Cycle Formula

Stock Cycle Formula

Stock cycle formula is shown below. This formula has been explained with an easy example;

Stock Cycle =     Number of Weeks in a Year   
                             Number of Order

 Stock Cycle Formula Example

Number of Weeks in a Year = 52
Number of order placed during year= 15
Calculate Stock Cycle?

Solution

Stock Cycle =     Number of Weeks    
                          Number of Order
=52/15
=3.46 weeks or 3.46 x7 =24.22 Days

Stock cycle basically tell about the frequency of order placement. Stock cycle may be calculated in week or days. Stock cycle may either be directly calculated in days by using following formula, or weeks may be converted into days.

Stock Cycle =     Number of Days in Year    
                             Number of Order


Example

Number of Days in a Year = 365
Number of order placed during year= 15
Calculate Stock Cycle?

Solution

Stock Cycle =     Number of Days in Year    
                           Number of Order
=365/15
=24.33 Days


Significance of Stock Cycle Calculation

Stock cycle helps management in placing the stock orders. Management knows the timing of each order. With the help of stock cycle calculation, a tentative schedule of stock orders can be prepared.




Wednesday, 3 February 2016

Average Stock Level Formula

Average Stock Level Formula

Average stock level formula has shown below. Average stock level formula has been explained with an example.

Average Stock Level= Minimum level + (Reorder level/2)


Average Stock Level Formula Example


Minimum level Requirement= 40,000
Re order level or Point = 30,000
Calculate Average Stock Level?

Solution

Average Stock Level = Minimum level + (Reorder level/2)
= 40,000 + (30,000/2)
= 55,000 (Average Stock Level)

Advantage of Average Stock Level


Average Stock level offers a balanced solution, and therefore is preferred by many organizations. Average stock level is above the minimum level and below the maximum level.

Average Stock Level Formula
Maximum Stock Level Formula
Minimum Stock Level formula
Re Order Level Formula

Maximum Stock Level Formula

Maximum Stock Level Formula


Maximum Stock Level formula is given below. This formula has been explained with an example.

Maximum Stock level = Reorder level + reorder Quantity- (Minimum usage x Minimum lead time)


Maximum Stock Level Formula Example


Reorder level of Inventory = 20,000
Reorder Quantity (EOQ) = 15,000
Minimum usage of inventory = 5000
Minimum lead time for arrival = 2 weeks

Solution

Maximum level = Reorder level + reorder Quantity- (minimum usage x minimum lead time)
=20,000 + 15,000- (5000 x2)
=35,000-10000
=15,000

 Significance of Maximum Stock Level Calculation


Holding of stock or inventory is not free; rather holding of stock requires reasonable amount of expenditure or cost. Maximum stock level is calculated for reducing holding cost of the company. Any Stock above maximum stock level is not recommended.

Reasons of Stock level above the maximum Stock level


One of the main reasons is low consumption of stock that has resulted in piling up of stock. Therefore stock level may be controlled either by reducing re order quantity or reducing the re order level.

Important factor for Maximum Stock Level Determination


Important factor for determining the maximum stock level includes the storing or holding cost, space availability, seasonal stock consumption fluctuation etc. Therefore stock level formula just provides a general guidance, therefore management decide the actual stock level on the bases above mentioned factors.

Maximum Stock Level Practice Question


Reorder level of Inventory = 30,000
Reorder Quantity (EOQ) = 6,000
Minimum usage of inventory = 4,000
Minimum lead time for arrival = 3 weeks
Calculate Maximum Stock Level?




Minimum Stock Level Formula

Minimum Stock Level Formula

Minimum stock level formula may be calculated by the following formula. Minimum stock level formula has been explained with a simple example.

Minimum Stock Level = Reorder Level - (Average usage x average Lead Time)


Minimum Stock Level Formula Example


Re Oder level of Inventory= 70,000
Average usage per week= 10,000
Average lead time for inventory = 5 weeks

Solution


Minimum Stock Level = Reorder Level - (Average usage x average Lead Time)
= 70,000-(10,000 x 5)
=70,000-50,000
=20,000 (minimum stock level)

Significance of Minimum Stock Level


Minimum stock level is very critical level and at this level management should take appropriate actions or steps to ensure the availability of material. It is important to remember that this level is not an ordering level or re ordering level; rather this is a control or safety level.

Advantages of Minimum Stock Level Calculation


First advantage of minimum stock level is to provide management an effective control of the inventory management. Management can take appropriate steps to ensure timely availability. Minimum stock level calculation also helps in ensuring operations of the entity.

Minimum Stock Level and Inventory orders


Ideally inventory order should reach the warehouse before the inventory level touches the minimum stock level. If this is not the case, then operation of organization may be halted for shortage of inventory.

Other name of Minimum Stock Level


Other name of minimum stock level is safety stock level. It means that organization must maintain that level for safety or continuity of its operation. Minimum stock level ensures a safe environment for operations.

Minimum Stock Level Formula Question


Re Oder level of Inventory= 800,000
Average usage per week= 20,000
Average lead time for inventory = 8 weeks

Calculate the minimum stock level?


Other related Formulas




Tuesday, 2 February 2016

Re order Level Formula

Re order Level Formula

Re order level formula is given below. Re order level is that level of inventory at which order needs to be placed.  Re order level may be calculated by multiplying maximum usage with maximum lead time.

Re order Level = Maximum usage x Maximum Lead Time


OR

Re Order Level = (Average Usage x Lead Time )+ Safety Stock

 

Re order Level Formula Example (Method 1)


Maximum Usage per week = 9,000
Maximum Lead time         = 10 weeks
What would be Re order level?

Solution

Re order Level = Maximum usage x Maximum Lead Time

= 9,000 x 10
=90,000 units

Re order Level Formula Example (Method 2)


Average Usage per week = 10,000
Lead time         = 5 weeks
Safety stock= 4,000 units
What would be Re order level?

Solution

Re order Level = (Average usage x Lead Time) + Safety

= (10,000 x 5) + 4,000
=54,000 units


Significance of Re order Calculation


It means that when stock level reaches at 90,000 (unit), we must place a new order. Technically it means that, when the new stock will reach in 10 weeks, then the current stock would have finished. Thus re order level calculation is very important factor for effective inventory management.


Re order Level and Lead Time


Lead time is time interval between placing the order and reaching the inventory to the warehouse. Lead time has been classified into three categorize i.e. maximum lead time, minimum lead time and average lead time. Maximum and average lead time is used to calculate re order level by two different formulas as explained above.