Job Cost Report: Cost Spreadsheet by Date Range (Hours to Units Conversion)

I have a Sage 300 Construction and Real Estate question.  We currently use Version 13.1.

We estimate labor for each item based on the unit description cost (ex. Square Yard, Acre, etc.) not per hour. However, we pay employees per hour not "Square Yard".  We have added columns to the Cost Spreadsheet by Date Range in Job Cost to add Units & Unit Cost to each category (labor, material, equip, etc) but it is pulling the hours paid from payroll.  How can I make the conversion from "hours" to "Square Yard" / etc.?

Parents
  • 0

    If I understand correctly, you want the number of square yards instead of hours.  When you set up the job, could you put the number of square yards into the Size field under JC-Set Up Job - General Tab-Size?  If you could use the "Size" field shown on the General Tab, you could change the "Total Labor Est Units" formula with simply Size (JC-Job).   To clarify your report, you could use the Unit Description on the JC-Set Up Job - General Tab - Unit Description to report along side your calculations to clarify if your intention was to use square yards, square acres, etc.  

  • 0 in reply to Rhonda V

    Rhonda  V - It appears the size field relates to the job as a whole.  Our jobs contain different items which are estimated with different units for each item.  For example, a job consists of 1 item that is billed as "Acres", the next item billed as "Square Yards", the next item as "TONs".  All of these on the same job.  So I'm not sure how I would use the size field to capture all of the items and be able to report each of them separately.

Reply
  • 0 in reply to Rhonda V

    Rhonda  V - It appears the size field relates to the job as a whole.  Our jobs contain different items which are estimated with different units for each item.  For example, a job consists of 1 item that is billed as "Acres", the next item billed as "Square Yards", the next item as "TONs".  All of these on the same job.  So I'm not sure how I would use the size field to capture all of the items and be able to report each of them separately.

Children
  • 0 in reply to Ronnie22

    In this situation, I think you should look at Jesse's response about Production Units.  I believe if you can set up different cost codes to correlate to the different units (i.e. cc1= acres, cc2= sq yrds, cc3= tons, etc.), then you could pull that information into the "Total Labor Est Units" formula and get it to work.  I believe you'd enter the size or the number of acres, square yards, and/or tons on each cost code through Enter Misc Worksheets task.  I'm not familiar with Production Units so if it were me, I'd create a copy of the company folder and test it or play with it.