Attachment_2_USM_Historical_Data.docx

DOCX document 4 MB Posted

Attached to
Order Management System Retail Sales End to End Solution
Solicitation number
USM-HQ-13-0018
Issued by

About this file

Attachment 2 - USM Historical Data

View the file

Other files

File Type Posted
Amendment_009_USM-HQ-13-0018.pdf PDF
Amendment_008_USM-HQ-13-0018.pdf PDF
Amendment_007_USM-HQ-13-0018.pdf PDF
Amendment_006_USM-HQ-13-0018.pdf PDF
Amendment_005_USM-HQ-13-0018.pdf PDF
Public_Laws.Regulations_and_Policies_Attachment.docx DOCX document
USM_Interval_Report_June_2012.xlsx XLSX spreadsheet
Amendment_004_USM-HQ-13-0018.pdf PDF
Amendment_003_USM-HQ-13-0018.pdf PDF
Amendment_002_USM-HQ-13-0018.pdf PDF
Attachment_9_Contractor_Performance_Questionairre.docx DOCX document
Attachment_14_-_System_Security_Control_Baselines.docx DOCX document
Attachment_G-9_IPP_Waiver.docx DOCX document
Appendix_D_USM_Internal_and_External_Systems_Interface_Descriptions.xlsx XLSX spreadsheet
Attachment_9_Contractor_Performance_Questionairre.docx DOCX document
Appendix_C_Go-Live_and_Full_Operational_Capability_(FOC)_Definitions.docx DOCX document
Attachment_5_Operational_Cost_Scenario_Template.xlsx XLSX spreadsheet
Attachment_1__SOO.docx DOCX document
Attachment_12_Security_Manual_TD_P_15-71.pdf PDF
Attachment_4_Pricing_Template.xls XLS spreadsheet
Attachment_13_-_HSPD-12.docx DOCX document
Attachment_7_Overall_Factor_and_Sub-Factor_Weighting.pptx PPTX presentation
Attachment_C-1_EIT_Accessibility.pdf PDF
Attachment_H-1_Rules_Of_Behavior_for_United_States_Mint_IT_Systems_Users.pdf PDF
Appendix_A_Functional_and_Business_Requirements.xlsx XLSX spreadsheet
Attachment_G-3_Contractor_Travel_Voucher.pdf PDF
Attachment_10_Contract_Release-_Form_7510.doc DOC document
Appendix_B_Deliverables_and_Content_Requirements.docx DOCX document
Attachment_11_Sample_Labor_Categories_and_Descriptions.doc DOC document
Attachment_3_Legacy_Data_Model.docx DOCX document
RFP_USM-HQ-13-0018.docx DOCX document
Attachment_8_Management_and_Technical__Section_L_ _M.pptx PPTX presentation
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

ATTACHMENT 2 – USM HISTORICAL DATA

ATTACHMENT 2 – USM HISTORICAL DATA

United states mint Historical Data

Table of Contents

NUMBER OF CUSTOMERS3
CALL VOLUMES4
FIVE BUSIEST CALL VOLUME DAYS – 20125
BUSIEST CALL VOLUME DAY – 20126
CALL CENTER CLAIMS TASK VOLUMES7
HALF HOUR SPLIT REPORT – Full-Time Agents8
INCOMING CALL REASON REPORT9
ORDER/SALES VOLUME BY CHANNEL10
TOP SELLING NUMISMATIC PRODUCTS12
MAJOR COIN DROP ANALYSIS13
PICK, PACK AND SHIP VOLUMES14
INVENTORY AND SKUs15
FY ‘13 SKU FORECAST16
RETURNS PROCESSING VOLUMES17
SHIP DISTRIBUTION BY STATE18
FEDEX SMARTPOST OUTBOUND SHIPPING19
UPS OUTBOUND SHIPPING20
BACKORDER SCOPE21
FY ’13 PRODUCT FULFILLMENT SCORECARD22
CUSTOMER SATISFACTION INDEX (CALL CENTER) – CY 201223
KEY PERFORMANCE INDEX (KPI)23
TRENDS24
DEMOGRAPHICS25
SCORES26
USM KEY CUSTOMER SATISFACTION MEASUREMENTS27
OVERALL CUSTOMER EXPERIENCE28
OVERALL PRODUCT QUALITY29
COMMUNICATIONS30
PAST 90 DAY EXPERIENCE31
SATISFACTION OF RECENT ORDER32
LIKELIHOOD TO RECOMMEND33
COMMERCE SITES33
2013 PRODUCT SCHEDULE36
SHIP TO COUNTRIES39
ADDITIONAL METRICS40
Product/Pricing Update Frequency40
Pallet Weight40
Precious Metal Storage40
Warehouse Square Footage40
Catalog Mailings40
Gift Wrap Requirements40
Gift Certificates40
Frequently Asked Questions40
Average Order Value Definition40
Average Unit Value41
Inbound Purchase Orders41
Outbound Order Profile41
Outbound Processing41
Kiosk Volumes/Locations41
Outgoing Correspondence Volumes - Headquarters41
Outgoing Correspondence Volumes – GovDelivery (Promotional Emails)41

