Minihack - Inventory Optimization Agent
Goal
Flash Mobility needs to closely monitor available inventory to eliminate potential manufacturing delays. Stretch your skills to see if you can develop a solution using Retool Automation.
Optimize Inventory
Flash Mobility due to its physical plant size needs to be careful how it orders assemblies from its suppliers. The following image introduces some terminology and considerations when ordering.
As shown in the image when an ordered is placed the total time it takes for Flash Mobility to receive new assemblies is represented by Lead Time + Manufacturing Time + Delivery Time.
| Type | Description |
|---|---|
| Lead time | Time a supplier takes to plan, acquire raw materials, and finalize order. |
| Manufacturing time | Time a supplier takes to manufacture the assembly(s) for the batch size. |
| Delivery time | Time it takes to package and the deliver assembilies to Flash Mobility. |
Flash Suppliers Table
To support the minihack, we need an additional table to help identify assembly suppliers.
- Select Retool Home > Database.
- Select + and a form will appear as follows:
- Use Import CSV to import the following CSV example.
| Column name | Type |
|---|---|
| id | Number (Primary key) |
| name | Text |
| street_address | Text |
| state | Text |
| assembly | Foreign-key to flash_inventory primary key (Number) |
| lead_time | Number |
| manufacturing_time | Number |
| delivery_time | Number |
| cost_per_unit | Number |
| batch_size | Number |
Next steps
Identity data sources
Think about how you would support automated inventory management and what Retool Database tables will help in this effort. Remember you currently have:
- flash_customer
- flash_service
- flash_telematics
- flash_inventory
- flash_suppliers
Identify relevant Retool services
Identify which Retool services can help including:
- Retool Apps
- Retool Workflows
- Retool Agents
- Retool Database
- Retool Email
Define a solution architecture
Create a solution diagram, using Retool Iconography, that helps your team visualize how Retool Services and Data can be combined to solve the business problem.