0- Exhibit E- Sample- ABC Company- Qtrly Volume Reports- Summary and Detailed- v1b.xls
XLS spreadsheet 96 KB Posted
- Solicitation number
- IFB1 AAEA 2016000071 2
- Issued by
- Denver County, Denver City, Colorado
About this file
This document is a Quarterly Volume Report (QVR) template and sample submission from ABC Company to the State of Colorado Purchasing Office for a Facilities Maintenance, Repair, and Operations (MRO) price agreement (Colorado Price Agreement #2015-0000-0000-0999). The report covers the quarterly period of July through September 2014 and documents sales of various maintenance and safety products including pipe wrenches, safety masks, brake cleaner, screwdrivers, worm drive clamps, safety vests, and O-ring kits to multiple state entities. The detailed transaction data identifies individual customers, invoice dates, product descriptions, quantities shipped, unit prices, and account numbers for each sale. Customers include Colorado State University, Metro State University of Denver, Fort Lewis College, Trinidad State Junior College, City of Englewood, Colorado Springs Utilities, Jefferson County Schools, St. Vrain Valley School District/CDC, Goodwill Industries, CDOT facilities, Department of Corrections, and Department of Natural Resources locations.
The sample report indicates total quarterly sales of $1,872.60 at regular list pricing of $2,578.89, generating estimated cost savings to the state of $706.29 or 27 percent. Sales were distributed across state agencies ($455.77), higher education institutions ($818.72), political subdivisions ($594.12), and non-profit organizations ($3.99). Notably, 68 percent of total sales ($1,264.52) were paid by commercial credit card, and 27 percent ($502.93) qualified as green products with environmental attributes. The vendor is required to remit a one percent administrative fee of $18.73 within 30 days after quarter end. The document includes detailed transaction-level data supporting all reported amounts and serves as the required format for vendors to report sales activity and associated metrics under Colorado's price agreement program.
View the file
Other files
Show all 12
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
Qtrly Volume Report- Summary
| . | |
| STATE OF COLORADO |
VENDOR QUARTERLY
| SUMMARY VOLUME REPORT | Send completed form to: State Purchasing Office 1525 Sherman Street, Third Floor Denver, CO 80203 or email to Sourcing Specialist | |||||||||||
| Vendor Name: | ABC Company | Revised - 8/1/14 | ||||||||||
| Contact Person: | Robin Bloom | |||||||||||
| E-Mail Address: | rbloom@abccompanySAMPLE.com | Fill In Highlighted Areas | ||||||||||
| Phone: | 303-999-9999 | |||||||||||
| Date: | October 29, 2014 | |||||||||||
| Colorado Price Agreement #: | 2015-0000-0000-0999 (sample) | |||||||||||
| Commodity or Service Name: | Facilities MRO | |||||||||||
| Reporting Period - Please select the appropriate period: | Select one from each Drop Down Menu | |||||||||||
| Reporting Year - Please select the appropriate year: | ||||||||||||
| SPO Sourcing Specialist Contact - Please select the Specialist and e-mail this form to: | ||||||||||||
| Sales Data Reported | ||||||||||||
| Type of Entity . | Total Sales Dollars This Quarter¹ | Regular (List) Pricing of Total Sales² | Estimated Cost Savings³ | Total Paid By Commercial Credit Card4 | Total Green Sales5 | |||||||
| State Agencies and other State Departments | $ 455.77 | $ 585.87 | $ 130.10 | 22% | $ 406.36 | 89% | $ 380.41 | 83% | ||||
| Higher Education | $ 818.72 | $ 1,072.22 | $ 253.50 | 24% | $ 802.72 | 98% | $ 40.92 | 5% | ||||
| Political Subdivisions6 | $ 594.12 | $ 876.17 | $ 282.05 | 32% | $ 51.45 | 9% | $ 81.60 | 14% | ||||
| Non-Profit7 | $ 3.99 | $ 44.63 | $ 40.64 | 91% | $ 3.99 | 100% | $ 0.00 | 0% | ||||
| Totals | $ 1,872.60 | $ 2,578.89 | $ 706.29 | 27% | $ 1,264.52 | 68% | $ 502.93 | 27% | SPO Use Only: Reconcilation of Admin. Fee | |||
| Colo. Admin. Fee8 | $ 18.73 | Note: Make check payable to "State of Colorado". Send to: Colorado State Purchasing Office, 1525 Sherman Street, Third Floor, Denver, CO 80203 | $ 18.73 | $ 18.73 | $ 0.00 | |||||||
| (calculated @ 1%) | Amount Shown Owed | Difference | ||||||||||
| Vendor Comments: | of Total Sales | (from B29) | ||||||||||
| Admin. Fee due of 1% by 30th day after quarter end. | ||||||||||||
| Legend | ||||||||||||
| 1 | Total Sales Dollars this Quarter - Attach detailed reports/data to support these amounts. | |||||||||||
| 2 | Regular (List) Pricing of Total Sales- The List / Catalog / MSRP Pricing and %, prior to any discounts. | |||||||||||
| 3 | Estimated Cost Savings - Savings to the State and % as a direct result of this price agreement. | |||||||||||
| 4 | Total Paid by Commercial Card - Reflects the portion of total sales and % paid by the State Procurement Card or credit cards. | |||||||||||
| 5 | Total Green Sales - Reflects the portion of total sales and % that has Environmentally Preferable attributes. Note: third-party certified or registered (no self-certifying allowed) | |||||||||||
| 6 | Political Subdivisions - Examples include City/County/Local Governments, Special Districts (School, Fire, Water, Transportation etc.) | |||||||||||
| 7 | Non-Profits - Organizations qualified by the State Purchasing Office based on C.R.S. 24-110-207.5. | |||||||||||
| 8 | Colorado Administration Fee - Only applicable to price agreements where the State is collecting a fee. Vendor manually enters data. | |||||||||||
| ------------------------------------- SPO Use Only ------------------------------------------- Date entered to QVR | Date Entered to QVR Log: | ___________________ | ||||||||||
| Notes/Comments: | (enter comments here--->) | |||||||||||
| Nikki Kalen (303) 866-5671 Nikki.Kalen@state.co.us | ||||||||||||
| Lenora Kingston (303) 866-3986 Lenora.Kingston@state.co.us | ||||||||||||
| Tara Larwick (303) 866-4552 Tara.Larwick@state.co.us | ||||||||||||
| Cheri Miller (303) 866-4005 Cheri.Miller@state.co.us | ||||||||||||
| Molly Randol (303) 866-6191 Molly.Randol@state.co.us | ||||||||||||
| Amy Risley (303) 866-5663 Amy.Risley@state.co.us | ||||||||||||
| Christine Weber (303) 866-6146 Christine.Weber@state.co.us | ||||||||||||
| January - March | 2013 | |||||||||||
| April - June | 2014 | |||||||||||
| July - September | 2015 | |||||||||||
| October - December | ||||||||||||
| spo2014 | ||||||||||||
| (see Rows 76-99) |
Qtrly Volume Report- Detailed
| (SAMPLE) ABC Company | Quarterly Volume Report-Detail for July-Sept. 2014 | |||||||||||||||||||
| (Note: does not have to be in capital letters--->) | Other relevant fields ---> | |||||||||||||||||||
| Item | Packing Slip | Type | Customer Name | Invoice Date | Item Description | UM | QTY Shipped | Unit Price | Ext Amount | List Price | Ext List Price | Savings | Pmnt Type | Paid by Credit Card | Green Products | PO | Account Number | Invoice # | Product # | |
| 84977206 | 70290951 | HE | COLORADO STATE UNIVERSITY/HE | 7/31/14 | 8" BLACK POLY - MEDIUM COUNTER DUSTER | 1 | 10 | $ 0.47 | $ 4.70 | .55 | $ 5.50 | $ 0.80 | Visa | $ 4.70 | $ 4.70 | 4555778 | 101 | 78-994787 | 1234 | |
| 84977206 | 72511201 | HE | COLORADO STATE UNIVERSITY/HE | 8/1/14 | 810 PIPE WRENCH RIDGE TOOLS | 1 | 10 | $ 0.47 | $ 4.70 | .55 | $ 5.50 | $ 0.80 | Visa | $ 4.70 | 4555991 | 101 | 78-12645 | 5678 | ||
| 87909107 | 74308991 | HE | METRO STATE UNIVERS.OF DENVER | 9/25/14 | 814 PIPE WRENCH RIDGE TOOLS | 100 | 100 | $ 5.76 | $ 576.00 | 6.67 | $ 667.00 | $ 91.00 | Visa | $ 576.00 | 756886 | 103 | 78-54778 | 2345 | ||
| 57499162 | 50648111 | HE | FORT LEWIS COLLEGE | 8/25/14 | 8180 14OZ AEROS LOWVOC 3M HIGH POWER BRAKE CLNR | 1 | 1 | $ 16.00 | $ 16.00 | $ 32.00 | $ 32.00 | $ 16.00 | check | 3265 | 117 | 78-78744 | 6780 | |||
| 06363634 | 58992341 | HE | TRINIDAD STATE JR COLLEGE | 8/11/14 | 8180 14OZ AEROS LOWVOC 3M HIGH POWER BRAKE CLNR | 1 | 2 | $ 36.22 | $ 72.44 | 60.37 | $ 120.74 | $ 48.30 | MasterCard | $ 72.44 | 122456 | 129 | 78-9898 | 1111 | ||
| 06363634 | 59101261 | HE | TRINIDAD STATE JR COLLEGE | 8/11/14 | 8210 N95 20PK 3M SAFETY MASK | 1 | 1 | $ 36.22 | $ 36.22 | 60.37 | $ 60.37 | $ 24.15 | MasterCard | $ 36.22 | $ 36.22 | 122456 | 129 | 78-454162 | 1231 | |
| 06363659 | 58992341 | HE | TRINIDAD STATE JR COLLEGE | 9/15/14 | 827B.500"D.X200"DBL HD STARRETT EDGE FINDERS | 1 | 3 | $ 36.22 | $ 108.66 | 60.37 | $ 181.11 | $ 72.45 | MasterCard | $ 108.66 | 134501 | 129 | 79-8897 | 6477 | ||
| Total HE | $ 818.72 | $ 1,072.22 | $ 253.50 | $ 802.72 | $ 40.92 | |||||||||||||||
| 74779794 | 67282541 | PS | CITY OF ENGLEWOOD | 9/8/14 | RND SHNK PHILLIPS #1 KLEIN CUSH-GRIP SCREWDRVR | 1 | 1 | $ 3.99 | $ 3.99 | 44.63 | $ 44.63 | $ 40.64 | check | 1455573 | 374 | 78-12677 | 2121 | |||
| 74779802 | 67282541 | PS | CITY OF ENGLEWOOD | 9/8/14 | SAE SIZE 10 STANDARD TRIDON WORM DRIVE CLAMPS | 1 | 5 | $ 54.28 | $ 271.40 | 60.63 | $ 303.15 | $ 31.75 | check | 756886 | 374 | 78-54666 | 3155 | |||
| 87878955 | 55692161 | PS | COLORADO SPRINGS UTILITIES | 7/31/14 | SAE SIZE 12 STANDARD TRIDON WORM DRIVE CLAMPS | 1 | 44 | $ 4.22 | $ 185.68 | 6.23 | $ 274.12 | $ 88.44 | check | 13265 | 319 | 78-78123 | 4566 | |||
| 00324574 | 72674391 | PS | JEFFCO SCHOOLS | 9/25/14 | SAE SIZE 20 STANDARD TRIDON WORM DRIVE CLAMPS | 1 | 5 | $ 10.29 | $ 51.45 | 31.75 | $ 158.75 | $ 107.30 | MasterCard | $ 51.45 | 9855-456 | 415 | 78-98788 | 4879 | ||
| 86425261 | 63224051 | PS | ST VRAIN K-12 VALLEY SCHL/CDC | 8/25/14 | SAETY VEST M/L W/LOGO SAFETY RADIANS VEST QIA | 1 | 3 | $ 27.20 | $ 81.60 | 31.84 | $ 95.52 | $ 13.92 | check | $ 81.60 | 492 | 7771 | ||||
| Total PS | $ 594.12 | $ 876.17 | $ 282.05 | $ 51.45 | $ 81.60 | |||||||||||||||
| 74779794 | 67282541 | NP | Goodwill Industries | 9/8/14 | RND SHNK PHILLIPS #1 KLEIN CUSH-GRIP SCREWDRVR | 1 | 1 | $ 3.99 | $ 3.99 | 44.63 | $ 44.63 | $ 40.64 | MasterCard | $ 3.99 | P4564 | 677 | 77-89444 | 2121 | ||
| Total NP | $ 3.99 | $ 44.63 | $ 40.64 | $ 3.99 | $ - 0 | |||||||||||||||
| 01763903 | 48499531 | SA | CDOT REGION 1 WHS 5 | 7/2/14 | 5 PT BRKWY W/PKT CDOT CL3 VEST GRN ZIP 3X/5X QI | 1 | 3 | $ 7.65 | $ 22.95 | 10.82 | $ 32.46 | $ 9.51 | check | $ 22.95 | UT-9978 | 719 | 78-54778 | 4002 | ||
| 00240606 | 51940391 | SA | CDOT EISENHOWER TUNNEL | 9/9/14 | 5 PT BRKWY W/PKT CDOT CL3 VEST GRN ZIP M/L QIA | 1 | 12 | $ 4.32 | $ 51.84 | 9.24 | $ 110.88 | $ 59.04 | MasterCard | $ 51.84 | $ 51.84 | 66001 | 720 | 79-8744 | 6547 | |
| 87524518 | 56212381 | SA | CDOT CO DEPT OF TRANSP HQ | 8/6/14 | 5 PT BRKWY W/PKT CDOT CL3 VEST GRN ZIP XL/2XQIA | 1 | 1 | $ 1.86 | $ 1.86 | 5.89 | $ 5.89 | $ 4.03 | check | $ 1.86 | 1390 | 721 | 78-9898 | 7894 | ||
| 09861543 | 53073251 | SA | DOC CTCF COLORADO TERRITORIAL | 9/10/14 | YELLOW PVC/POLY WEBTEX XXL 48"COAT W/HOOD SNAPSA | 1 | 10 | $ 1.22 | $ 12.20 | 1.39 | $ 13.90 | $ 1.70 | check | Z-4547 | 811 | 79-4162 | 5612 | |||
| 09861568 | 53073251 | SA | DOC CTCF COLORADO TERRITORIAL | 7/2/14 | 12PC WOOD/METAL W/CASE RECIPROCATING BLADE SET | 1 | 10 | $ 1.24 | $ 12.40 | 1.41 | $ 14.10 | $ 1.70 | check | 4578 | 811 | 77-98897 | 5645 | |||
| 04774782 | 62708881 | SA | CDNR DOW PUEBLO HATCHERY | 7/31/14 | 382 PC. BUNA-N O-RING KIT | 1 | 6 | $ 8.46 | $ 50.76 | 10.58 | $ 63.48 | $ 12.72 | visa | $ 50.76 | 56798 | 887 | 77-94578 | 3214 | ||
| 89308035 | 67838351 | SA | CDNR CRYSTAL RIVER HATCHERY | 9/9/14 | 5PK WHITE PADS FOR SCRUB AID SWIVEL HOLDER | 1 | 4 | $ 75.94 | $ 303.76 | 86.29 | $ 345.16 | $ 41.40 | check | $ 303.76 | $ 303.76 | 32654 | 895 | 79-469 | 4567 | |
| Total SA | $ 455.77 | $ 585.87 | $ 130.10 | $ 406.36 | $ 380.41 | |||||||||||||||
| Summary | ||||||||||||||||||||
| State Agencies | $ 455.77 | $ 585.87 | $ 130.10 | $ 406.36 | $ 380.41 | |||||||||||||||
| Higher Education | $ 818.72 | $ 1,072.22 | $ 253.50 | $ 802.72 | $ 40.92 | |||||||||||||||
| Total State Entities | $ 1,274.49 | $ 1,658.09 | $ 383.60 | $ 1,209.08 | $ 421.33 | |||||||||||||||
| Political Subdivisions | $ 594.12 | $ 876.17 | $ 282.05 | $ 51.45 | $ 81.60 | |||||||||||||||
| Non-Profits | $ 3.99 | $ 44.63 | $ 40.64 | $ 3.99 | $ - 0 | |||||||||||||||
| Total NON-State Entities | $ 598.11 | $ 920.80 | $ 322.69 | $ 55.44 | $ 81.60 | |||||||||||||||
| Total Qtr Sales - Oct-Dec.2014 | $ 1,872.60 | $ 2,578.89 | $ 706.29 | $ 1,264.52 | $ 502.93 | |||||||||||||||
| Admin. Fee of 1 % | $ 18.73 |
&R&P
Sheet3
File details come from the government source that posted it. Updated .