Spreadsheet: 710559d1609099107-help-with-cost-forecasting-formulas-project-reporting-v8
Sheet: PO, SO, WO

1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planning |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecasting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Potential Pyramid Peak Date | Pyramid Slope | Check Sum | Check Sum | Entry Date | WBS / Cost Center | WBS / Cost Center   Name | GL | [NAME]/WO | PO/SO | Agreement | Website Link for PO or SO | Scope of Work or Material List  Link | [NAME]  Link | Quote  Link | Vendor | Stock Code / Part Number | Vendor Description | Package Name / Scope Name | Quantity Ordered | Unit of Measure | Gross Price | Freight | Estimated Approval Time | Goods Lead Time | Services Duration | Estimated Start Date | Estimated End Date | Contact Name | Contact Number | Contact E-Mail Address | Capital / Capital Expense / Expense | Goods / Services | Distribution  Uniform / Pyramid | Depreciable / Consumable | Asset Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MM/DD/YYYY | $/day2 | $ | $ | MM/DD/YYYY | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | - | $ | $ | Weeks | Weeks | Weeks | MM/DD/YYYY | MM/DD/YYYY | - | (NNN)-NNN-NNNN | - | - | - |  | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-03 00:00:00 |  | A |  |  |  |  |  |  |  |  | AA |  |  | AAA |  |  | 1000 |  | 1 | 4 |  |  |  |  |  |  |  | Goods | Pyramid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-03 00:00:00 |  | B |  |  |  |  |  |  |  |  | BB |  |  | AAA |  |  | 2000 |  | 1 | 5 |  |  |  |  |  |  |  | Goods | Uniform
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-04 00:00:00 |  | C |  |  |  |  |  |  |  |  | CC |  |  | AAA |  |  | 3000 |  | 10 | 10 |  |  |  |  |  |  |  | Goods | Uniform
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-05 00:00:00 |  | B |  |  |  |  |  |  |  |  | DD |  |  | BBB |  |  | 4000 |  | 2 |  | 20 |  |  |  |  |  |  | Services | Pyramid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-06 00:00:00 |  | A |  |  |  |  |  |  |  |  | EE |  |  | BBB |  |  | 5000 |  | 2 |  | 5 |  |  |  |  |  |  | Services | Pyramid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-02-07 00:00:00 |  | A |  |  |  |  |  |  |  |  | EE |  |  | BBB |  |  | 5000 |  |  |  |  |  |  |  |  |  |  | Services | Pyramid