ESM_Attachment 7 Operational Cost Scenario Template Final.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- Enterprise Sales and Marketing Solution Federal contract opportunity
- Solicitation number
- 2031JG22R00025
About this file
This document contains a template and instructions for offerors to provide pricing for operating cost scenarios for an enterprise sales and marketing solution. The template includes four scenarios with varying order volumes and transaction details for calls, orders, shipments and website traffic. Offerors are to apply their proposed variable and fixed pricing to the parameters for each scenario and summarize the total variable costs, fixed costs, and grand total. Instructions specify using GFY 2024 rates and assuming a full fiscal year of operations for fixed costs. Assumptions used to calculate costs for each scenario must be clearly identified.
The related federal contract opportunity is a solicitation for an end-to-end enterprise sales and marketing solution for the United States Mint's numismatic program, including contact center and fulfillment operations, an integrated order management system, eCommerce platform, business analytics, customer relationship management, and business-to-business solutions. The scope covers hardware, software, hosting, operations and maintenance, staffing, and integration with internal and external systems. The selected contractor will provide a turnkey retail service solution.
View the file
Other files for this federal contract opportunity
Show all 23
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Pricing Instructions
| Supplemental information for Operating Cost Scenario | |
| The purpose of the Operating Cost Scenario workbook is to evaluate the offeror’s proposed prices for Operations and Maintenance based on various scenarios. The offeror is responsible for applying the applicable fixed and variable prices in self-determined units for each scenario. Any assumptions to the cost factors used shall be outlined in the tables. | |
| There is a “Scenario” tab/worksheet for each of the four scenarios. The scenario tabs allow each offeror to apply their proposed transactional and fixed rates to the USM provided cost model parameters to price out each scenario. The Scenario Summary Roll-up tab will link to the calculated “Grand Totals” from each scenario tab/worksheet. | |
| Operating Cost Scenario Instructions: | |
| 1. For each scenario, the USM has provided a variety of cost parameters that the offeror can use to estimate the annual O&M costs. The Government does not expect all cost parameters will be used by the offeror; only the applicable variables should be used based on each offerors unique pricing practices. | |
| 2. For each scenario, the offeror shall only use the transactional and fixed rates that are proposed in the pricing template under the O&M tab. | |
| 3. The offeror shall use Government Fiscal Year (GFY) 2024 rates for each scenario. | |
| 4. For all monthly or annual fixed rates, the offeror shall assume one full GFY of operations for each scenario. | |
| 5. The offeror shall clearly identify any assumptions that are used for the calculation of each cost (e.g., 50% of bulk orders are made through the web). |
ATTACHMENT 5 - OPERATIONAL COST SCENARIO TEMPLATE
Scenario Summary Roll-up US Mint Provided Cost Model Parameters
| Order Volume by Channel | ||||||||||||||||
| (Number of Units Sold) | Calls | Pick/Pack/Ship | Web Page | |||||||||||||
| Web | Subscriptions | Phone | Bulk | Total Call Volume | Average Call Length (minutes) | Total call minutes | Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | ||
| Scenario 1 | 3,285,337 | 1,167,580 | 49,065 | 458,638 | 492,124 | 7.64 | 3,759,827.36 | 1,847,307 | 1,936,937 | 3,851,229 | 1,657,072 | 16,261 | 157,568,476 | 9,493,984 | 25,256,976 | |
| Scenario 2 | 2,399,271 | 965,546 | 270,395 | 442,974 | 413,187 | 6.97 | 2,877,847.46 | 1,483,549 | 1,769,594 | 3,607,864 | 1,397,573 | 15,045 | 104,814,734 | 7,082,541 | 17,546,680 | |
| Scenario 3 | 1,513,205 | 763,511 | 491,724 | 427,309 | 334,250 | 6.29 | 2,102,432.50 | 1,119,791 | 1,602,251 | 3,364,498 | 1,138,074 | 13,829 | 52,060,991 | 4,671,097 | 9,836,384 |
OFFEROR SCENARIO SUMMARY TOTALS
(Totals automatically calculated from each "Scenario" Tab)
DO NOT EDIT FORMULAS
| Total Variable Costs | Total Fixed Costs | Grand Total | |
| Scenario 1 | $0.00 | $0.00 | $0.00 |
| Scenario 2 | $0.00 | $0.00 | $0.00 |
| Scenario 3 | $0.00 | $0.00 | $0.00 |
NOTE: All phone calls do not result in an order.
Scenario 1
| COST MODEL PARAMETERS | ||||||||||||||||
| Order Volume by Channel | ||||||||||||||||
| (Number of Units Sold) | Calls | Pick/Pack/Ship | Web Page | |||||||||||||
| Scenario 1 | Web | Subscriptions | Phone | Bulk | Total Call Volume | Average Call Length (minutes) | Total Call Minutes | Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | |
| 3,285,337 | 1,167,580 | 49,065 | 458,638 | 492,124 | 7.64 | 3,759,827 | 1,847,307 | 1,936,937 | 3,851,229 | 1,657,072 | 16,261 | 157,568,476 | 9,493,984 | 25,256,976 |
| Provide variable and fixed costs (as applicable), along with assumptions used to address scenario parameters above. | |||||||
| Vendor Cost Factors | |||||||
| Cost | Cost Definition | Variable Cost/Unit | # of Units | Per Unit Description | Fixed | Total | Cost Assumptions |
| cost 1 | $0.00 | $0.00 | |||||
| cost 2 | $0.00 | $0.00 | |||||
| cost 3 | $0.00 | $0.00 |
| if needed, |
| insert more rows |
Grand Total $ - 0 $0.00 $0.00
Scenario 2
| COST MODEL PARAMETERS | ||||||||||||||||
| Order Volume by Channel | ||||||||||||||||
| (Number of Units Sold) | Calls | Pick/Pack/Ship | Web Page | |||||||||||||
| Scenario 2 | Web | Subscriptions | Phone | Bulk | Total Call Volume | Average Call Length (minutes) | Total call minutes | Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | |
| 2,399,271 | 965,546 | 270,395 | 442,974 | 413,187 | 6.97 | 2,877,847 | 1,483,549 | 1,769,594 | 3,607,864 | 1,397,573 | 15,045 | 104,814,734 | 7,082,541 | 17,546,680 | ||
| Provide variable and fixed costs (as applicable), along with assumptions used to address scenario parameters above. | ||||||||||||||||
| Vendor Cost Factors | ||||||||||||||||
| Cost | Cost Definition | Variable Cost/Unit | # of Units | Per Unit Description | Fixed | Total | Cost Assumptions | |||||||||
| cost 1 | $0.00 | $0.00 | ||||||||||||||
| cost 2 | $0.00 | $0.00 | ||||||||||||||
| cost 3 | $0.00 | $0.00 |
| if needed, |
| insert more rows |
Grand Total $ - 0 $0.00 $0.00
Scenario 3
| COST MODEL PARAMETERS | ||||||||||||||||
| Order Volume by Channel | ||||||||||||||||
| (Number of Units Sold) | Calls | Pick/Pack/Ship | Web Page | |||||||||||||
| Scenario 3 | Web | Subscriptions | Phone | Bulk | Total Call Volume | Average Call Length (minutes) | Total call minutes | Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | |
| 1,513,205 | 763,511 | 491,724 | 427,309 | 334,250 | 6.29 | 2,102,433 | 1,119,791 | 1,602,251 | 3,364,498 | 1,138,074 | 13,829 | 52,060,991 | 4,671,097 | 9,836,384 | ||
| Provide variable and fixed costs (as applicable), along with assumptions used to address scenario parameters above. | ||||||||||||||||
| Vendor Cost Factors | ||||||||||||||||
| Cost | Cost Definition | Variable Cost/Unit | # of Units | Per Unit Description | Fixed | Total | Cost Assumptions | |||||||||
| cost 1 | $0.00 | $0.00 | ||||||||||||||
| cost 2 | $0.00 | $0.00 | ||||||||||||||
| cost 3 | $0.00 | $0.00 |
| if needed, |
| insert more rows |
Grand Total $ - 0 $0.00 $0.00
File details come from the government source that posted it. Updated .