# I need help in Creatinga Firm Fixed Price Formula for Outyears Forecasting

## Excel Help for I Need Help In Creatinga Firm Fixed Price Formula For Outyears Forecasting in Excel Multiple Regression Analysis and Forecasting Template

### I Need Help In Creatinga Firm Fixed Price Formula For Outyears Forecasting

Rate this:
(3/5 from 1 vote)
Hi everybody!

I will love to find help from you in terms of how can I creat the Firm Fixed Price Formula to forecast outeyars pricing.  This will help me in my actual work in the area of Manufacturing.

Here is two examples that I created in order to generate this FFP forecast formula.

1.  take as a base history price; and I need to forecast that Firm Fixed Priced for 5 years more; considering the needed quantities projected.

 Qty 2009 FFP    Unit Price Qty 2010  FFP    Unit Price HISTORICAL PER UNIT COST History QTY ORDERED \$    7.45 54 40 150 \$ 186.75 6 40 150 \$    3.65 810 40 150

1.  take as a base actual 2008 price; and I need to forecast that Firm Fixed Priced for 5 years more; considering the needed quantities projected.  Also, I have a question.  Do the amounts quoted on the first column affect the results of the forecast?

 Given FFP FFP FFP Qty. 2008 Price Qty. 2009 Qty. 2010 Qty 2011 10 9.25 25 45 55 25 14.5 35 55 65 67 55.25 40 65 75

I really will appreciate all your help.
Posted by on

 Replies - Displaying 1 to 1 of 1 Order Replies By: Most Recent | Chronological | Highest Rated
 Rate this: (3/5 from 1 vote) The regression equation used for the forecast uses the first column has the dependent variable.  The forecast then predicts the price going forward. Excel Business Forums Administrator Posted by Excel Helper on 01 Sep 2008
 Displaying page 1 of 1

 Find relevant Excel templates and add-ins for I need help in Creatinga Firm Fixed Price Formula for Outyears Forecasting in the Excel Business Solutions Directory