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?
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
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
