{ Fundamentals of Financial Modeling 
    Revenue SubModel 
    Version 6.0 - use the FORECAST function to do an initial forecast of Total sales, but then 
                  allow user to manually override the forecast for one or more periods. 

                  } 

 'Column Control' = 'Last History Column' For c1 
 'Column Control' = 'Last History Column' COL 1 + 1.0 for c2  { This is the first projected column } 
 'Column Control' = LastColumn() for c3  { Last column in the matrix } 

 !Define For_History_Columns For c1 - Ind1 
 !Define For_Projected_Columns For Ind2 - Ind3 

 'Last History Column' 

 'Total Sales' = 'Sales - Cars' SUM 'Sales - Airplanes' For_History_Columns 
 'Sales Forecast Override' 
 'Total Sales' = ForecastRegression ('Total Sales', 1, 'Last History Column' COL 1) For_Projected_Columns 

 { Here is the override calculation:  } 

 ByColumn For_Projected_Columns 
   If 'Sales Forecast Override' <> 0.0 THEN 
     Begin 
       'Total Sales' = 'Sales Forecast Override' 
     END 
 EndByColumn 

 { Enter a projection for "Total Sales", and then apply a mix percentage to allocate sales to product lines } 

 'Sales - Cars' = 'Sales Mix % - Cars' * 'Total Sales' / 100.0 For_Projected_Columns 
 'Sales - Trucks'= 'Sales Mix % - Trucks' * 'Total Sales' / 100.0 For_Projected_Columns 
 'Sales - Airplanes'= 'Sales Mix % - Airplanes' * 'Total Sales' / 100.0 For_Projected_Columns 

   
   
 { Calculate the "Mix %" for historical time periods } 

 'Sales Mix % - Cars' = 'Sales - Cars' % 'Total Sales' For_History_Columns 
 'Sales Mix % - Trucks' = 'Sales - Trucks' % 'Total Sales' For_History_Columns 
 'Sales Mix % - Airplanes' = 'Sales - Airplanes' % 'Total Sales' For_History_Columns 
 '100% Mix check' = 'Sales Mix % - Cars' SUM 'Sales Mix % - Airplanes' 

   
 { Calculate cost of sales as a percentage of sales for historical time periods: } 
 'COS % - Cars' = 'COS - Cars' % 'Sales - Cars' For_History_Columns 
 'COS % - Trucks' = 'COS - Trucks' % 'Sales - Trucks' For_History_Columns 
 'COS % - Airplanes' = 'COS - Airplanes' % 'Sales - Airplanes' For_History_Columns 

 { Calculate cost of sales for the projected years only: } 
 'COS - Cars' = 'Sales - Cars' * 'COS % - Cars' / 100.0  For_Projected_Columns 
 'COS - Trucks' = 'Sales - Trucks' * 'COS % - Trucks' / 100.0 For_Projected_Columns 
 'COS - Airplanes' = 'Sales - Airplanes' * 'COS % - Airplanes' / 100.0 For_Projected_Columns 

 'Total Cost of Sales' = 'COS - Cars' SUM 'COS - Airplanes' 
 'Gross Profit' = 'Total Sales' - 'Total Cost of Sales' 

 'Overall COS %' = 'Total Cost of Sales' % 'Total Sales' 
 'Gross Margin %' = 'Gross Profit' % 'Total Sales'