Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am Trying to create a Work in Progress Backlog report using WIP Accounting practices. Where I am getting stuck is the not to exceed portion. I have a table that reflects the following fields. Estimated Reveue, Total Job Cost, and Recognized Revenue
Estimated Revenue is the amount we believe we are going to be paid for the job
Total Job Cost is the amount currently Spent in Cost on the job
Recognized Revenue is (Total Job Cost / 0.40 (Target Profit Margin))
I need help with the formula to make sure (Recognized Revenue does not exceed Estimated Revenue)
Perhaps rangemin([Recognized Revenue], [Estimated Revenue])
Perhaps rangemin([Recognized Revenue], [Estimated Revenue])
That worked Thank you.