Thursday, May 19, 2011

Inventory Management, an introduction and Method



Inventory Management
Introduction
Inventories refer to total amounts tied up in raw materials, work in progress and finished goods. Company usually record inventories once a year basically at the year –end. Inventories has to be recorded based on accounting principles i.e. GAAP. Inventories are recorded in the income statement on the cost-of-goods sold calculation and also shown in balance sheet as current assets (All business, 2010). The cost of inventories is initially recorded on the balance sheet. As the inventories sold, these costs are removed from the balance sheet and flow into the income statement as cost of goods sold (Wild J.J., Subramanyam, K.R., & Halsey, R.F., 2007).
Inventory Management system is the systematic plan, procedure and method deployed to maintain the optimal amount of inventories in the organization. The objective of inventory management system is to facilitate continuous productions and sales at the lowest cost and also to specify the proper volume of inventories needed. The inventory management concerns with activities such as “carrying costs of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, available physical space for inventory, quality management, replenishment, returns and defective goods and demand forecasting” (Inventory management, 2007).  Inventories should be ordered in proper amounts that assist to meet the proper customer demand and also to lower the holding cost of inventories.  When inventory get shortage the company has to lose customers at the same time when inventories get excess company has to abide holding cost. Managing inventories is very complex and challenging task. Especially for the manufacturing company effective inventory management play crucial function for the success of the company. The reason is that firm has invested most of the funds in inventories and if inventories are not managed properly then their investment stuck on warehouse of the company instead of earning the returns (Donovan, 2010).
Methods of Inventory valuation
Inventory storage method refers to the valuation of inventories and recording them into company’s financial statements reflecting all the changes that occurs over the year in inventory. Changes in the inventory could occur as a result of “obsolescence, deterioration, increase/ decrease in demand and supply levels, and market trends” (Ehow, 2010). Inventories carry significant percentage of company’s operating assets and therefore needed to reveal accurately on balance sheet (Ehow, 2010). General Accepted Accounting Principle (GAAP) allows companies several options to determine inventories values which can be recognized as cost of goods sold in the income statement and removed portion of inventory from balance sheet (Donovan, 2010).
First-In, First-Out (FIFO)
This method assumes that the first units purchased are the first unit sold. FIFO inventory accounting corresponds most closely to the actual physical flows inventory since inventories are cost on first in first out basis (Droms G., 2003). However, during the period of frequent price rise this method does not reflect correct value of inventories in the income statement and also in balance sheet. Since the inventories are recorded on old price that overstate net income by lowering the cost of goods sold. FIFO inventory accounting record the cost of the recent inventory in the balance sheet based on the assumption that the first purchased are used on production or sales and last purchased are stored. Since the new price of the inventories are recorded on balance sheet that overstate the total assets (Bragg, 2007).
Last-In, First-Out (LIFO)
This method assumes that the last unit purchased is the first unit sold. LIFO inventory accounting record the cost of the old inventory in the balance sheet based on the assumption that the recent purchased are used on production or sales (Droms G., 2003). Since the old price of the inventories are recorded on balance sheet that understate the total assets. During the period of frequent price rise this method reflects correct value of inventories in the income statement as cost of goods sold. LIFO method is very useful from tax consequences. In the income statement the latest price of the inventories are recorded that understate net income and helps the company to obligate less tax liability (Bragg, 2007).
Average Cost
Average cost method is fairly straight forward that is often used to account for fungible goods such as wheat and other physically indistinguishable products. In this method, inventory is priced as weighted average of cost prices of inventories at the time of purchase (Bragg, 2007). In the income statement the cost of goods sold is calculated as a weighted average of the total cost of goods available for sale divided by the number of units available for sale. Ending units are recorded on the balance sheet (Wild, J. et al., 2007). This method is not as popular as LIFO and FIFO.
Effect of inventory valuation on financial statement
Effects on Profitability
The profitability of the company differs by the choice of the company’s inventory costing method. During the periods of continuous rising of inventory prices, FIFO produce higher gross profits than LIFO because lower cost of inventories are recorded on income statement. The figure of the gross profit overstated as the current market price of the inventory (Cost of goods sold) is higher than book value. Similarly, LIFO produce lower gross profit by recording inflationary cost of inventories and also by significantly impacting on tax liabilities. While at the period of decreasing inventory prices, FIFO produce lower gross profits than LIFO because higher cost of inventories are recorded on income statement (Wild et. al., 2007).
   LIFO best matches the current value of cost of goods sold with current revenue by assigning most recent inventory costs. Therefore, LIFO produces the cost of goods sold figure that is closest to what it would cost company to replace the goods that were sold. In this sense, LIFO produces the best measure of net income. In contract, FIFO matches the oldest inventory costs against the revenue – a poor match of current expenses with current revenue (Horngren, 2010).
