Spreadsheet: 677933d1589596094-pick-cost-based-on-value-purchase-order-sept-2019-example
Sheet: Purchase Order

 |  |  |  | PURCHASE ORDER
 |  |  |  |  |  |  |  | PO DATE
 |  |  |  |  |  |  |  |  | R7 - T53 |  |  |  |  |  |  |  |  | Model | LCD | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/5 C | OEM | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 S | OEM | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | OEM | 19
 | DELIVERY ADDRESS |  |  |  |  | BILLING ADDRESS (If different to Delivery Address) |  |  |  |  |  |  |  |  |  |  |  | 6 S | OEM | 23
 | *Business Name: |  |  |  |  | *Business Name: |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | OEM | 26
 | *Business Position |  |  |  |  | *Business Position |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | OEM | 32
 | *Title: |  |  |  |  | *Title: |  |  |  |  |  |  |  |  |  |  |  | 7 | OEM | 30
 | *Full Name: |  |  |  |  | *Full Name: |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | OEM | 46
 | *Address Line 1: |  |  |  |  | *Address Line 1:
 | Address Line 2: |  |  |  |  | Address Line 2: |  |  |  |  |  |  |  |  |  |  |  | 8 | OEM | 43
 | *Town/City: |  |  |  |  | *Town/City: |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | OEM | 54
 | *County: |  |  |  |  | *County: |  |  |  |  |  |  |  |  |  |  |  | X | OEM | 161
 | *Postcode: |  |  |  |  | *Postcode: |  |  |  |  |  |  |  |  |  |  |  | X Off Phone | OEM | 166
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XR | OEM | 96
 | *Contact Number: |  |  |  |  | *Contact Number: |  |  |  |  |  |  |  |  |  |  |  | XS | OEM | 171
 | *Email Address |  |  |  |  | *Email Address |  |  |  |  |  |  |  |  |  |  |  | [NAME] | OEM | 236
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/5 C | GENERIC | 10
 | ITEM # | Make | LCD | Model | Colour | QTY | UNIT PRICE | AMOUNT |  |  |  |  |  |  |  |  |  | SE | GENERIC | 10
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | GENERIC | 11
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | GENERIC | 16
 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S | GENERIC | 16
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | GENERIC | 19
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | GENERIC | 17
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 With Plate | GENERIC | 18
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | GENERIC | 19
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | GENERIC | 19
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | GENERIC | 21
 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X Hard OLED New | GENERIC | 81
 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X Soft OLED | GENERIC | 121
 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XR Copy | GENERIC | 71
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XS OLED | GENERIC | 131
 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Premium | 14
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | Premium | 19
 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S | Premium | 18
 | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | Premium | 19.5
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Prem/Tianma | Premium | 19.5
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | Premium | 23.5
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Prem/Tianma | Premium | 23.5
 |  |  |  |  |  | SUB TOTAL
 |  |  |  |  |  | Shipping & Handling |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | Premium | 26
 |  |  |  |  |  | VAT @20%
 | Notes/Additional Information |  |  |  |  | TOTAL NET |  |  |  |  |  |  |  |  |  |  |  | 6 | NCC | 15.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 Plus | NCC | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S | NCC | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 S Plus | NCC | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | NCC | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 Plus | NCC | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | NCC | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Plus | NCC | 26