excel
Mommia
EX2-ConstructionSupplyCompanyInventory.xlsxSheet1
| Construction Supply Company | Change | 2.5 | |||||
| Inventory, in cases | |||||||
| Pylons | Bricks | Tarps | Insulation | Total | What if? | ||
| Storage 1 | 67 | 65 | 67 | 48 | 247 | 617.5 | |
| Storage 2 | 39 | 53 | 57 | 62 | 211 | 0 | |
| Storage 3 | 50 | 44 | 69 | 33 | 196 | ERROR:#VALUE! | |
| Storage 4 | 33 | 89 | 56 | 39 | 217 | 152522.5 | |
| Storage 5 | 38 | 42 | 51 | 53 | 184 | 0 | |
| Total | 227 | 293 | 300 | 235 | |||
| 30% drop | 158.9 | 205.1 | 210 | 164.5 | |||
| Average | 45.4 | 58.6 | 60 | 47 | 211 | ||
| Maximum | 67 | 89 | 69 | 62 | 247 | ||
| Minimum | 33 | 42 | 51 | 33 | 184 |