Effect on balance sheet
            LIFO reports the oldest cost of inventory on balance sheet as the latest inventory is used first. During the period of continuous price rising, prices of inventory on balance sheet are significantly lower than replacement cost. Therefore, the balance sheet of LIFO companies does not correctly embody the current investment on inventories. While the FIFO reports the most current inventory cost on balance sheet. In the period of rising prices, prices of inventory on balance sheet are higher than market prices which overstate the balance sheet. As a result, the invested capital from the balance sheet is omitted (Wild et al., 2007).
Effect on Cash flow
            As the FIFO report the higher gross profit company owes higher tax liability. During the period of price rising company might have problems on cash flow because of higher tax obligation. At the same time company must replace the inventory sold at the higher replacement cost than the original purchase price that ultimately lead the liquidity problems (Wild et al., 2007). LIFO reports the lower gross profit and consequently the lower tax liability. At the period of price rising, replacement cost of the inventory is almost the same as the original purchase price. However, as per the IRS requirement, if companies use LIFO inventory costing for tax purposes then they have to use LIFO methods for financial reporting also (Wild et al., 2007).

Concerns for the Financial Analyst
               As per the nature of the business, company uses different inventory valuation techniques. At the same time outer environmental forces such as raise in prices, inflation, interest rate, economic recession, and regulatory forces also influence the value of the inventory on different methods.  Even though, companies have to follow stated accounting rules i.e. GAAP while preparing their financial statement, management could use those rules for their own interest and benefits. Therefore, it is the responsibility of financial analyst to check accuracy of the value stated on every elements of financial statement i.e. income statement, balance sheet, and cash flow statement. Following are some of the concerns that the financial analyst may have while analyzing the accuracy of inventory value.
·         To what extend portion of inventories are moving slow.
·         Is the value of inventories on balance sheet reflecting the current inventories cost.
·         The value of inventories increased on balance sheet is on the same proportion compared to investment side of cash flow statement or not? If not then what happen on the differences of inventories value. Are they obsolete or company sold them due to excess on warehouse?
·         Changes on inventory costing method during the accounting year. For example from LIFO to FIFO.  The chances in costing methods significantly impact on value of cost of goods sold, ending value of inventory, and money invested on inventory (replacement cost).
·         The same company may use different methods of inventory costing for different types of inventory, for different business segments. It is the responsibility of analyst to distinguish among them and calculate the value of inventories accordingly (All business, 2005).
·         To what extend company is able to self finance its working capital. Is the cash cycle of the company too big or appropriate?

Conclusion
         Inventory is one of the important operating assets of the company. Specially manufacturing company has to invest momentous percentages of their investment on inventories. Therefore, inventories should be managed properly that assist to meet the proper customer demand and also to lower the carrying cost of inventories.  Inventories are classified into three categories: Raw materials, work-in progress and finished goods. As per the nature of these inventories their movement differs from company to company. For example, inventory cycle for hotel and restaurant is very short and risky because of perishable nature of the inventory; similarly inventory cycle of departmental store is long and don’t have riskiness of perishable of inventory. All inventory costing methods: LIFO, FIFO and weighted average cost are very useful for the companies for valuation of the inventories. Based on the nature of business and requirement of federal government, some companies use LIFO, some other companies use FIFO and Weighted average cost. “LIFO and FIFO are widely used in USA” (All business, 2005) mostly in USA, companies use LIFO method. Companies which values are appreciating day by day use the LIFO inventory valuation techniques. For example, oil and gas refining company, drug retail, home furnishing, food retail, and others. As per the inventories costing method that company is using, the value of inventories differs. Those differences on value of inventories significantly impact on cost of goods sold, net income, inventory on balance sheet, tax liability and others. Therefore, it is the responsibility of financial analyst to check financial statement of companies to reflect the accuracy on financial statements and to make sure the management has not use any resources solely for their benefits. 



































                                                                                                                               





