Attachment_F.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- MCV Magazine Fulfillment Services
- Solicitation number
- 2000018474
- Issued by
- Minnesota
About this file
This is a fiscal year 2026 operational data attachment for the Minnesota Department of Natural Resources' Minnesota Conservation Volunteer (MCV) magazine fulfillment services contract. The document provides monthly performance metrics and activity records spanning July through June, tracking subscriber management, print production, donation processing, and customer service operations. Key operational data includes average active subscriber counts of 117,394 records and 120,919 copies per month, with total annual print orders of 744,493 copies distributed across U.S., Canadian, international, and bulk fulfillment channels. The data encompasses monthly order volumes averaging 8,170 transactions, donor acknowledgment mailings totaling 49,021 annually across email, postcard, letter, and gift letter formats, and customer service interactions including 3,079 phone calls and 325 emails handled throughout the fiscal year.
The document details financial performance showing total contributions of $1,784,731 across 49,021 donations with an average contribution of $36.41, supported by both check/cash and credit card payment methods. Operational activities include subscriber attrition tracking with 5,999 new additions and 3,820 removals, renewal efforts organized into regular and gift series with four contact attempts each (two electronic and two mailed), and customer service metrics averaging 284 total interactions monthly. The fulfillment operations require ongoing merge/purge activities for direct mail campaigns utilizing 20 to 30 lists annually, with miscellaneous bulk distribution created by the publisher and supplied to the printer. Expiration group estimates total approximately 21,405 regular and 3,125 gift renewal efforts annually, representing the scope of subscription lifecycle management required for the magazine fulfillment contract.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT_C.docx | DOCX document | |
| RFP-_Final.docx | DOCX document | |
| Sample_Contract.docx | DOCX document | |
| MCV_Magazine_Fulfillment_Services.pdf | ||
| Attachment_G.docx | DOCX document | |
| RFP_Attachments.docx | DOCX document |
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
FY26 information
| Attachment F | ||||||||||||||
| FY26 Information | July | August | September | October | November | December | January | February | March | April | May | June | FY26 Total | FY26 Avg. |
| Active Subscribers: | ||||||||||||||
| Records | 116,035 | 116,556 | 116,377 | 116,725 | 116,666 | 117,357 | 117,276 | 118,535 | 118,107 | 118,513 | 118,181 | 118,400 | 1,408,728 | 117,394 |
| Copies | 119,383 | 119,905 | 119,728 | 120,196 | 120,912 | 120,912 | 120,840 | 122,111 | 121,422 | 121,951 | 121,625 | 122,047 | 1,451,032 | 120,919 |
| Print Order Counts (Copies): | |||||||||
| US | 116,002 | 116,350 | 116,606 | 117,251 | 118,077 | 118,115 | 702,401 | 117,067 | |
| Canadian | 11 | 11 | 10 | 7 | 8 | 8 | 55 | 9 | |
| International | 15 | 15 | 15 | 12 | 10 | 10 | 77 | 13 | |
| Bulk Copies | 3,623 | 3,345 | 3,510 | 3,528 | 3,313 | 3,491 | 20,810 | 3,468 | Avg 128 recs |
| Supplement Copies | 500 | 500 | 1,000 | 1,000 | 700 | 500 | 4,200 | 700 | |
| Misc Bulk (not on sub file)* | 3,523 | 2,636 | 2,436 | 2,454 | 3,215 | 2,686 | 16,950 | 2,825 | avg 278 recs |
| Print Order Total: | 123,674 | 122,857 | 123,577 | 124,252 | 125,323 | 124,810 | 744,493 | 124,082 |
| Subscriber Attrition: | ||||||||||||||
| Add | 653 | 694 | 1,047 | 1,628 | 573 | 1,404 | 5,999 | 1,000 | ||||||
| Remove/Cancelled | 616 | 403 | 331 | 429 | 733 | 1,308 | 3,820 | 637 | ||||||
| 120,196 | 120,912 | 122,111 | 121,951 | 122,047 | ||||||||||
| Monthly Orders by Payment Source: | ||||||||||||||
| Check/Cash Donations | 2,727 | 1,070 | 2,362 | 3,044 | 3,554 | 4,287 | 4,183 | 1,753 | 3,540 | 1,971 | 2,494 | 1,344 | 32,329 | 5,388 |
| Credit Card Donations | 1,327 | 950 | 1,245 | 1,175 | 1,363 | 2,083 | 2,084 | 1,105 | 1,681 | 1,140 | 1,483 | 1,056 | 16,692 | 2,782 |
| Total orders received: | 4054 | 2,020 | 3,607 | 4,219 | 4,917 | 6,370 | 6,267 | 2,858 | 5,221 | 3,111 | 3,977 | 2,400 | 49,021 | 8,170 |
| % By CC | 33% | 47% | 35% | 28% | 28% | 33% | 33% | 39% | 32% | 37% | 37% | 44% | 34% | 34% |
| Monthly Donations: | ||||||||||||||
| Regular | 3,897 | 1,943 | 3,442 | 2,493 | 3,025 | 4,385 | 5,655 | 2,721 | 4,951 | 2,995 | 3,828 | 2,320 | 41,655 | 3,471 |
| Gift | 157 | 77 | 165 | 1,726 | 1,892 | 1,985 | 612 | 137 | 270 | 116 | 149 | 80 | 7,366 | 614 |
| Total Contributions | 4054 | 2,020 | 3,607 | 4,219 | 4,917 | 6,370 | 6,267 | 2,858 | 5,221 | 3,111 | 3,977 | 2,400 | 49,021 | 4,085 |
| Total Contributions Amounts | $146,294 | $64,501 | $131,408 | $138,415 | $167,471 | $225,152 | $240,480 | $106,115 | $209,897 | $116,322 | $154,110 | $84,566 | $1,784,731 | $297,455 |
| Average contribution | $36.09 | $31.93 | $36.43 | $32.81 | $34.06 | $35.35 | $38.37 | $37.13 | $40.20 | $37.39 | $38.75 | $35.24 | $36.41 | $36.41 |
| Donor Acknowledgement mailings: | ||||||||||||||
| Via Email | 1,785 | 756 | 1,688 | 2,008 | 2,116 | 3,371 | 2,495 | 1,323 | 2,231 | 1,584 | 1,333 | 1,259 | 21,949 | 1,829 |
| Postcards (list only) ** | 1,758 | 994 | 1,424 | 1,223 | 1,495 | 1,763 | 2,303 | 1,097 | 2,217 | 1,121 | 1,978 | 829 | 18,202 | 1,517 |
| Regular Letters | 425 | 220 | 385 | 325 | 375 | 340 | 790 | 315 | 590 | 335 | 550 | 240 | 4,890 | 408 |
| Gift Letters | 86 | 50 | 110 | 663 | 931 | 896 | 679 | 123 | 183 | 71 | 116 | 72 | 3,980 | 332 |
| Total Acknowledgements: | 4,054 | 2,020 | 3,607 | 4,219 | 4,917 | 6,370 | 6,267 | 2,858 | 5,221 | 3,111 | 3,977 | 2,400 | 49,021 | 4,085 |
| Expire Groups Estimates***: | ||||||||||||||
| Regular | 1,000 | 2,325 | 1,075 | 1,815 | 1,325 | 2,575 | 1,925 | 2,260 | 1,225 | 2,030 | 1,950 | 1,900 | 21,405 | 1,784 |
| Gift | 240 | 235 | 1,325 | 640 | 235 | 175 | 2,850 | 475 |
| Customer Service: | ||||||||||||||
| Phone Calls: | 215 | 120 | 250 | 205 | 355 | 370 | 350 | 135 | 385 | 235 | 245 | 214 | 3,079 | 257 |
| Emails: | 20 | 35 | 15 | 40 | 5 | 5 | 45 | 30 | 20 | 45 | 35 | 30 | 325 | 27 |
| Customer Service Totals: | 235 | 155 | 265 | 245 | 360 | 375 | 395 | 165 | 405 | 280 | 280 | 244 | 3,404 | 284 |
| Merge/Purge for Direct Mail: | There can be 1-3 direct mails per year using 20 - 30 lists. They will need to be deduped against each other and the active subscriber file. | |||||||||||||
| * The miscellaneous bulk file is created by publisher and supplied to printer for distribution. | ||||||||||||||
| **Fulfillment vendor would supply list of donation under $50 to mailhouse for lettershop and mailing. | ||||||||||||||
| ***There are 4 efforts for both the regular and gift renewal series - 2 eblasts and 2 mailed efforts. | ||||||||||||||
| - Regular renewal groups are based on the date of the latest donation so started monthly. | ||||||||||||||
| - Gift renewal groups are based on the expire issue so started every other month. |
FY21 MCV Counts
File details come from the government source that posted it. Updated .