Resource Leveling over Time in Excel

I have four employees producing widgets, and each has been assigned a target that is out of proportion with their throughput. This has an impact on the overall time taken to complete the production order (see attached Excel snapshot image).

Is there a formula/function I can use to distribute the load to match each employee's throughput, and level out production to complete the order in the shortest possible time?

FYI,

The month of January shows each employee's target, which decreases each subsequent month based on the number of widgets expected to be produced based on their maximum output.

Many thanks.