| |
[Company Name] |
|
|
|
|
|
| |
Procurement Analysis Worksheet |
|
|
|
|
| |
[Date] |
|
|
|
|
|
| |
|
|
|
|
|
|
| |
Gray cells are calculated for you. You do not need to enter anything into them. |
|
|
|
| |
Procurement information |
|
|
|
|
|
| |
Date of purchase request |
|
|
|
|
| |
Requested by |
|
|
|
|
| |
Description of purchase |
|
|
|
|
| |
Type of purchase |
|
|
|
|
| |
Delivery date requested |
|
|
|
|
| |
|
|
|
|
|
|
| |
Vendor information |
|
|
|
|
|
| |
Name of vendor |
|
|
|
|
| |
If a formal contract is in place, indicate contract number here |
|
|
|
|
|
| |
Vendor address |
|
|
|
|
| |
Vendor contact number |
|
|
|
|
| |
Vendor contact name and title |
|
|
|
|
| |
|
|
|
|
|
|
| |
Investment |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
|
| |
Initial investment |
$1,200,000 |
$0 |
$0 |
$0 |
|
| |
Implementation costs |
400,000 |
0 |
0 |
0 |
|
| |
On-going support costs |
0 |
100,000 |
100,000 |
100,000 |
|
| |
Training costs |
50,000 |
25,000 |
25,000 |
25,000 |
|
| |
Other costs |
0 |
0 |
0 |
0 |
|
| |
Total costs |
$1,650,000 |
$125,000 |
$125,000 |
$125,000 |
|
| |
Cumulative costs |
$1,650,000 |
$1,775,000 |
$1,900,000 |
$2,025,000 |
|
| |
|
|
|
|
|
|
| |
Benefits |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
|
| |
Total benefits realized |
$0 |
$1,243,675 |
$1,275,000 |
$1,342,980 |
|
| |
Cumulative benefits |
$0 |
$1,243,675 |
$2,518,675 |
$3,861,655 |
|
| |
|
|
|
|
|
|
| |
Net flow |
(1,650,000) |
1,118,675 |
1,150,000 |
1,217,980 |
|
| |
Cumulative net |
($1,650,000) |
($531,325) |
$618,675 |
$1,836,655 |
|
| |
|
|
|
|
|
|
| |
Financial measures |
|
|
|
|
|
| |
Cost of capital |
15% |
|
|
|
|
| |
Net present value |
$993,168 |
|
|
|
|
| |
Payback (in years) |
1.46 |
|
|
|
|
| |
|
|
|
|
|
|
| |
Signatures |
|
|
|
|
|
| |
Requester |
|
Notes |
|
|
| |
Approver—Level 1 |
|
If request is denied, please indicate reason. |
|
| |
Approver—Level 2 (if required) |
|
Please provide any other notes regarding the procurement request. |
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
