Assistance building a VBA for a production rate tool

I am looking to build a tool that would assist my supervisors with determining the correct speed which they should look to operate their equipment at. I have an idea for a format of the VBA and a way to determine the optimal pace. I would need support bringing both of these concepts together.