Business Plan Help
Cost of Goods Sold (COGS) Help
Explanation of Terms: COGS (Per Unit)
Cost of Goods Sold refers to the actual cost of producing a product or service. Each inventory item may have a different cost associated with it. The worksheet includes spaces for seven different items, however you may use “cut and paste” to add as many as you will need. The costs of an item may include more than just the price of the item when you buy it, such as:
• Shipping costs
to get the item to you, or to ship to a customer if you pay the shipping.
Generally all costs
directly associated with the individual cost of the product that go
up in price with the volume of sales of the product will be part of
the Cost Of Goods Sold. For example, the following is the COGS for
a “widget” that is bought in pieces, then assembled, and sold. The
salesman that sells them receives a 10% commission. Each widget sells
for $30 each (retail).
* To get all the parts shipped to the company from the suppliers costs approx. $1 per item. If parts are shipped in bulk you will need to divide the shipping charges by the number of parts to figure the actual cost per unit.
** It costs $3 each for an employee to fit the pieces together. In this case, an employee is paid $15 per hour and can assemble 5 widgets per hour, so the labor to produce each widget is $3 ($15 divided by 5 equals $3).
*** The salesman
is paid a 10% commission on each widget sold. The widgets sell for
$30 each, so he will receive $3 for each one sold.
Explanation of Terms: COGS Projections
If you have completed the Sales Projections section, the Cost Of Goods Sold (COGS) Projections will mirror the quantities you entered for each month but this time you will enter the COGS of each item.
As described in the Sales Projections section, most companies sell more than one product or service. Because the selling price and the cost to purchase or produce each individual item varies, there are seven different entry lines for the various items. If your business is a “Service Based” business, the items you are selling are probably “billable hours”, or the amount of time (on an hourly basis) that you can charge customers for. If different rates are charged for different services, each should be on a different entry line. The “quantity” will be the amount of hours charged for that particular service. An example: Bill’s Yardwork Inc. performs many types of service, and charges different prices depending on the service and therefore pays his employees different wages based on their ability to produce a particular service. In addition, there are other costs incurred in producing each service, so the Cost of Goods Sold varies for the different services. In the projection that follows he is using the following: Raking: Pays wages of $6 per hour (no other costs); Tilling: Pays wages of $8 per hour and the machine uses $2 worth of gas per hour making his COGS $10 per hour; Weeding: Pays wages of $6 per hour.
Sometimes companies will break down sales by the various profit margins for particular type products. You may need to configure the amounts on a worksheet, then enter in the figures. These lines will correspond to the same lines under the Sales projections during the previous step to help accurately project income. Bill has now purchased an appliance business and has grouped the following because of the various profit margins: Stoves @ 40% profit margin, Refrigerators @ 25% profit margin, and Dishwashers @ 20% profit margin:
Explanation of Terms: COGS (Annual)
Annual figures for determining Cost of Goods Sold can be determined by the following formula:
plus Purchases (including shipping and direct labor costs)