No information you provide on this form is stored by this or any other website. You may enter information directly into this form, but....IF YOU WISH TO RETAIN THE INFORMATION, DOWNLOAD THE FORM TO AN APPROPRIATE FILE ON YOUR SYSTEM. Use the download button at the bottom right of the form.
There is a demonstration worksheet which illustrates how to use this tool directly below the live worksheet.
The calculator may show negative numbers for completed projects because the overhead allocation factor is constantly adjusting to the actual relationship between Cost of Goods Sold and General and Administrative expenses for all jobs in all periods.
Make the adjustments monthly or annually by making a General Journal entry to your accounting platform.