Objectives and Strategies of CVS Corporation


Objectives
·         Achieve 2010 profitability increases by 10%.
·         Improve credit policy from liberal to tight.
·         Acquire competitors in order to grow market share and sales volume.
·         Global expansion.
·         Continue to develop innovative services, which compete on pricing, technology, performance, consumer convenience and quality against competitors.
·         Increase employee motivation and reward system.
·         To be the easiest pharmacy retailer for customer to use. (CVS 10k, 2010)
·         Enhance personalize customer services.
·         To provide innovative pharmaceutical solutions and quality client service (CVS 10k, 2010).
Strategies
The overall implementation of Company’s strategies within in close future will certainly be enhanced by the economic recovery, and may require intensified effort in some areas of the operation throughout the process.
Licensing strategy for global expansion
CVS has grand Expansion and grand success with in US market. In order to place itself in the top global retail pharmacy company, CVS can expand its share in to foreign market place. Since CVS is related to somehow risky business environment. For CVS licensing would be the best strategy to expand their market into global market. In that way CVS does have to take full risk of the business into the foreign market.

Acquisition strategy for the market Expansion
In spite of macroeconomic turmoil on the current global scene, the company will continue to strengthen its market position through searching new acquisition opportunities. Even though CVS already sustained certain derogation in affect in the2008 and is still expecting to face some headwinds in 2009, the company’s main performance characteristics and conditions remain quite strong. The company manages well its strong brands, maintains good trade relationships, and holds major market share throughout the world. Due to this objective reality and solid financial grounds, the company can display confidence in the ability to spend on long-term growth initiatives. In addition to several previous acquisitions, the company will continue to seek appropriate acquisition opportunities and diversification not only within, but also outside of golf (Business Week, 2009).

Related and Unrelated Diversification Strategy
One of the possible ways to overcome the seasonality sale fluctuation and improve gross profit margin, would be implementation of a related or unrelated diversification strategy. Appropriate acquisition of different companies not directly related to the retail industry would stabilize the company’s sales throughout the year. The company should also search the opportunities for related diversification. One of the alternatives could be a development of their own brand products and services that would enable to practice with their own set of off-season and under unfavorable weather conditions.  
Innovative technology
The retail industry became very technology driven that most new service technology do not stay on the shelves longer than a couple of years. Therefore, competing companies are forced to match their opposition with offering fast and prompt service offering advance technology. Price wars are unlikely in such a high-end segment because only matters are the quality and performance of the products and its innovation (Navy, 2010). Not only high investments in R&D, organization commitment, and human expertise contribute to the company’s innovations, but mainly attention given to “understanding customer experience” (CVS, 2010). 
Other Strategies
·         Internet strategy for sales improvement.
·         Implementing discount programs for early payment of account receivable.
·         Simplify store layouts and customer accessibility
·         Greater benefits and incentives for employees
·         Continuously updating Competitive pricing strategies
·         Apply ongoing challenge sessions for employees to express concerns and their commitment to the company.


Balance Scored Card, CVS


Balance Scorecard
                                                                       Table: 10
Objectives

Measures
Initiatives
Financials

1) Achieve increase in 2010 profitability by 10%.

2) Improve credit policy from liberal to tight.


1) Review/Evaluate the profitability of previous year and coming year profitability.
 
2) Evaluate the average collection period periodically.

1) Expand business operation through unrelated and related diversification.

2) Implementing discount programs for early payment of account receivable.

Customer service
1) Enhance personalize customer services.
2) To provide innovative pharmaceutical solutions and quality client service
1) Survey current customers about service and their satisfaction.

2) Survey customers about their experience of visiting pharmacy.
1) Increase resources to train employees for the quality customer service.

2) Adoption of updated and Innovative technology.
Internal processes:
1) Increase employee Motivation and Reward system.

