I Need Help In Creatinga Firm Fixed Price Formula For Outyears Forecasting
(3/5 from 1 vote)
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.
2009 FFP Unit Price
2010 FFP Unit Price
HISTORICAL PER UNIT COST
History QTY ORDERED
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?