Jul 02 2019 02:47 AM
Hi,
First time on here, maybe some one can help? I would appreciate some review/feedback and help on the attached images (can send file if necessary) which fails to compute change in salaried employee start date and reduce direct cost from the month they started.
I believe all other formulas work correctly but please let me know if there's a better way; formulas I've used:
Much appreciated and love you guys.
Jul 02 2019 03:21 AM
Jul 02 2019 03:44 AM
Thanks for your kind review; please see attached @Twifoo
Jul 02 2019 04:02 AM
Jul 02 2019 04:10 AM
As you can see in assumption boxes; all these variables should perfectly flow into forecast; for example if salaried employee starts in Oct instead then then the forecast should compute its first payment . from Nov & the Direct cost payable also reduces from Nov linking back to the number of jobs that employee can do per week @Twifoo