2) Increase effort in innovative technology.

1) Review employee satisfaction and learning opportunities.

2) Review/Identify competitor’s past and present innovation technology strategies.

1) Apply ongoing challenge sessions for employees to express concerns and their commitment to the company.

2) Deployed resources to innovative updated technology.
 Growth
1) Acquire competitors in order to grow market share and sales volume.

2) Global expansion.



1) Evaluate percentage of increase market share compared to previous year.

2) Evaluate and Identify the presence of CVS in foreign market.



1) Acquisition strategy for market expansion.

2)Licensing strategy for global expansion


Principal forms of business organization, financial intermediaries and their conomic functions


1-2 What are three principal forms of business organization? What are the advantages and disadvantages of each?
The three principal forms of business organization are as follows:
a)      Sole proprietorship: Sole proprietorship is an unincorporated business owned by one individual. In this type of business, owner has all responsibility, accountability and right to handle business. To open sole proprietorship, owner should obtain any required city or state business license. Some advantages and disadvantages of this business are as follows:
Advantages:
·         Easily and inexpensively formed.
·         Subject to few government regulation.
·         Its income is not subject to corporate taxation but taxed only as a part of the proprietor’s personal income.
Disadvantages:
·         Difficult to generate cash for the growth of an organization.
·         Proprietor has unlimited personal liability for the business debt.
·         The life of the sole proprietorship business limited to the life of its founder.
b)      Partnership Business: Partnership business is non corporate business owned by two or more persons for profit. Partnership may operate under different degrees of formality, ranging from informal, oral understanding to formal agreements field with the secretary of the state in which the partnership was formed. Partnership agreement whether formal or informal, defines the ways any profits and losses are shared between partners. Some advantages and disadvantages of partnership business are as follows:
Advantages:
·         Easy and inexpensively formed.
·         Income is not subject to the corporate taxation but is taxed only as a part of the partner’s personal incomes.
·         Subject to few governmental regulation.
Disadvantages:
·         Unlimited liabilities
·         Limited life of organization
·         Difficulty in raising capital
c)      Corporation: A corporation is a legal entity created by a state, and is separate and distinct from its owner and mangers. Unlike the sole proprietor and partnership business it has its own existence in the society as an entity. Some advantages and disadvantages of corporation are as follows:
Advantages:
·         Unlimited life: A corporation can continue after its original owners and managers are dead.
·         Limited liability: Losses are limited to the actual funds invested.
·         Easy transferability of ownership interest: Ownership interests can be dividend into share of stock, which can be transferred for more easily than proprietorship or partnership interest.
Disadvantages:
·         Subject to double tax: The earning of the corporation are taxed at the corporate level, and then earnings paid out as dividends are taxed again as income to the stake holders.
·         Subject to the large government regulation: Setting up a corporation involves preparing a charter, writing a set of bylaws, and filing the many required state and federal reports.
·         Complex and time consuming.
1-4. What are financial intermediaries, and what economic functions do they perform?
Financial intermediary is a financial institution that acquires funds from one group of investors and make available to another economic unit. Thus, financial intermediaries play a very pertinent role in the economy by channeling funds from surplus savings units to deficit units. Financial intermediaries can be commercial bank, savings and loan associations, mutual fund, pension fund, credit union and many more. Some of the economic functions of the financial intermediaries are as follows:
·         Perform denomination divisibility function: Financial intermediary pools the savings of many small investors and invested these funds in securities of various sizes. It helps small savers to invest their funds in a situation when they have no sufficient funds to employ in large denomination transactions.
·         Perform maturity Flexibility function: It is able to buy direct securities issued by deficit spending units and issue indirect securities with precise maturities desired by the surplus spending units. In this regard, commercial bank and financial companies have enabled investors to put deposits of various maturities and they are made payable on demand.








Financial Statement Analysis



Answer question number b.
Current Liabilities
Projected Current Ration in 2008       =     Current Assets           
$1,039,8000
                                                             =    $2,680,112
                                                             = 2.57 times
