Attachment_5_Operational_Cost_Scenario_Template.xlsx
XLSX spreadsheet 38 KB Posted
- Solicitation number
- USM-HQ-13-0018
About this file
Attachment 5 - Operational Cost Scenario Template
View the file
Other files
Show all 32
On GovTribe
Work with this file
- 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) 2014 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 | Total Call Minutes | Number of Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | |||
| Scenario 1 | 1,917,855 | 1,895,619 | 839,409 | 272,391 | 605,931 | 597,896 | 3,328,617 | 5,531,205 | 2,592,348 | 5,558,829 | 1,784,610 | 105,597 | 919,836,162 | 7,595,009 | 14,532,247 | |
| Scenario 2 | 3,300,908 | 1,053,208 | 1,265,134 | 282,568 | 481,650 | 753,641 | 4,152,837 | 6,383,468 | 3,063,317 | 6,421,709 | 2,141,126 | 128,014 | 2,269,098,242 | 16,346,144 | 37,314,067 | |
| Scenario 3 | 4,621,271 | 1,474,491 | 1,771,188 | 395,595 | 674,310 | 1,055,097 | 5,813,972 | 8,936,855 | 4,288,644 | 8,990,393 | 2,997,576 | 179,220 | 3,176,737,539 | 22,884,602 | 52,239,694 | |
| Scenario 4 | 5,941,634 | 1,895,774 | 2,277,241 | 508,622 | 866,970 | 1,356,554 | 7,475,107 | 11,490,242 | 6,004,101 | 12,586,550 | 4,196,607 | 250,907 | 4,084,376,836 | 29,423,059 | 67,165,321 |
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 | For each scenario, totals are linked to calculations from each tab. DO NOT EDIT FORMULAS. |
| Scenario 2 | $0.00 | $0.00 | $0.00 | |
| Scenario 3 | $0.00 | $0.00 | $0.00 | |
| Scenario 4 | $0.00 | $0.00 | $0.00 |
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 | Total Call Minutes | Number of Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | ||
| 1,917,855 | 1,895,619 | 839,409 | 272,391 | 605,931 | 597,896 | 3,328,617 | 5,531,205 | 2,592,348 | 5,558,829 | 1,784,610 | 105,597 | 919,836,162 | 7,595,009 | 14,532,247 | ||
| 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 | Total Call Minutes | Number of Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | ||
| 3,300,908 | 1,053,208 | 1,265,134 | 282,568 | 481,650 | 753,641 | 4,152,837 | 6,383,468 | 3,063,317 | 6,421,709 | 2,141,126 | 128,014 | 2,269,098,242 | 16,346,144 | 37,314,067 | ||
| 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 | Unit | 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 | Total Call Minutes | Number of Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | ||
| 4,621,271 | 1,474,491 | 1,771,188 | 395,595 | 674,310 | 1,055,097 | 5,813,972 | 8,936,855 | 4,288,644 | 8,990,393 | 2,997,576 | 179,220 | 3,176,737,539 | 22,884,602 | 52,239,694 | ||
| 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 | Unit | 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 4
| Cost Model Parameters | ||||||||||||||||
| Order Volume by Channel: | ||||||||||||||||
| (Number of Units Sold) | Calls | Pick/Pack/Ship: | Web Page | |||||||||||||
| Scenario 4 | Web | Subscriptions | Phone | Bulk | Total Call Volume | Total Call Minutes | Number of Unique Orders | Total Lines | Units Shipped | Packages Shipped | Returns | Views | Visitors | Visits | ||
| 5,941,634 | 1,895,774 | 2,277,241 | 508,622 | 866,970 | 1,356,554 | 7,475,107 | 11,490,242 | 6,004,101 | 12,586,550 | 4,196,607 | 250,907 | 4,084,376,836 | 29,423,059 | 67,165,321 | ||
| 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 | Unit | 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
Sheet1
File details come from the government source that posted it. Updated .