0- Exhibit E- Sample- ABC Company- Qtrly Volume Reports- Summary and Detailed- v1b.xls

XLS spreadsheet 96 KB Posted

Attached to
FIRE PROTECTION SYSTEM SERVICES AND FIRE EXTINGUISHERS IFB
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 REPORTSend completed form to: State Purchasing Office 1525 Sherman Street, Third Floor Denver, CO 80203 or email to Sourcing Specialist
Vendor Name:ABC CompanyRevised - 8/1/14
Contact Person:Robin Bloom
E-Mail Address:rbloom@abccompanySAMPLE.comFill 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 Card4Total Green Sales5
State Agencies and other State Departments$ 455.77$ 585.87$ 130.1022%$ 406.3689%$ 380.4183%
Higher Education$ 818.72$ 1,072.22$ 253.5024%$ 802.7298%$ 40.925%
Political Subdivisions6$ 594.12$ 876.17$ 282.0532%$ 51.459%$ 81.6014%
Non-Profit7$ 3.99$ 44.63$ 40.6491%$ 3.99100%$ 0.000%
Totals$ 1,872.60$ 2,578.89$ 706.2927%$ 1,264.5268%$ 502.9327%SPO Use Only: Reconcilation of Admin. Fee
Colo. Admin. Fee8$ 18.73Note: 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 OwedDifference
Vendor Comments:of Total Sales(from B29)
Admin. Fee due of 1% by 30th day after quarter end.
Legend
1Total Sales Dollars this Quarter - Attach detailed reports/data to support these amounts.
2Regular (List) Pricing of Total Sales- The List / Catalog / MSRP Pricing and %, prior to any discounts.
3Estimated Cost Savings - Savings to the State and % as a direct result of this price agreement.
4Total Paid by Commercial Card - Reflects the portion of total sales and % paid by the State Procurement Card or credit cards.
5Total Green Sales - Reflects the portion of total sales and % that has Environmentally Preferable attributes. Note: third-party certified or registered (no self-certifying allowed)
6Political Subdivisions - Examples include City/County/Local Governments, Special Districts (School, Fire, Water, Transportation etc.)
7Non-Profits - Organizations qualified by the State Purchasing Office based on C.R.S. 24-110-207.5.
8Colorado Administration Fee - Only applicable to price agreements where the State is collecting a fee. Vendor manually enters data.
------------------------------------- SPO Use Only ------------------------------------------- Date entered to QVRDate 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 - March2013
April - June2014
July - September2015
October - December
spo2014
(see Rows 76-99)

Qtrly Volume Report- Detailed

