Hey all,
Looking for an Airtable and Zapier automation expert to discuss feasibility and implement the following for a manufacturing environment building large electrical and controls skids. We have a few disparate excel sheets built out and goals in mind, but feel the need to move to a database system to truly get what we’re after:
Tracking the reception of Purchase Orders and generating automatic emails and automatic table updates as material quantities are changed by the client and our team (if feasible, from changes in a sharepoint Excel or some such)
Track the deadline start and end dates on a project based on manloading, bottlenecks created by delivery of materials from (4) different vendors. Implement a calendar buildout to view gaps in the schedule. We have approximately (10) bays where skids are fabricated with a variable amount of employees dependent on size of skid.
Track average delay times created by bottlenecks from suppliers
Create PDF-able “client views” to show clients updated ship dates and status of existing projects (% complete, estimated ship date, serial no., tracking no.)
Accounting for manufacturing costs, labor costs, markup/OH and the variance from the estimate of these items to the actual quantities being realized
Automate the updating of hours spent on individual jobs based on a report generated by our WBS program
Other cool, time-saving stuff you can suggest
If you’re interested, please post here and I’ll reach out to set up a time to meet and discuss scope and pricing.
An NDA may be required re: our financials based on our sensitive clientele.