NUMBER OF CUSTOMERS

CALL VOLUMES

FIVE BUSIEST CALL VOLUME DAYS – 2012

BUSIEST CALL VOLUME DAY – 2012

CALL CENTER CLAIMS TASK VOLUMES

HALF HOUR SPLIT REPORT – Full-Time Agents

INCOMING CALL REASON REPORT

(Page 1)

FY ’12 FY ‘11

INCOMING CALL REASON REPORTNOTE: Calls In could be for multiple reasons and counted multiple times. For actual call volumes see Call Volume report.

(Page 2)

FY ’10 CALL REASON CODES

ORDER/SALES VOLUME BY CHANNELNOTE: Calls In could be for multiple reasons and counted multiple times. For actual call volumes see Call Volume report.

TOP SELLING NUMISMATIC PRODUCTS

FY ‘12

2012 American Eagle Silver Proof One Ounce Coin 2012 Proof Set 2012 Silver Proof Set 2012 Uncirculated Set 2011 Proof Set

FY ‘11

2010 American Eagle Silver Proof One Ounce Coin 2011 Proof Set 2011 American Eagle Silver Proof One Ounce Coin 2010 Proof Set 2011 Silver Proof Set

FY ‘10

2009 Uncirculated Coin Set 2010 Proof Set 2010 Presidential $1 Coin Proof 2010 Uncirculated Coin set 2009 Proof Set

MAJOR COIN DROP ANALYSIS

(Web Traffic Only)

PICK, PACK AND SHIP VOLUMES

INVENTORY AND SKUs

NOTE: This data represents a snapshot of Inventory on Hand for three specific dates.

FY ‘13 SKU FORECAST

RETURNS PROCESSING VOLUMES

Note: Returns/Exchanges - Items must be received before a new order is sent out. Total Return/Exchange orders are approximately .5%.

SHIP DISTRIBUTION BY STATE

FEDEX SMARTPOST OUTBOUND SHIPPING

Week Ending 1-21-13

UPS OUTBOUND SHIPPING

Week Ending 1-21-13

BACKORDER SCOPE

As of May 24, 2012

FY ’13 PRODUCT FULFILLMENT SCORECARD

(Post-Call Survey Results)

CALL CENTER CUSTOMER SATISFACTION INDEX – CY 2012

KEY PERFORMANCE INDEX (KPI)

TRENDS

DEMOGRAPHICS

SCORES

USM KEY CUSTOMER SATISFACTION MEASUREMENTS

1Q FY13

CUSTOMER SATISFACTION MEASUREMENTS

OVERALL CUSTOMER EXPERIENCE

CUSTOMER SATISFACTION MEASUREMENTS

OVERALL PRODUCT QUALITY

CUSTOMER SATISFACTION MEASUREMENTS

COMMUNICATIONS

CUSTOMER SATISFACTION MEASUREMENTS

PAST 90 DAY EXPERIENCE

CUSTOMER SATISFACTION MEASUREMENTS