Liquidity ratio measures the firm’s ability to meet short term obligations which should be paid within a year. The current ration of the Computron Industries in the year 2006 and 2007 was 2.3 and 1.5 times respectively whereas the current ratio in 2008 is 2.57 times. Industry average current ratio is 2.7 times. This shows that the liquidity position of Computorn industries in 2006 and 2007 was relatively lower than current ratio of 2008. In these three years computron’s current ratio is below the industry average but in 2008 it is almost near to the industry average.  
Current Liabilities
Projected Quick ratio in 2008             =     Current Assets - Inventories           
$1,039,800
                                                             =      $2,680,112 - $1,716,480
                                                            =    0.93 times
The quick ratio of the Computorn industries in the year 2006 and 2007 was 0.8 and 0.5 times respectively whereas the quick ratio in 2008 is 0.93 times.  This shows that the liquidity position of computorn industries in 2006 and 2007 was relatively lower than 2008. This corporation has 2.57 times current ration and only 0.93 times quick ratio which indicate that it has high amount of inventories as the current assets. Therefore, it needs to change its inventory policy.  Still, the company has its ability to pay its short term obligations and if it would be able to collect its receivables in time then company can pay off its current liabilities without having to liquidate its inventory.
The different types of analysts have interest in the liquidity ratios and they analyze the same amount of liquidity position from different view:
Managers point of view
Regarding the manager, liquidity ratio suggest them whether the firm should reinvest its income or return to its shareholders. Also liquidity ratio suggests them to see the possible future economic downturns.
Bankers point of view
From creditors’ point of view, they like to see a high current ratio.  High current ratio means, firm has enough ability to meet its obligations. When a firm is getting into financial difficulty, it will begin paying its account payable more slowly, borrowing from its bank and so on. So its current liabilities will be increasing and hence lowering the liquidity ratio.
Stockholders point of view
From stockholders’ point of view, high current ratio could mean that the company has a lot of money tied up in nonproductive assets such as excess cash or marketable securities or inventories.
Answer question number C.
Inventories

Inventory Turnover ratio in 2008  =         Sales
$1,716,480

                                                       =      $7,035,600
                                                      =    4.09 times.
Computorn’s inventory turnover ratio is much lower than industry average. It has the inventory turnover ratio of 4.09 times where as industry average inventory turnover ratio is 6.1 times. This suggests that Computorn hold excessive inventories. Holding excessive inventory is unproductive because it is nonproductive asset and it gives low rate of return.
Average Sales per day
Days Sales Outstanding in 2008   =            Receivables
$7,035,600/3655
                                                      =        $878,000    
                                                      =    45.54 days  ≈ 46 days
Computron’s days sales outstanding is more than industry average.  It is the average length of time the firm must wait to receive cash of its credit sales. So lower the days sales outstanding better will be the firm’s credit policy. This company has to wait 46 days to receive the cash where as industry average days sales outstanding is 32 days. This shows that customers, on the average, are not paying their bill on time. This deprives Computron’s funds that it could use to invest in productive assests. Customers are not paying their bill on time.
Net fixed Assets
Fixed Asset turnover in 2008    =              Sales
$836,840
                                                   =     $7,035,600
                                                   =    8.40 times.
Computron’s fixed asset turnover ratio is higher than industry average. It has 8.40 times fixed asset turnover ratio where as industry average fixed asset turnover is 7.0 times. This shows that net fixed asset of Computron industries is low in comparision to the industry average or the company utilizes its plant and equipment more for the same volumes of sales comparing to other firm of the same industry.
Total Assets
Total Asset turnover in 2008    =          Sales
$3,516,952
                                                   =       $7,035,600
                                                   =       2.00 times
Computron’s total assets turnover ratio is lower than industry average. It has 2 times total assets turnover ratio where as industry average total assets turnover is 2.5 times. This shows that industry is not generating a sufficient volume of sales given its total asset management. Sales should be increased or some assets should be sold or a combination of these steps should be taken. Beside this, firm’s fixed assets turnover is above industry average but because of excessive amount of current assets, especially inventories and accounts receivables, its total assets turnover is lower. So firm should change its inventories policies and credit policy in order to improve its total assets turnover.

Answer question number d.
Total Assets
Debt ratio in 2008                     =      Total liabilities
$3,516,952
                                                  =     $1,539,800                                
                                                  =    0.4378   =  43.78%
