Second Needed Formula, This Time For Forecasting

New Contributor

I came to a second formula that I cannot figure out. I got a great resolution to the first one, and I am thinking this will be easier. I am great with the basics but this is beyond me. 

 

SImple enough, and I am using numbers from last month for an example.. 

 

Selling Days - 26

Selling Days Completed - 22

Monthly Forecast - 13 units

Delivered MTD - 9

 

To be on pace for the monthly forecast of 13, I need a formula that gives me the number I should have after the 22 days. In this case, I know it to be 8, 3, 11 top to bottom - I just cannot get there with the spreadsheet)

 

06/03/2021          
           
Selling Days26         
Selling Days Completed22         
           
  Daily SoldMonth-To-DateTo Be On Forecast*Month Forecast     
  DeliveredTrack %       
           
 New783%         ???10     
 CPO279%         ???3     
 Total982%         ???13     
    

should be*

      
    8      
    3      
    11      
           
          
        
           
           
           
           
           
           
           
           
1 Reply

 

Hi @baronjosefr ,

It is a little hard to tell from your description what is needed.
However, I think this is the formula you are looking for:
=ROUND(G15*($B$8/$B$7),0)

StoneKiwi_0-1622757850356.png