(SAMPLE) ABC CompanyQuarterly Volume Report-Detail for July-Sept. 2014
(Note: does not have to be in capital letters--->)Other relevant fields --->
ItemPacking SlipTypeCustomer NameInvoice DateItem DescriptionUMQTY ShippedUnit PriceExt AmountList PriceExt List PriceSavingsPmnt TypePaid by Credit CardGreen ProductsPOAccount NumberInvoice #Product #
8497720670290951HECOLORADO STATE UNIVERSITY/HE7/31/148" BLACK POLY - MEDIUM COUNTER DUSTER110$ 0.47$ 4.70.55$ 5.50$ 0.80Visa$ 4.70$ 4.70455577810178-9947871234
8497720672511201HECOLORADO STATE UNIVERSITY/HE8/1/14810 PIPE WRENCH RIDGE TOOLS110$ 0.47$ 4.70.55$ 5.50$ 0.80Visa$ 4.70455599110178-126455678
8790910774308991HEMETRO STATE UNIVERS.OF DENVER9/25/14814 PIPE WRENCH RIDGE TOOLS100100$ 5.76$ 576.006.67$ 667.00$ 91.00Visa$ 576.0075688610378-547782345
5749916250648111HEFORT LEWIS COLLEGE8/25/148180 14OZ AEROS LOWVOC 3M HIGH POWER BRAKE CLNR11$ 16.00$ 16.00$ 32.00$ 32.00$ 16.00check326511778-787446780
0636363458992341HETRINIDAD STATE JR COLLEGE8/11/148180 14OZ AEROS LOWVOC 3M HIGH POWER BRAKE CLNR12$ 36.22$ 72.4460.37$ 120.74$ 48.30MasterCard$ 72.4412245612978-98981111
0636363459101261HETRINIDAD STATE JR COLLEGE8/11/148210 N95 20PK 3M SAFETY MASK11$ 36.22$ 36.2260.37$ 60.37$ 24.15MasterCard$ 36.22$ 36.2212245612978-4541621231
0636365958992341HETRINIDAD STATE JR COLLEGE9/15/14827B.500"D.X200"DBL HD STARRETT EDGE FINDERS13$ 36.22$ 108.6660.37$ 181.11$ 72.45MasterCard$ 108.6613450112979-88976477
Total HE$ 818.72$ 1,072.22$ 253.50$ 802.72$ 40.92
7477979467282541PSCITY OF ENGLEWOOD9/8/14RND SHNK PHILLIPS #1 KLEIN CUSH-GRIP SCREWDRVR11$ 3.99$ 3.9944.63$ 44.63$ 40.64check145557337478-126772121
7477980267282541PSCITY OF ENGLEWOOD9/8/14SAE SIZE 10 STANDARD TRIDON WORM DRIVE CLAMPS15$ 54.28$ 271.4060.63$ 303.15$ 31.75check75688637478-546663155
8787895555692161PSCOLORADO SPRINGS UTILITIES7/31/14SAE SIZE 12 STANDARD TRIDON WORM DRIVE CLAMPS144$ 4.22$ 185.686.23$ 274.12$ 88.44check1326531978-781234566
0032457472674391PSJEFFCO SCHOOLS9/25/14SAE SIZE 20 STANDARD TRIDON WORM DRIVE CLAMPS15$ 10.29$ 51.4531.75$ 158.75$ 107.30MasterCard$ 51.459855-45641578-987884879
8642526163224051PSST VRAIN K-12 VALLEY SCHL/CDC8/25/14SAETY VEST M/L W/LOGO SAFETY RADIANS VEST QIA13$ 27.20$ 81.6031.84$ 95.52$ 13.92check$ 81.604927771
Total PS$ 594.12$ 876.17$ 282.05$ 51.45$ 81.60
7477979467282541NPGoodwill Industries9/8/14RND SHNK PHILLIPS #1 KLEIN CUSH-GRIP SCREWDRVR11$ 3.99$ 3.9944.63$ 44.63$ 40.64MasterCard$ 3.99P456467777-894442121
Total NP$ 3.99$ 44.63$ 40.64$ 3.99$ - 0
0176390348499531SACDOT REGION 1 WHS 57/2/145 PT BRKWY W/PKT CDOT CL3 VEST GRN ZIP 3X/5X QI13$ 7.65$ 22.9510.82$ 32.46$ 9.51check$ 22.95UT-997871978-547784002
0024060651940391SACDOT EISENHOWER TUNNEL9/9/145 PT BRKWY W/PKT CDOT CL3 VEST GRN ZIP M/L QIA112$ 4.32$ 51.849.24$ 110.88$ 59.04MasterCard$ 51.84$ 51.846600172079-87446547
8752451856212381SACDOT CO DEPT OF TRANSP HQ8/6/145 PT BRKWY W/PKT CDOT CL3 VEST GRN ZIP XL/2XQIA11$ 1.86$ 1.865.89$ 5.89$ 4.03check$ 1.86139072178-98987894
0986154353073251SADOC CTCF COLORADO TERRITORIAL9/10/14YELLOW PVC/POLY WEBTEX XXL 48"COAT W/HOOD SNAPSA110$ 1.22$ 12.201.39$ 13.90$ 1.70checkZ-454781179-41625612
0986156853073251SADOC CTCF COLORADO TERRITORIAL7/2/1412PC WOOD/METAL W/CASE RECIPROCATING BLADE SET110$ 1.24$ 12.401.41$ 14.10$ 1.70check457881177-988975645
0477478262708881SACDNR DOW PUEBLO HATCHERY7/31/14382 PC. BUNA-N O-RING KIT16$ 8.46$ 50.7610.58$ 63.48$ 12.72visa$ 50.765679888777-945783214
8930803567838351SACDNR CRYSTAL RIVER HATCHERY9/9/145PK WHITE PADS FOR SCRUB AID SWIVEL HOLDER14$ 75.94$ 303.7686.29$ 345.16$ 41.40check$ 303.76$ 303.763265489579-4694567
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 .