SATISFACTION OF RECENT ORDER

CUSTOMER SATISFACTION MEASUREMENTS

LIKELIHOOD TO RECOMMEND

COMMERCE SITES

VISITS, VISITORS, WEB PAGE VIEWS (Page 1 of 2)

COMMERCE SITE

VISITS, VISITORS, WEB PAGE VIEWS (Page 2)

2013 PRODUCT SCHEDULE

On-Sale Date

Product
Price

--------------------------Upcoming 2013 Products------------------------------------

02/28/2013
Girls Scouts of the USA Centennial Silver Dollar [ Proof ]
$54.95
02/28/2013
Girls Scouts of the USA Centennial Silver Dollar [ Uncirculated ]
$50.95
03/07/2013
2013 United States Mint Presidential $1 Coin Uncirculated Set™ (P&D)
$16.95
03/19/2013
2013 William McKinley $1 Coin Cover
$19.95
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ Proof Five Dollar Gold Coin ]
TBD
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ Uncirculated Five Dollar Gold Coin ]
TBD
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ Proof Silver Dollar ]
TBD
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ Uncirculated Silver Dollar ]
TBD
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ Proof Clad Half-Dollar ]
TBD
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ Uncirculated Clad Half-Dollar ]
TBD
03/21/2013
2013 5-Star Generals Commemorative Coin Program [ 3-Coin Proof Set ]
TBD
03/28/2013
2013 United States Mint Proof Set®
$31.95
04/2013
2013 America the Beautiful Quarters® Bags and Rolls – Perry’s Victory and International Peace Memorial (OH) [ “S” Roll ]
$18.95
04/2013
2013 America the Beautiful Quarters® Bags and Rolls – Perry’s Victory and International Peace Memorial (OH) [ 2 Roll Set (P, D) ]
$32.95
04/2013
2013 America the Beautiful Quarters® Bags and Rolls – Perry’s Victory and International Peace Memorial (OH) [ 100-Coin Bags ]
$34.95
04/2013
2013 America the Beautiful Quarters® Bags and Rolls – Perry’s Victory and International Peace Memorial (OH) [ 3 Rolls Set (P, D, S) ]
TBD
04/2013
Presidential $1 Coin Rolls, Bags and Boxes – Theodore Roosevelt [ Rolls ]
$32.95
04/2013
Presidential $1 Coin Rolls, Bags and Boxes – Theodore Roosevelt [ 100-Coin Bags ]
$111.95
04/2013
Presidential $1 Coin Rolls, Bags and Boxes – Theodore Roosevelt [ 250-Coin Boxes ]
$275.95
04/2013
Presidential $1 Coin Rolls, Bags and Boxes – Theodore Roosevelt [ 500-Coin Boxes ]
$550.95
04/2013
2013 United States Mint Uncirculated Coin Set®
$27.95
04/2013
2013 America the Beautiful Quarters 3-Coin Set™ - Perry’s Victory and International Peace Memorial (OH)
$9.95
04/2013
2013 American Eagle Gold Proof Coins [ 1 oz. ]
TBD
04/2013
2013 American Eagle Gold Proof Coins [ ½ oz. ]
TBD
04/2013
2013 American Eagle Gold Proof Coins [ ¼ oz. ]
TBD
04/2013
2013 American Eagle Gold Proof Coins [ 1/10 oz. ]
TBD
04/2013
2013 American Eagle Gold Proof Coins [ 4-Coin Set ]
TBD
04/2013
Native American $1 Coin Rolls, Bags and Boxes [ Rolls ]
$32.95
04/2013
Native American $1 Coin Rolls, Bags and Boxes [ 100-Coin Bags ]
$111.95
04/2013
Native American $1 Coin Rolls, Bags and Boxes [ 250-Coin Boxes ]
$275.95
04/2013
Native American $1 Coin Rolls, Bags and Boxes [ 500-Coin Boxes ]
$550.95
04/2013
2013 America the Beautiful Quarters Uncirculated Coin Set™
$12.95
05/2013
2013 United States Mint Silver Proof Set®
$67.95
05/2013
2013 Theodore Roosevelt $1 Coin Cover
$19.95
05/2013
2013 American Buffalo One Ounce Gold Proof Coin
TBD
05/2013
2013 American Eagle One Ounce Silver Uncirculated Coin
$53.95
May/June
American Eagle West Point Two-Coin Silver Set (final product name TBD)
TBD
06/2013
2013 American Eagle One Ounce Gold Uncirculated Coin
TBD
06/2013
2013 America the Beautiful Quarters® Bags and Rolls – Great Basin National Park (NV) [ “S” Roll ]
$18.95
06/2013
2013 America the Beautiful Quarters® Bags and Rolls – Great Basin National Park (NV) [ 2 Roll Set (P, D) ]
$32.95
06/2013
2013 America the Beautiful Quarters® Bags and Rolls – Great Basin National Park (NV) [ 100-Coin Bags ]
$34.95

