Appendix C - Price Sheets
Appendix C - Price Sheets
NOTE: This workbook is setup with formulas to autocalulate costs, subtotal, and total within individual tabs with references to individual tab subtotals in the Summary Tab.
It is also formatted for user friendly printing. Worksheets are protected without a password to prevent inadvertent modification or overwriting of the formulas and references. To
modify an individual worksheet, unprotect the worksheet and make your modifications. If Proposer modifies a worksheet, Proposer is responsible for ensuring the integrity of the
calculations, references, and formatting.
Summary Enter the following in the white highlighted areas. All other data is automatically updated from the other worksheets.
- Proposer Name - Enter the name of your company
- Solution Name - Enter a descriptive name of the solution you are proposing
- SaaS - Enter 'Yes' if this is a Software as a Solution (Cloud based) proposal. Enter 'No' if you are proposing a locally hosted solution.
- ERP Software Proposed - Define the ERP software being proposed.
NOTE: This list is used in the 'Licenses' tab to summarize by Licenses in the 'Summary' tab.
- Services Proposed - Define the Services being proposed.
NOTE: This list is referenced in the 'Services' tab to summarize by Services in the 'Summary' tab.
Licenses Provide a detailed breakout of software pricing or other licensed products needed to meet the RFP requirements. Identify the number of user licenses being
proposed and clearly describe the basis for licensing and method to justify number of licenses being proposed. NOTE: The 'Software' column in this tab
references the 'ERP Software Proposed' list in the 'Summary' tab. Make sure to select a valid entry so that the 'Licenses and Ongoing Maintenance Costs' section
in the 'Summary' tab will summarize correctly.
Services Identify the quantity, hourly rate, and total cost for all professional services needed to ensure a successful implementation. Proposers are encouraged to
provide a breakdown of the service categories that will be provided to support the implementation to allow evaluators to understand the level of effort,
resources, and cost of services. NOTE: The 'Software' column in this tab references the 'ERP Software Proposed' list in the 'Summary' tab. And the 'Services'
column in this tab references the 'Services Proposed' list in the Summary tab. Make sure to select a valid entry for these columns so that the 'Services Cost by
Service' and 'Services cost by Software' sections in the 'Summary' tab will summarize correctly.
SaaS-Hosting Provide a detailed breakout of software hosted pricing needed to meet the RFP requirements. NOTE: The 'Software' column in this tab references the 'ERP
Software Proposed' list in the 'Summary' tab. Make sure to select a valid entry so that the 'Hosting Costs' section in the 'Summary' tab will summarize correctly.
Optional Products Identify any optional product offerings that may be of interest that the Proposer would like to recommend.
Optional Services Identify any optional service offerings that may be of interest that the Proposer would like to recommend.
781528278.xlsx Page 1
Travel Identify the projected travel costs associated with Proposer’s implementation services including the anticipated number of trips, days of service per trip, and
estimated per trip cost. The selected Proposer will be reimbursed based on actual trip expenses supported by receipts and documentation.
Professional Services Provide hourly pricing for additional services that may be required during the implementation. If necessary, these rates will be used to purchase additional
services.
781528278.xlsx Page 2
Solution Pricing Summary
Solution Pricing Summary One Time Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total
Licenses and Ongoing Maintenance Costs Subtotal $ - $ - $ - $ - $ - $ - $ -
Hosting Costs Subtotal $ - $ - $ - $ - $ - $ - $ -
Services Costs Subtotal $ - $ -
Travel Costs Subtotal $ - $ -
Total Solution Cost $ - $ - $ - $ - $ - $ - $ -
Optional Products Subtotal $ - $ - $ - $ - $ - $ - $ -
Optional Services Costs Subtotal $ - $ -
Total Solution Cost with Options $ - $ - $ - $ - $ - $ - $ -
Licenses and Ongoing Maintenance Costs by Software One Time Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total
Finance $ - $ - $ - $ - $ - $ - $ -
Payroll $ - $ - $ - $ - $ - $ - $ -
HR $ - $ - $ - $ - $ - $ - $ -
Misc. Billing $ - $ - $ - $ - $ - $ - $ -
Business Licensing $ - $ - $ - $ - $ - $ - $ -
Other $ - $ - $ - $ - $ - $ - $ -
N/A $ - $ - $ - $ - $ - $ - $ -
Licenses and Ongoing Maintenance Costs $ - $ - $ - $ - $ - $ - $ -
OK OK OK OK OK OK OK
781528278.xlsx Page 3
Hosting Costs by Software Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total
Finance $ - $ - $ - $ - $ - $ -
Payroll $ - $ - $ - $ - $ - $ -
HR $ - $ - $ - $ - $ - $ -
Misc. Billing $ - $ - $ - $ - $ - $ -
Business Licensing $ - $ - $ - $ - $ - $ -
Other $ - $ - $ - $ - $ - $ -
N/A $ - $ - $ - $ - $ - $ -
Hosting Costs $ - $ - $ - $ - $ - $ -
OK OK OK OK OK OK
Services Costs by Service One Time Services Costs by Software One Time
Implementation $ - Finance $ -
Conversion $ - Payroll $ -
Interface $ - HR $ -
TBD1 $ - Misc. Billing $ -
TBD2 $ - Business Licensing $ -
Other $ - Other $ -
N/A $ - N/A $ -
Services Costs $ - Services Costs $ -
OK OK
781528278.xlsx Page 4
Proposer Name: Sample Vendor Solution Name: Sample Software
781528278.xlsx Page 5
Proposer Name: Sample Vendor Solution Name: Sample Software
781528278.xlsx Page 6
Proposer Name: Sample Vendor Solution Name: Sample Software
781528278.xlsx Page 7
Proposer Name: Sample Vendor Solution Name: Sample Software
781528278.xlsx Page 8
Proposer Name: Sample Vendor Solution Name: Sample Software
Hosting Costs
Software Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Note #
$ - 1
$ - 2
$ - 3
$ - 4
$ - 5
$ - 6
$ - 7
$ - 8
$ - 9
$ - 10
$ - 11
$ - 12
$ - 13
$ - 14
$ - 15
$ - 16
$ - 17
$ - 18
$ - 19
$ - 20
$ - 21
$ - 22
$ - 23
$ - 24
$ - 25
$ - 26
$ - 27
$ - 28
$ - 29
$ - 30
$ - 31
$ - 32
$ - 33
$ - 34
$ - 35
781528278.xlsx Page 9
Proposer Name: Sample Vendor Solution Name: Sample Software
Hosting Costs
Software Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Note #
$ - 36
$ - 37
$ - 38
$ - 39
$ - 40
Total Hosting Costs $ - $ - $ - $ - $ - $ -
OK OK OK OK OK OK
Group by Vendor and Software
1 - Enter name of Module for software listed or description. If 'Other' entered for software, enter name of
product or describe product.
2 - Notes and Assumptions (use Note # to correspond to table above)
781528278.xlsx Page 10
Proposer Name: Sample Vendor Solution Name: Sample Software
Hosting Costs
Software Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Note #
781528278.xlsx Page 11
Proposer Name: Sample Vendor Solution Name: Sample Software
Hosting Costs
Software Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Note #
781528278.xlsx Page 12
Proposer Name: Sample Vendor Solution Name: Sample Software
Services Costs
Service Software # of Hours 1Rate/ Hour One Time Cost Note #
$ - 1
$ - 2
$ - 3
$ - 4
$ - 5
$ - 6
$ - 7
$ - 8
$ - 9
$ - 10
$ - 11
$ - 12
$ - 13
$ - 14
$ - 15
$ - 16
$ - 17
$ - 18
$ - 19
$ - 20
$ - 21
$ - 22
$ - 23
$ - 24
$ - 25
$ - 26
$ - 27
$ - 28
$ - 29
$ - 30
$ - 31
$ - 32
$ - 33
781528278.xlsx Page 13
Proposer Name: Sample Vendor Solution Name: Sample Software
Services Costs
Service Software # of Hours 1Rate/ Hour One Time Cost Note #
$ - 34
$ - 35
$ - 36
$ - 37
$ - 38
$ - 39
$ - 40
Total Services Costs $ -
Check to Summary Tab -> OK
Group by Vendor and Service
1 - If Flat Rate for service, enter "Flat" in "# of Hours" and enter total cost in "Rate/Hour"
2 - Notes and Assumptions (use Note # to correspond to table above)
781528278.xlsx Page 14
Proposer Name: Sample Vendor Solution Name: Sample Software
Services Costs
Service Software # of Hours 1Rate/ Hour One Time Cost Note #
781528278.xlsx Page 15
Proposer Name: Sample Vendor Solution Name: Sample Software
Services Costs
Service Software # of Hours 1Rate/ Hour One Time Cost Note #
781528278.xlsx Page 16
Sample Vendor Sample Software
Travel Costs
Trip Description # of Trips Cost Per Trip Total Note #
$ - 1
$ - 2
$ - 3
$ - 4
$ - 5
$ - 6
$ - 7
$ - 8
$ - 9
$ - 10
$ - 11
$ - 12
$ - 13
$ - 14
$ - 15
$ - 16
$ - 17
$ - 18
$ - 19
$ - 20
Total Travel Costs - $ - $ -
781528278.xlsx Page 17
Sample Vendor Sample Software
Travel Costs
Trip Description # of Trips Cost Per Trip Total Note #
781528278.xlsx Page 18
Proposer Name: Sample Vendor Solution Name: Sample Software
Optional Products
Software # of Cost/
2
One Time Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Note #
Licenses License Cost
$ - $ - 1
$ - $ - 2
$ - $ - 3
$ - $ - 4
$ - $ - 5
$ - $ - 6
$ - $ - 7
$ - $ - 8
$ - $ - 9
$ - $ - 10
$ - $ - 11
$ - $ - 12
$ - $ - 13
$ - $ - 14
$ - $ - 15
$ - $ - 16
$ - $ - 17
$ - $ - 18
$ - $ - 19
$ - $ - 20
Total Optional Products $ - $ - $ - $ - $ - $ - $ -
Group by Software
1 - Enter name of Module for software listed or description. If 'Other' entered for software, enter name of
product or describe product.
2 - If Unlimited Licenses, enter "Unlim" in "# of Licenses" and enter total cost in "Cost/License"
3 - Notes and Assumptions (use Note # to correspond to table above)
781528278.xlsx Page 19
<Enter notes and assumptions>
Proposer Name: Sample Vendor Solution Name: Sample Software
Optional Products
Software # of 2
Cost/ One Time Year 1 Year 2 Year 3 Year 4 Year 5 Grand Total Note #
Licenses License Cost
781528278.xlsx Page 20
Proposer Name: Sample Vendor Solution Name: Sample Software
Group by Service
1 - If Flat Rate for service, enter "Flat" in "# of Hours" and enter total cost in "Rate/Hour"
2 - Notes and Assumptions (use Note # to correspond to table above)
781528278.xlsx Page 21
<Enter notes and assumptions>
781528278.xlsx Page 22
Sample Vendor Sample Software
781528278.xlsx Page 23
Sample Vendor Sample Software
781528278.xlsx Page 24