View Single Post
  #3   Report Post  
dukes
 
Posts: n/a
Default How do I calculate pro-rata formulas?

This is what the spreadsheet looks like. The payraise totals are $129,625.
The improvements totals are $425,866. How do I pro-rate these amounts to the
various providers and what would the formulas look like?

CONTRACTORS Beginning Budget PayRaise Improvements Ending Budget
Creative 166,635
GHL 1,029,902
Haralson 95,971
Lookout Mounta 1,731,389
Three Rivers 1,432,702
TOTALS 4,456,599

Thank you so much for your help!