2013 PRODUCT SCHEDULE (Page 2)

Product
Price

--------------------------Upcoming 2013 Products------------------------------------

06/2013
2013 America the Beautiful Quarters® Bags and Rolls – Great Basin National Park (NV) [ 3 Rolls Set (P, D, S) ]
TBD
06/2013
2013 Kennedy Half-Dollar Bags and Rolls [ 2-Roll Set ]
$32.95
06/2013
2013 Kennedy Half-Dollar Bags and Rolls [ 200-Coin Bags ]
$139.95
06/2013
America the Beautiful Quarters Three-Coin Set™ - Great Basin National Park (NV)
$9.95
07/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William Howard Taft [ Rolls ]
$32.95
07/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William Howard Taft [ 100-Coin Bags ]
$111.95
07/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William Howard Taft [ 250-Coin Boxes ]
$275.95
07/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William Howard Taft [ 500-Coin Boxes ]
$550.95
07/2013
2013 American Eagle One Ounce Platinum Proof Coin
TBD
07/2013
2013 United States Mint Annual Uncirculated Dollar Coin Set
TBD
08/2013
2013 William Howard Taft $1 Coin Cover
$19.95
08/2013
2013 America the Beautiful Quarters® Bags and Rolls – Ft. McHenry National Monument and Historic Shrine (MD) [ “S” Roll ]
$18.95
08/2013
2013 America the Beautiful Quarters® Bags and Rolls – Ft. McHenry National Monument and Historic Shrine (MD) [ 2 Roll Set (P, D) ]
$32.95
08/2013
2013 America the Beautiful Quarters® Bags and Rolls – Ft. McHenry National Monument and Historic Shrine (MD) [ 100-Coin Bags ]
$34.95
08/2013
2013 America the Beautiful Quarters® Bags and Rolls – Ft. McHenry National Monument and Historic Shrine (MD) [ 3 Rolls Set (P, D, S) ]
TBD
09/2013
America the Beautiful Quarters Three-Coin Set™ - Ft. McHenry National Monument and Historic Shrine (MD)
$9.95
10/2013
Presidential $1 Coin Rolls, Bags and Boxes – Woodrow Wilson [ Rolls ]
$32.95
10/2013
Presidential $1 Coin Rolls, Bags and Boxes – Woodrow Wilson [ 100-Coin Bags ]
$111.95
10/2013
Presidential $1 Coin Rolls, Bags and Boxes – Woodrow Wilson [ 250-Coin Boxes ]
$275.95
10/2013
Presidential $1 Coin Rolls, Bags and Boxes – Woodrow Wilson [ 500-Coin Boxes ]
$550.95
10/2013
2013 Presidential $1 Four-Coin Sets
$9.95
11/2013
2013 America the Beautiful Quarters® Bags and Rolls – Mt. Rushmore National Memorial (SD) [ “S” Roll ]
$18.95
11/2013
2013 America the Beautiful Quarters® Bags and Rolls – Mt. Rushmore National Memorial (SD) [ 2 Roll Set (P, D) ]
$32.95
11/2013
2013 America the Beautiful Quarters® Bags and Rolls – Mt. Rushmore National Memorial (SD) [ 100-Coin Bags ]
$34.95
11/2013
2013 America the Beautiful Quarters® Bags and Rolls – Mt. Rushmore National Memorial (SD) [ 3 Rolls Set (P, D, S) ]
TBD
11/2013
2013 Woodrow Wilson $1 Coin Cover
$19.95
11/2013
America the Beautiful Quarters Three-Coin Set™ - Mt. Rushmore National Memorial (SD)
$9.95
11/2013
2013 America the Beautiful Quarters Circulating Coin Set™
$5.95
12/2013
2013 First Spouse Bronze Medal Set
$16.95

