Spreadsheet: 137574d1327233879-excel-2007-sales-tax-formula-sample-mec-po-11
Sheet: Purchase Order

 | [NAME]
 |  |  |  | Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | P.O. #: |  | /2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Vendor |  |  | Delivery Point |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  | Middle East Caravan Abu Rawash Factory - Abu Rawash Industrial Zone Cairo, Egypt. [NAME]: (+202) 3539 1093 - (+202) 3539 1192 Fax: (+202) 3539 1056 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2012 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2013 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2014 |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2015 |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2016 |  |  |  |  |  |  |  |  | 13
Shipping Method |  | Payment Terms |  |  | Delivery Date |  |  |  |  |  |  |  |  |  | /2017 |  |  |  |  |  |  |  |  | 14
Car |  | Postponed Cheque |  |  | 2012-01-16 00:00:00 |  |  |  |  |  |  |  |  |  | /2018 |  |  |  |  |  |  |  |  | 15
 |  | 2 Months |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | 16
Item # | Description |  |  | Quantity | Unit Price | Total Price |  |  |  |  |  |  |  |  | /2020 |  |  |  |  |  |  |  |  | 17
 |  |  |  | 22 | 5 |  |  |  |  |  |  |  |  |  | /2021 |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2022 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2023 |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2024 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2025 |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2026 |  |  |  | XXXXXX |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2027 |  |  |  | 1 Week |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2028 |  |  |  | 2 Weeks |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2029 |  |  |  | 3 Weeks |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | Included | 100% At Supply | /2030 |  |  |  | 4 Weeks |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100% At Delivery | /2031 |  |  |  | 1 Month |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60% Advance Payment & 40% At Delivery | /2032 |  |  |  | 2 Months |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50% Advance Payment & 50% At Delivery | /2033 |  |  |  | 3 Months |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash | /2034 |  |  |  | 4 Months |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Postponed Cheque | /2035 |  |  |  | 5 Months |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2036 |  |  |  | 6 Months |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2037 |  |  |  | 7 Months |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | Truck |  |  |  | /2038 |  |  |  | 8 Months |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  | Air Freight |  |  |  | /2039 |  |  |  | 9 Months |  |  |  |  | 36
 |  |  |  |  | Subtotal |  |  |  |  |  | Car |  |  |  | /2040 |  |  |  | 10 Months |  |  |  |  | 37
 |  |  |  |  | Overall Discount (%) | 53 |  |  |  |  | Container Shipping |  |  |  | /2041 |  |  |  | 11 Months |  |  |  |  | 38
 |  |  |  |  | Net Total Price |  |  |  |  |  | Express Mail Service (DHL, Fedex, TNT,..) |  |  |  | /2042 |  |  |  | 12 Months |  |  |  |  | 39
 |  |  |  | Included | Sales Tax (10%) |  |  |  |  |  |  |  |  |  | /2043 |  |  |  |  |  |  |  |  | 40
 | Mr. [NAME] Middle East Caravan Abu Rawash Factory - Abu Rawash Industrial Zone Cairo, Egypt. [NAME]: (+202) 3539 1093 - (+202) 3539 1192 Fax: (+202) 3539 1056 |  |  |  | Withholding Tax (0.05%) | 0 |  |  |  |  |  |  |  |  | /2044 |  |  |  |  |  |  |  |  | 41
 |  |  |  |  | Net Payable |  |  |  |  |  |  |  |  |  | /2045 |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2046 |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2047 |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2048 |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2049 |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2050 |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2051 |  |  | Site Office: |  |  |  |  |  | 48
 |  |  |  | Mr. [NAME] |  | 2012-01-17 00:00:00 |  |  |  |  |  |  |  |  | /2052 |  |  | Other: |  |  |  |  |  | 49
 |  |  |  | Authorized by |  | Date |  |  |  |  |  |  |  |  | /2053 |  |  | Middle East Caravan Abu Rawash Factory - Abu Rawash Industrial Zone Cairo, Egypt. [NAME]: (+202) 3539 1093 - (+202) 3539 1192 Fax: (+202) 3539 1056 |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2054 |  |  | Middle East Caravan Al Obour Factory - Al Obour Industrial Zone Cairo, Egypt. [NAME]: (+202) 4665 0183 Fax: (+202) 4665 0184 |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2055 |  |  | Middle East Caravan 17A [NAME]Cairo, Egypt. [NAME]: (+202) 2737 4648 Fax: (+202) 2737 4649 |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2056 |  |  |  |  |  |  |  |  | 53
[NAME] : 17 أ شارع محمد مظهر – الزمالك. القاهرة.           تليفون : 27374649 – 27374648             فاكس : 27374649. Head Office : 17 A. Mohamed Mazher st, [NAME], Cairo. [NAME] : (202) 27374649, 27374648.  Fax : 27374649. Factory :  [NAME] , [NAME]. [NAME]. : (202) 35391056, 35391093, 35391192 . Fax : 35391056 E- Mail : [EMAIL], [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2057 |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2058 |  |  |  |  | Mr. [NAME] |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2059 |  |  |  |  | Eng. [NAME] |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2060 |  |  |  |  | Mr. [NAME] |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2061 |  |  |  |  | Mr. [NAME] |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2062 |  |  |  |  | Mr. [NAME] |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2063 |  |  | Mr. [NAME] Middle East Caravan Abu Rawash Factory - Abu Rawash Industrial Zone Cairo, Egypt. [NAME]: (+202) 3539 1093 - (+202) 3539 1192 Fax: (+202) 3539 1056 |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2064 |  |  | Mr. [NAME] Middle East Caravan 17A [NAME]Cairo, Egypt. [NAME]: (+202) 2737 4648 Fax: (+202) 2737 4649 |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2065 |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2066 |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2067 |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2068 |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2069 |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2070 |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2071 |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2072 |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2073 |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2074
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2076
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2077
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2078
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2079
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2080
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2081
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2082
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2083
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2084
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2085
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2086
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2087
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2088
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2089
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /2090