The debt ratio of computron industries is lower than the industry average. It has 43.78% debt ratio where as industry average debt ratio is 50%. This shows that computron’s creditors have supplied less than half the total financing. More than half of the total financing is financed by equity capital. It means Computron’s financial condition is sound and the firm doesn’t have risk of bankruptcy.
Interest charge
Times Interest Earned ratio         =           EBIT
$80000
                                                    =      $502,640
                                                    =     6.28 times.
Computron Industry has 2.28 time interest earned ration which is almost same as industry average. The industry average time interest earned ratio is 6.20 times.  It suggests that computron has sound ability to pay its interest.                                      
Answer question number e.
Sales
Profit margin ratio in 2008         =      Net Income available to shareholder          
$7,035,600
                                                    =      $253,584
                                                    =       3.60%
Profit margin of Computron industries is equal to the industry average i.e. 3.60% equals to 3.60%. This suggests that the cost incurred while operating industry is efficient. Computron Industries’ profit margin is identical with industry average that means their sales, operating costs, EBIT and uses of debt are identical. Its profit margin in 2007 was very bad in negative; however expected profit margin in 2008 is the good.
Total Assets
Basic Earning Power ratio         =          EBIT
$3,516,952
                                                   =       $502,640
                                                   =     14.29%
Basic Earning Power ratio of Computron industries is lower than the industry average. It has 14.28% BEP ratio where as the industry average BEP ratio is 17.8%. This shows the raw earning power of the firm’s assets, before the influence of taxes and leverage. Because of its low total asset turnover ratio, Computron is not getting as high a return on its assets as is the average company in its industry.
Total Assets
Return on Assets (ROA)           =     Net income available to common stockholder 
$3,516,952
                                                   =     $253,584          
                                                   =     7.21%
Ruturn on Assets of Computron industries is below the industry average. The compay has Return on Assets of 7.21% where as the industry average ROA is 9%. This is because of low BEP ratio and high interest cost, deprives the net income to be high.
Common equity
Return on Equity (ROE)            =     Net income available to common stockholder             
$1,977,152
                                                   =     $253,584
                                                   =     12.82%
Ruturn on Equity (ROE) of Computron industries is lower than the industry average. The industry average ROE is 17.9% where as the firm has ROE of 12.82%.  This suggests the stockholders investment to get a return on their money. This ratio is somewhat below than industry average but far better than ROE of 2007. Though its ROE in an industry is lower, while analyzing its performance through trend analysis it is improving.
Answer question number f.
Earnings per share
Price/ Earnings ratio in 2008      =        Price per share           
 $1.014
                                                   =      $12.17             
                                                   =    12 times.
The price earning ration of Computron industries is below the industry average. The company has Price Earnings ratio of 12 times whereas industry average is 16.2 times. This suggests that the company is regarded as being somewhat riskier than most of the other company in an industry because of low PE ratio. Certainly this shows that investors are expected to have low opinion of the company. However, looking at its trend, company is expected improve its performance in 2008. Its PE ratio in 2007 was -6.3 times where as in 2008 12 times.
Cash flow per share
Price/cash flow ratio in 2008     =        Price per share
$1.49
                                                   =     $12.17
                                                   =     8.16 times
Calculation of cashflow per share
 Number of Shares outstanding
Cash flow per share                   =     Net income + Depreciation + Amortization
250,000
                                                   =     $253584+120000+0
                                                   =     $1.49
The price/cashflow ratio of computron industries is above the industry average. The industry average price/cash flow ratio is 7.6 times whereas firm has 816 times. This suggest that its growth prospects are above average and risk is below average. This ratio indicates that investors are expected to have high opinion of the company because of high price/cash flow ratio than industry average.
 Book value per share
Market/Book ratio in 2008         =     Market price per share
$7.909
                                                   =     $12.17  
                                                   =    1.53 times
The market/book ratio is relatively lower than industry average i.e. the firm has market/book ratio of 1.53 times whereas industry average is 2.9 times. This suggests that Computron industries has to raise common equity to get this ratio high. Investors are expected to have low opinion about the company because of low market/book ratio. However, firm’s this ratio is increases comparing to 2007.