2013 PRODUCT SCHEDULE (Page 3) --------------------------On Sale Date To Be Determined------------------------------

2013 First Spouse Series One-Half Ounce Gold Proof Coin – Ida McKinley

2013 First Spouse Series One-Half Ounce Gold Proof Coin – Edith Roosevelt

2013 First Spouse Series One-Half Ounce Gold Proof Coin – Helen Taft

2013 First Spouse Series One-Half Ounce Gold Proof Coin – Ellen Wilson

2013 First Spouse Series One-Half Ounce Gold Proof Coin – Edith Wilson

2013 First Spouse Series One-Half Ounce Gold Uncirculated Coin – Ida McKinley

2013 First Spouse Series One-Half Ounce Gold Uncirculated Coin – Edith Roosevelt

2013 First Spouse Series One-Half Ounce Gold Uncirculated Coin – Helen Taft

2013 First Spouse Series One-Half Ounce Gold Uncirculated Coin – Ellen Wilson

2013 First Spouse Series One-Half Ounce Gold Uncirculated Coin – Edith Wilson

2013 United States Mint Presidential $1 Coin & First Spouse Medal Set™ William McKinley

2013 United States Mint Presidential $1 Coin & First Spouse Medal Set™ Theodore Roosevelt

2013 United States Mint Presidential $1 Coin & First Spouse Medal Set™ William Howard Taft

2013 United States Mint Presidential $1 Coin & First Spouse Medal Set™ Woodrow Wilson – Ellen Wilson

2013 United States Mint Presidential $1 Coin & First Spouse Medal Set™ Woodrow Wilson – Edith Wilson

2013 America the Beautiful Five Ounce Silver Uncirculated Coin™ – White Mountain National Forest (NH)

2013 America the Beautiful Five Ounce Silver Uncirculated Coin™ – Perry’s Victory and International Peace Memorial (OH)

2013 America the Beautiful Five Ounce Silver Uncirculated Coin™ – Great Basin National Park (NV)

2013 America the Beautiful Five Ounce Silver Uncirculated Coin™ – Ft. McHenry National Monument and Historic Shrine (MD)

2013 America the Beautiful Five Ounce Silver Uncirculated Coin™ – Mt. Rushmore National Memorial (SD)

Product
Price

--------------------------Released 2013 Products------------------------------------

01/08/2013
2013 United States Mint America the Beautiful Quarters Silver Proof Set™
$41.95
01/15/2013
2013 Birth Set
$19.95
01/22/2013
2013 United States Mint America the Beautiful Quarters Proof Set™
$14.95
01/24/2013
2013 American Eagle One Ounce Silver Proof Coin
$62.95
01/28/2013
2013 America the Beautiful Quarters® Bags and Rolls – White Mountain National Forest (NH) [ “S” Roll ]
$18.95
01/28/2013
2013 America the Beautiful Quarters® Bags and Rolls – White Mountain National Forest (NH) [ 2 Roll Set (P, D) ]
$32.95
01/28/2013
2013 America the Beautiful Quarters® Bags and Rolls – White Mountain National Forest (NH) [ 3 Roll Set (P, D, S) ]
$46.95
01/28/2013
2013 America the Beautiful Quarters® Bags and Rolls – White Mountain National Forest (NH) [ 100-Coin Bags ]
$34.95
02/12/2013
2013 America the Beautiful Quarters Three-Coin Set™ - White Mountain National Forest (NH)
$9.95
02/14/2013
2013 United States Mint Presidential $1 Coin Proof Set™
$18.95
02/19/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William McKinley [ Rolls ]
$32.95
02/19/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William McKinley [ 100-Coin Bags ]
$111.95
02/19/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William McKinley [ 250-Coin Boxes ]
$275.95
02/19/2013
Presidential $1 Coin Rolls, Bags, and Boxes – William McKinley [ 500-Coin Boxes ]
$550.95

