Saturday, October 29, 2011

Costing Inventory:Average Cost Valuation

   The average cost valuation system, also known as weighted average, is based on the average cost of inventory during the period and takes into consideration the quantity and the price of the inventory items by assigning the same amount of cost to identical items. In other words, it spreads the total dollar cost of the goods available for sale equally among all the units.
   The ending inventory is determined by the following procedure:

  1. The cost of the total number of units available for sale (beginning inventory plus purchases) is divided by the total units available for sale.
  2. The number of units in the ending inventory is multiplied by this weighted average figure.
Example 1

Referring to the data in Chart 1, the cost of the 385 units on hand would be calculated as follows:
  1. $7,475 / 695 units = $10.76
  2. $10.76 X 385 units on hand = $4,143 ending inventory
Example 2

    The cost of goods sold is then calculated by subtracting the value of the ending inventory from the total value of the inventory available for sale ($7,475 - $4,143 = $3,332).
   Because there were 695 units available for sale and 385 units on hand at the end of the period, the number of units sold was determined as 695 - 385 = 310 units. Therefore, another method of computation to determine the cost of good sold would be $10.76 X 310 units (cost of goods sold) = $3,336

Rounded to the nearest dollar.

   The average cost method is best used by firms that buy large amounts of goods that are similar in nature and stored in a common place. Grain, gasoline, and coal are good examples of products that could logically be costed under weighted average.

   There are some limitations that should be noted in this valuation procedure. Unit cost cannot be related to any physical purchase and does not represent any price changes. In those industries that are greatly affected by price and style change, this method will not yield specific cost determination. Also, the time needed to assemble the data is greater under this method than for FIFO or LIFO, if there are many purchases of a variety of different items bought.

      Sunday, October 23, 2011

      Costing Inventory: Last-In, First-Out (LIFO)

      The last-in, first-out (LIFO) method of costing inventory assumes that the most recently purchased items are the first ones sold and the remaining inventory consist of the earliest items purchased. In other words, the goods are sold in the reverse order in which they are bought. Unlike FIFO, the LIFO method specifies that the cost of inventory on hand (ending inventory) is determined by working forward from the beginning inventory through purchases until sufficient units are obtained to cover the ending inventory. This is the opposite of the FIFO system.

      Remember the FIFO assumes costs flow in the order in which they are incurred, while LIFO assumes that costs flow in the reverse order form that in which they are incurred.

      Example 1

      Under LIFO, the inventory at the end of the period is considered to be merchandise purchased in the first part of the period. What is the cost of the385 units oh hand?

                       Jan. 1 purchase      115 units @ $8  = $   920
                       Mar. 10 purchase  145 units @  $7  =  1,015
                       June 6 purchase     125 units @ $10 =  1,250
                                                    385 units              $3,185                    

      Thus, ending inventory under the LIFO method would be valued at $3,185


      Example 2

      The cost of goods sold is determined (from Example 1 by subtracting the value of the ending inventory from the total value of the inventory available for sale ($7,475 - $3,185 = $4,290). This cost may also be

                   Oct. 1                   245 units @ $12 = $2,940
                   July  5                   135 units @ $10 =   1,350
                  Cost of goods sold 380 units                $4,290

         A disadvantage of the LIFO method is that it does not represent the actual physical movement of goods in the business, as most business do not move out their most recent purchases. Yet firms favor this method because it does match the most recent costs against current revenue, thereby keeping earnings from being greatly distorted by any fluctuating increases or decreases in prices. Yet it sometimes allows too much maneuvering by managers to change net income. For example, if prices are rising rapidly and a company wishes to pay less taxes (lower net income) for that year, management can buy large amounts of inventory near the end of that period. These higher inventory costs, because of rising prices, under LIFO immediately become an expense (cost of goods sold), and thus result in the financial statement may want to increase net income to garner favor with stockholders. This can be done by delaying any large purchase of high-cost inventory until the following period by keeping the purchases out of the Cost of Goods Sold section for the current year, and thus avoiding any decrease in net income.
         In a rising price market, certain tax advantages are gained through LIFO because it yields a lower profit because of its higher cost of goods sold.

      Example 3

      Use Chart 1.

                                                                  FIFO                                        LIFO

      Sales (assumed)                                                    $25,000                                 $25,000
      Cost of Goods Sold:
         Goods Available for sale                  $7,475                                       $7,475
      Less: Ending Inventory                         5,070                                         3,185
      Cost of Goods Sold                                                 2,405                                      4,290
      Gross Profit                                                         $22,595                                  $20,710

         As Example 3 shows, LIFO produces (in a rising market)
      (1) a lower ending inventory,      
      (2) a higher cost of goods sold,
      (3) a lower gross profit. FIFO will produce the opposite.

         The IRS will permit companies to use LIFO for tax purposes only if they use LIFO for financial reporting purposes. Thus, if a business uses LIFO for tax purposes, it must also report inventory and income on the same valuation basis in its financial statements, but it is allowed to report an alternative amount in the notes to the financial  statements. This is permitted because it affords true financial analysis in comparing, on a similar basis, one business with another. It should be noted that a business cannot change its inventory valuation method any time it chooses. Once a method has been adopted, the business should use the same procedure from one period to the next. If management feels a need to change, permission must be granted by the IRS. The business must then follow specific authoritative guides that detail how the changes should be treated on financial statements.
                   

      Monday, October 17, 2011

      Pricing Merchandise

      Exercise 2 

      Solve the following problem:

      1. Equipment of $500 is sold to a retailer at a 25 percent trade discount. What is the retailer's cost?

      2. Determine the last day allowable for a company to take advantage of the full discount.
                                                                                   
               Term                        Date of Order                  Date of Delivery

      a).  2/10, n/30                       March 4                            March 8
      b). 2/10, 1/15, n/30               March 4                            March 8
      c). 2/10, n/30, ROG              March 4                            March 8
      d). 2/10, n/30, EOM             March 4                            March 8



      3. Company X gives terms of 30 percent discounts on all items purchased. Company Y gives chain discounts    of 18 percent and 9 percent. If Shehgarlynn bought $750 of supplies, how much would be save by dealing with Company Y rather than with Company X?
           
      4. If freight of $35 were added to the purchase in Problem 1, What would be the net cost?

      5. Determine the single equivalent discount in each of the following:
      a). 20 percent, 5 percent;
      b). 25 percent, 10 percent

      6. Office supplies selling $18 per box have a markup on cost (markon) of 25 percent. What is the cost of one box?

      7. Shehgarlynn bought $950 of goods for her company on January 1, subject to a  20 percent trade discount, bearing terms 2/10, 1/20, n/30. If the invoice was paid on January 7, how much was her payment?

      8. The following information, determine the merchandise inventory turnover.

                   Cost of Goods Sold:
                       Merchandise Inventory, Jan. 1         $28,000
                       Purchases (net)                                 69,500
                       Available for Sale                              97,500
                       Merchandise Inventory, Dec. 31        14,500
                       Cost of Goods Sold                                         $83,000

      9. From the selected information below, determine:
      a). Turnover of inventory
      b). Average daily cost of goods sold
      c). Number of days' sales in inventory

                     Cost of Goods Sold                             $850,000
                      Inventory (Beginning)                              93,000
                      Inventory (Ending)                                  69,000

      10. A watch that costs $55 is marked up 30 percent on cost. What is the selling price?

      Pricing Merchandise-Quiz

      Exercise 1

      Fill the following answer on the blank

      1. _________________ What is the abbreviation ROG?
      2. _________________ What the difference between cost and selling price?
      3. Downward adjustments of the selling price are often necessary to induce customers to buy and are referred to as ______________.
      4. An adjustment of the retail price is known as ______________.
      5. Cash discount are referred to as  _________________.
      6. When cost is used as a basis for markup percent, it is sometimes  known as as ___________.
      7. The " 2 " in 2/10, n/30 is the  ____________________.
      8. In order to give consideration to pricing and profit planning, it is important to consider the __________.
      9. A substitute for varying increasing single  discounts to different classes of purchases is referred to as a ____________. 
      10. An inducement offered to the buyer to encourage payment of his or her bill within a specific period of time is called a _____________

      Number Of Days' Sales In Inventory

      The relationship between inventory and cost of goods sold can also be expressed as the number of days' sales in inventory. In this ratio, the inventory at the end of the year is divided by the average daily cost of goods sold. The latter figure is determined by dividing the cost of goods sold by 365. The number of days' sales in inventory provides a rough measure of the length of time required to buy, sell, and then replace the inventory.

                                                           The Shehgarlynn Company
                                                               Turnover of Inventory

                           Cost of Goods Sold                                                  $895,000
                           Merchandise Inventory:
                              Beginning of Year                                                   $  85,200
                              End of Year                                                              150,300
                          Total                                                                             235,500
                          Average                                                                        105,150
                          Turnover of Inventory (895,000/105,150)                         8.5


      The average daily cost of goods sold is $895,000/365 = $2,452.05

                                                         The Shehgarlynn Company
                                                   Number of Days' Sales in Inventory

                                                                                                                  2007

                           Inventory at End of Year                                             $150,300
                           Average Daily Cost of Goods Sold                                   2,452
                           Number of Days' Sales in Inventory (150,300/2,452)       61.29                                                             

                                            

      Sunday, October 16, 2011

      Markdowns

      Once the price of an item has been established, there is no guarantee that will represent the ultimate selling price. Downward adjustments of the selling price are often necessary to induce customers to buy. These are referred to as markdowns. The seller is in effect forced, perhaps because of overstocking or too high a selling price, to abandon the original price. Markdowns take the form of direct price reductions.

      Example 1

      A cell phone listing for $125 was marked down 25 percent. What is the new selling price?

      Markdown  $125 X 25% = $31.25

      Selling price $125 - 31.25  = $93.75

      Turnover-Ratios for Inventory

      The firm's investment in inventory also has a direct effect on its working capital. Excess inventory means that funds are tied up in inventory that could be used more profitably elsewhere. Also, additional cost are being incurred for storage, insurance, and property taxes, not to mention the danger of a price decline and obsolescence of goods.

      Whenever any consideration is given to pricing and profit planning, it is important to consider the merchandise inventory turnover. This is the number of times the average inventory is sold during a year. The turnover shows how quickly the inventory is moving. Assuming that the company maintains a reasonable inventory for its type of business, a high turnover rate (such as for a grocery store) indicates that only a relatively small profit need be added to the price of each item to maintain a high profit overall. Turnover is also a good indication of the amount of working capital that needs to be tied up in inventory at one time.

      Merchandise inventory turnover can be computed from the cost of goods sold section of the income statement. It should be noted, however, that the turnover is an annual rate and should not be computed from interim statements.

      Merchandise inventory turnover =    cost of goods sold                
                                                          average merchandise inventory

      *Beginning inventory + ending inventory / 2

      Example 1

           Cost of Goods Sold:
           Merchandise Inventory, Jan. 1                 $10,000.00
           Net Purchases                                          88,000.00
           Merchandise Available for Sale                $98,000.00
           Merchandise Inventory, Dec. 31                15,000.00
           Cost of Goods Sold                                                       $83,000.00
              

      Merchandise inventory turnover =  $83,000.00
      ($10,000 + 15,000) /2                    12,500.00

        = 6.64

      In a retail business, such as a department store, turnover may effectively be computed either by departments or by classes of items. This can be accomplished by using the following turnover formula, which will yield approximately the same turnover rate as above:


      Merchandise inventory turnover =            sales in units           
                                                            average inventory in units


      Example 2

      ShehGarLynn Dress Shop sells uniform in four sizes, small, medium, large, extra large, all of which sell for the same price. What is the turnover for each color as computed from the data below? What, if any, problems does reveal?


      Size                Sales in Units                 Beginning Inventory                  End Inventory
      Small                  800                                                140                                     120
      Medium              900                                                200                                     150
      Large                  600                                                 75                                      125
      Extra Large         300                                                210                                    190

      Small turnover   = 800 = 6.15
                                  130

      Medium turnover = 900 = 5.14
                                     175

      Large turnover  = 600  = 6
                                 100

      Extra Large  =     300 =  1.5
                                 200

      The Extra Large uniform should be eliminated because of its low rate of turnover.


      Cost As A Basis

      When cost is used as a base for markup, it is sometimes referred to as a markon. It has the advantage of expressing clearly the fact that the price increase is added directly to its basis (cost).

      Computing Percent Markup

      Percent markup = $ markup
                                      cost

      Example 1 

      A printer that sells for $115 cost $95. What is the percent markup based on cost?

      Percent markup = $20 ($115-$95)
                                   $95
      Markup             = 21.05%

      Example 2  (Computing the cost)

      If an item selling for $75 has a 20 percent markup on cost, what is the cost

      Selling price = cost + markup
       $75            = 100% + 20%
       $75            = 120%
       $75/1.20    = cost
      $62.5          = cost

      Computing Selling Price

      In order to compute the selling price from either the cost or the markup, you once again must look at the formula for selling price from the point of view of percents. The cost (basis) is 100 percent.

      Example 3

      If a tie that costs $50 has a markup of 30 percent on cost, what is the selling price?

      Selling price = cost + $ markup
                         = $50 + (0.30) ($50)
                         = $50 + 15
                         = $65


      Saturday, October 15, 2011

      Markup

      In order to make a profit, each company must sell its products for more than they cost. The difference between cost and selling price is referred to as markup.

      Example 1

      A washing machine selling for $500 costs the seller $350. The markup is $150

      Percent Markup
      Markup is generally expressed in terms of a percentage:

      Percent = percentage
                         base

      where      percent = markup percent
                percentage = markup
                         base = selling price or cost

      Selling Price as a basis :  Computing percent markup

      Example 2

      A shoes selling for $20 cost the seller $15. What is the percent markup based on selling price?

      percent  =$5  ($20-$15)
                     $20
      Percent markup = .25

      Computing Cost
      In order to use the percent markup to compute either the cost or the selling price, the selling price formula must be reexamined in terms of percents. It should be noted that the base is 100 percent.

      Example 3

      A shoes selling for $20 has a markup percent of 25 percent .What is the cost?

        25% = X
                   20

      X      = 25% X $20
               = $5 (markup)
      Cost  =  $20 - $5 = $15

      Computing Selling Price

      Example 4

      A shoes has a markup percent of $5, which 25 percent of the selling price. What is the selling price?


      25%    = $5
                    X
      25%X = $5
             X = $5
                    .25
            X = $20

      Cash Discounts

      Are an inducement offered to the buyer to encourage payment of a bill within a specified period of time. They tend to narrow the gap between the time of sale and the time of  collection, which can become a source of cash flow difficulties for the seller. Cash discounts are referred to as terms and may appear on a bill as 2/10, net 30, where

        2 = the percent of the discount
      10 = number of days within which the buyer must pay in order to qualify for the discount net
      30 = number of days at which payment must be made in full

      Example 1
      An invoice of $500, dated March 6, has terms of 2/10, net 30. If payment is made on March 16, the net amount is:
      1. $500 X 2% = $10 discount
      2. $500 - $10 = 490
      If payment is made on March 17, the entire $500 is due.

      Some companies offer a varied cash discount depending on when payment is made--for example, 2/10, 1/20, net 30. This means that the company offers a 2 percent discount if the buyer pays within 10 days; if he or she pays after 10 days, but within 20 days of purchase, he or she gets a 1 percent discount; the net amount is due within 30 days.

      Example 2
      A $750 invoice dated April 6 has terms of 3/10, 2/15, net 30. If paid by April 16, the discount will be $22.50. If the invoice is paid after April 16, but by April 21, the discount will be $15. The entire bill of $750 must be paid by May 6.

      Although in most cases the cash discount period is computed from the "invoice" or purchase date, the date may also be computed from either the date of receipt of the goods (ROG) or starting with the end of the month (EOM).

      ROG is used primarily when there is a significant gap between the date of the sale and the delivery date. This eliminates the necessity for the buyer to pay for goods before receiving them in order to get a discount.

      EOM is used primarily as a convenience with traditional end-of-month billing practices followed by most companies.

      Example 3
      The last date on which a discount can be taken is shown below:

                                       Invoice       Goods                                      Last Day on Which
                                         Date      Received        Terms                 Discount Can Be Taken
      Invoice $600            Oct. 3       Oct. 8       2/10, n/30 ROG             Oct. 18
      Invoice $750            Oct. 3       Oct. 8       2/10, n/30 EOM            Nov. 10*
      *10 days after the end of month (EOM).


      Chain Discounts

      When using chain discounts, there are two methods that may be used to compute the net cost price:

      1. Determine a single equivalent discount and then proceed to compute the net cost price as illustrated earlier. This method is also useful for companies that wish to compare varying discount policies of competing companies.

      To compute an equivalent discount, multiply the complements of each of the discounts (100 percent - discount) together and subtract the result from 100 percent. For example, the single discount equivalent of 10 percent and 20 percent and 20 percent is computed as:

      Step 1 (100% - 10%) X (100%-20%)
      Step 2 0.90 X 0.80 = 0.72
      Step 3 Equivalent discount = 100% - 72% = 28%


      Example 1
      A computer is offered to wholesalers at a  list price of $750, less chain discounts 25 percent and 20 percent. What is the net cost price?

      1. (100%-25%) X (100% - 20%)
      2. (0.75) X(0.80) = 0.60
      3. Equivalent discount = 100% -60% = 40%
      4. Discount = $750 X 0.40 = $300
      5. Net cost price = $750 - $300 = $450
      Alternative method:
      1. Price X first discount percentage  ( $750 X 0.25 = $187.50)
      2. Price minus first discount  ( $750 - 187.50 = $562.50)
      3. Discounted price X second discount percentage  ($562.50 X 0.20 = $112.50)
      4. Discounted price minus second discount ($562.50 - $112.50 = $450.00)

      2. The net cost price can be computed directly by multiplying the list price by the complement of each of the discount in the series. It does not make any difference in what order the discounts are arranged.

      Example 2

      Assume the same information as in Example1:
      1. (100% - 25%) X (100% - 20%)
      2. (0.75) X (0.80) = 0.60
      3. $750 X 0.60 = $450