Quick answer
Keep the calculated need and purchase quantity in separate columns. That preserves the reason for extra material such as waste, touch-up allowance or whole-package rounding.
Project record
Project Material Shopping List
| Room / area | Material | Calculated need | Purchase quantity | Package / unit | Supplier / notes | Row action |
|---|---|---|---|---|---|---|