SHIP TO COUNTRIES

ADDITIONAL METRICS

Product/Pricing Update Frequency

· 19 SKUs are scheduled for regular pricing review in 2013

· All platinum and gold products are reviewed weekly for changes in the market that might require repricing.

· Additionally, product containing silver is monitored and pricing changes may occur with large fluctuations in the metals market.

· On average, the Web team updates content 40 – 60 times per month = 600/year

· Content changes may include pricing update, image updates, or placing new products for sale.

· Once per month more substantial changes can be made to Web page layout and functionality.

Pallet Weight

· The heaviest average pallet weight is 1500 lbs. based on the transportation shipping request. Pallet weight will vary by product.

· One SKU per pallet

· One SKU per case Precious Metal Storage

· Precious metal in storage is 14% of all product pallets.

Warehouse Square Footage

· Current warehouse footing is 110,000 square feet.

Catalog Mailings

· 3 catalog and 2 direct mail brochures each year.

· Catalogs are sent in the Spring (April/May), Fall (Aug/Sept) and Holidays (Oct)

· Two direct mail brochures are typically mailed in the 1st quarter of the calendar year.

Gift Wrap Requirements

· January 2013 – 2.0% (December 27, 2012-January 25, 2013) Gift Certificates

· Since 2001, a total of ~$13K Gift Certificates in denominations of $25, $50, $75, $100, and $200 have been sold.

· FY 2012 – Total 1,233 GC Sold (Avg 3 per day)

· FY 2011 – Total 2,181 GC Sold (Avg 6 per day)

· FY 2010 – Total 1,866 GC Sold (Avg 5 per day)

Frequently Asked Questions

· Refer to following link on USM Website https://answers.usmint.gov/ Average Order Value Definition

· Based on Customer Operations Dash Board – FY 2012

· Sales = 508,927,493.32

· Orders = 1,715,928

· Average Order = $296.00 Average Unit Value

· $88.27 Inbound Purchase Orders

· CY 2012 – 223 POs

· CY 2011 – 257 POs Outbound Order Profile

· Average order size = 3.37 Units / Order

· Value = $296

· Lines = 1.48 / Order

· Units per line / 2.27

· Promotional materials per order = Varies based on promotion Outbound Processing

· Average Orders Per Day – FY ‘12

· Peak – 10,842 (April-July)

· Non-Peak – 6,500 (August-March)

· International Orders – October-December 2012

· Approximately 950 UPS shipments to Canada and international countries.

· International shipments represent less than one percent of total shipments.

Kiosk Volumes/Locations

· Two permanent locations in Washington, DC:

· Headquarters – Avg sales $1.0M (3 year average)

· Union Station - Avg sales $1.6M (3 year average)

· Conventions and Off-Site Sales – Avg Sales $169K (3 year average) Outgoing Correspondence Volumes - Headquarters

· FY ’12

· Subscription Related Emails ~574,719

· Credit Card Decline Notifications ~ 134,181 emails and 15,898 letters Outgoing Correspondence Volumes – GovDelivery (Promotional Emails)

· 2012 – 45,969,972

· 2011 – 33,828,787 image2.emf image3.png image4.emf image5.png image6.emf image7.emf image8.png image9.emf image10.emf image100.emf image11.emf image12.emf image13.emf image14.emf image15.emf image16.emf image17.png image18.png image19.png image20.emf image21.emf image22.emf image23.png image24.emf image25.emf image26.emf image27.emf image28.png image29.png image30.png image31.png image32.png image33.png image34.png image35.png image36.png image37.png image38.png image39.png image40.png image41.emf image42.png image43.png image44.png image45.emf image1.emf

File details come from the government source that posted it. Updated .