Overhead Distribution V2

Essentially when I saw this I had thought the client would be able to spread overhead costs out like the electric bill to whatever they had actively growing at the time they choose to spread the costs.

However, after reviewing the video the original intent of this was to allow users to mass output against production orders.

I would like to expand on this feature in V2 to allow the spreading of costs like the electric bill while keeping the ability to mass output. We would do this by adding a "Spread Cost" toggle on the Generate Lines from Production Order options page.

If the toggle is Off it will act as it does today. The fields that we are adding for spreading cost (listed below) will be greyed out and the user cannot input data into them unless the toggle is turned on. Turning the toggle from on to off will clear out these fields.

If the toggle is On users will be able to input data into the following fields:

• Direct Labor Amount

• Overhead Amount

To use this the user must select at least one work center on the options page.

When the user click OK the system will generate lines for the selected work center for all released production orders that have that work center (not necessarily ones with remaining quantity because they may do this end of month).

The system will count the number of lines it is going to insert and divide the Direct Labor Amount and Overhead Amount by the number of lines and insert the Directly Labor amount as the unit cost and the Overhead Amount as the overhead rate. If there is rounding - the final line will take the difference so the amounts equal the user input perfectly to two decimal places.

This is so the system can hit whichever of these two buckets they please:

Right now they only hit the Direct Cost. For something like electricity they would want to hit overhead cost.

Mock-up attached:

• Distribute costs across existing output inventory

• Need to be able to see Section and Bin in Overhead Distribution so that users can filter to these fields and apply overhead to the same sections / bins

*Pot size factor - McCorkle, identifies overhead for a month and distributes overhead across production orders based on Pot Size Factor (different pot sizes get diffenernt cost distribution).

Discuss with Dave Brobst and Chris McCorkle