Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2016, 09:43 AM
dee38 dee38 is offline Help please - billing and cost forecast model Windows 7 64bit Help please - billing and cost forecast model Office 2007
Novice
Help please - billing and cost forecast model
 
Join Date: Oct 2016
Posts: 1
dee38 is on a distinguished road
Default 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.
Attached Files
File Type: xlsm Budget Forescast Model.xlsm (234.3 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help please - billing and cost forecast model how to forecast repeating monthly expenses entry Richard1970 Excel 3 04-22-2016 06:53 PM
Help please - billing and cost forecast model Cost resource not taken in real cost pascalbidouille Project 1 08-21-2015 01:25 PM
Help please - billing and cost forecast model Average Billing Rate tbrozovich Project 2 08-18-2015 04:00 PM
Help please - billing and cost forecast model How to save a macro in a document generated with a word model? Cristin7 Word VBA 4 03-25-2014 03:25 AM
Help please - billing and cost forecast model Comparing with a model format qetuo Word 2 05-01-2013 11:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft