Up Your Cash Flow 
Budgeting & cash flow forecasting software
Phone number 310-387-5403 Pacific
  • Home
  • Products
    • Up Your Cash Flow >
      • Product Features
      • Benefits
      • Sample Reports
    • Advisor Services
    • Free-Books To Download
  • Store
  • Support
    • Update Your File
    • How The Program Works
    • Benefits
    • Help Files
    • FAQ's
    • Contact Us
  • Company
    • About Us
    • Contact Us
    • Testimonials
    • Blog
  • Articles
    • Making More Money Helping Your Clients
    • Let's Begin The Forecasting Process
    • The Profit And Loss Forecast-Step 1
    • The Profit And Loss Forecast-Step 2
    • The Profit And Loss Forecast-Step 3
    • AP-AR Turnover Ratio
    • Inventory Turnover Ratio
    • Net Income To Net Sales Ratio
    • Net Income To Equity Ratio
    • Debt To Equity Ratio
    • Why Plan
    • Tough Blog
    • Importance Of The Balance Sheet
    • Business Financial planning A must
  • Blog
  • Business Planning Series
    • 1. Whose Business Is It, Anyway?
    • 2. How to Identify and Monitor the Key Financial Elements of Your Company
    • 3. Kill The Budget
    • 4. How to Foresee And Predict Your Financial Future
    • 5. The Dynamic Financial Planning Process
    • 6. Developing The Forecast
    • 7. Expenses
    • 8. The Cash Flow Forecast
    • 9. What Do You Do with Your Forecast Now That You Have One?
    • 10. In Summary
    • 11. What Do All the Numbers
    • 12. The Business Plan: We Must Plan For The Future
    • 13. Personal Planning Is a Must
    • 14. A Matter Of Minutes >
      • 15. A Final Word
  • Advisor Services
  • Special ADP Video On Planning
  • Library

The Profit And Loss Forecast - Step 3

COST OF GOODS SOLD

The next item to be considered in the forecast is the cost of goods sold—how much you will pay for what you sell.

I have listed two basic methods for determining the cost of goods sold. Pick the one you find the simplest and use it.

Method 1: The Percentage Method. Let's assume that over the years your business has been operating on a consistent cost of goods sold percentage. Let's further assume that you would like to continue to operate at the same level for the coming year and believe you will. Simply multiply that percent by each month's sales; the result becomes the cost of sales for the month. This method may prove to be the simplest way to forecast cost of goods sold; however, its major weakness will be discovered when the actual costs are more or less than what was forecasted, and you try to find out the reasons why.

Unlike most of the expenses of your business, the actual cost of goods sold can vary depending on several factors: an incorrect beginning inventory, sales recorded in the wrong period, purchases recorded in the wrong period, an incorrect ending inventory, improper valuation of the inventory, and an inaccurate count of the items in the inventory. There-fore, if you have a variance between the actual percent of cost of goods sold compared to the estimated percent used in the forecast, pinpointing the reason for the variance can be quite difficult.

In general, a company will not compute the actual cost of goods sold until an accurate physical inventory is taken or reliable perpetual inventory records are maintained. Therefore, management may prepare their actual financial statements using the forecasted cost of goods sold and often- times will not compute the actual cost of goods sold more than once or twice a year when inventories are taken.

Only when the actual costs are computed can meaningful comparisons between actual and forecasted cost of goods sold take place.

Method 2: For a more precise method of determining your forecasted cost of goods sold, begin with the number of units of a particular product that you anticipate selling (see Sales Forecast, Method 2) and price the units to be sold.

Do this for each product line of sales.

 

 

Example:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Units to be Sold

 

Anticipated Cost of Each Unit

 

Cost of
Goods Sold

 

 

 

 

 

 

 

 

 

 

Product A

50,000

 

      7.80

 

    390,000

 

 

Product B

35,000

 

12.75

 

446,250

 

 

Product C

100,000

 

   1.25

 

       125,000

 

 

 

 

 

 

 

 

 

 

Cost of Goods Sold

 

 

 

 

   961,250

 

 

 

 

 

 

 

 

 

Source: Harvey A. Goldstein, CPA , Granville Publications

Copyright GoHagIt,Inc, Granville Software 2015,2016

Cash Flow Forecasting Software
| Business Budgeting Software | Business Budget Forecasting | Budgeting and Forecasting Software
 Financial Budgeting Software |  Business Budgeting | Cash Flow Analysis

.