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 yguerreroreb2007 on 30 Aug 2008

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Regression equation 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