#1
|
|||
|
|||
Help please - billing and cost forecast model
I've set up a forecast model to forecast billings and estimated costs so I can update it every month and it will calculate based on the remaining contract amounts to bill and the remaining estimated costs when I input updated start dates and end dates. We get updated schedules all the time and most of dates for our tasks for each job change so much, that it's too time consuming to try to manually calculate.
It's set up to calculate based on weeks for the duration, but I run into the dates falling into partial weeks and it either over calculates a week or under calculates a week. I've thought of using days as the duration, but more often than not we work Saturdays, sometimes on holidays, and even if we're not working on holidays, our Operators and foreman get paid holidays. Is there a formula or a different way to calculate the duration that will compensate for the partial weeks? Thank you so much for any suggestions. I've uploaded a sample of the worksheet I'm working on. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to forecast repeating monthly expenses entry | Richard1970 | Excel | 3 | 04-22-2016 06:53 PM |
Cost resource not taken in real cost | pascalbidouille | Project | 1 | 08-21-2015 01:25 PM |
Average Billing Rate | tbrozovich | Project | 2 | 08-18-2015 04:00 PM |
How to save a macro in a document generated with a word model? | Cristin7 | Word VBA | 4 | 03-25-2014 03:25 AM |
Comparing with a model format | qetuo | Word | 2 | 05-01-2013 11:23 PM |