qjhart
commented
9 years ago @ncparker @blyeo @judyhanna I have updated the project to include two new files. materials.csv and operations.csv.
materials.csv
| material | units | class | description |
|---|
Is a list of every line item that was found in any of Santiago's budgets. You will see from this a number of things:
- There are a lot of items that are the same, but with different names
- There is a great deal of specificity for things like fertilizers.
- The units need to be cleaned up.
- The current budgets use a lot of line items for things that Nathan described as operations. This is a problem, because, you'd like to reuse your materials for different operations. For example, the material Cool and Pack, should probably be an operation, where you reuse the material, like Labor.
operations.csv
Based on that, I've created a second file
| phase | operation | unit | description |
|---|
That describes the operations you might budget for. I pulled these from the line items (materials) above. So, I will update the production table to include an operation for each line item. That way, we can start to think of how we can annualize (and variably adjust) these costs.
The current budgets are fairly fast and loose with the materials used. We need to get better standardization on this inputs. The first item for that is to get list of the current materials and budgets used.